Temps de requête : 3.49 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.039 MB Rangées retournées : 1
SELECT `data`
FROM `i9kgm_session`
WHERE `session_id` = X'6f6b3861346e68643062336e697165386c336b38356e6e386172'
| 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.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.62 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 1.45 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 1.10 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 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 : 4.97 ms Après la dernière requête : 0.68 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.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.63 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 3.75 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 |
|---|
| 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 : 10.37 ms Après la dernière requête : 0.44 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.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 3.07 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 | 7.03 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 |
|---|
| 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 : 1.10 ms Après la dernière requête : 0.27 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.08 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.79 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 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 |
|---|
| 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 : 9.83 ms Après la dernière requête : 0.19 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.05 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.05 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 9.26 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.08 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 : 5.65 ms Après la dernière requête : 7.09 ms Mémoire de requête : 0.022 MB mémoire avant requête : 1.618 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.06 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.57 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 2.01 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.01 ms |
| freeing items | 0.03 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 : 12.29 ms Après la dernière requête : 5.71 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.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.64 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 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 | 10.83 ms |
| end | 0.02 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 |
|---|
| 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 : 0.92 ms Après la dernière requête : 0.22 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.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.60 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 | 0.03 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 |
|---|
| 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.34 ms Après la dernière requête : 8.06 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.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.01 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.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 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.83 ms Après la dernière requête : 4.86 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.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.56 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 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 : 2.81 ms Après la dernière requête : 0.10 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.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.48 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 1.89 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.05 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 : 5.44 ms Après la dernière requête : 0.45 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.285 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.03 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.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 5.22 ms |
| end | 0.01 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 |
|---|
| 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 : 5.76 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.294 MB Rangées retournées : 0
SELECT `source`,`keepurlparams`
FROM `i9kgm_admintools_redirects`
WHERE ((`dest` = 'fr/recherche-simple/simple/Auteur/2/Giroux,+Maxime/perso') OR (`dest` = 'fr/recherche-simple/simple/Auteur/2/Giroux,+Maxime/perso') OR ('fr/recherche-simple/simple/Auteur/2/Giroux,+Maxime/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.06 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.46 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 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 | 5.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 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: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 : 14.44 ms Après la dernière requête : 0.99 ms Mémoire de requête : 0.233 MB mémoire avant requête : 2.327 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.08 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 4.00 ms |
| init | 0.03 ms |
| System lock | 0.01 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 | 10.03 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 |
|---|
| 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 : 32.99 ms Après la dernière requête : 4.59 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.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.26 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 31.74 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.11 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_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 : 0.83 ms Après la dernière requête : 39.65 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.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.30 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.10 ms |
| end | 0.00 ms |
| query end | 0.01 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 : 330.28 ms Après la dernière requête : 0.22 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:51:11'
| 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 | 16529 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.15 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for table level lock | 61.91 ms |
| System lock | 4.30 ms |
| updating | 248.81 ms |
| end | 8.05 ms |
| query end | 0.01 ms |
| closing tables | 6.85 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.02 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 : 65.45 ms Après la dernière requête : 0.35 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.07 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.63 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 51.98 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 12.37 ms |
| freeing items | 0.11 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.33 ms Après la dernière requête : 8.54 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.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 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 |
|---|
| 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 : 52.56 ms Après la dernière requête : 10.49 ms Mémoire de requête : 5.923 MB mémoire avant requête : 4.258 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 | 51.57 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.01 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 : 18.91 ms Après la dernière requête : 35.87 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.05 ms |
| checking permissions | 0.01 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 |
| executing | 0.00 ms |
| Sending data | 18.63 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 |
|---|
| 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 : 58.85 ms Après la dernière requête : 0.26 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.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 9.34 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 5.72 ms |
| Creating sort index | 37.55 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 5.77 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 |
|---|
| 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 : 40.83 ms Après la dernière requête : 2.88 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.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.00 ms |
| executing | 0.00 ms |
| Sending data | 39.87 ms |
| end | 0.01 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\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 : 23.90 ms Après la dernière requête : 37.26 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.730 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.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.12 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 18.41 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 4.84 ms |
| freeing items | 0.08 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 : 6.79 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.720 MB
UPDATE `i9kgm_extensions`
SET `params` = '{\"mediaversion\":\"e205545996b357483efa2f587dc431c4\"}'
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.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.07 ms |
| updating | 5.46 ms |
| end | 0.01 ms |
| query end | 1.06 ms |
| closing tables | 0.03 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 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 : 36.69 ms Après la dernière requête : 1.91 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.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 35.71 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 |
|---|
| 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 : 17.20 ms Après la dernière requête : 41.40 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.987 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.04 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 | 16.87 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 |
|---|
| 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.42 ms Après la dernière requête : 1.20 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.979 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.03 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.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.21 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.03 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 : 65.63 ms Après la dernière requête : 0.73 ms Mémoire de requête : 5.926 MB mémoire avant requête : 4.995 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.02 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.01 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 64.63 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 |
|---|
| 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 : 30.50 ms Après la dernière requête : 36.25 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.023 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.03 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.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 30.17 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 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 : 9.91 ms Après la dernière requête : 1.31 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.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 | 9.60 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 |
|---|
| 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 : 90.49 ms Après la dernière requête : 3.01 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:51:12')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-10-24 09:51:12')
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.12 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 3.29 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 86.58 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.01 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 : 105.29 ms Après la dernière requête : 11.27 ms Mémoire de requête : 0.033 MB mémoire avant requête : 5.275 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.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 3.35 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| Opening tables | 3.04 ms |
| checking permissions | 0.06 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.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.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.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 |
| Sending data | 87.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 11.28 ms |
| closing tables | 0.03 ms |
| freeing items | 0.06 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.48 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.041 MB mémoire avant requête : 5.294 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.01 ms |
| Opening tables | 0.02 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 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.01 ms |
| freeing items | 0.03 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 : 18.32 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.319 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.37 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.02 ms |
| executing | 0.00 ms |
| Sending data | 7.00 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| removing tmp table | 10.55 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.09 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 : 20.22 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.327 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.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 19.77 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 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\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 : 13.63 ms Après la dernière requête : 1.33 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.346 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.09 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 13.35 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.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 : 6.10 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.09 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 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 : 57.27 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.855 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.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.08 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 47.18 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| removing tmp table | 9.57 ms |
| query end | 0.02 ms |
| closing tables | 0.02 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 : 11.25 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.863 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.13 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 10.74 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 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.31 ms Après la dernière requête : 0.58 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.874 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.08 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.00 ms |
| freeing items | 0.02 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 : 32.76 ms Après la dernière requête : 11.68 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.11 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 | 31.59 ms |
| end | 0.02 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.10 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 : 55.34 ms Après la dernière requête : 37.16 ms Mémoire de requête : 5.924 MB mémoire avant requête : 6.294 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.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 | 54.23 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.13 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 : 5.80 ms Après la dernière requête : 35.56 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.371 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.07 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 5.25 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.14 ms |
| preparing | 0.01 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.05 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 : 21.83 ms Après la dernière requête : 6.35 ms Mémoire de requête : 0.021 MB mémoire avant requête : 6.465 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.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 | 14.84 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 6.74 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 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 : 60.55 ms Après la dernière requête : 4.51 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.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| checking permissions | 40.25 ms |
| Sending data | 0.18 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 19.43 ms |
| closing tables | 0.02 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.02 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 : 5.78 ms Après la dernière requête : 0.29 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.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.61 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 | 3.66 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 1.21 ms |
| freeing items | 0.06 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\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
