Adulte

Dispo	Titre	Auteur Principal	Année	Genre	Vues
Livre 0	Un talent monstre ! T.6 Résumé	Mr Tan	2013	BD jeunesse - petit format	18
Livre 0	Qui s'y frotte s'hippique ! T.2 Résumé Qui s'y frotte s'hippique ! T.2 Xanax, Gossbo, Flash et les autres font connaissance avec Bella, la jument un peu maladroite à la beauté... fatale ! Avec elle, l'expression « tomber amoureux » prend tout son sens ! Quant à sa propriétaire, même Bijou au sacré caractère de poney la trouve insupportable. Sur ce, Balou, l'imposant cheval de trait, débarque avec ses gros sabots... Pas sur que tout ce petit monde retombe sur ses pattes !	Dufreney Laurent	2016	BD jeunesse	161
Livre 0	Hip hippique, hourra ! T.1 Résumé Hip hippique, hourra ! T.1 C'est la rentrée au club ! Les jeunes cavaliers font connaissance avec Bijou le poney grincheux, Cookie le gourmand, Kamboui le crado, Xanax le trouillard ou encore Flash, le pur-sang électrique à la technique de saut d'obstacles très... particulière ! Une joyeuse bande de chevaux et poneys hauts en couleur qui, entre deux cours d'équitation, blaguent, observent et mènent la vie dure aux cavaliers !	Dufreney Laurent	2015	BD jeunesse	147
Livre 0	Tout ça finira mal T.1 Résumé	Mr Tan	2013	BD jeunesse - petit format	243
Livre 0	L'Enfer, c'est les autres T.2 Résumé	Mr Tan	2013	BD jeunesse - petit format	552
Livre 0	Coeur de la forêt (Le) T.1 Résumé Coeur de la forêt (Le) T.1 Jack est un jeune garçon. Mais parfois, c'est aussi un singe, un ours ou un paresseux. Parce que depuis qu'il est né, Jack a le pouvoir de se transformer en n'importe quel animal, et tout le monde trouve ça normal ! Même s'il n'a jamais prononcé le moindre mot, Jack est extraordinaire et vit une existence ordinaire avec ses parents dans un village au milieu de la forêt... Une vie paisible qui se retrouve tout à coup troublée par des disparitions inexpliquées d'enfants. Seul rescapé de ces événements, Jack ne peut rester sans rien faire. Et ses pouvoirs lui seront bien utiles pour résoudre ce mystère ! Car derrière cette histoire inquiétante se cache un étrange secret...	Toussaint Kid	2019	BD jeunesse - petit format	422
Livre 0	Montagne magique (La) T.2 Résumé Montagne magique (La) T.2 Jack, le jeune garçon qui peut prendre la forme de n'importe quel animal, est bien embêté. Sa maman ne retrouve pas de travail et les soucis la rongent. Ni une ni deux, il décide d'aider ses parents. Accompagné par son amie Gladys, ils prennent le chemin de la montagne pour y trouver le trésor caché ! Jack semble couver un mauvais rhume sous sa forme humaine, mais pas sous ses diverses formes animales... Le parcours est semé d'embûches, d'autant qu'un chasseur semble bien décidé à attraper Jack. Ce dernier paraît cacher de nombreux secrets à son entourage : va-t-il continuer à leur cacher sa véritable nature ?	Toussaint Kid	2019	BD jeunesse - petit format	445
Livre 0	Planète du singe (La) T.3 Résumé	Toussaint Kid	2020	BD jeunesse - petit format	427
Livre 0	Réveil des dodos (Le) T.4 Résumé Réveil des dodos (Le) T.4 C'est la veille des vacances et Jack rêve de retrouver ses amis les animaux. Mais le soir à la maison, avec ses parents, un coup de téléphone annonce le décès de sa grand-mère et décide du départ de toute la famille chez Pop's, son grand-père adoré, pour lui tenir compagnie. Dans cette campagne tranquille, Jack se retrouve nez à nez avec un étrange volatile avec lequel il n'arrive pas à communiquer... C'est un dodo ! Bientôt d'autres espèces disparues réapparaissent... Faire de la pédagogie avec du merveilleux, c'est la recette du succès pour cette série qui sensibilise et enchante autant par la tendresse des dessins que par l'intelligence du scénario. De l'aventure pour éveiller la curiosité et réfléchir sur la nature, le temps qui passe et les menaces qui pèsent sur l'avenir.	Toussaint Kid	2021	BD jeunesse - petit format	491
Livre 0	Revoir un printemps T.5 Résumé Revoir un printemps T.5 Les parents de Gladys décident d’emmener Jack avec eux en Russie pour que leur fille Gladys se sente moins seule. Lors de l’arrêt à une station-service, ils recueillent un chat abandonnéà qui parle ! Et qui raconte de fort belles histoires pour endormir les enfants. Quand ils se réveillent, Jack et Gladys sont dans une chambre vieillotte d’une maison modeste où vit Yaya, une espèce de sorcière. Alors qu’ils tentent de fuir, ils se retrouvent sur la place d’un village enneigé où se baladent fées, centaures et autres créatures magiquesà Kid Toussaint et Miss Prickly font la paire dans cette nouvelle série fantastique qui fait rire et réfléchir ! Aventure, merveilleux et danger se mêlent dans ce récit abordant des thèmes fondamentaux tels que la différence, la protection de l’environnement ou les relations familiales.	Toussaint Kid	2021	BD jeunesse - petit format	463
Livre 0	Plein d'aventures (Le) T.7 Résumé Plein d'aventures (Le) T.7 A travers quatre histoires courtes, Jack nous emmène dans des aventures surprenantes, éducatives et drôles : que ce soit pour conseiller une castor trop romantique dans ses histoires de cœur, enquêter sur la disparition des villageois lors de la nuit d'Halloween, comprendre pourquoi le père Noe[u0308]l n'a pas distribué de cadeaux ou tenter de casser un œuf de Pâques particulièrement récalcitrant, les aventures de Jack sont toujours l'occasion de répéter les valeurs de respect de la différence et de protection de la nature. Cet album offre également de nombreux bonus : jeux, pages pédagogiques ou cours de dessin.	Kid Toussaint Thierry	2022	BD jeunesse - petit format	175

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685708128,
                "last": 1685708128,
                "now": 1685708128
            },
            "token": "X67zVJ9MLVR7HXdcM2pUb9gawVkQOg5n"
        },
        "registry": {
            "Com_nglibrary": {
                "Books": {
                    "authors": {
                        "id": "4373"
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 20.85 ms / 20.85 ms Mémoire: 2.022 MB / 2.41 MB Application: afterLoad

Temps: 76.61 ms / 97.46 ms Mémoire: 4.694 MB / 7.10 MB Application: afterInitialise

Temps: 17.31 ms / 114.77 ms Mémoire: 1.050 MB / 8.15 MB Application: afterRoute

Temps: 3.20 ms / 117.96 ms Mémoire: 0.160 MB / 8.31 MB Application: beforeRenderComponent com_nglibrary

Temps: 97.15 ms / 215.11 ms Mémoire: 4.542 MB / 12.86 MB Application: Before Access::preloadComponents (all components)

Temps: 1.49 ms / 216.61 ms Mémoire: 0.065 MB / 12.92 MB Application: After Access::preloadComponents (all components)

Temps: 0.04 ms / 216.64 ms Mémoire: -0.003 MB / 12.92 MB Application: Before Access::getAssetRules (id:62 name:com_nglibrary)

Temps: 0.67 ms / 217.32 ms Mémoire: 0.027 MB / 12.95 MB Application: After Access::getAssetRules (id:62 name:com_nglibrary)

Temps: 1524.71 ms / 1742.03 ms Mémoire: 4.553 MB / 17.50 MB Application: afterRenderComponent com_nglibrary

Temps: 1.08 ms / 1743.11 ms Mémoire: 0.008 MB / 17.51 MB Application: afterDispatch

Temps: 16.37 ms / 1759.47 ms Mémoire: 0.426 MB / 17.93 MB Application: beforeRenderModule mod_articles_category (Pied de page)

Temps: 2.62 ms / 1762.09 ms Mémoire: 0.215 MB / 18.15 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Temps: 0.08 ms / 1762.17 ms Mémoire: 0.007 MB / 18.16 MB Application: After Access::getAssetRules (id:8 name:com_content)

Temps: 10.47 ms / 1772.64 ms Mémoire: 0.221 MB / 18.38 MB Application: afterRenderModule mod_articles_category (Pied de page)

Temps: 0.12 ms / 1772.76 ms Mémoire: -0.084 MB / 18.29 MB Application: beforeRenderModule mod_breadcrumbs (Fil d'Ariane)

Temps: 2.04 ms / 1774.80 ms Mémoire: 0.050 MB / 18.34 MB Application: afterRenderModule mod_breadcrumbs (Fil d'Ariane)

Temps: 0.08 ms / 1774.89 ms Mémoire: -0.005 MB / 18.34 MB Application: beforeRenderModule mod_custom (Suggestions)

Temps: 0.67 ms / 1775.56 ms Mémoire: 0.008 MB / 18.35 MB Application: afterRenderModule mod_custom (Suggestions)

Temps: 0.06 ms / 1775.62 ms Mémoire: 0.002 MB / 18.35 MB Application: beforeRenderModule mod_ngsearch (Recherche)

Temps: 170.39 ms / 1946.01 ms Mémoire: -0.548 MB / 17.80 MB Application: afterRenderModule mod_ngsearch (Recherche)

Temps: 0.06 ms / 1946.07 ms Mémoire: -0.026 MB / 17.77 MB Application: beforeRenderModule mod_custom (Horaires d'ouverture et contact)

Temps: 0.34 ms / 1946.42 ms Mémoire: 0.003 MB / 17.78 MB Application: afterRenderModule mod_custom (Horaires d'ouverture et contact)

Temps: 0.09 ms / 1946.51 ms Mémoire: 0.008 MB / 17.78 MB Application: beforeRenderModule mod_menu (Main Menu)

Temps: 9.20 ms / 1955.71 ms Mémoire: 0.169 MB / 17.95 MB Application: afterRenderModule mod_menu (Main Menu)

Temps: 0.13 ms / 1955.85 ms Mémoire: -0.006 MB / 17.95 MB Application: beforeRenderModule mod_login (Connexion)

Temps: 2.81 ms / 1958.65 ms Mémoire: 0.036 MB / 17.98 MB Application: afterRenderModule mod_login (Connexion)

Temps: 6.43 ms / 1965.09 ms Mémoire: 0.300 MB / 18.28 MB Application: afterRender

Total de requêtes base de données : 1493.49 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN impossible sur la requête : INSERT INTO `nr3zk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3830666531353264353665613165373636636236373530366137323733373832', 1, 1685708128, 0, '', 0)

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
update	0.17 ms
end	0.01 ms
query end	0.08 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.21 ms Après la dernière requête : 3.15 ms Mémoire de requête : 0.064 MB mémoire avant requête : 4.472 MB Rangées retournées : 41

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	41	1.00	Using where

Profil

Status	Duration
starting	0.26 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.39 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.74 ms Après la dernière requête : 2.96 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.752 MB Rangées retournées : 5

SELECT id, rules

  FROM `nr3zk_viewlevels`

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_viewlevels	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	100.00	NULL

Profil

Status	Duration
starting	0.22 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.81 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.764 MB Rangées retournées : 2

SELECT b.id

  FROM nr3zk_usergroups AS a

  LEFT JOIN nr3zk_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.12 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.66 ms Après la dernière requête : 1.19 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.833 MB Rangées retournées : 97

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM nr3zk_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	116	0.60	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
Sorting result	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.84 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.14 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.22 ms Après la dernière requête : 18.33 ms Mémoire de requête : 0.021 MB mémoire avant requête : 6.583 MB Rangées retournées : 1

SELECT `extension`

  FROM `nr3zk_action_logs_extensions`

  WHERE `extension` = 'com_icagenda'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_action_logs_extensions	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	18	10.00	Using where

Profil

Status	Duration
starting	0.47 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/actionlog/icagenda/icagenda.php:111
10	PlgActionlogIcagenda->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
9	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
8	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/plugins/system/actionlogs/actionlogs.php:64
7	PlgSystemActionLogs->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.39 ms Après la dernière requête : 12.86 ms Mémoire de requête : 0.049 MB mémoire avant requête : 7.293 MB Rangées retournées : 23

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM nr3zk_menu AS m

  LEFT JOIN nr3zk_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	33	3.33	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	b54bqdde_thones.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.30 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.49 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.92 ms Après la dernière requête : 9.15 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.926 MB Rangées retournées : 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `nr3zk_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil

Status	Duration
starting	0.28 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:1498
8	plgSystemGdpr->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.56 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.006 MB mémoire avant requête : 7.919 MB

UPDATE `nr3zk_extensions`

  SET `params` = '{\"mediaversion\":\"54357f0cbfa217840ec27f7e216830e0\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	nr3zk_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.06 ms
updating	0.09 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:1498
8	plgSystemGdpr->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.67 ms Après la dernière requête : 3.09 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.170 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_languages	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.19 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.71 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.179 MB Rangées retournées : 3

SELECT id, home, template, s.params

  FROM nr3zk_template_styles as s

  LEFT JOIN nr3zk_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	b54bqdde_thones.e.element	1	60.00	Using index condition; Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.87 ms Après la dernière requête : 8.22 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.929 MB Rangées retournées : 1

Requêtes dupliquées: #15 #16 #17

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_nglibrary'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	41	10.00	Using where

Profil

Status	Duration
starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
10	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
9	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
8	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:133
7	FOF30\Container\Container::getInstance()	JROOT/components/com_nglibrary/nglibrary.php:19
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.27 ms Après la dernière requête : 7.60 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.260 MB Rangées retournées : 1

Requêtes dupliquées: #14 #16 #17

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_nglibrary'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	41	10.00	Using where

Profil

Status	Duration
starting	0.33 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.32 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
10	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
9	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
8	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:133
7	FOF30\Container\Container::getInstance()	JROOT/components/com_nglibrary/nglibrary.php:19
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.90 ms Après la dernière requête : 1.46 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.333 MB Rangées retournées : 1

Requêtes dupliquées: #14 #15 #17

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_nglibrary'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	41	10.00	Using where

Profil

Status	Duration
starting	0.22 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.12 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
10	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
9	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
8	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
7	FOF30\Container\Container::getInstance()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.91 ms Après la dernière requête : 2.43 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.351 MB Rangées retournées : 1

Requêtes dupliquées: #14 #15 #16

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_nglibrary'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	41	10.00	Using where

Profil

Status	Duration
starting	0.23 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
10	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
9	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
8	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
7	FOF30\Container\Container::getInstance()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.19 ms Après la dernière requête : 26.08 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.559 MB Rangées retournées : 110

SHOW TABLES

Explication

EXPLAIN impossible sur la requête : SHOW TABLES

Profil

Status	Duration
starting	0.27 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
checking permissions	0.37 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.02 ms
closing tables	0.05 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
18	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/fof30/Model/DataModel.php:736
17	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
16	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
15	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
14	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Controller/Controller.php:612
13	FOF30\Controller\Controller->getModel()	JROOT/libraries/fof30/Controller/DataController.php:1542
12	FOF30\Controller\DataController->getModel()	JROOT/libraries/fof30/Controller/DataController.php:277
11	FOF30\Controller\DataController->checkACL()	JROOT/libraries/fof30/Controller/Controller.php:1049
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:378
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.57 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.033 MB mémoire avant requête : 10.582 MB Rangées retournées : 39

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_books`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_books`

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.04 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
Sending data	0.10 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
17	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
16	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
15	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
14	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Controller/Controller.php:612
13	FOF30\Controller\Controller->getModel()	JROOT/libraries/fof30/Controller/DataController.php:1542
12	FOF30\Controller\DataController->getModel()	JROOT/libraries/fof30/Controller/DataController.php:277
11	FOF30\Controller\DataController->checkACL()	JROOT/libraries/fof30/Controller/Controller.php:1049
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:378
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.21 ms Après la dernière requête : 7.83 ms Mémoire de requête : 0.028 MB mémoire avant requête : 11.105 MB Rangées retournées : 2

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_editors`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_editors`

Profil

Status	Duration
starting	0.27 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.06 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
24	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
23	FOF30\Model\DataModel->__construct()	JROOT/libraries/fof30/Model/TreeModel.php:57
22	FOF30\Model\TreeModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
21	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
20	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
19	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsTo.php:43
18	FOF30\Model\DataModel\Relation\BelongsTo->__construct()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:180
17	FOF30\Model\DataModel\RelationManager->addRelation()	JROOT/libraries/fof30/Model/DataModel.php:457
16	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
15	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
14	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Controller/Controller.php:612
13	FOF30\Controller\Controller->getModel()	JROOT/libraries/fof30/Controller/DataController.php:1542
12	FOF30\Controller\DataController->getModel()	JROOT/libraries/fof30/Controller/DataController.php:277
11	FOF30\Controller\DataController->checkACL()	JROOT/libraries/fof30/Controller/Controller.php:1049
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:378
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.67 ms Après la dernière requête : 1.00 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.202 MB Rangées retournées : 1

SELECT `params`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_nglibrary'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Params/Params.php:54
15	FOF30\Params\Params->reload()	JROOT/libraries/fof30/Params/Params.php:39
14	FOF30\Params\Params->__construct()	JROOT/libraries/fof30/Container/Container.php:507
13	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:113
12	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
11	FOF30\Container\ContainerBase->__get()	JROOT/components/com_nglibrary/Controller/Book.php:33
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.17 ms Après la dernière requête : 22.01 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.164 MB Rangées retournées : 1

Requêtes dupliquées: #24

SELECT *

  FROM nr3zk_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_wf_profiles	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	20.00	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.41 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.13 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jce/editor/libraries/classes/application.php:196
21	WFApplication->getProfile()	JROOT/administrator/components/com_jce/helpers/browser.php:72
20	WfBrowserHelper::getMediaFieldOptions()	JROOT/plugins/system/jce/jce.php:45
19	PlgSystemJce->getMediaRedirectUrl()	JROOT/plugins/system/jce/jce.php:183
18	PlgSystemJce->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:559
15	FOF30\Platform\Joomla\Platform->runPlugins()	JROOT/libraries/fof30/Model/DataModel.php:4196
14	FOF30\Model\DataModel->preprocessForm()	JROOT/libraries/fof30/Model/DataModel.php:4139
13	FOF30\Model\DataModel->loadForm()	JROOT/libraries/fof30/Model/DataModel.php:4076
12	FOF30\Model\DataModel->getForm()	JROOT/libraries/fof30/Controller/DataController.php:419
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.91 ms Après la dernière requête : 4.72 ms Mémoire de requête : 0.027 MB mémoire avant requête : 12.510 MB Rangées retournées : 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM nr3zk_fields AS a

  LEFT JOIN `nr3zk_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN nr3zk_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN nr3zk_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN nr3zk_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN nr3zk_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_nglibrary.Books.form.listing' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	b54bqdde_thones.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	b54bqdde_thones.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	b54bqdde_thones.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	b54bqdde_thones.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	b54bqdde_thones.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.44 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.20 ms
preparing	0.05 ms
Creating tmp table	0.09 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.36 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.09 ms
query end	0.02 ms
closing tables	0.07 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
20	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
19	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
18	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:559
15	FOF30\Platform\Joomla\Platform->runPlugins()	JROOT/libraries/fof30/Model/DataModel.php:4196
14	FOF30\Model\DataModel->preprocessForm()	JROOT/libraries/fof30/Model/DataModel.php:4139
13	FOF30\Model\DataModel->loadForm()	JROOT/libraries/fof30/Model/DataModel.php:4076
12	FOF30\Model\DataModel->getForm()	JROOT/libraries/fof30/Controller/DataController.php:419
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.69 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.028 MB mémoire avant requête : 12.524 MB Rangées retournées : 1

Requêtes dupliquées: #22

SELECT *

  FROM nr3zk_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_wf_profiles	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	20.00	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/components/com_jce/editor/libraries/classes/application.php:196
26	WFApplication->getProfile()	JROOT/administrator/components/com_jce/helpers/browser.php:72
25	WfBrowserHelper::getMediaFieldOptions()	JROOT/plugins/system/jce/jce.php:45
24	PlgSystemJce->getMediaRedirectUrl()	JROOT/plugins/system/jce/jce.php:183
23	PlgSystemJce->onContentPrepareForm()	JROOT/plugins/system/jce/jce.php:26
22	PlgSystemJce->onPlgSystemJceContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/content/jce/jce.php:19
18	PlgContentJce->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:559
15	FOF30\Platform\Joomla\Platform->runPlugins()	JROOT/libraries/fof30/Model/DataModel.php:4196
14	FOF30\Model\DataModel->preprocessForm()	JROOT/libraries/fof30/Model/DataModel.php:4139
13	FOF30\Model\DataModel->loadForm()	JROOT/libraries/fof30/Model/DataModel.php:4076
12	FOF30\Model\DataModel->getForm()	JROOT/libraries/fof30/Controller/DataController.php:419
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.22 ms Après la dernière requête : 4.00 ms Mémoire de requête : 0.031 MB mémoire avant requête : 12.862 MB Rangées retournées : 41

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `nr3zk_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_carouselck','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gdpr','com_icagenda','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_ngconfig','com_nglibrary','com_plugin_pdffp','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_assets	NULL	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	116	36.21	Using where

Profil

Status	Duration
starting	0.30 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.19 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
24	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
23	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
22	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
21	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
20	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:587
19	FOF30\Platform\Joomla\Platform->authorise()	JROOT/libraries/fof30/View/DataView/Raw.php:109
18	FOF30\View\DataView\Raw->getPermissions()	JROOT/libraries/fof30/View/DataView/Raw.php:57
17	FOF30\View\DataView\Raw->__construct()	JROOT/libraries/fof30/Factory/Magic/ViewFactory.php:66
16	FOF30\Factory\Magic\ViewFactory->make()	JROOT/libraries/fof30/Factory/MagicFactory.php:97
15	FOF30\Factory\MagicFactory->view()	JROOT/libraries/fof30/Controller/DataController.php:384
14	FOF30\Controller\DataController->getView()	JROOT/libraries/fof30/Controller/Controller.php:456
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.40 ms Après la dernière requête : 7.06 ms Mémoire de requête : 0.032 MB mémoire avant requête : 13.186 MB Rangées retournées : 3

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_authors`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_authors`

Profil

Status	Duration
starting	0.28 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.35 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.05 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.09 ms
closing tables	0.05 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
31	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
30	FOF30\Model\DataModel->__construct()	JROOT/libraries/fof30/Model/TreeModel.php:57
29	FOF30\Model\TreeModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
28	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
27	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
26	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsToMany.php:288
25	FOF30\Model\DataModel\Relation\BelongsToMany->getCountSubquery()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:380
24	FOF30\Model\DataModel\RelationManager->getCountSubquery()	JROOT/libraries/fof30/Model/DataModel/Behaviour/RelationFilters.php:37
23	FOF30\Model\DataModel\Behaviour\RelationFilters->onAfterBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
22	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
21	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1762
20	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1836
19	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
18	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
17	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/View/DataView/Raw.php:269
16	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1199
15	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/DataView/Form.php:47
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 437.90 ms Après la dernière requête : 0.89 ms Mémoire de requête : 0.049 MB mémoire avant requête : 13.216 MB Rangées retournées : 11

Requêtes dupliquées: #29

SELECT *

  FROM nr3zk_nglibrary_books AS book

  WHERE ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_authors` AS `reltbl`

  INNER JOIN `nr3zk_nglibrary_books_authors` AS `pivotTable` 
  ON(`pivotTable`.`nglibrary_author_id` = `reltbl`.`nglibrary_author_id`)

  WHERE 
(`pivotTable`.`nglibrary_book_id` =`book`.`nglibrary_book_id`) 
  AND 
(`pivotTable`.`nglibrary_author_id` = '4373')) >= '1')

  ORDER BY `nglibrary_book_id` ASC,`nglibrary_book_id` ASC 
  LIMIT 20

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	NULL	index	NULL	PRIMARY	8	NULL	20	100.00	Using where
2	DEPENDENT SUBQUERY	reltbl	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	Using index
2	DEPENDENT SUBQUERY	pivotTable	NULL	eq_ref	PRIMARY	PRIMARY	16	b54bqdde_thones.book.nglibrary_book_id,const	1	100.00	Using where; Using index

Profil

Status	Duration
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.03 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.02 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.09 ms
freeing items	0.15 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
19	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
18	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
17	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/View/DataView/Raw.php:269
16	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1199
15	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/DataView/Form.php:47
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 427.42 ms Après la dernière requête : 5.10 ms Mémoire de requête : 0.025 MB mémoire avant requête : 13.306 MB Rangées retournées : 1

SELECT COUNT(*)

  FROM nr3zk_nglibrary_books AS book

  WHERE ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_authors` AS `reltbl`

  INNER JOIN `nr3zk_nglibrary_books_authors` AS `pivotTable` 
  ON(`pivotTable`.`nglibrary_author_id` = `reltbl`.`nglibrary_author_id`)

  WHERE 
(`pivotTable`.`nglibrary_book_id` =`book`.`nglibrary_book_id`) 
  AND 
(`pivotTable`.`nglibrary_author_id` = '4373')) >= '1')

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	NULL	index	NULL	nglibrary_book_id	4	NULL	16999	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	reltbl	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	Using index
2	DEPENDENT SUBQUERY	pivotTable	NULL	eq_ref	PRIMARY	PRIMARY	16	b54bqdde_thones.book.nglibrary_book_id,const	1	100.00	Using where; Using index

Profil

Status	Duration
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.07 ms
freeing items	0.13 ms
cleaning up	0.04 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Model/DataModel.php:1709
17	FOF30\Model\DataModel->count()	JROOT/libraries/fof30/View/DataView/Raw.php:270
16	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1199
15	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/DataView/Form.php:47
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 462.46 ms Après la dernière requête : 36.83 ms Mémoire de requête : 0.051 MB mémoire avant requête : 15.227 MB Rangées retournées : 11

Requêtes dupliquées: #27

SELECT *

  FROM nr3zk_nglibrary_books AS book

  WHERE ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_authors` AS `reltbl`

  INNER JOIN `nr3zk_nglibrary_books_authors` AS `pivotTable` 
  ON(`pivotTable`.`nglibrary_author_id` = `reltbl`.`nglibrary_author_id`)

  WHERE 
(`pivotTable`.`nglibrary_book_id` =`book`.`nglibrary_book_id`) 
  AND 
(`pivotTable`.`nglibrary_author_id` = '4373')) >= '1')

  ORDER BY `nglibrary_book_id` ASC,`nglibrary_book_id` ASC 
  LIMIT 20

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	NULL	index	NULL	PRIMARY	8	NULL	20	100.00	Using where
2	DEPENDENT SUBQUERY	reltbl	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	Using index
2	DEPENDENT SUBQUERY	pivotTable	NULL	eq_ref	PRIMARY	PRIMARY	16	b54bqdde_thones.book.nglibrary_book_id,const	1	100.00	Using where; Using index

Profil

Status	Duration
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.03 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.09 ms
freeing items	0.14 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
26	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
25	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
24	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
23	FOF30\Model\DataModel->get()	JROOT/libraries/ngfof/Render/Listing.php:326
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.59 ms Après la dernière requête : 4.00 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.399 MB Rangées retournées : 1

Requêtes dupliquées: #49 #54

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '1979')

  ORDER BY `nglibrary_editor_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_editors	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/libraries/fof30/Form/Form.php:1142
24	FOF30\Form\Form->modelToBindSource()	JROOT/libraries/fof30/Form/Form.php:881
23	FOF30\Form\Form->bind()	JROOT/libraries/ngfof/Render/Listing.php:337
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.37 ms Après la dernière requête : 9.97 ms Mémoire de requête : 0.036 MB mémoire avant requête : 15.758 MB Rangées retournées : 22

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_copies`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_copies`

Profil

Status	Duration
starting	0.22 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.04 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.04 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
31	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
30	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
29	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
28	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
27	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.91 ms Après la dernière requête : 1.85 ms Mémoire de requête : 0.035 MB mémoire avant requête : 15.830 MB Rangées retournées : 9

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_libraries`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_libraries`

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
40	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
39	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
38	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
37	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
36	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
35	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
34	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
33	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsTo.php:43
32	FOF30\Model\DataModel\Relation\BelongsTo->__construct()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:180
31	FOF30\Model\DataModel\RelationManager->addRelation()	JROOT/libraries/fof30/Model/DataModel.php:457
30	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
29	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
28	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
27	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.89 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.036 MB mémoire avant requête : 15.876 MB Rangées retournées : 6

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_bookstatuses`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_bookstatuses`

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
41	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
40	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
39	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
38	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
37	FOF30\Model\DataModel->__construct()	JROOT/libraries/fof30/Model/TreeModel.php:57
36	FOF30\Model\TreeModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
35	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
34	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
33	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsTo.php:43
32	FOF30\Model\DataModel\Relation\BelongsTo->__construct()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:180
31	FOF30\Model\DataModel\RelationManager->addRelation()	JROOT/libraries/fof30/Model/DataModel.php:457
30	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
29	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
28	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
27	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.54 ms Après la dernière requête : 0.77 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.915 MB Rangées retournées : 6

Requêtes dupliquées: #40 #45 #50 #55 #61 #66 #71 #76 #81 #86

SELECT nglibrary_bookstatus_id AS ID

  FROM `nr3zk_nglibrary_bookstatuses`

  WHERE `is_displayed` != 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	16	90.00	Using where

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
34	JDatabaseDriver->loadColumn()	JROOT/components/com_nglibrary/Model/Behaviour/CopiesDisabler.php:32
33	Nglibrary\Site\Model\Behaviour\CopiesDisabler->onBeforeBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
32	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
31	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1730
30	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1836
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.76 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.930 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_nglibrary_copies

  WHERE nglibrary_bookstatus_id NOT IN (2,3,4,5,7,8) 
  AND (`nglibrary_book_id` = '20661')

  ORDER BY `nglibrary_copy_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_copies	NULL	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	const	1	63.39	Using index condition; Using where

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
30	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.67 ms Après la dernière requête : 1.35 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.957 MB Rangées retournées : 1

Requêtes dupliquées: #42 #47 #52 #57 #58 #63 #68 #73 #78 #83 #88

SELECT *

  FROM nr3zk_nglibrary_bookstatuses

  WHERE (`nglibrary_bookstatus_id` = '1')

  ORDER BY `nglibrary_bookstatus_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/components/com_nglibrary/Form/Field/Cover.php:109
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.40 ms Après la dernière requête : 0.94 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.988 MB Rangées retournées : 8

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_comments`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_comments`

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.31 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.11 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.09 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
30	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
29	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
28	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
27	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
26	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
25	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
24	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Rate.php:31
23	Nglibrary\Site\Form\Field\Rate->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.52 ms Après la dernière requête : 1.58 ms Mémoire de requête : 0.029 MB mémoire avant requête : 16.035 MB Rangées retournées : 0

SELECT *

  FROM nr3zk_nglibrary_comments

  WHERE `enabled` = '1' 
  AND (`nglibrary_book_id` = '20661')

  ORDER BY `nglibrary_comment_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_comments	NULL	index	NULL	PRIMARY	8	NULL	1	100.00	Using where

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
29	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
28	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
27	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
26	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
25	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
24	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Rate.php:31
23	Nglibrary\Site\Form\Field\Rate->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.50 ms Après la dernière requête : 1.06 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.060 MB Rangées retournées : 1

Requêtes dupliquées: #44

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '1138')

  ORDER BY `nglibrary_editor_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_editors	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/libraries/fof30/Form/Form.php:1142
24	FOF30\Form\Form->modelToBindSource()	JROOT/libraries/fof30/Form/Form.php:881
23	FOF30\Form\Form->bind()	JROOT/libraries/ngfof/Render/Listing.php:337
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.65 ms Après la dernière requête : 3.25 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.108 MB Rangées retournées : 6

Requêtes dupliquées: #34 #45 #50 #55 #61 #66 #71 #76 #81 #86

SELECT nglibrary_bookstatus_id AS ID

  FROM `nr3zk_nglibrary_bookstatuses`

  WHERE `is_displayed` != 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	16	90.00	Using where

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.12 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
34	JDatabaseDriver->loadColumn()	JROOT/components/com_nglibrary/Model/Behaviour/CopiesDisabler.php:32
33	Nglibrary\Site\Model\Behaviour\CopiesDisabler->onBeforeBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
32	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
31	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1730
30	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1836
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.73 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.030 MB mémoire avant requête : 16.123 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_nglibrary_copies

  WHERE nglibrary_bookstatus_id NOT IN (2,3,4,5,7,8) 
  AND (`nglibrary_book_id` = '23867')

  ORDER BY `nglibrary_copy_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_copies	NULL	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	const	1	63.39	Using index condition; Using where

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
30	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.45 ms Après la dernière requête : 0.85 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.150 MB Rangées retournées : 1

Requêtes dupliquées: #36 #47 #52 #57 #58 #63 #68 #73 #78 #83 #88

SELECT *

  FROM nr3zk_nglibrary_bookstatuses

  WHERE (`nglibrary_bookstatus_id` = '1')

  ORDER BY `nglibrary_bookstatus_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/components/com_nglibrary/Form/Field/Cover.php:109
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.54 ms Après la dernière requête : 1.19 ms Mémoire de requête : 0.029 MB mémoire avant requête : 16.182 MB Rangées retournées : 0

SELECT *

  FROM nr3zk_nglibrary_comments

  WHERE `enabled` = '1' 
  AND (`nglibrary_book_id` = '23867')

  ORDER BY `nglibrary_comment_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_comments	NULL	index	NULL	PRIMARY	8	NULL	1	100.00	Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
29	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
28	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
27	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
26	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
25	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
24	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Rate.php:31
23	Nglibrary\Site\Form\Field\Rate->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.55 ms Après la dernière requête : 1.01 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.203 MB Rangées retournées : 1

Requêtes dupliquées: #39

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '1138')

  ORDER BY `nglibrary_editor_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_editors	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/libraries/fof30/Form/Form.php:1142
24	FOF30\Form\Form->modelToBindSource()	JROOT/libraries/fof30/Form/Form.php:881
23	FOF30\Form\Form->bind()	JROOT/libraries/ngfof/Render/Listing.php:337
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.70 ms Après la dernière requête : 4.79 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.251 MB Rangées retournées : 6

Lundi		13h30-17h30
Mardi	9h-12h
Mercredi	9h-12h	13h30-17h30
Jeudi	9h-12h
Vendredi	9h-12h
Samedi	8h30-13h30

11 Nouveautés adultes

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

100 requêtes exécutées 1493.49 ms

42 doubles découverts!