Console de débogage Joomla! Requêtes de base de données 38 requêtes exécutées 76.15 ms 6 doubles découverts! 2 requêtes dupliquées: #3  #37 2 requêtes dupliquées: #4  #38 2 requêtes dupliquées: #22  #23 1. Temps de requête : 0.59 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.960 MB Rangées retournées : 1 2. SELECT `data` 3.   FROM `sygjw_session`   WHERE `session_id` = 'eecc75be0ee6253550dfa48b838a3909' Explication idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEsygjw_sessionconstPRIMARYPRIMARY194const1Profil StatusDurationstarting0.03 mschecking permissions0.01 msOpening tables0.01 msSystem lock0.02 msinit0.01 msoptimizing0.01 msstatistics0.06 mspreparing0.01 msexecuting0.00 msSending data0.01 msend0.00 msquery end0.00 msclosing tables0.01 msfreeing items0.02 mslogging slow query0.00 mscleaning up0.00 msPile d'appels #AppelFichier et numéro de ligne16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:173415JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:4514JSessionStorageDatabase->read()Même appel que celui de la ligne ci-dessous.13session_start()JROOT/libraries/joomla/session/handler/native.php:26012JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:5011JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:8810JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:6609Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:6208Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:4987Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:4556Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:7585Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:1354Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:663Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:3442Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:1401Joomla\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 : 18.01 ms Après la dernière requête : 3.57 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.315 MB Rangées retournées : 16 SHOW FULL COLUMNS   FROM `sygjw_users` Explication EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `sygjw_users` Profil StatusDurationstarting0.04 mschecking permissions0.01 msOpening tables11.52 msSystem lock0.02 msinit0.01 msoptimizing0.00 msstatistics0.01 mspreparing0.01 msexecuting0.01 msOpening tables0.01 mschecking permissions0.03 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 mschecking permissions0.01 msSending data0.05 msend0.01 msquery end0.00 msclosing tables0.00 msremoving tmp table1.07 msclosing tables0.01 msfreeing items0.10 mslogging slow query0.01 mscleaning up0.01 msPile d'appels #AppelFichier et numéro de ligne20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:169519JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:44518JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:24517Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:16416Joomla\CMS\Table\Table->__construct()JROOT/libraries/src/Table/User.php:4015Joomla\CMS\Table\User->__construct()JROOT/libraries/src/Table/Table.php:31214Joomla\CMS\Table\Table::getInstance()JROOT/libraries/src/User/User.php:60313Joomla\CMS\User\User::getTable()JROOT/libraries/src/User/User.php:88012Joomla\CMS\User\User->load()JROOT/libraries/src/User/User.php:94611Joomla\CMS\User\User->__wakeup()Même appel que celui de la ligne ci-dessous.10unserialize()JROOT/libraries/src/Session/Session.php:6709Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:6208Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:4987Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:4556Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:7585Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:1354Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:663Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:3442Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:1401Joomla\CMS\Factory::getApplication()JROOT/index.php:46[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] 5. Temps de requête : 4.66 ms Après la dernière requête : 0.77 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.356 MB Rangées retournées : 1 Requêtes dupliquées: #37 SELECT *   FROM `sygjw_users`   WHERE `id` = 990 Explication idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEsygjw_usersconstPRIMARYPRIMARY4const1Profil StatusDurationstarting0.03 mschecking permissions0.01 msOpening tables0.01 msSystem lock0.01 msinit0.02 msoptimizing0.01 msstatistics0.04 mspreparing0.01 msexecuting0.00 msSending data0.02 msend0.00 msquery end0.00 msclosing tables0.01 msfreeing items0.09 mslogging slow query0.01 mscleaning up0.00 msPile d'appels #AppelFichier et numéro de ligne15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:145914JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/User.php:8613Joomla\CMS\Table\User->load()JROOT/libraries/src/User/User.php:88312Joomla\CMS\User\User->load()JROOT/libraries/src/User/User.php:94611Joomla\CMS\User\User->__wakeup()Même appel que celui de la ligne ci-dessous.10unserialize()JROOT/libraries/src/Session/Session.php:6709Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:6208Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:4987Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:4556Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:7585Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:1354Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:663Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:3442Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:1401Joomla\CMS\Factory::getApplication()JROOT/index.php:46[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] 6. Temps de requête : 1.11 ms Après la dernière requête : 3.36 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.919 MB Rangées retournées : 1 Requêtes dupliquées: #38 SELECT `g`.`id`,`g`.`title`   FROM `sygjw_usergroups` AS g   INNER JOIN `sygjw_user_usergroup_map` AS m   ON m.group_id = g.id   WHERE `m`.`user_id` = 990 Explication idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEmrefPRIMARYPRIMARY4const1Using index1SIMPLEgeq_refPRIMARYPRIMARY4cnmbploncnmb2019.m.group_id1Profil StatusDurationstarting0.03 mschecking permissions0.00 mschecking permissions0.00 msOpening tables0.01 msSystem lock0.01 msinit0.01 msoptimizing0.01 msstatistics0.03 mspreparing0.01 msexecuting0.00 msSending data0.09 msend0.01 msquery end0.01 msclosing tables0.01 msfreeing items0.07 mslogging slow query0.01 mscleaning up0.00 msPile d'appels #AppelFichier et numéro de ligne15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:150014JDatabaseDriver->loadAssocList()JROOT/libraries/src/Table/User.php:11113Joomla\CMS\Table\User->load()JROOT/libraries/src/User/User.php:88312Joomla\CMS\User\User->load()JROOT/libraries/src/User/User.php:94611Joomla\CMS\User\User->__wakeup()Même appel que celui de la ligne ci-dessous.10unserialize()JROOT/libraries/src/Session/Session.php:6709Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:6208Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:4987Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:4556Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:7585Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:1354Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:663Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:3442Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:1401Joomla\CMS\Factory::getApplication()JROOT/index.php:46[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] 7. Temps de requête : 0.52 ms Après la dernière requête : 2.31 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.038 MB Rangées retournées : 5 8. SELECT id, rules   FROM `sygjw_viewlevels` Explication idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEsygjw_viewlevelsALLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULL5Profil StatusDurationstarting0.02 mschecking permissions0.01 msOpening tables0.01 msSystem lock0.01 msinit0.01 msoptimizing0.00 msstatistics0.01 mspreparing0.01 msexecuting0.00 msSending data0.03 msend0.00 msquery end0.00 msclosing tables0.01 msfreeing items0.08 mslogging slow query0.01 mscleaning up0.01 msPile d'appels #AppelFichier et numéro de ligne10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:15009JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:10638Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:4587Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:3216Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:875Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:1294Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:6043Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:2122Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:1961Joomla\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.79 ms Après la dernière requête : 2.38 ms Mémoire de requête : 0.033 MB mémoire avant requête : 4.209 MB Rangées retournées : 35 10. SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 11.   FROM `sygjw_extensions`   WHERE `type` = 'component'   AND `state` = 0   AND `enabled` = 1 Explication idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEsygjw_extensionsrefextensionextension82const35Using whereProfil StatusDurationstarting0.03 mschecking permissions0.01 msOpening tables0.01 msSystem lock0.01 msinit0.01 msoptimizing0.01 msstatistics0.03 mspreparing0.01 msexecuting0.00 msSending data0.14 msend0.01 msquery end0.00 msclosing tables0.01 msfreeing items0.13 mslogging slow query0.01 mscleaning up0.01 msPile d'appels #AppelFichier et numéro de ligne18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:169517JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:44516Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Même appel que celui de la ligne ci-dessous.15call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:17314Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:45313Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:51912Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:4411Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:10310Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Access/Access.php:9399Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:10958Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:4587Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:3216Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:875Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:1294Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:6043Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:2122Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:1961Joomla\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.48 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.260 MB Rangées retournées : 2 13. SELECT b.id 14.   FROM sygjw_user_usergroup_map AS map 15.   LEFT JOIN sygjw_usergroups AS a   ON a.id = map.group_id 16.   LEFT JOIN sygjw_usergroups AS b   ON b.lft <= a.lft   AND b.rgt >= a.rgt   WHERE map.user_id = 990 Explication idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEmaprefPRIMARYPRIMARY4const1Using index1SIMPLEaeq_refPRIMARYPRIMARY4cnmbploncnmb2019.map.group_id11SIMPLEbindexidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup8NULL9Using indexProfil StatusDurationstarting0.03 mschecking permissions0.01 mschecking permissions0.00 mschecking permissions0.00 msOpening tables0.01 msSystem lock0.01 msinit0.01 msoptimizing0.01 msstatistics0.03 mspreparing0.01 msexecuting0.00 msSending data0.03 msend0.01 msquery end0.00 msclosing tables0.01 msfreeing items0.07 mslogging slow query0.01 mscleaning up0.00 msPile d'appels #AppelFichier et numéro de ligne11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:154410JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:9809Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:10958Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:4587Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:3216Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:875Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:1294Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:6043Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:2122Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:1961Joomla\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.71 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.031 MB mémoire avant requête : 4.321 MB Rangées retournées : 83 18. SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 19.   FROM sygjw_extensions 20.   WHERE enabled = 1   AND type = 'plugin'   AND state IN (0,1)   AND access IN (1,1,2,3,6)   ORDER BY ordering Explication idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1SIMPLEsygjw_extensionsALLextensionINDEX N'A PU ÊTRE UTILISÉNULLNULL134Using where; Utilisation du tri complet de type filesortProfil StatusDurationstarting0.05 mschecking permissions0.01 msOpening tables0.01 msSystem lock0.01 msinit0.02 msoptimizing0.01 msstatistics0.04 mspreparing0.02 msexecuting0.01 msSorting result0.26 msSending data0.55 msend0.01 msquery end0.01 msclosing tables0.01 msfreeing items0.13 mslogging slow query0.01 mscleaning up0.01 msPile d'appels #AppelFichier et numéro de ligne11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:169510JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:3549Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Même appel que celui de la ligne ci-dessous.8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:1737Joomla\CMS\Cache\Controller\CallbackControlle