Sisters (Les) T.16 : Cap ou pas cap ?

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1642501945,
                "last": 1642501945,
                "now": 1642501945
            },
            "token": "MKMaWOxzOfPJERraREoOhyIfUetEDxTY"
        },
        "registry": {
            "Com_nglibrary": {
                "Copies": {
                    "limit": "20",
                    "filter_order": "title",
                    "nglibrary_book_id": "20972"
                }
            }
        },
        "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
        }
    }
}

Temps

Mémoire

70 requêtes exécutées 571.58 ms

1. Temps de requête : 0.94 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.954 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `nr3zk_session`
   
     WHERE `session_id` = X'3139383534323461613664373462323131313466353266643537663636623734'

   Explication

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

   Profil

   Status	Duration
   starting	0.30 ms
   checking permissions	0.03 ms
   Opening tables	0.05 ms
   init	0.04 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.07 ms
   executing	0.03 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.06 ms
   freeing items	0.14 ms
   cleaning up	0.07 ms

   Pile d'appels

   #	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:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
   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:414
   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]

   ---

2. Temps de requête : 0.79 ms Après la dernière requête : 2.36 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.112 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `nr3zk_session`
   
     WHERE `session_id` = X'3139383534323461613664373462323131313466353266643537663636623734' 
     LIMIT 1

   Explication

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

   Profil

   Status	Duration
   starting	0.25 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
   executing	0.02 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.06 ms
   freeing items	0.11 ms
   cleaning up	0.06 ms

   Pile d'appels

   #	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:856
   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:414
   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]

   ---

