Temps de requête : 23.85 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.040 MB Rangées retournées : 1
SELECT `data`
FROM `i9kgm_session`
WHERE `session_id` = X'396c70667035727665317531656a656161676176303370753536'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 23.25 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.03 ms |
| freeing items | 0.82 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT\libraries\joomla\session\storage\database.php:45 |
| 14 | JSessionStorageDatabase->read() | Même appel que celui de la ligne ci-dessous. |
| 13 | session_start() | JROOT\libraries\joomla\session\handler\native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT\libraries\joomla\session\handler\native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT\libraries\joomla\session\handler\joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT\libraries\src\Session\Session.php:661 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT\libraries\src\Session\Session.php:621 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT\libraries\src\Session\Session.php:499 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT\libraries\src\Session\Session.php:456 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT\libraries\src\Application\CMSApplication.php:826 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT\libraries\src\Application\CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT\libraries\src\Application\SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT\libraries\src\Application\CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT\libraries\src\Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT\index.php:46 |
Temps de requête : 17.98 ms Après la dernière requête : 0.71 ms Mémoire de requête : 0.040 MB mémoire avant requête : 1.088 MB Rangées retournées : 45
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `i9kgm_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_extensions | NULL | ref | extension | extension | 82 | const | 46 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 16.93 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.02 ms |
| # | 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 |
Temps de requête : 1.29 ms Après la dernière requête : 0.70 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.123 MB Rangées retournées : 7
SELECT id, rules
FROM `i9kgm_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_viewlevels | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | 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 |
Temps de requête : 0.34 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.136 MB Rangées retournées : 2
SELECT b.id
FROM i9kgm_usergroups AS a
LEFT JOIN i9kgm_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | 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 |
Temps de requête : 139.72 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.035 MB mémoire avant requête : 1.158 MB Rangées retournées : 143
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM i9kgm_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_extensions | NULL | ref | extension | extension | 82 | const | 197 | 0.60 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 139.01 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.13 ms |
| cleaning up | 0.02 ms |
| # | 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 |
Temps de requête : 31.31 ms Après la dernière requête : 7.55 ms Mémoire de requête : 0.022 MB mémoire avant requête : 1.619 MB Rangées retournées : 1
SELECT `value`
FROM `i9kgm_admintools_storage`
WHERE `key` = 'cparams'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_admintools_storage | NULL | const | PRIMARY | PRIMARY | 402 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 20.48 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 10.38 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1740 |
| 13 | JDatabaseDriver->loadResult() | JROOT\administrator\components\com_admintools\Helper\Storage.php:122 |
| 12 | Akeeba\AdminTools\Admin\Helper\Storage->load() | JROOT\administrator\components\com_admintools\Helper\Storage.php:37 |
| 11 | Akeeba\AdminTools\Admin\Helper\Storage->__construct() | JROOT\administrator\components\com_admintools\Helper\Storage.php:49 |
| 10 | Akeeba\AdminTools\Admin\Helper\Storage::getInstance() | JROOT\plugins\system\admintools\admintools\main.php:409 |
| 9 | plgSystemAdmintools->loadComponentParameters() | JROOT\plugins\system\admintools\admintools\main.php:892 |
| 8 | plgSystemAdmintools->initialize() | JROOT\plugins\system\admintools\admintools\main.php:84 |
| 7 | plgSystemAdmintools->__construct() | JROOT\libraries\src\Plugin\PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT\libraries\src\Plugin\PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT\libraries\src\Application\CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 50.72 ms Après la dernière requête : 1.44 ms Mémoire de requête : 0.022 MB mémoire avant requête : 1.650 MB Rangées retournées : 2
SELECT *
FROM i9kgm_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_languages | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | 50.00 | Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 35.71 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 14.68 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.03 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Language\LanguageHelper.php:150 |
| 11 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT\plugins\system\admintools\admintools\main.php:700 |
| 10 | plgSystemAdmintools->loadWAFExceptionsSEF() | JROOT\plugins\system\admintools\admintools\main.php:640 |
| 9 | plgSystemAdmintools->loadWAFExceptions() | JROOT\plugins\system\admintools\admintools\main.php:901 |
| 8 | plgSystemAdmintools->initialize() | JROOT\plugins\system\admintools\admintools\main.php:84 |
| 7 | plgSystemAdmintools->__construct() | JROOT\libraries\src\Plugin\PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT\libraries\src\Plugin\PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT\libraries\src\Application\CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 1.55 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.659 MB Rangées retournées : 0
SELECT *
FROM `i9kgm_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_admintools_wafexceptions | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.05 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1506 |
| 11 | JDatabaseDriver->loadAssocList() | JROOT\plugins\system\admintools\admintools\main.php:729 |
| 10 | plgSystemAdmintools->loadWAFExceptionsSEF() | JROOT\plugins\system\admintools\admintools\main.php:640 |
| 9 | plgSystemAdmintools->loadWAFExceptions() | JROOT\plugins\system\admintools\admintools\main.php:901 |
| 8 | plgSystemAdmintools->initialize() | JROOT\plugins\system\admintools\admintools\main.php:84 |
| 7 | plgSystemAdmintools->__construct() | JROOT\libraries\src\Plugin\PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT\libraries\src\Plugin\PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT\libraries\src\Application\CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 0.53 ms Après la dernière requête : 9.33 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.111 MB Rangées retournées : 4
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `i9kgm_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_extensions | NULL | ref | extension | extension | 82 | const | 4 | 1.25 | Using where |
| Status | Duration |
|---|
| starting | 0.11 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.08 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Language\LanguageHelper.php:209 |
| 8 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT\plugins\system\languagefilter\languagefilter.php:110 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT\libraries\src\Plugin\PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT\libraries\src\Plugin\PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT\libraries\src\Application\CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 0.20 ms Après la dernière requête : 4.23 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.272 MB Rangées retournées : 0
SELECT *
FROM `i9kgm_admintools_ipautoban`
WHERE `ip` = '216.73.216.136'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1662 |
| 12 | JDatabaseDriver->loadObject() | JROOT\plugins\system\admintools\feature\autoipfiltering.php:74 |
| 11 | AtsystemFeatureAutoipfiltering->isIPBlocked() | JROOT\plugins\system\admintools\feature\autoipfiltering.php:23 |
| 10 | AtsystemFeatureAutoipfiltering->onAfterInitialise() | JROOT\plugins\system\admintools\admintools\main.php:308 |
| 9 | plgSystemAdmintools->runFeature() | JROOT\plugins\system\admintools\admintools\main.php:144 |
| 8 | plgSystemAdmintools->onAfterInitialise() | 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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 0.17 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.277 MB Rangées retournées : 49
SELECT `ip`
FROM `i9kgm_admintools_ipblock`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_admintools_ipblock | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 34 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1550 |
| 12 | JDatabaseDriver->loadColumn() | JROOT\plugins\system\admintools\feature\ipblacklist.php:143 |
| 11 | AtsystemFeatureIpblacklist->isIPBlocked() | JROOT\plugins\system\admintools\feature\ipblacklist.php:37 |
| 10 | AtsystemFeatureIpblacklist->onAfterInitialise() | JROOT\plugins\system\admintools\admintools\main.php:308 |
| 9 | plgSystemAdmintools->runFeature() | JROOT\plugins\system\admintools\admintools\main.php:144 |
| 8 | plgSystemAdmintools->onAfterInitialise() | 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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 20.11 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.286 MB Rangées retournées : 1
SELECT *
FROM `i9kgm_admintools_storage`
WHERE `key` LIKE 'timestamp_%'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_admintools_storage | NULL | range | PRIMARY | PRIMARY | 402 | NULL | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.03 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 19.79 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1506 |
| 13 | JDatabaseDriver->loadAssocList() | JROOT\plugins\system\admintools\feature\abstract.php:277 |
| 12 | AtsystemFeatureAbstract->loadTimestamps() | JROOT\plugins\system\admintools\feature\abstract.php:356 |
| 11 | AtsystemFeatureAbstract->getTimestamp() | JROOT\plugins\system\admintools\feature\disableobsoleteadmins.php:115 |
| 10 | AtsystemFeatureDisableobsoleteadmins->onAfterInitialise() | JROOT\plugins\system\admintools\admintools\main.php:308 |
| 9 | plgSystemAdmintools->runFeature() | JROOT\plugins\system\admintools\admintools\main.php:144 |
| 8 | plgSystemAdmintools->onAfterInitialise() | 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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 41.56 ms Après la dernière requête : 0.67 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.295 MB Rangées retournées : 0
SELECT `source`,`keepurlparams`
FROM `i9kgm_admintools_redirects`
WHERE ((`dest` = 'fr/recherche-simple/simple/Sujet/2/Soins+en+phase+terminale+:+Aspect+psychologique/perso') OR (`dest` = 'fr/recherche-simple/simple/Sujet/2/Soins+en+phase+terminale+:+Aspect+psychologique/perso') OR ('fr/recherche-simple/simple/Sujet/2/Soins+en+phase+terminale+:+Aspect+psychologique/perso' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_admintools_redirects | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | 100.00 | Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.14 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 41.13 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1773 |
| 11 | JDatabaseDriver->loadRow() | JROOT\plugins\system\admintools\feature\urlredir.php:91 |
| 10 | AtsystemFeatureUrlredir->onAfterInitialise() | JROOT\plugins\system\admintools\admintools\main.php:308 |
| 9 | plgSystemAdmintools->runFeature() | JROOT\plugins\system\admintools\admintools\main.php:144 |
| 8 | plgSystemAdmintools->onAfterInitialise() | 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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 391.57 ms Après la dernière requête : 1.04 ms Mémoire de requête : 0.233 MB mémoire avant requête : 2.328 MB Rangées retournées : 209
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 i9kgm_menu AS m
LEFT JOIN i9kgm_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
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_client_id_parent_id_alias_language | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 342 | 7.60 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 07812-st-germain-laye.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 391.08 ms |
| end | 0.02 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Menu\SiteMenu.php:93 |
| 21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Même appel que celui de la ligne ci-dessous. |
| 20 | call_user_func_array() | JROOT\libraries\src\Cache\Controller\CallbackController.php:173 |
| 19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT\libraries\src\Menu\SiteMenu.php:101 |
| 18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT\libraries\src\Menu\AbstractMenu.php:78 |
| 17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT\libraries\src\Menu\SiteMenu.php:62 |
| 16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT\libraries\src\Menu\AbstractMenu.php:142 |
| 15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT\libraries\src\Application\CMSApplication.php:417 |
| 14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT\libraries\src\Application\SiteApplication.php:275 |
| 13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT\libraries\src\Router\SiteRouter.php:65 |
| 12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT\libraries\src\Router\Router.php:189 |
| 11 | Joomla\CMS\Router\Router::getInstance() | JROOT\libraries\src\Application\CMSApplication.php:533 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT\libraries\src\Application\SiteApplication.php:403 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT\plugins\system\languagefilter\languagefilter.php:145 |
| 8 | PlgSystemLanguageFilter->onAfterInitialise() | 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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 80.19 ms Après la dernière requête : 5.53 ms Mémoire de requête : 5.923 MB mémoire avant requête : 3.227 MB Rangées retournées : 43621
SELECT `id`,`name`,`type`,`hits`
FROM `i9kgm_opac_stoprobot`
WHERE `state` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_stoprobot | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 43621 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 76.36 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT\components\com_opac\helpers\divers.php:1279 |
| 9 | OpacHelperDivers::is_robot() | JROOT\plugins\system\opac_cas\opac_cas.php:67 |
| 8 | plgSystemOpac_Cas->onAfterInitialise() | 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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 73.55 ms Après la dernière requête : 39.11 ms Mémoire de requête : 0.021 MB mémoire avant requête : 3.720 MB Rangées retournées : 1
SELECT *
FROM `i9kgm_opac_config`
WHERE `act` = 279
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_config | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 324 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 73.09 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1662 |
| 10 | JDatabaseDriver->loadObject() | JROOT\components\com_opac\helpers\divers.php:810 |
| 9 | OpacHelperDivers::getValCfg() | JROOT\plugins\system\opac\opac.php:51 |
| 8 | plgSystemOpac->onAfterInitialise() | 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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 261.28 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.005 MB mémoire avant requête : 3.727 MB
DELETE
FROM i9kgm_opac_log_entries
WHERE date < '2025-10-22 09:55:29'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | DELETE | i9kgm_opac_log_entries | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 16540 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 3.54 ms |
| updating | 241.66 ms |
| end | 15.71 ms |
| query end | 0.01 ms |
| closing tables | 0.18 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT\plugins\system\opac\opac.php:58 |
| 8 | plgSystemOpac->onAfterInitialise() | 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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 10.86 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.021 MB mémoire avant requête : 3.735 MB Rangées retournées : 2
SELECT id, home, template, s.params
FROM i9kgm_template_styles as s
LEFT JOIN i9kgm_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
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 6 | 1.00 | Using index condition; Using where |
| 1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | 07812-st-germain-laye.e.element | 1 | 66.67 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 10.49 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Application\SiteApplication.php:486 |
| 9 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT\plugins\system\rgaac3rb\rgaac3rb.php:69 |
| 8 | plgSystemRgaac3rb->onAfterInitialise() | 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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 0.59 ms Après la dernière requête : 4.33 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.955 MB Rangées retournées : 3
SELECT element, enabled
FROM i9kgm_extensions
WHERE element IN('com_opac','com_c3rbagents','com_droppics','com_weblinks')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_extensions | NULL | range | element_clientid,element_folder_clientid | element_clientid | 402 | NULL | 4 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.13 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.07 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1506 |
| 10 | JDatabaseDriver->loadAssocList() | JROOT\administrator\components\com_c3rbevenement\src\C3rbevenement\Helper\DependencyHelper.php:16 |
| 9 | C3rbevenement\Helper\DependencyHelper::checkEnabled() | JROOT\administrator\components\com_c3rbevenement\src\init.php:13 |
| 8 | include_once JROOT\administrator\components\com_c3rbevenement\src\init.php | JROOT\components\com_c3rbevenement\router.php:7 |
| 7 | require_once JROOT\components\com_c3rbevenement\router.php | JROOT\libraries\src\Router\SiteRouter.php:779 |
| 6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT\libraries\src\Router\SiteRouter.php:131 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT\libraries\src\Application\CMSApplication.php:1142 |
| 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 |
Temps de requête : 57.56 ms Après la dernière requête : 8.44 ms Mémoire de requête : 5.923 MB mémoire avant requête : 4.259 MB Rangées retournées : 43621
SELECT `id`,`name`,`type`,`hits`
FROM `i9kgm_opac_stoprobot`
WHERE `state` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_stoprobot | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 43621 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 56.59 ms |
| end | 0.03 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.17 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT\components\com_opac\helpers\divers.php:1279 |
| 10 | OpacHelperDivers::is_robot() | JROOT\components\com_opac\router.php:654 |
| 9 | OpacRouter->parse() | JROOT\libraries\src\Router\SiteRouter.php:438 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT\libraries\src\Router\Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT\libraries\src\Router\Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT\libraries\src\Router\SiteRouter.php:139 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT\libraries\src\Application\CMSApplication.php:1142 |
| 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 |
Temps de requête : 1.02 ms Après la dernière requête : 41.13 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.265 MB Rangées retournées : 1
SELECT *
FROM `i9kgm_opac_config`
WHERE `act` = 1044
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_config | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 324 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.43 ms |
| optimizing | 0.03 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1662 |
| 12 | JDatabaseDriver->loadObject() | JROOT\components\com_opac\helpers\divers.php:810 |
| 11 | OpacHelperDivers::getValCfg() | JROOT\components\com_opac\helpers\divers.php:981 |
| 10 | OpacHelperDivers::sef_to_str() | JROOT\components\com_opac\router.php:661 |
| 9 | OpacRouter->parse() | JROOT\libraries\src\Router\SiteRouter.php:438 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT\libraries\src\Router\Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT\libraries\src\Router\Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT\libraries\src\Router\SiteRouter.php:139 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT\libraries\src\Application\CMSApplication.php:1142 |
| 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 |
Temps de requête : 161.90 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.274 MB Rangées retournées : 1
SELECT *
FROM `i9kgm_admintools_wafblacklists`
WHERE `verb` IN('','GET')
AND `option` IN('','com_opac')
AND `view` IN('','results')
AND `task` IN('','rechsimple','results.rechsimple')
AND `enabled` = '1'
GROUP BY `query`
ORDER BY `query` ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_admintools_wafblacklists | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 3 | 33.33 | Using where; Using temporary; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 112.79 ms |
| Creating sort index | 15.30 ms |
| end | 0.03 ms |
| query end | 0.01 ms |
| removing tmp table | 33.38 ms |
| query end | 0.03 ms |
| closing tables | 0.03 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT\plugins\system\admintools\feature\wafblacklist.php:92 |
| 10 | AtsystemFeatureWafblacklist->onAfterRoute() | JROOT\plugins\system\admintools\admintools\main.php:308 |
| 9 | plgSystemAdmintools->runFeature() | JROOT\plugins\system\admintools\admintools\main.php:154 |
| 8 | plgSystemAdmintools->onAfterRoute() | JROOT\libraries\joomla\event\event.php:70 |
| 7 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT\libraries\src\Application\SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT\libraries\src\Application\SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 56.76 ms Après la dernière requête : 3.01 ms Mémoire de requête : 5.923 MB mémoire avant requête : 4.643 MB Rangées retournées : 43621
SELECT `id`,`name`,`type`,`hits`
FROM `i9kgm_opac_stoprobot`
WHERE `state` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_stoprobot | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 43621 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 55.72 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT\components\com_opac\helpers\divers.php:1279 |
| 9 | OpacHelperDivers::is_robot() | JROOT\plugins\system\opac\opac.php:262 |
| 8 | plgSystemOpac->onAfterRoute() | JROOT\libraries\joomla\event\event.php:70 |
| 7 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT\libraries\src\Application\SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT\libraries\src\Application\SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT\libraries\src\Application\CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 20.71 ms Après la dernière requête : 32.84 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.731 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `i9kgm_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 20.28 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT\libraries\src\Helper\LibraryHelper.php:167 |
| 13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Même appel que celui de la ligne ci-dessous. |
| 12 | call_user_func_array() | JROOT\libraries\src\Cache\Controller\CallbackController.php:173 |
| 11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT\libraries\src\Helper\LibraryHelper.php:175 |
| 10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT\libraries\src\Helper\LibraryHelper.php:43 |
| 9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT\libraries\src\Helper\LibraryHelper.php:90 |
| 8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT\libraries\src\Version.php:321 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT\libraries\src\Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT\libraries\src\Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT\libraries\src\Application\WebApplication.php:1137 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT\libraries\src\Application\SiteApplication.php:133 |
| 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 |
Temps de requête : 31.36 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.721 MB
UPDATE `i9kgm_extensions`
SET `params` = '{\"mediaversion\":\"e2d0ac4e608725431243b670eaa2f1b9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | i9kgm_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.12 ms |
| updating | 16.04 ms |
| end | 0.03 ms |
| query end | 0.87 ms |
| closing tables | 13.90 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT\libraries\src\Helper\LibraryHelper.php:117 |
| 9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT\libraries\src\Version.php:372 |
| 8 | Joomla\CMS\Version->setMediaVersion() | JROOT\libraries\src\Version.php:331 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT\libraries\src\Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT\libraries\src\Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT\libraries\src\Application\WebApplication.php:1137 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT\libraries\src\Application\SiteApplication.php:133 |
| 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 |
Temps de requête : 72.11 ms Après la dernière requête : 1.78 ms Mémoire de requête : 5.923 MB mémoire avant requête : 4.981 MB Rangées retournées : 43621
SELECT `id`,`name`,`type`,`hits`
FROM `i9kgm_opac_stoprobot`
WHERE `state` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_stoprobot | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 43621 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 71.00 ms |
| end | 0.03 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.17 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT\components\com_opac\helpers\divers.php:1279 |
| 7 | OpacHelperDivers::is_robot() | JROOT\components\com_opac\opac.php:78 |
| 6 | require_once JROOT\components\com_opac\opac.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 |
Temps de requête : 43.15 ms Après la dernière requête : 36.71 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.988 MB Rangées retournées : 1
SELECT *
FROM `i9kgm_opac_config`
WHERE `act` = 250
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_config | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 324 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 8.39 ms |
| optimizing | 0.02 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 34.38 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1662 |
| 8 | JDatabaseDriver->loadObject() | JROOT\components\com_opac\helpers\divers.php:810 |
| 7 | OpacHelperDivers::getValCfg() | JROOT\components\com_opac\opac.php:86 |
| 6 | require_once JROOT\components\com_opac\opac.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 |
Temps de requête : 0.75 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.980 MB Rangées retournées : 3
SELECT language,id
FROM `i9kgm_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_menu | NULL | ALL | idx_client_id_parent_id_alias_language | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 342 | 0.76 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.24 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Language\Multilanguage.php:107 |
| 8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT\plugins\system\languagefilter\languagefilter.php:751 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT\libraries\joomla\event\event.php:70 |
| 6 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\SiteApplication.php:199 |
| 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 |
Temps de requête : 116.98 ms Après la dernière requête : 1.18 ms Mémoire de requête : 5.926 MB mémoire avant requête : 4.996 MB Rangées retournées : 43621
SELECT `id`,`name`,`type`,`hits`
FROM `i9kgm_opac_stoprobot`
WHERE `state` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_stoprobot | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 43621 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 116.01 ms |
| end | 0.03 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.13 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT\components\com_opac\helpers\divers.php:1279 |
| 16 | OpacHelperDivers::is_robot() | JROOT\components\com_opac\router.php:199 |
| 15 | OpacRouter->build_spl() | JROOT\components\com_opac\router.php:105 |
| 14 | OpacRouter->build() | JROOT\libraries\src\Router\SiteRouter.php:532 |
| 13 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT\libraries\src\Router\SiteRouter.php:502 |
| 12 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT\libraries\src\Router\Router.php:281 |
| 11 | Joomla\CMS\Router\Router->build() | JROOT\libraries\src\Router\SiteRouter.php:155 |
| 10 | Joomla\CMS\Router\SiteRouter->build() | JROOT\libraries\src\Router\Route.php:144 |
| 9 | Joomla\CMS\Router\Route::link() | JROOT\libraries\src\Router\Route.php:93 |
| 8 | Joomla\CMS\Router\Route::_() | JROOT\plugins\system\languagefilter\languagefilter.php:763 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT\libraries\joomla\event\event.php:70 |
| 6 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\SiteApplication.php:199 |
| 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 |
Temps de requête : 65.60 ms Après la dernière requête : 34.50 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.024 MB Rangées retournées : 1
SELECT *
FROM `i9kgm_opac_config`
WHERE `act` = 1700
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_config | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 324 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 65.05 ms |
| end | 0.04 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1662 |
| 11 | JDatabaseDriver->loadObject() | JROOT\components\com_opac\helpers\divers.php:810 |
| 10 | OpacHelperDivers::getValCfg() | JROOT\components\com_opac\helpers\urlmedia.php:201 |
| 9 | OpacHelperUrlMedia::add_constantes_js() | JROOT\components\com_opac\helpers\urlmedia.php:173 |
| 8 | OpacHelperUrlMedia::script() | JROOT\plugins\system\opac\opac.php:360 |
| 7 | plgSystemOpac->onAfterDispatch() | JROOT\libraries\joomla\event\event.php:70 |
| 6 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\SiteApplication.php:199 |
| 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 |
Temps de requête : 52.68 ms Après la dernière requête : 1.56 ms Mémoire de requête : 0.020 MB mémoire avant requête : 5.030 MB Rangées retournées : 1
SELECT *
FROM `i9kgm_opac_config`
WHERE `act` = 1000
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_config | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 324 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 52.38 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1662 |
| 9 | JDatabaseDriver->loadObject() | JROOT\components\com_opac\helpers\divers.php:810 |
| 8 | OpacHelperDivers::getValCfg() | JROOT\plugins\system\opac\opac.php:366 |
| 7 | plgSystemOpac->onAfterDispatch() | JROOT\libraries\joomla\event\event.php:70 |
| 6 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\SiteApplication.php:199 |
| 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 |
Temps de requête : 570.87 ms Après la dernière requête : 2.13 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.085 MB Rangées retournées : 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM i9kgm_modules AS m
LEFT JOIN i9kgm_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN i9kgm_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-10-24 09:55:30')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-10-24 09:55:30')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 178 OR mm.menuid <= 0)
AND m.language IN ('fr-FR','*')
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | PRIMARY,published,newsfeeds,idx_language | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 101 | 1.54 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | 07812-st-germain-laye.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | 07812-st-germain-laye.m.id | 8 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.13 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.13 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 531.32 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 38.87 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | Même appel que celui de la ligne ci-dessous. |
| 14 | call_user_func_array() | JROOT\libraries\src\Cache\Controller\CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT\libraries\src\Helper\ModuleHelper.php:441 |
| 12 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT\libraries\src\Helper\ModuleHelper.php:371 |
| 11 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT\libraries\src\Helper\ModuleHelper.php:87 |
| 10 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT\libraries\src\Document\HtmlDocument.php:601 |
| 9 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT\templates\c3rb_rgaa\layout\fullwidthFixed.php:2 |
| 8 | include_once JROOT\templates\c3rb_rgaa\layout\fullwidthFixed.php | JROOT\templates\c3rb_rgaa\index.php:55 |
| 7 | require JROOT\templates\c3rb_rgaa\index.php | JROOT\libraries\src\Document\HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT\libraries\src\Application\CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 110.24 ms Après la dernière requête : 11.13 ms Mémoire de requête : 0.033 MB mémoire avant requête : 5.276 MB Rangées retournées : 38
SHOW FULL COLUMNS
FROM `i9kgm_c3rbevenement_libraries`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `i9kgm_c3rbevenement_libraries`
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 20.65 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| Opening tables | 15.48 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.02 ms |
| Sending data | 73.42 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.14 ms |
| closing tables | 0.01 ms |
| freeing items | 0.42 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT\libraries\joomla\database\driver\mysqli.php:448 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT\modules\mod_c3rbevenement_schedules\helper\helper.php:39 |
| 13 | ModC3rbevenement_schedulesHelper::getSelectList() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:134 |
| 12 | ModC3rbevenement_schedulesModel->getLocationsData() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:35 |
| 11 | ModC3rbevenement_schedulesModel->getItems() | JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php:9 |
| 10 | include JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 0.46 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.041 MB mémoire avant requête : 5.295 MB Rangées retournées : 1
SELECT `location`.*,
`location`.`id` AS `location_id`,
`location`.`asset_id` AS `location_asset_id`,
`location`.`title` AS `location_title`,
`location`.`alias` AS `location_alias`,
`location`.`email` AS `location_email`,
`location`.`phone` AS `location_phone`,
`location`.`mobile` AS `location_mobile`,
`location`.`fax` AS `location_fax`,
`location`.`website` AS `location_website`,
`location`.`facebook` AS `location_facebook`,
`location`.`instagram` AS `location_instagram`,
`location`.`youtube` AS `location_youtube`,
`location`.`latitude` AS `location_latitude`,
`location`.`longitude` AS `location_longitude`,
`location`.`street_address` AS `location_street_address`,
`location`.`postal_code` AS `location_postal_code`,
`location`.`po_box_number` AS `location_po_box_number`,
`location`.`locality` AS `location_locality`,
`location`.`region` AS `location_region`,
`location`.`country` AS `location_country`,
`location`.`introtext` AS `location_introtext`,
`location`.`moreinfos` AS `location_moreinfos`,
`location`.`images` AS `location_images`,
`location`.`created` AS `location_created`,
`location`.`created_by` AS `location_created_by`,
`location`.`modified` AS `location_modified`,
`location`.`modified_by` AS `location_modified_by`,
`location`.`ordering` AS `location_ordering`,
`location`.`state` AS `location_state`,
`location`.`checked_out` AS `location_checked_out`,
`location`.`checked_out_time` AS `location_checked_out_time`,
`location`.`access` AS `location_access`,
`location`.`params` AS `location_params`,
`location`.`affluences_counter_token` AS `location_affluences_counter_token`,
`location`.`affluences_timetable_token` AS `location_affluences_timetable_token`,
`location`.`show_on_map` AS `location_show_on_map`,
`location`.`map_marker_params` AS `location_map_marker_params`,
`location`.`menuitem_detail` AS `location_menuitem_detail`
FROM i9kgm_c3rbevenement_libraries AS location
WHERE location.state > 0
AND location.access
IN(1,1,5)
AND `id` = 3
ORDER BY field(id, 3)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | location | NULL | const | PRIMARY,idx_access,cat_index | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.25 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:152 |
| 12 | ModC3rbevenement_schedulesModel->getLocationsData() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:35 |
| 11 | ModC3rbevenement_schedulesModel->getItems() | JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php:9 |
| 10 | include JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 50.50 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.320 MB Rangées retournées : 1
SELECT DISTINCT(`section_id`) AS `id`,IFNULL(`sections`.`title`,'Non définie') AS `libelle`
FROM `i9kgm_c3rbevenement_schedules` AS `schedules`
LEFT JOIN `i9kgm_c3rbevenement_schedulesections` AS `sections`
ON `sections`.`id` = `schedules`.`section_id`
WHERE
(`library_id` = 3
AND `schedules`.`state` = 1)
AND
(`sections`.`state` IS NULL OR `sections`.`state` = 1)
ORDER BY `sections`.`ordering` ASC,`libelle` ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | sections | NULL | system | PRIMARY | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
| 1 | SIMPLE | schedules | NULL | ref | cat_index,library_id | cat_index | 1 | const | 9 | 38.46 | Using index condition; Using where; Using temporary |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 17.46 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| removing tmp table | 2.80 ms |
| query end | 0.01 ms |
| closing tables | 29.86 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:64 |
| 13 | ModC3rbevenement_schedulesModel->getSectionsSchedules() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:163 |
| 12 | ModC3rbevenement_schedulesModel->getLocationsData() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:35 |
| 11 | ModC3rbevenement_schedulesModel->getItems() | JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php:9 |
| 10 | include JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 18.06 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.328 MB Rangées retournées : 5
SELECT `id`,`day`,`morning_open`,`morning_start`,`morning_start_note`,`morning_end`,`morning_end_note`,`afternoon_open`,`afternoon_start`,`afternoon_start_note`,`afternoon_end`,`afternoon_end_note`,`continuous_day`,`from_date`,`to_date`
FROM i9kgm_c3rbevenement_schedules
WHERE `state` > 0
AND `library_id` = 3
AND `section_id` = 0
AND ((ISNULL(`from_date`) OR `from_date`='0000-00-00 00:00:00') OR `from_date` <= NOW())
AND ((ISNULL(`to_date`) OR `to_date`='0000-00-00 00:00:00') OR `to_date` >= NOW())
ORDER BY FIELD(`day`,1,2,3,4,5,6,0), `from_date` ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_c3rbevenement_schedules | NULL | ref | cat_index,library_id | library_id | 4 | const | 10 | 3.85 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 17.65 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:244 |
| 13 | ModC3rbevenement_schedulesModel->getSchedules() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:166 |
| 12 | ModC3rbevenement_schedulesModel->getLocationsData() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:35 |
| 11 | ModC3rbevenement_schedulesModel->getItems() | JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php:9 |
| 10 | include JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 0.26 ms Après la dernière requête : 1.13 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.347 MB Rangées retournées : 0
SELECT `t`.`id`,`t`.`title`,`t`.`images`,`t`.`link`
FROM `i9kgm_c3rbevenement_libraryservices` AS `t`
INNER JOIN `i9kgm_c3rbevenement_libraryservices_map` AS m
ON m.libraryservices_id = t.id
AND m.library_id = 3
WHERE `state` = 1
ORDER BY `ordering` ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:306 |
| 13 | ModC3rbevenement_schedulesModel->getLibraryMap() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:187 |
| 12 | ModC3rbevenement_schedulesModel->getLocationsData() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:35 |
| 11 | ModC3rbevenement_schedulesModel->getItems() | JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php:9 |
| 10 | include JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 0.45 ms Après la dernière requête : 4.06 ms Mémoire de requête : 0.041 MB mémoire avant requête : 5.830 MB Rangées retournées : 1
SELECT `location`.*,
`location`.`id` AS `location_id`,
`location`.`asset_id` AS `location_asset_id`,
`location`.`title` AS `location_title`,
`location`.`alias` AS `location_alias`,
`location`.`email` AS `location_email`,
`location`.`phone` AS `location_phone`,
`location`.`mobile` AS `location_mobile`,
`location`.`fax` AS `location_fax`,
`location`.`website` AS `location_website`,
`location`.`facebook` AS `location_facebook`,
`location`.`instagram` AS `location_instagram`,
`location`.`youtube` AS `location_youtube`,
`location`.`latitude` AS `location_latitude`,
`location`.`longitude` AS `location_longitude`,
`location`.`street_address` AS `location_street_address`,
`location`.`postal_code` AS `location_postal_code`,
`location`.`po_box_number` AS `location_po_box_number`,
`location`.`locality` AS `location_locality`,
`location`.`region` AS `location_region`,
`location`.`country` AS `location_country`,
`location`.`introtext` AS `location_introtext`,
`location`.`moreinfos` AS `location_moreinfos`,
`location`.`images` AS `location_images`,
`location`.`created` AS `location_created`,
`location`.`created_by` AS `location_created_by`,
`location`.`modified` AS `location_modified`,
`location`.`modified_by` AS `location_modified_by`,
`location`.`ordering` AS `location_ordering`,
`location`.`state` AS `location_state`,
`location`.`checked_out` AS `location_checked_out`,
`location`.`checked_out_time` AS `location_checked_out_time`,
`location`.`access` AS `location_access`,
`location`.`params` AS `location_params`,
`location`.`affluences_counter_token` AS `location_affluences_counter_token`,
`location`.`affluences_timetable_token` AS `location_affluences_timetable_token`,
`location`.`show_on_map` AS `location_show_on_map`,
`location`.`map_marker_params` AS `location_map_marker_params`,
`location`.`menuitem_detail` AS `location_menuitem_detail`
FROM i9kgm_c3rbevenement_libraries AS location
WHERE location.state > 0
AND location.access
IN(1,1,5)
AND `id` = 4
ORDER BY field(id, 4)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | location | NULL | const | PRIMARY,idx_access,cat_index | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.06 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:152 |
| 12 | ModC3rbevenement_schedulesModel->getLocationsData() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:35 |
| 11 | ModC3rbevenement_schedulesModel->getItems() | JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php:9 |
| 10 | include JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 30.06 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.856 MB Rangées retournées : 1
SELECT DISTINCT(`section_id`) AS `id`,IFNULL(`sections`.`title`,'Non définie') AS `libelle`
FROM `i9kgm_c3rbevenement_schedules` AS `schedules`
LEFT JOIN `i9kgm_c3rbevenement_schedulesections` AS `sections`
ON `sections`.`id` = `schedules`.`section_id`
WHERE
(`library_id` = 4
AND `schedules`.`state` = 1)
AND
(`sections`.`state` IS NULL OR `sections`.`state` = 1)
ORDER BY `sections`.`ordering` ASC,`libelle` ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | sections | NULL | system | PRIMARY | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
| 1 | SIMPLE | schedules | NULL | ref | cat_index,library_id | library_id | 4 | const | 6 | 34.62 | Using index condition; Using where; Using temporary |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 26.96 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| removing tmp table | 2.38 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:64 |
| 13 | ModC3rbevenement_schedulesModel->getSectionsSchedules() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:163 |
| 12 | ModC3rbevenement_schedulesModel->getLocationsData() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:35 |
| 11 | ModC3rbevenement_schedulesModel->getItems() | JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php:9 |
| 10 | include JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 103.86 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.864 MB Rangées retournées : 4
SELECT `id`,`day`,`morning_open`,`morning_start`,`morning_start_note`,`morning_end`,`morning_end_note`,`afternoon_open`,`afternoon_start`,`afternoon_start_note`,`afternoon_end`,`afternoon_end_note`,`continuous_day`,`from_date`,`to_date`
FROM i9kgm_c3rbevenement_schedules
WHERE `state` > 0
AND `library_id` = 4
AND `section_id` = 0
AND ((ISNULL(`from_date`) OR `from_date`='0000-00-00 00:00:00') OR `from_date` <= NOW())
AND ((ISNULL(`to_date`) OR `to_date`='0000-00-00 00:00:00') OR `to_date` >= NOW())
ORDER BY FIELD(`day`,1,2,3,4,5,6,0), `from_date` ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_c3rbevenement_schedules | NULL | ref | cat_index,library_id | library_id | 4 | const | 6 | 3.85 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 103.41 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:244 |
| 13 | ModC3rbevenement_schedulesModel->getSchedules() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:166 |
| 12 | ModC3rbevenement_schedulesModel->getLocationsData() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:35 |
| 11 | ModC3rbevenement_schedulesModel->getItems() | JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php:9 |
| 10 | include JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 0.18 ms Après la dernière requête : 0.34 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.875 MB Rangées retournées : 0
SELECT `t`.`id`,`t`.`title`,`t`.`images`,`t`.`link`
FROM `i9kgm_c3rbevenement_libraryservices` AS `t`
INNER JOIN `i9kgm_c3rbevenement_libraryservices_map` AS m
ON m.libraryservices_id = t.id
AND m.library_id = 4
WHERE `state` = 1
ORDER BY `ordering` ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:306 |
| 13 | ModC3rbevenement_schedulesModel->getLibraryMap() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:187 |
| 12 | ModC3rbevenement_schedulesModel->getLocationsData() | JROOT\modules\mod_c3rbevenement_schedules\model\model.php:35 |
| 11 | ModC3rbevenement_schedulesModel->getItems() | JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php:9 |
| 10 | include JROOT\modules\mod_c3rbevenement_schedules\mod_c3rbevenement_schedules.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 55.11 ms Après la dernière requête : 10.42 ms Mémoire de requête : 5.924 MB mémoire avant requête : 6.259 MB Rangées retournées : 43621
SELECT `id`,`name`,`type`,`hits`
FROM `i9kgm_opac_stoprobot`
WHERE `state` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_stoprobot | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 43621 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 54.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.12 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT\components\com_opac\helpers\divers.php:1279 |
| 11 | OpacHelperDivers::is_robot() | JROOT\modules\mod_opac_rech_rapide\mod_opac_rech_rapide.php:36 |
| 10 | include JROOT\modules\mod_opac_rech_rapide\mod_opac_rech_rapide.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 121.03 ms Après la dernière requête : 39.36 ms Mémoire de requête : 5.924 MB mémoire avant requête : 6.295 MB Rangées retournées : 43621
SELECT `id`,`name`,`type`,`hits`
FROM `i9kgm_opac_stoprobot`
WHERE `state` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_opac_stoprobot | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 43621 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 119.98 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT\components\com_opac\helpers\divers.php:1279 |
| 11 | OpacHelperDivers::is_robot() | JROOT\modules\mod_opac_login\mod_opac_login.php:39 |
| 10 | include JROOT\modules\mod_opac_login\mod_opac_login.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 0.90 ms Après la dernière requête : 34.54 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.372 MB Rangées retournées : 2
SELECT `c2`.`language`,`c2`.`id`
FROM `i9kgm_menu` AS `c`
INNER JOIN `i9kgm_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `i9kgm_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `i9kgm_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 178
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_key | PRIMARY | 206 | const,const | 1 | 100.00 | NULL |
| 1 | SIMPLE | a2 | NULL | ref | idx_key | idx_key | 128 | const | 2 | 100.00 | Using index |
| 1 | SIMPLE | c2 | NULL | eq_ref | PRIMARY | PRIMARY | 4 | 07812-st-germain-laye.a2.id | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.14 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.16 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Language\Associations.php:115 |
| 13 | Joomla\CMS\Language\Associations::getAssociations() | JROOT\administrator\components\com_menus\helpers\menus.php:321 |
| 12 | MenusHelper::getAssociations() | JROOT\modules\mod_languages\helper.php:58 |
| 11 | ModLanguagesHelper::getList() | JROOT\modules\mod_languages\mod_languages.php:17 |
| 10 | include JROOT\modules\mod_languages\mod_languages.php | JROOT\libraries\src\Helper\ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT\libraries\src\Document\HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT\libraries\src\Document\HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT\libraries\src\Document\HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT\libraries\src\Application\CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 53.02 ms Après la dernière requête : 7.58 ms Mémoire de requête : 0.021 MB mémoire avant requête : 6.466 MB Rangées retournées : 1
SELECT `value`
FROM `i9kgm_admintools_storage`
WHERE `key` = 'criticalfiles'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_admintools_storage | NULL | const | PRIMARY | PRIMARY | 402 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 25.42 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 27.27 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1740 |
| 11 | JDatabaseDriver->loadResult() | JROOT\plugins\system\admintools\feature\criticalfiles.php:204 |
| 10 | AtsystemFeatureCriticalfiles->load() | JROOT\plugins\system\admintools\feature\criticalfiles.php:32 |
| 9 | AtsystemFeatureCriticalfiles->onAfterRender() | JROOT\plugins\system\admintools\admintools\main.php:308 |
| 8 | plgSystemAdmintools->runFeature() | JROOT\plugins\system\admintools\admintools\main.php:187 |
| 7 | plgSystemAdmintools->onAfterRender() | JROOT\libraries\joomla\event\event.php:70 |
| 6 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\CMSApplication.php:1118 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 336.68 ms Après la dernière requête : 3.36 ms Mémoire de requête : 0.039 MB mémoire avant requête : 6.533 MB Rangées retournées : 375
SHOW TABLES
EXPLAIN impossible sur la requête : SHOW TABLES
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| checking permissions | 296.62 ms |
| Sending data | 0.16 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 39.55 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1550 |
| 15 | JDatabaseDriver->loadColumn() | JROOT\libraries\joomla\database\driver\mysqli.php:505 |
| 14 | JDatabaseDriverMysqli->getTableList() | JROOT\administrator\components\com_acymailing\compat\joomla.php:725 |
| 13 | acymailing_getTableList() | JROOT\administrator\components\com_acymailing\classes\cpanel.php:19 |
| 12 | cpanelClass->load() | JROOT\administrator\components\com_acymailing\helpers\helper.php:544 |
| 11 | acymailing_config() | JROOT\administrator\components\com_acymailing\compat\joomla.php:1102 |
| 10 | include_once JROOT\administrator\components\com_acymailing\compat\joomla.php | JROOT\administrator\components\com_acymailing\helpers\helper.php:22 |
| 9 | include_once JROOT\administrator\components\com_acymailing\helpers\helper.php | JROOT\plugins\system\regacymailing\regacymailing.php:26 |
| 8 | plgSystemRegacymailing->initAcy() | JROOT\plugins\system\regacymailing\regacymailing.php:150 |
| 7 | plgSystemRegacymailing->onAfterRender() | JROOT\libraries\joomla\event\event.php:70 |
| 6 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\CMSApplication.php:1118 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Temps de requête : 185.52 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.033 MB mémoire avant requête : 6.578 MB Rangées retournées : 137
SELECT *
FROM i9kgm_acymailing_config
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i9kgm_acymailing_config | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 136 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 167.88 ms |
| end | 0.03 ms |
| query end | 0.01 ms |
| closing tables | 17.11 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT\libraries\joomla\database\driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT\administrator\components\com_acymailing\compat\joomla.php:629 |
| 13 | acymailing_loadObjectList() | JROOT\administrator\components\com_acymailing\classes\cpanel.php:24 |
| 12 | cpanelClass->load() | JROOT\administrator\components\com_acymailing\helpers\helper.php:544 |
| 11 | acymailing_config() | JROOT\administrator\components\com_acymailing\compat\joomla.php:1102 |
| 10 | include_once JROOT\administrator\components\com_acymailing\compat\joomla.php | JROOT\administrator\components\com_acymailing\helpers\helper.php:22 |
| 9 | include_once JROOT\administrator\components\com_acymailing\helpers\helper.php | JROOT\plugins\system\regacymailing\regacymailing.php:26 |
| 8 | plgSystemRegacymailing->initAcy() | JROOT\plugins\system\regacymailing\regacymailing.php:150 |
| 7 | plgSystemRegacymailing->onAfterRender() | JROOT\libraries\joomla\event\event.php:70 |
| 6 | JEvent->update() | JROOT\libraries\joomla\event\dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Application\CMSApplication.php:1118 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
7 × SELECT `id`,`name`,`type`,`hits`
FROM `i9kgm_opac_stoprobot`
5 × SELECT *
FROM `i9kgm_opac_config`
2 × SELECT `value`
FROM `i9kgm_admintools_storage`
2 × SELECT `id`,`day`,`morning_open`,`morning_start`,`morning_start_note`,`morning_end`,`morning_end_note`,`afternoon_open`,`afternoon_start`,`afternoon_start_note`,`afternoon_end`,`afternoon_end_note`,`continuous_day`,`from_date`,`to_date`
FROM i9kgm_c3rbevenement_schedules
2 × SELECT DISTINCT(`section_id`) AS `id`,IFNULL(`sections`.`title`,'Non définie') AS `libelle`
FROM `i9kgm_c3rbevenement_schedules` AS `schedules`
LEFT JOIN `i9kgm_c3rbevenement_schedulesections` AS `sections`
ON `sections`.`id` = `schedules`.`section_id`
2 × SELECT `location`.*, `location`.`id` AS `location_id`, `location`.`asset_id` AS `location_asset_id`, `location`.`title` AS `location_title`, `location`.`alias` AS `location_alias`, `location`.`email` AS `location_email`, `location`.`phone` AS `location_phone`, `location`.`mobile` AS `location_mobile`, `location`.`fax` AS `location_fax`, `location`.`website` AS `location_website`, `location`.`facebook` AS `location_facebook`, `location`.`instagram` AS `location_instagram`, `location`.`youtube` AS `location_youtube`, `location`.`latitude` AS `location_latitude`, `location`.`longitude` AS `location_longitude`, `location`.`street_address` AS `location_street_address`, `location`.`postal_code` AS `location_postal_code`, `location`.`po_box_number` AS `location_po_box_number`, `location`.`locality` AS `location_locality`, `location`.`region` AS `location_region`, `location`.`country` AS `location_country`, `location`.`introtext` AS `location_introtext`, `location`.`moreinfos` AS `location_moreinfos`, `location`.`images` AS `location_images`, `location`.`created` AS `location_created`, `location`.`created_by` AS `location_created_by`, `location`.`modified` AS `location_modified`, `location`.`modified_by` AS `location_modified_by`, `location`.`ordering` AS `location_ordering`, `location`.`state` AS `location_state`, `location`.`checked_out` AS `location_checked_out`, `location`.`checked_out_time` AS `location_checked_out_time`, `location`.`access` AS `location_access`, `location`.`params` AS `location_params`, `location`.`affluences_counter_token` AS `location_affluences_counter_token`, `location`.`affluences_timetable_token` AS `location_affluences_timetable_token`, `location`.`show_on_map` AS `location_show_on_map`, `location`.`map_marker_params` AS `location_map_marker_params`, `location`.`menuitem_detail` AS `location_menuitem_detail`
FROM i9kgm_c3rbevenement_libraries AS location
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `i9kgm_extensions`
1 × SELECT `c2`.`language`,`c2`.`id`
FROM `i9kgm_menu` AS `c`
INNER JOIN `i9kgm_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `i9kgm_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `i9kgm_menu` AS `c2`
ON a2.id = c2.`id`
1 × SELECT `t`.`id`,`t`.`title`,`t`.`images`,`t`.`link`
FROM `i9kgm_c3rbevenement_libraryservices` AS `t`
INNER JOIN `i9kgm_c3rbevenement_libraryservices_map` AS m
ON m.libraryservices_id = t.id
AND m.library_id = 4
1 × SELECT `t`.`id`,`t`.`title`,`t`.`images`,`t`.`link`
FROM `i9kgm_c3rbevenement_libraryservices` AS `t`
INNER JOIN `i9kgm_c3rbevenement_libraryservices_map` AS m
ON m.libraryservices_id = t.id
AND m.library_id = 3
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM i9kgm_modules AS m
LEFT JOIN i9kgm_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN i9kgm_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT language,id
FROM `i9kgm_menu`
1 × SELECT *
FROM `i9kgm_admintools_wafblacklists`
1 × SELECT element, enabled
FROM i9kgm_extensions
1 × SELECT id, home, template, s.params
FROM i9kgm_template_styles as s
LEFT JOIN i9kgm_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `data`
FROM `i9kgm_session`
1 × 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 i9kgm_menu AS m
LEFT JOIN i9kgm_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `source`,`keepurlparams`
FROM `i9kgm_admintools_redirects`
1 × SELECT *
FROM `i9kgm_admintools_storage`
1 × SELECT `ip`
FROM `i9kgm_admintools_ipblock
1 × SELECT *
FROM `i9kgm_admintools_ipautoban`
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `i9kgm_extensions`
1 × SELECT *
FROM `i9kgm_admintools_wafexceptions`
1 × SELECT *
FROM i9kgm_languages
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM i9kgm_extensions
1 × SELECT b.id
FROM i9kgm_usergroups AS a
LEFT JOIN i9kgm_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `i9kgm_viewlevels
1 × SELECT *
FROM i9kgm_acymailing_confi