3. Temps de requête : 0.76 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.004 MB mémoire avant requête : 4.117 MB

   INSERT INTO `nr3zk_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3139383534323461613664373462323131313466353266643537663636623734', 1, 1642501945, 0, '', 0)

   Explication

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

   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
   update	0.12 ms
   Waiting for query cache lock	0.02 ms
   update	0.02 ms
   end	0.02 ms
   query end	0.08 ms
   closing tables	0.06 ms
   freeing items	0.11 ms
   cleaning up	0.06 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:856
   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:414
   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]

   ---

4. Temps de requête : 1.12 ms Après la dernière requête : 5.04 ms Mémoire de requête : 0.055 MB mémoire avant requête : 4.336 MB Rangées retournées : 39

   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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

   Profil

   Status	Duration
   starting	0.22 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   init	0.05 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.34 ms
   end	0.02 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: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]

   ---

5. Temps de requête : 0.69 ms Après la dernière requête : 4.38 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.553 MB Rangées retournées : 5

   SELECT id, rules
   
     FROM `nr3zk_viewlevels`

   Explication

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

   Profil

   Status	Duration
   starting	0.23 ms
   checking permissions	0.02 ms
   Opening tables	0.03 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.05 ms
   freeing items	0.10 ms
   cleaning up	0.14 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]

   ---

6. Temps de requête : 0.77 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.565 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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

   Profil

   Status	Duration
   starting	0.20 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.12 ms
   preparing	0.03 ms
   executing	0.02 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.05 ms
   freeing items	0.10 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]

   ---

7. Temps de requête : 1.09 ms Après la dernière requête : 1.09 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.633 MB Rangées retournées : 81

   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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	101	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort

   Profil

   Status	Duration
   starting	0.16 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   preparing	0.03 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.46 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.04 ms
   freeing items	0.08 ms
   cleaning up	0.06 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]

   ---

8. Temps de requête : 1.21 ms Après la dernière requête : 39.33 ms Mémoire de requête : 0.048 MB mémoire avant requête : 6.870 MB Rangées retournées : 15

   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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	17	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.m.component_id	1	100.00	Using where

   Profil

   Status	Duration
   starting	0.33 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   init	0.05 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.07 ms
   preparing	0.04 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	0.22 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.05 ms
   freeing items	0.10 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: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:445
   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:561
   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:1169
   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]

   ---

9. Temps de requête : 0.80 ms Après la dernière requête : 8.34 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.451 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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nr3zk_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

   Profil

   Status	Duration
   starting	0.21 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.05 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	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.08 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:937
   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:1218
   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]

   ---

10. Temps de requête : 0.66 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.006 MB mémoire avant requête : 7.444 MB

    UPDATE `nr3zk_extensions`
    
      SET `params` = '{\"mediaversion\":\"f958cb79fdb346fb2207f135df48f119\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

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

    Profil

    Status	Duration
    starting	0.14 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.08 ms
    updating	0.07 ms
    end	0.02 ms
    Waiting for query cache lock	0.01 ms
    end	0.01 ms
    query end	0.09 ms
    closing tables	0.04 ms
    freeing items	0.07 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:937
    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:1218
    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]

    ---

11. Temps de requête : 0.79 ms Après la dernière requête : 3.43 ms Mémoire de requête : 0.019 MB mémoire avant requête : 7.631 MB Rangées retournées : 1

    SELECT *
    
      FROM nr3zk_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_languages	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.18 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.07 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]

    ---

12. Temps de requête : 0.77 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.019 MB mémoire avant requête : 7.639 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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3	100.00	NULL
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	pf4175j0_neuilly.s.template,const	1	100.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.08 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
    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]

    ---

13. Temps de requête : 0.90 ms Après la dernière requête : 8.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.390 MB Rangées retournées : 1
    Requêtes dupliquées: #14  #15  #16  #36  #37

    SELECT `manifest_cache`
    
      FROM `nr3zk_extensions`
    
      WHERE `type` = 'component' 
      AND `name` = 'com_nglibrary'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

    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.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.15 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.08 ms
    cleaning up	0.08 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]

    ---

14. Temps de requête : 0.80 ms Après la dernière requête : 10.33 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.785 MB Rangées retournées : 1
    Requêtes dupliquées: #13  #15  #16  #36  #37

    SELECT `manifest_cache`
    
      FROM `nr3zk_extensions`
    
      WHERE `type` = 'component' 
      AND `name` = 'com_nglibrary'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.17 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.14 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.07 ms
    cleaning up	0.08 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]

    ---

15. Temps de requête : 0.67 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.822 MB Rangées retournées : 1
    Requêtes dupliquées: #13  #14  #16  #36  #37

    SELECT `manifest_cache`
    
      FROM `nr3zk_extensions`
    
      WHERE `type` = 'component' 
      AND `name` = 'com_nglibrary'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

    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.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.02 ms
    Sending data	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.07 ms
    cleaning up	0.06 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]

    ---

16. Temps de requête : 0.96 ms Après la dernière requête : 2.42 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.838 MB Rangées retournées : 1
    Requêtes dupliquées: #13  #14  #15  #36  #37

    SELECT `manifest_cache`
    
      FROM `nr3zk_extensions`
    
      WHERE `type` = 'component' 
      AND `name` = 'com_nglibrary'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.19 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.24 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.05 ms
    freeing items	0.10 ms
    cleaning up	0.06 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]

    ---

17. Temps de requête : 1.38 ms Après la dernière requête : 25.77 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.982 MB Rangées retournées : 103

    SHOW TABLES

    Explication

    EXPLAIN impossible sur la requête : SHOW TABLES

    Profil

    Status	Duration
    starting	0.23 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.03 ms
    checking permissions	0.49 ms
    Sending data	0.07 ms
    end	0.02 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.09 ms
    cleaning up	0.03 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]

    ---

18. Temps de requête : 38.60 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.004 MB Rangées retournées : 38

    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.14 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	21.79 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.03 ms
    Opening tables	0.04 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 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
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 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
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 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
    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
    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
    checking permissions	0.03 ms
    Sending data	0.12 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	14.94 ms
    closing tables	0.12 ms
    freeing items	0.16 ms
    cleaning up	0.09 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]

    ---

19. Temps de requête : 40.03 ms Après la dernière requête : 10.77 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.590 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.29 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	23.97 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.03 ms
    Opening tables	0.04 ms
    checking permissions	0.06 ms
    checking permissions	0.04 ms
    Sending data	0.07 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    removing tmp table	14.79 ms
    closing tables	0.10 ms
    freeing items	0.16 ms
    cleaning up	0.09 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]

    ---

20. Temps de requête : 0.84 ms Après la dernière requête : 2.58 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.615 MB Rangées retournées : 1
    Requêtes dupliquées: #24

    SELECT *
    
      FROM `nr3zk_nglibrary_books`
    
      WHERE `nglibrary_book_id` = '20972'

    Explication

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

    Profil

    Status	Duration
    starting	0.24 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/fof30/Model/DataModel.php:2537
    13	FOF30\Model\DataModel->find()	JROOT/libraries/fof30/Controller/DataController.php:1591
    12	FOF30\Controller\DataController->getIDsFromRequest()	JROOT/libraries/fof30/Controller/DataController.php:452
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

21. Temps de requête : 42.13 ms Après la dernière requête : 18.46 ms Mémoire de requête : 0.027 MB mémoire avant requête : 11.535 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.item' 
      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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	pf4175j0_neuilly.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.group_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.45 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
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    init	0.11 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	0.24 ms
    preparing	0.08 ms
    Creating tmp table	0.10 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	24.44 ms
    Creating sort index	0.10 ms
    end	0.02 ms
    removing tmp table	15.66 ms
    end	0.05 ms
    query end	0.02 ms
    closing tables	0.12 ms
    freeing items	0.20 ms
    cleaning up	0.08 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:189
    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:476
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

22. Temps de requête : 1.00 ms Après la dernière requête : 4.11 ms Mémoire de requête : 0.027 MB mémoire avant requête : 11.786 MB Rangées retournées : 1

    SELECT *
    
      FROM nr3zk_nglibrary_editors
    
      WHERE (`nglibrary_editor_id` = '1198')
    
      ORDER BY `nglibrary_editor_id` ASC

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    24	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
    23	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
    22	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
    21	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
    20	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
    19	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
    18	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
    17	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
    16	FOF30\Model\DataModel->__get()	JROOT/libraries/fof30/Form/Form.php:1142
    15	FOF30\Form\Form->modelToBindSource()	JROOT/libraries/fof30/Form/Form.php:881
    14	FOF30\Form\Form->bind()	JROOT/libraries/fof30/Model/DataModel.php:4145
    13	FOF30\Model\DataModel->loadForm()	JROOT/libraries/fof30/Model/DataModel.php:4076
    12	FOF30\Model\DataModel->getForm()	JROOT/libraries/fof30/Controller/DataController.php:476
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

23. Temps de requête : 1.32 ms Après la dernière requête : 9.97 ms Mémoire de requête : 0.030 MB mémoire avant requête : 12.064 MB Rangées retournées : 37

    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_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gdpr','com_gmapfp','com_installer','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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_assets	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	101	39.60	Using where

    Profil

    Status	Duration
    starting	0.27 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.09 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.15 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.28 ms
    end	0.02 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
    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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

24. Temps de requête : 0.75 ms Après la dernière requête : 2.52 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.196 MB Rangées retournées : 1
    Requêtes dupliquées: #20

    SELECT *
    
      FROM `nr3zk_nglibrary_books`
    
      WHERE `nglibrary_book_id` = '20972'

    Explication

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

    Profil

    Status	Duration
    starting	0.21 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/fof30/Model/DataModel.php:2537
    18	FOF30\Model\DataModel->find()	JROOT/libraries/fof30/Model/DataModel.php:2414
    17	FOF30\Model\DataModel->findOrFail()	JROOT/libraries/fof30/View/DataView/Raw.php:367
    16	FOF30\View\DataView\Raw->onBeforeRead()	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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

25. Temps de requête : 1.04 ms Après la dernière requête : 30.77 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.272 MB Rangées retournées : 2
    Requêtes dupliquées: #49

    SELECT *
    
      FROM nr3zk_nglibrary_libraries

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:112
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

26. Temps de requête : 31.32 ms Après la dernière requête : 17.75 ms Mémoire de requête : 0.032 MB mémoire avant requête : 14.320 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.20 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	21.52 ms
    init	0.04 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.03 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	8.93 ms
    closing tables	0.07 ms
    freeing items	0.10 ms
    cleaning up	0.05 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/fof30/Model/TreeModel.php:57
    28	FOF30\Model\TreeModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
    27	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
    26	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
    25	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
    24	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
    23	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Relation.php:66
    22	Nglibrary\Site\Form\Field\Relation->getRepeatable()	JROOT/components/com_nglibrary/Form/Field/Relation.php:31
    21	Nglibrary\Site\Form\Field\Relation->getStatic()	JROOT/libraries/fof30/Form/Field/GenericList.php:77
    20	FOF30\Form\Field\GenericList->__get()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:164
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

27. Temps de requête : 0.66 ms Après la dernière requête : 0.78 ms Mémoire de requête : 0.028 MB mémoire avant requête : 14.350 MB Rangées retournées : 2

    SELECT `nglibrary_author_id`
    
      FROM `nr3zk_nglibrary_books_authors`
    
      WHERE `nglibrary_book_id` = '20972'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_nglibrary_books_authors	ref	PRIMARY	PRIMARY	8	const	2	100.00	Using where; Using index

    Profil

    Status	Duration
    starting	0.16 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.07 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.10 ms
    cleaning up	0.04 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    26	JDatabaseDriver->loadColumn()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsToMany.php:261
    25	FOF30\Model\DataModel\Relation\BelongsToMany->filterForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:142
    24	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
    23	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Relation.php:66
    22	Nglibrary\Site\Form\Field\Relation->getRepeatable()	JROOT/components/com_nglibrary/Form/Field/Relation.php:31
    21	Nglibrary\Site\Form\Field\Relation->getStatic()	JROOT/libraries/fof30/Form/Field/GenericList.php:77
    20	FOF30\Form\Field\GenericList->__get()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:164
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

28. Temps de requête : 0.53 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.029 MB mémoire avant requête : 14.365 MB Rangées retournées : 2

    SELECT *
    
      FROM nr3zk_nglibrary_authors
    
      WHERE (`nglibrary_author_id` IN ('44','11211'))
    
      ORDER BY `nglibrary_author_id` ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_nglibrary_authors	range	PRIMARY	PRIMARY	8	NULL	2	100.00	Using where

    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.03 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.04 ms
    freeing items	0.07 ms
    cleaning up	0.07 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    28	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
    27	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
    26	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
    25	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
    24	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
    23	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Relation.php:66
    22	Nglibrary\Site\Form\Field\Relation->getRepeatable()	JROOT/components/com_nglibrary/Form/Field/Relation.php:31
    21	Nglibrary\Site\Form\Field\Relation->getStatic()	JROOT/libraries/fof30/Form/Field/GenericList.php:77
    20	FOF30\Form\Field\GenericList->__get()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:164
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

29. Temps de requête : 32.69 ms Après la dernière requête : 0.76 ms Mémoire de requête : 0.033 MB mémoire avant requête : 14.394 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.12 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	18.17 ms
    init	0.05 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.03 ms
    checking permissions	0.04 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
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.03 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
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	13.34 ms
    closing tables	0.09 ms
    freeing items	0.12 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
    26	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
    25	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
    24	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
    23	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
    22	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
    21	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
    20	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:220
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

30. Temps de requête : 28.26 ms Après la dernière requête : 1.92 ms Mémoire de requête : 0.034 MB mémoire avant requête : 14.463 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.18 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	19.51 ms
    init	0.04 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.03 ms
    checking permissions	0.04 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
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	7.80 ms
    closing tables	0.07 ms
    freeing items	0.11 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:1701
    34	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    33	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
    32	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
    31	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
    30	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
    29	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
    28	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsTo.php:43
    27	FOF30\Model\DataModel\Relation\BelongsTo->__construct()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:180
    26	FOF30\Model\DataModel\RelationManager->addRelation()	JROOT/libraries/fof30/Model/DataModel.php:457
    25	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
    24	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
    23	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
    22	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
    21	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
    20	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:220
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

31. Temps de requête : 32.00 ms Après la dernière requête : 0.68 ms Mémoire de requête : 0.033 MB mémoire avant requête : 14.493 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	17.46 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	13.67 ms
    closing tables	0.09 ms
    freeing items	0.10 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    35	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    34	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
    33	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
    32	FOF30\Model\DataModel->__construct()	JROOT/libraries/fof30/Model/TreeModel.php:57
    31	FOF30\Model\TreeModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
    30	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
    29	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
    28	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsTo.php:43
    27	FOF30\Model\DataModel\Relation\BelongsTo->__construct()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:180
    26	FOF30\Model\DataModel\RelationManager->addRelation()	JROOT/libraries/fof30/Model/DataModel.php:457
    25	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
    24	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
    23	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
    22	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
    21	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
    20	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:220
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

32. Temps de requête : 0.63 ms Après la dernière requête : 1.09 ms Mémoire de requête : 0.029 MB mémoire avant requête : 14.529 MB Rangées retournées : 9
    Requêtes dupliquées: #39  #41  #51

    SELECT nglibrary_bookstatus_id AS ID
    
      FROM `nr3zk_nglibrary_bookstatuses`
    
      WHERE `is_displayed` != 1

    Explication

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

    Profil

    Status	Duration
    starting	0.18 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 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.07 ms
    cleaning up	0.08 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/components/com_nglibrary/Model/Behaviour/CopiesDisabler.php:32
    28	Nglibrary\Site\Model\Behaviour\CopiesDisabler->onBeforeBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
    27	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
    26	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1730
    25	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1836
    24	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
    23	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
    22	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
    21	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
    20	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:220
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

33. Temps de requête : 0.91 ms Après la dernière requête : 1.42 ms Mémoire de requête : 0.029 MB mémoire avant requête : 14.567 MB Rangées retournées : 1

    SELECT *
    
      FROM nr3zk_nglibrary_copies
    
      WHERE nglibrary_bookstatus_id NOT IN (2,3,5,6,7,8,9,10,12) 
      AND (`nglibrary_book_id` = '20972')
    
      ORDER BY `nglibrary_copy_id` ASC

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    25	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
    24	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
    23	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
    22	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
    21	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
    20	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:220
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

34. Temps de requête : 0.57 ms Après la dernière requête : 1.35 ms Mémoire de requête : 0.029 MB mémoire avant requête : 14.593 MB Rangées retournées : 1
    Requêtes dupliquées: #55

    SELECT *
    
      FROM nr3zk_nglibrary_bookstatuses
    
      WHERE (`nglibrary_bookstatus_id` = '4')
    
      ORDER BY `nglibrary_bookstatus_id` ASC

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    28	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
    27	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
    26	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
    25	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
    24	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
    23	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
    22	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
    21	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
    20	FOF30\Model\DataModel->__get()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:223
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

35. Temps de requête : 23.04 ms Après la dernière requête : 1.77 ms Mémoire de requête : 0.061 MB mémoire avant requête : 14.610 MB Rangées retournées : 30

    SELECT *
    
      FROM nr3zk_nglibrary_books
    
      WHERE serie LIKE "Les sisters%" 
      LIMIT 0, 30

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_nglibrary_books	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	18415	100.00	Using where

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:476
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

36. Temps de requête : 0.84 ms Après la dernière requête : 0.85 ms Mémoire de requête : 0.027 MB mémoire avant requête : 14.770 MB Rangées retournées : 1
    Requêtes dupliquées: #13  #14  #15  #16  #37

    SELECT `manifest_cache`
    
      FROM `nr3zk_extensions`
    
      WHERE `type` = 'component' 
      AND `name` = 'com_nglibrary'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    24	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
    23	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
    22	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
    21	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:133
    20	FOF30\Container\Container::getInstance()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:616
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

37. Temps de requête : 1.24 ms Après la dernière requête : 2.81 ms Mémoire de requête : 0.027 MB mémoire avant requête : 14.794 MB Rangées retournées : 1
    Requêtes dupliquées: #13  #14  #15  #16  #36

    SELECT `manifest_cache`
    
      FROM `nr3zk_extensions`
    
      WHERE `type` = 'component' 
      AND `name` = 'com_nglibrary'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.34 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.10 ms
    preparing	0.04 ms
    executing	0.02 ms
    Sending data	0.23 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.07 ms
    freeing items	0.11 ms
    cleaning up	0.10 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    24	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
    23	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
    22	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
    21	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:133
    20	FOF30\Container\Container::getInstance()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:616
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

38. Temps de requête : 31.34 ms Après la dernière requête : 7.07 ms Mémoire de requête : 0.033 MB mémoire avant requête : 14.842 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.Copies.form.book' 
      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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	pf4175j0_neuilly.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.group_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.45 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.06 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.06 ms
    Creating tmp table	0.10 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	19.44 ms
    Creating sort index	0.07 ms
    end	0.01 ms
    removing tmp table	10.28 ms
    end	0.04 ms
    query end	0.02 ms
    closing tables	0.10 ms
    freeing items	0.19 ms
    cleaning up	0.07 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    36	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    35	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    34	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
    33	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    32	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
    31	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    30	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    29	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    28	JEventDispatcher->trigger()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:559
    27	FOF30\Platform\Joomla\Platform->runPlugins()	JROOT/libraries/fof30/Model/DataModel.php:4196
    26	FOF30\Model\DataModel->preprocessForm()	JROOT/libraries/fof30/Model/DataModel.php:4139
    25	FOF30\Model\DataModel->loadForm()	JROOT/libraries/fof30/Model/DataModel.php:4076
    24	FOF30\Model\DataModel->getForm()	JROOT/libraries/fof30/Controller/DataController.php:419
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

39. Temps de requête : 0.71 ms Après la dernière requête : 0.87 ms Mémoire de requête : 0.033 MB mémoire avant requête : 14.930 MB Rangées retournées : 9
    Requêtes dupliquées: #32  #41  #51

    SELECT nglibrary_bookstatus_id AS ID
    
      FROM `nr3zk_nglibrary_bookstatuses`
    
      WHERE `is_displayed` != 1

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    35	JDatabaseDriver->loadColumn()	JROOT/components/com_nglibrary/Model/Behaviour/CopiesDisabler.php:32
    34	Nglibrary\Site\Model\Behaviour\CopiesDisabler->onBeforeBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
    33	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
    32	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1730
    31	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1836
    30	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
    29	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
    28	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/View/DataView/Raw.php:269
    27	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1199
    26	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/DataView/Form.php:47
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

40. Temps de requête : 0.78 ms Après la dernière requête : 0.75 ms Mémoire de requête : 0.030 MB mémoire avant requête : 14.945 MB Rangées retournées : 1
    Requêtes dupliquées: #52

    SELECT *
    
      FROM nr3zk_nglibrary_copies
    
      WHERE nglibrary_bookstatus_id NOT IN (2,3,5,6,7,8,9,10,12) 
      AND (`nglibrary_book_id` = '20972')
    
      ORDER BY `nglibrary_copy_id` ASC 
      LIMIT 20

    Explication

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

    Profil

    Status	Duration
    starting	0.17 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.04 ms
    Sorting result	0.01 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.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    31	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
    30	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
    29	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
    28	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/View/DataView/Raw.php:269
    27	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1199
    26	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/DataView/Form.php:47
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

41. Temps de requête : 0.53 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.032 MB mémoire avant requête : 14.964 MB Rangées retournées : 9
    Requêtes dupliquées: #32  #39  #51

    SELECT nglibrary_bookstatus_id AS ID
    
      FROM `nr3zk_nglibrary_bookstatuses`
    
      WHERE `is_displayed` != 1

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    33	JDatabaseDriver->loadColumn()	JROOT/components/com_nglibrary/Model/Behaviour/CopiesDisabler.php:32
    32	Nglibrary\Site\Model\Behaviour\CopiesDisabler->onBeforeBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
    31	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
    30	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1730
    29	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1703
    28	FOF30\Model\DataModel->count()	JROOT/libraries/fof30/View/DataView/Raw.php:270
    27	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1199
    26	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/DataView/Form.php:47
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

42. Temps de requête : 0.53 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.029 MB mémoire avant requête : 14.978 MB Rangées retournées : 1

    SELECT COUNT(*)
    
      FROM nr3zk_nglibrary_copies
    
      WHERE nglibrary_bookstatus_id NOT IN (2,3,5,6,7,8,9,10,12) 
      AND (`nglibrary_book_id` = '20972')

    Explication

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

    Profil

    Status	Duration
    starting	0.11 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.03 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.07 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    29	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Model/DataModel.php:1709
    28	FOF30\Model\DataModel->count()	JROOT/libraries/fof30/View/DataView/Raw.php:270
    27	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1199
    26	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/DataView/Form.php:47
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

43. Temps de requête : 36.34 ms Après la dernière requête : 5.23 ms Mémoire de requête : 0.036 MB mémoire avant requête : 15.285 MB Rangées retournées : 8

    SHOW FULL COLUMNS 
      FROM `nr3zk_assets`

    Explication

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

    Profil

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	20.24 ms
    init	0.05 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.03 ms
    checking permissions	0.04 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
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	15.11 ms
    closing tables	0.08 ms
    freeing items	0.16 ms
    cleaning up	0.05 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    43	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    42	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
    41	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
    40	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
    39	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
    38	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    37	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    36	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    35	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:587
    34	FOF30\Platform\Joomla\Platform->authorise()	JROOT/libraries/fof30/Toolbar/Toolbar.php:75
    33	FOF30\Toolbar\Toolbar->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:597
    32	FOF30\Factory\BasicFactory->createToolbar()	JROOT/libraries/fof30/Factory/BasicFactory.php:274
    31	FOF30\Factory\BasicFactory->toolbar()	JROOT/libraries/fof30/Factory/MagicFactory.php:120
    30	FOF30\Factory\MagicFactory->toolbar()	JROOT/libraries/fof30/Container/Container.php:543
    29	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:113
    28	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
    27	FOF30\Container\ContainerBase->__get()	JROOT/libraries/fof30/View/DataView/Html.php:40
    26	FOF30\View\DataView\Html->preRender()	JROOT/libraries/fof30/View/DataView/Form.php:54
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

44. Temps de requête : 1.03 ms Après la dernière requête : 1.25 ms Mémoire de requête : 0.034 MB mémoire avant requête : 15.332 MB Rangées retournées : 0
    Requêtes dupliquées: #45  #46  #47  #48

    SELECT *
    
      FROM nr3zk_assets
    
      WHERE `name` = 'com_foobar'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.21 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.06 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:1465
    40	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
    39	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    38	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    37	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    36	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    35	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:587
    34	FOF30\Platform\Joomla\Platform->authorise()	JROOT/libraries/fof30/Toolbar/Toolbar.php:75
    33	FOF30\Toolbar\Toolbar->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:597
    32	FOF30\Factory\BasicFactory->createToolbar()	JROOT/libraries/fof30/Factory/BasicFactory.php:274
    31	FOF30\Factory\BasicFactory->toolbar()	JROOT/libraries/fof30/Factory/MagicFactory.php:120
    30	FOF30\Factory\MagicFactory->toolbar()	JROOT/libraries/fof30/Container/Container.php:543
    29	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:113
    28	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
    27	FOF30\Container\ContainerBase->__get()	JROOT/libraries/fof30/View/DataView/Html.php:40
    26	FOF30\View\DataView\Html->preRender()	JROOT/libraries/fof30/View/DataView/Form.php:54
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

45. Temps de requête : 0.62 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.034 MB mémoire avant requête : 15.358 MB Rangées retournées : 0
    Requêtes dupliquées: #44  #46  #47  #48

    SELECT *
    
      FROM nr3zk_assets
    
      WHERE `name` = 'com_foobar'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.13 ms
    checking permissions	0.03 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    executing	0.04 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.06 ms
    freeing items	0.11 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:1465
    40	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
    39	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    38	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    37	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    36	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    35	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:587
    34	FOF30\Platform\Joomla\Platform->authorise()	JROOT/libraries/fof30/Toolbar/Toolbar.php:76
    33	FOF30\Toolbar\Toolbar->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:597
    32	FOF30\Factory\BasicFactory->createToolbar()	JROOT/libraries/fof30/Factory/BasicFactory.php:274
    31	FOF30\Factory\BasicFactory->toolbar()	JROOT/libraries/fof30/Factory/MagicFactory.php:120
    30	FOF30\Factory\MagicFactory->toolbar()	JROOT/libraries/fof30/Container/Container.php:543
    29	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:113
    28	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
    27	FOF30\Container\ContainerBase->__get()	JROOT/libraries/fof30/View/DataView/Html.php:40
    26	FOF30\View\DataView\Html->preRender()	JROOT/libraries/fof30/View/DataView/Form.php:54
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

46. Temps de requête : 0.57 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.034 MB mémoire avant requête : 15.376 MB Rangées retournées : 0
    Requêtes dupliquées: #44  #45  #47  #48

    SELECT *
    
      FROM nr3zk_assets
    
      WHERE `name` = 'com_foobar'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.13 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.03 ms
    closing tables	0.05 ms
    freeing items	0.11 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:1465
    40	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
    39	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    38	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    37	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    36	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    35	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:587
    34	FOF30\Platform\Joomla\Platform->authorise()	JROOT/libraries/fof30/Toolbar/Toolbar.php:77
    33	FOF30\Toolbar\Toolbar->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:597
    32	FOF30\Factory\BasicFactory->createToolbar()	JROOT/libraries/fof30/Factory/BasicFactory.php:274
    31	FOF30\Factory\BasicFactory->toolbar()	JROOT/libraries/fof30/Factory/MagicFactory.php:120
    30	FOF30\Factory\MagicFactory->toolbar()	JROOT/libraries/fof30/Container/Container.php:543
    29	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:113
    28	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
    27	FOF30\Container\ContainerBase->__get()	JROOT/libraries/fof30/View/DataView/Html.php:40
    26	FOF30\View\DataView\Html->preRender()	JROOT/libraries/fof30/View/DataView/Form.php:54
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

47. Temps de requête : 0.65 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.034 MB mémoire avant requête : 15.395 MB Rangées retournées : 0
    Requêtes dupliquées: #44  #45  #46  #48

    SELECT *
    
      FROM nr3zk_assets
    
      WHERE `name` = 'com_foobar'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.15 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.05 ms
    freeing items	0.08 ms
    cleaning up	0.04 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    41	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    40	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
    39	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    38	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    37	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    36	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    35	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:587
    34	FOF30\Platform\Joomla\Platform->authorise()	JROOT/libraries/fof30/Toolbar/Toolbar.php:78
    33	FOF30\Toolbar\Toolbar->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:597
    32	FOF30\Factory\BasicFactory->createToolbar()	JROOT/libraries/fof30/Factory/BasicFactory.php:274
    31	FOF30\Factory\BasicFactory->toolbar()	JROOT/libraries/fof30/Factory/MagicFactory.php:120
    30	FOF30\Factory\MagicFactory->toolbar()	JROOT/libraries/fof30/Container/Container.php:543
    29	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:113
    28	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
    27	FOF30\Container\ContainerBase->__get()	JROOT/libraries/fof30/View/DataView/Html.php:40
    26	FOF30\View\DataView\Html->preRender()	JROOT/libraries/fof30/View/DataView/Form.php:54
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

48. Temps de requête : 0.58 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.034 MB mémoire avant requête : 15.413 MB Rangées retournées : 0
    Requêtes dupliquées: #44  #45  #46  #47

    SELECT *
    
      FROM nr3zk_assets
    
      WHERE `name` = 'com_foobar'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.17 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.07 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:1465
    40	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
    39	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    38	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    37	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    36	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    35	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:587
    34	FOF30\Platform\Joomla\Platform->authorise()	JROOT/libraries/fof30/Toolbar/Toolbar.php:79
    33	FOF30\Toolbar\Toolbar->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:597
    32	FOF30\Factory\BasicFactory->createToolbar()	JROOT/libraries/fof30/Factory/BasicFactory.php:274
    31	FOF30\Factory\BasicFactory->toolbar()	JROOT/libraries/fof30/Factory/MagicFactory.php:120
    30	FOF30\Factory\MagicFactory->toolbar()	JROOT/libraries/fof30/Container/Container.php:543
    29	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:113
    28	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
    27	FOF30\Container\ContainerBase->__get()	JROOT/libraries/fof30/View/DataView/Html.php:40
    26	FOF30\View\DataView\Html->preRender()	JROOT/libraries/fof30/View/DataView/Form.php:54
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

49. Temps de requête : 0.58 ms Après la dernière requête : 0.93 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.435 MB Rangées retournées : 2
    Requêtes dupliquées: #25

    SELECT *
    
      FROM nr3zk_nglibrary_libraries

    Explication

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

    Profil

    Status	Duration
    starting	0.16 ms
    checking permissions	0.03 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.07 ms
    cleaning up	0.05 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/components/com_nglibrary/View/Copies/tmpl/book.php:12
    30	include JROOT/components/com_nglibrary/View/Copies/tmpl/book.php	JROOT/libraries/fof30/View/View.php:1031
    29	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
    28	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
    27	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
    26	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

50. Temps de requête : 1.43 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.452 MB Rangées retournées : 0
    Requêtes dupliquées: #59

    SELECT *
    
      FROM nr3zk_nglibrary_members
    
      WHERE user_id =0

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	nr3zk_nglibrary_members	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	457	100.00	Using where

    Profil

    Status	Duration
    starting	0.17 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.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.80 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.09 ms
    cleaning up	0.10 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    31	JDatabaseDriver->loadObject()	JROOT/components/com_nglibrary/View/Copies/tmpl/book.php:22
    30	include JROOT/components/com_nglibrary/View/Copies/tmpl/book.php	JROOT/libraries/fof30/View/View.php:1031
    29	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
    28	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
    27	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
    26	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

51. Temps de requête : 1.04 ms Après la dernière requête : 8.64 ms Mémoire de requête : 0.035 MB mémoire avant requête : 15.748 MB Rangées retournées : 9
    Requêtes dupliquées: #32  #39  #41

    SELECT nglibrary_bookstatus_id AS ID
    
      FROM `nr3zk_nglibrary_bookstatuses`
    
      WHERE `is_displayed` != 1

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    42	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    41	JDatabaseDriver->loadColumn()	JROOT/components/com_nglibrary/Model/Behaviour/CopiesDisabler.php:32
    40	Nglibrary\Site\Model\Behaviour\CopiesDisabler->onBeforeBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
    39	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
    38	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1730
    37	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1836
    36	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
    35	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
    34	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:803
    33	FOF30\Render\AkeebaStrapper->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
    32	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
    31	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Copies/tmpl/book.php:51
    30	include JROOT/components/com_nglibrary/View/Copies/tmpl/book.php	JROOT/libraries/fof30/View/View.php:1031
    29	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
    28	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
    27	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
    26	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

52. Temps de requête : 1.05 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.034 MB mémoire avant requête : 15.773 MB Rangées retournées : 1
    Requêtes dupliquées: #40

    SELECT *
    
      FROM nr3zk_nglibrary_copies
    
      WHERE nglibrary_bookstatus_id NOT IN (2,3,5,6,7,8,9,10,12) 
      AND (`nglibrary_book_id` = '20972')
    
      ORDER BY `nglibrary_copy_id` ASC 
      LIMIT 20

    Explication

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

    Profil

    Status	Duration
    starting	0.19 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.20 ms
    preparing	0.05 ms
    Sorting result	0.02 ms
    executing	0.02 ms
    Sending data	0.09 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
    38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    37	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
    36	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
    35	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
    34	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:803
    33	FOF30\Render\AkeebaStrapper->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
    32	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
    31	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Copies/tmpl/book.php:51
    30	include JROOT/components/com_nglibrary/View/Copies/tmpl/book.php	JROOT/libraries/fof30/View/View.php:1031
    29	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
    28	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
    27	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
    26	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
    25	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
    24	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
    23	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
    22	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
    21	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
    20	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/View/Books/tmpl/item.php:617
    19	include JROOT/components/com_nglibrary/View/Books/tmpl/item.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:484
    11	FOF30\Controller\DataController->read()	JROOT/components/com_nglibrary/Controller/Book.php:23
    10	Nglibrary\Site\Controller\Book->read()	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]

    ---

53. Temps de requête : 0.77 ms Après la dernière requête : 1.26 ms Mémoire de requête : 0.036 MB mémoire avant requête : 15.871 MB Rangées retournées : 1