Temps de requête : 2.92 ms Mémoire de requête : 0.019 MB mémoire avant requête : 3.558 MB Rangées retournées : 0
SELECT `session_id`
FROM `oqkiz_session`
WHERE `session_id` = X'6264313166393766633362633966363332363435363335343637373338326334'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.23 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.18 ms |
| After opening tables | 0.22 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.09 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.21 ms |
| Preparing | 0.03 ms |
| Executing | 0.26 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Temps de requête : 74.73 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.003 MB mémoire avant requête : 3.562 MB
INSERT INTO `oqkiz_session`
(`session_id`,`guest`,`time`,`userid`,`username`)
VALUES
(X'6264313166393766633362633966363332363435363335343637373338326334', 1, 1730428160, 0, '')
EXPLAIN impossible sur la requête : INSERT INTO `oqkiz_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'6264313166393766633362633966363332363435363335343637373338326334', 1, 1730428160, 0, '')
| Status | Duration |
|---|
| Starting | 0.24 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.02 ms |
| Init for update | 0.07 ms |
| Update | 0.57 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 73.16 ms |
| Closing tables | 0.06 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Temps de requête : 5.93 ms Après la dernière requête : 49.86 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.725 MB Rangées retournées : 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oqkiz_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_extensions | ref | extension | extension | 82 | const | 44 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.37 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.14 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.33 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 2.46 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Même appel que celui de la ligne ci-dessous. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 3.01 ms Après la dernière requête : 49.31 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.879 MB Rangées retournées : 3
SELECT id, rules
FROM `oqkiz_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_viewlevels | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 3 | |
| Status | Duration |
|---|
| Starting | 0.21 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.06 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.07 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.07 ms |
| Preparing | 0.08 ms |
| Executing | 0.02 ms |
| Sending data | 0.67 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 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 : 3.57 ms Après la dernière requête : 0.83 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.888 MB Rangées retournées : 1
SELECT b.id
FROM oqkiz_usergroups AS a
LEFT JOIN oqkiz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.39 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.12 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.39 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.13 ms |
| Executing | 0.02 ms |
| Sending data | 0.43 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 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 : 17.00 ms Après la dernière requête : 8.05 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.947 MB Rangées retournées : 109
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM oqkiz_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_extensions | ref | extension | extension | 82 | const | 150 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| Starting | 0.34 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.17 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.33 ms |
| Preparing | 0.17 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.13 ms |
| Creating sort index | 14.64 ms |
| End of update loop | 0.06 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.10 ms |
| Closing tables | 0.20 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.04 ms |
| Updating status | 8.48 ms |
| Reset for next command | 0.05 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 : 2.27 ms Après la dernière requête : 374.68 ms Mémoire de requête : 0.020 MB mémoire avant requête : 5.474 MB Rangées retournées : 0
SELECT `name`
FROM `oqkiz_extensions`
WHERE `type` = 'package'
AND `element` = 'pkg_eventgallery_full'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.24 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.11 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.52 ms |
| Preparing | 0.15 ms |
| Executing | 0.02 ms |
| Sending data | 0.42 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 9 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_eventgallery/version.php:24 |
| 8 | include_once JROOT/administrator/components/com_eventgallery/version.php | JROOT/plugins/system/picasaupdater/picasaupdater.php:32 |
| 7 | plgSystemPicasaupdater->__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 : 8.22 ms Après la dernière requête : 266.95 ms Mémoire de requête : 0.062 MB mémoire avant requête : 6.059 MB Rangées retournées : 25
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 oqkiz_menu AS m
LEFT JOIN oqkiz_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 38 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.47 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 1.55 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.21 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.33 ms |
| Preparing | 0.20 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.11 ms |
| Creating sort index | 4.53 ms |
| End of update loop | 0.06 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.05 ms |
| Updating status | 4.65 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Même appel que celui de la ligne ci-dessous. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
| 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
| 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 2.42 ms Après la dernière requête : 278.92 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.686 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oqkiz_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.12 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.49 ms |
| Preparing | 0.15 ms |
| Executing | 0.02 ms |
| Sending data | 0.54 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Même appel que celui de la ligne ci-dessous. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/oziojquery/oziojquery.php:57 |
| 8 | plgSystemOziojquery->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 : 47.54 ms Après la dernière requête : 3.50 ms Mémoire de requête : 0.005 MB mémoire avant requête : 6.677 MB
UPDATE `oqkiz_extensions`
SET `params` = '{\"mediaversion\":\"99ed56d80510fee0372d81641a61becd\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN impossible sur la requête : UPDATE `oqkiz_extensions`
SET `params` = '{\"mediaversion\":\"99ed56d80510fee0372d81641a61becd\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.24 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.04 ms |
| Table lock | 0.02 ms |
| Init for update | 0.55 ms |
| Updating | 0.63 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 45.38 ms |
| Closing tables | 0.05 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/oziojquery/oziojquery.php:57 |
| 8 | plgSystemOziojquery->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 : 3.45 ms Après la dernière requête : 489.85 ms Mémoire de requête : 0.019 MB mémoire avant requête : 6.857 MB Rangées retournées : 1
SELECT *
FROM oqkiz_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_languages | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| Starting | 0.22 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.34 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.15 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.09 ms |
| Preparing | 0.09 ms |
| Sorting result | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.09 ms |
| Creating sort index | 0.60 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 4.41 ms Après la dernière requête : 2.70 ms Mémoire de requête : 0.018 MB mémoire avant requête : 6.863 MB Rangées retournées : 4
SELECT id, home, template, s.params
FROM oqkiz_template_styles as s
LEFT JOIN oqkiz_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 7 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | tiroyenT.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.35 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.28 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.17 ms |
| Optimizing | 0.13 ms |
| Statistics | 0.51 ms |
| Preparing | 0.20 ms |
| Executing | 0.02 ms |
| Sending data | 1.03 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 3.78 ms Après la dernière requête : 404.80 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.827 MB Rangées retournées : 0
SELECT a.title, a.description AS text, a.created_time AS created, '2' AS browsernav, a.id AS catid,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM oqkiz_categories AS a
WHERE (a.title LIKE '%championnats%' OR a.description LIKE '%championnats%')
AND a.published IN (1,2)
AND a.extension = 'com_content'
AND a.access IN (1,1)
GROUP BY a.id, a.title, a.description, a.alias, a.created_time
ORDER BY a.title DESC
LIMIT 50
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | cat_idx,idx_access | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 15 | Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| Starting | 0.63 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.17 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.28 ms |
| Optimizing | 0.13 ms |
| Statistics | 0.67 ms |
| Preparing | 0.13 ms |
| Sorting result | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.93 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/search/categories/categories.php:172 |
| 15 | PlgSearchCategories->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 6.46 ms Après la dernière requête : 14.24 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.835 MB Rangées retournées : 0
SELECT a.name AS title, '' AS created, a.con_position, a.misc,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(',', a.name, a.con_position, a.misc) AS text,CONCAT_WS(' / ', 'Contacts', c.title) AS section,'2' AS browsernav
FROM oqkiz_contact_details AS a
INNER JOIN oqkiz_categories AS c
ON c.id = a.catid
WHERE (a.name LIKE '%championnats%' OR a.misc LIKE '%championnats%' OR a.con_position LIKE '%championnats%' OR a.address LIKE '%championnats%' OR a.suburb LIKE '%championnats%' OR a.state LIKE '%championnats%' OR a.country LIKE '%championnats%' OR a.postcode LIKE '%championnats%' OR a.telephone LIKE '%championnats%' OR a.fax LIKE '%championnats%')
AND a.published IN (1,2)
AND c.published=1
AND a.access IN (1,1)
AND c.access IN (1,1)
ORDER BY a.name DESC
LIMIT 50
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | range | idx_access,idx_state,idx_catid | idx_access | 4 | NULL | 1 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | tiroyenT.a.catid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.89 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 1.92 ms |
| After opening tables | 0.06 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.42 ms |
| Optimizing | 0.19 ms |
| Statistics | 0.93 ms |
| Preparing | 0.24 ms |
| Sorting result | 0.07 ms |
| Executing | 0.02 ms |
| Sending data | 0.17 ms |
| Creating sort index | 0.91 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 3.90 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/search/contacts/contacts.php:169 |
| 15 | PlgSearchContacts->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 5.62 ms Après la dernière requête : 7.55 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.843 MB Rangées retournées : 0
SELECT cfv.item_id
FROM oqkiz_fields_values AS cfv
LEFT JOIN oqkiz_fields AS f
ON f.id = cfv.field_id
WHERE (f.context IS NULL OR f.context = 'com_content.article')
AND (f.state IS NULL OR f.state = 1)
AND (f.access IS NULL OR f.access IN (1,1))
AND LOWER(cfv.value) LIKE LOWER('%championnats%')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cfv | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.cfv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.43 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 2.40 ms |
| After opening tables | 0.06 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.21 ms |
| Optimizing | 0.14 ms |
| Statistics | 0.16 ms |
| Preparing | 0.22 ms |
| Executing | 0.02 ms |
| Sending data | 0.68 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:174 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 24.42 ms Après la dernière requête : 1.00 ms Mémoire de requête : 0.040 MB mémoire avant requête : 7.855 MB Rangées retournées : 10
SELECT
CASE WHEN LOWER(a.title) LIKE LOWER('%championnats%') THEN 5 ELSE 0 END AS relevance,a.title AS title, a.metadesc, a.metakey, a.created AS created, a.language, a.catid,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav
FROM oqkiz_content AS a
INNER JOIN oqkiz_categories AS c
ON c.id=a.catid
WHERE ((LOWER(a.title) LIKE LOWER('%championnats%') OR LOWER(a.introtext) LIKE LOWER('%championnats%') OR LOWER(a.fulltext) LIKE LOWER('%championnats%') OR LOWER(a.metakey) LIKE LOWER('%championnats%') OR LOWER(a.metadesc) LIKE LOWER('%championnats%')))
AND a.state=1
AND c.published = 1
AND a.access IN (1,1)
AND c.access IN (1,1)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-01 02:29:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-01 02:29:23')
GROUP BY a.id, a.title, a.metadesc, a.metakey, a.created, a.language, a.catid, a.introtext, a.fulltext, c.title, a.alias, c.alias, c.id
ORDER BY relevance DESC, a.created DESC
LIMIT 50
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_state | 1 | const | 40 | Using where; Using temporary; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | tiroyenT.a.catid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 1.12 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 5.12 ms |
| After opening tables | 0.06 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.56 ms |
| Optimizing | 0.25 ms |
| Statistics | 0.78 ms |
| Preparing | 0.34 ms |
| Creating tmp table | 0.27 ms |
| Sorting result | 0.07 ms |
| Executing | 0.12 ms |
| Sending data | 12.80 ms |
| Creating sort index | 1.39 ms |
| Removing tmp table | 0.57 ms |
| Creating sort index | 0.32 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.11 ms |
| Updating status | 3.83 ms |
| Reset for next command | 0.06 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/search/content/content.php:312 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 12.56 ms Après la dernière requête : 3.55 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.890 MB Rangées retournées : 12
SELECT
CASE WHEN LOWER(a.title) LIKE LOWER('%championnats%') THEN 5 ELSE 0 END AS relevance,a.title AS title, a.metadesc, a.metakey, a.created AS created, a.language, a.catid,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav
FROM oqkiz_content AS a
INNER JOIN oqkiz_categories AS c
ON c.id=a.catid
AND c.access IN (1,1)
WHERE ((LOWER(a.title) LIKE LOWER('%championnats%') OR LOWER(a.introtext) LIKE LOWER('%championnats%') OR LOWER(a.fulltext) LIKE LOWER('%championnats%') OR LOWER(a.metakey) LIKE LOWER('%championnats%') OR LOWER(a.metadesc) LIKE LOWER('%championnats%')))
AND a.state = 2
AND c.published = 1
AND a.access IN (1,1)
AND c.access IN (1,1)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-01 02:29:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-01 02:29:23')
ORDER BY relevance DESC, relevance DESC, a.created DESC
LIMIT 40
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_state | 1 | const | 50 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | tiroyenT.a.catid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 1.11 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.28 ms |
| After opening tables | 0.04 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.47 ms |
| Optimizing | 0.25 ms |
| Statistics | 0.54 ms |
| Preparing | 0.27 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.09 ms |
| Creating sort index | 8.66 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.10 ms |
| Updating status | 1.29 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/search/content/content.php:387 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.52 ms Après la dernière requête : 1.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.914 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '97'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.38 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.05 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.63 ms |
| Preparing | 0.18 ms |
| Executing | 0.02 ms |
| Sending data | 0.22 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 7.77 ms |
| Reset for next command | 0.04 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.30 ms Après la dernière requête : 18.19 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.937 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '87'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.39 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.38 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.25 ms Après la dernière requête : 1.78 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.944 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '75'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.38 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.33 ms Après la dernière requête : 18.90 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.950 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '73'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.38 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.45 ms Après la dernière requête : 1.34 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.957 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '88'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.20 ms |
| Statistics | 0.44 ms |
| Preparing | 0.22 ms |
| Executing | 0.02 ms |
| Sending data | 0.36 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 3.57 ms Après la dernière requête : 2.28 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.963 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '81'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.22 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.43 ms Après la dernière requête : 1.29 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.970 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '78'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.49 ms |
| Preparing | 0.23 ms |
| Executing | 0.02 ms |
| Sending data | 0.37 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.29 ms Après la dernière requête : 2.08 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.976 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '38'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.38 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.07 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 4.14 ms Après la dernière requête : 1.40 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.983 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '48'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.38 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 1.89 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 3.52 ms Après la dernière requête : 1.44 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.990 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '7'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 1.61 ms |
| Preparing | 0.19 ms |
| Executing | 0.02 ms |
| Sending data | 0.38 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.91 ms Après la dernière requête : 2.60 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.996 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '65'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.39 ms |
| Preparing | 0.33 ms |
| Executing | 0.03 ms |
| Sending data | 0.85 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 1.98 ms Après la dernière requête : 1.34 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.003 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '35'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 1.99 ms Après la dernière requête : 1.24 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.010 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '33'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.22 ms Après la dernière requête : 1.35 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.016 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '31'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.20 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.45 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.18 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.43 ms Après la dernière requête : 1.36 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.023 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '24'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.03 ms Après la dernière requête : 1.26 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.032 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '61'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.03 ms Après la dernière requête : 2.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.040 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '55'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.39 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.00 ms Après la dernière requête : 1.64 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.046 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '34'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 1.99 ms Après la dernière requête : 1.24 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.053 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '32'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.00 ms Après la dernière requête : 1.68 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.059 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '26'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 1.91 ms Après la dernière requête : 1.35 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.066 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '17'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.03 ms |
| Query end | 0.01 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 1.77 ms |
| Reset for next command | 0.04 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 2.08 ms Après la dernière requête : 1.50 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.072 MB Rangées retournées : 0
SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
WHERE f.context = 'com_content.article'
AND fv.item_id = '16'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fv | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 1 | Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY,idx_context | PRIMARY | 4 | tiroyenT.fv.field_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.26 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.38 ms |
| Preparing | 0.17 ms |
| Executing | 0.02 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 3.24 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/search/content/content.php:425 |
| 15 | PlgSearchContent->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 4.58 ms Après la dernière requête : 2.83 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.074 MB Rangées retournées : 0
SELECT a.name AS title, '' AS created, a.link AS text,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Fils d\'actualité', c.title) AS section,'1' AS browsernav
FROM oqkiz_newsfeeds AS a
INNER JOIN oqkiz_categories as c
ON c.id = a.catid
WHERE ((a.name LIKE '%championnats%' OR a.link LIKE '%championnats%'))
AND a.published IN (1,2)
AND c.published = 1
AND c.access IN (1,1)
ORDER BY a.name ASC
LIMIT 50
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | idx_state,idx_catid | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | tiroyenT.a.catid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.64 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.26 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.28 ms |
| Optimizing | 0.15 ms |
| Statistics | 0.72 ms |
| Preparing | 0.18 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.43 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.05 ms |
| Updating status | 1.50 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/search/newsfeeds/newsfeeds.php:184 |
| 15 | PlgSearchNewsfeeds->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 4.99 ms Après la dernière requête : 1.17 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.081 MB Rangées retournées : 0
SELECT a.title AS title, a.created AS created, a.url, a.description AS text,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Recherche - Liens web', c.title) AS section,'1' AS browsernav
FROM oqkiz_weblinks AS a
INNER JOIN oqkiz_categories as c
ON c.id = a.catid
WHERE ((a.url LIKE '%championnats%' OR a.description LIKE '%championnats%' OR a.title LIKE '%championnats%'))
AND a.state IN (1,2)
AND c.published = 1
AND c.access IN (1,1)
ORDER BY a.created DESC
LIMIT 50
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | idx_state,idx_catid | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | tiroyenT.a.catid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.67 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 1.47 ms |
| After opening tables | 0.06 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.30 ms |
| Optimizing | 0.15 ms |
| Statistics | 0.74 ms |
| Preparing | 0.18 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| Creating sort index | 0.49 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.05 ms |
| Updating status | 6.60 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/search/weblinks/weblinks.php:194 |
| 15 | PlgSearchWeblinks->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 5.60 ms Après la dernière requête : 15.58 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.116 MB Rangées retournées : 1
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `oqkiz_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_menu | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 39 | Using where |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.44 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.15 ms |
| Optimizing | 0.10 ms |
| Statistics | 0.28 ms |
| Preparing | 0.14 ms |
| Executing | 0.02 ms |
| Sending data | 2.45 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 |
| 16 | iCutilities\Menus\Menus::iClistMenuItemsInfo() | JROOT/plugins/search/icagenda/icagenda.php:104 |
| 15 | PlgSearchiCagenda->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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.11 ms Après la dernière requête : 4.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.126 MB Rangées retournées : 2
SELECT DISTINCT(user_id)
FROM oqkiz_usergroups as ug1
INNER JOIN oqkiz_usergroups AS ug2
ON ug2.lft=ug1.lft
AND ug1.rgt=ug2.rgt
INNER JOIN oqkiz_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id='8'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | Using temporary |
| 1 | SIMPLE | ug2 | ref | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 8 | const,const | 1 | Using index |
| 1 | SIMPLE | m | index | NULL | PRIMARY | 8 | NULL | 2276 | Using where; Using index; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.34 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 4.13 ms |
| After opening tables | 0.05 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.14 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.49 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.14 ms |
| Creating tmp table | 0.18 ms |
| Executing | 0.02 ms |
| Sending data | 10.77 ms |
| Removing tmp table | 0.07 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 1.30 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 17 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:1029 |
| 16 | Joomla\CMS\Access\Access::getUsersByGroup() | JROOT/plugins/search/icagenda/icagenda.php:255 |
| 15 | PlgSearchiCagenda->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 8.14 ms Après la dernière requête : 0.95 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.135 MB Rangées retournées : 0
SELECT e.title AS title, e.created AS created, e.next AS next, e.displaytime AS displaytime, e.alias AS alias, e.desc AS text, e.id AS eventID, c.id AS catid, c.title AS cattitle, e.language AS language, "0" AS browsernav
FROM oqkiz_icagenda_events AS e
INNER JOIN `oqkiz_icagenda_category` AS `c`
ON (`c`.`id` = `e`.`catid`)
WHERE e.state = 1
AND c.state = 1
AND e.access IN (1,1)
AND ((LOWER(e.title) LIKE '%championnats%' OR LOWER(e.shortdesc) LIKE '%championnats%' OR LOWER(e.desc) LIKE '%championnats%' OR LOWER(e.metadesc) LIKE '%championnats%' OR LOWER(e.place) LIKE '%championnats%' OR LOWER(e.city) LIKE '%championnats%' OR LOWER(e.country) LIKE '%championnats%' OR LOWER(e.address) LIKE '%championnats%' OR LOWER(c.title) LIKE '%championnats%'))
AND e.approval <> 1
GROUP BY e.id
ORDER BY e.next DESC
LIMIT 50
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | index | idx_state,idx_approval,idx_catid | PRIMARY | 4 | NULL | 5 | Using where; Using temporary; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_state | PRIMARY | 4 | tiroyenT.e.catid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.75 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 2.44 ms |
| After opening tables | 0.06 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.45 ms |
| Optimizing | 0.18 ms |
| Statistics | 0.81 ms |
| Preparing | 0.24 ms |
| Creating tmp table | 0.16 ms |
| Sorting for group | 0.04 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 1.43 ms |
| Creating sort index | 0.19 ms |
| Removing tmp table | 0.39 ms |
| Creating sort index | 0.06 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 5.11 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/search/icagenda/icagenda.php:315 |
| 15 | PlgSearchiCagenda->onContentSearch() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_search/models/search.php:146 |
| 12 | SearchModelSearch->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_search/views/search/view.html.php:126 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 13.79 ms Après la dernière requête : 271.19 ms Mémoire de requête : 0.024 MB mémoire avant requête : 8.999 MB Rangées retournées : 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM oqkiz_fields AS a
LEFT JOIN `oqkiz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN oqkiz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN oqkiz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN oqkiz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN oqkiz_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_search.search'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | tiroyenT.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.group_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.87 ms |
| Checking permissions | 0.05 ms |
| Opening tables | 5.14 ms |
| After opening tables | 0.06 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.42 ms |
| Optimizing | 0.21 ms |
| Statistics | 1.54 ms |
| Preparing | 0.32 ms |
| Creating tmp table | 0.36 ms |
| Sorting result | 0.10 ms |
| Executing | 0.02 ms |
| Sending data | 3.19 ms |
| Creating sort index | 0.23 ms |
| Removing tmp table | 0.42 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.07 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 5.97 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 14 | JHtmlContent::prepare() | Même appel que celui de la ligne ci-dessous. |
| 13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/components/com_search/views/search/view.html.php:166 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 5.98 ms Après la dernière requête : 477.01 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.339 MB Rangées retournées : 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `oqkiz_categories` AS `s`
INNER JOIN `oqkiz_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 9
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 15 | Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| Starting | 0.76 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 1.51 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.52 ms |
| Optimizing | 0.28 ms |
| Statistics | 0.77 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.24 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.17 ms |
| Creating sort index | 0.75 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 28 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 27 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 26 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 25 | ContentRouter->getCategorySegment() | Même appel que celui de la ligne ci-dessous. |
| 24 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 23 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 22 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 21 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 20 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 19 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 18 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 17 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/components/com_search/views/search/tmpl/default_results.php:18 |
| 15 | include JROOT/components/com_search/views/search/tmpl/default_results.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 14 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_search/views/search/tmpl/default.php:25 |
| 13 | include JROOT/components/com_search/views/search/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_search/views/search/view.html.php:195 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 4.41 ms Après la dernière requête : 16.56 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.386 MB Rangées retournées : 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `oqkiz_categories` AS `s`
INNER JOIN `oqkiz_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 10
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 15 | Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| Starting | 0.78 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.19 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.36 ms |
| Optimizing | 0.19 ms |
| Statistics | 0.75 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.15 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.16 ms |
| Creating sort index | 0.73 ms |
| End of update loop | 0.18 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 28 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 27 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 26 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 25 | ContentRouter->getCategorySegment() | Même appel que celui de la ligne ci-dessous. |
| 24 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 23 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 22 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 21 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 20 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 19 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 18 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 17 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/components/com_search/views/search/tmpl/default_results.php:18 |
| 15 | include JROOT/components/com_search/views/search/tmpl/default_results.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 14 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_search/views/search/tmpl/default.php:25 |
| 13 | include JROOT/components/com_search/views/search/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_search/views/search/view.html.php:195 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 6.14 ms Après la dernière requête : 3.63 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.402 MB Rangées retournées : 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `oqkiz_categories` AS `s`
INNER JOIN `oqkiz_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 2
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 2 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.73 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.19 ms |
| After opening tables | 0.04 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.35 ms |
| Optimizing | 0.19 ms |
| Statistics | 0.87 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.18 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 2.24 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 28 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 27 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 26 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 25 | ContentRouter->getCategorySegment() | Même appel que celui de la ligne ci-dessous. |
| 24 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 23 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 22 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 21 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 20 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 19 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 18 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 17 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/components/com_search/views/search/tmpl/default_results.php:18 |
| 15 | include JROOT/components/com_search/views/search/tmpl/default_results.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 14 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_search/views/search/tmpl/default.php:25 |
| 13 | include JROOT/components/com_search/views/search/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_search/views/search/view.html.php:195 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 4.34 ms Après la dernière requête : 4.24 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.418 MB Rangées retournées : 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `oqkiz_categories` AS `s`
INNER JOIN `oqkiz_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 14
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 15 | Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| Starting | 0.73 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.19 ms |
| After opening tables | 0.04 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.36 ms |
| Optimizing | 0.19 ms |
| Statistics | 0.86 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.15 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.16 ms |
| Creating sort index | 0.73 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 28 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 27 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 26 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 25 | ContentRouter->getCategorySegment() | Même appel que celui de la ligne ci-dessous. |
| 24 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 23 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 22 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 21 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 20 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 19 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 18 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 17 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 16 | Joomla\CMS\Router\Route::_() | JROOT/components/com_search/views/search/tmpl/default_results.php:18 |
| 15 | include JROOT/components/com_search/views/search/tmpl/default_results.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 14 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_search/views/search/tmpl/default.php:25 |
| 13 | include JROOT/components/com_search/views/search/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_search/views/search/view.html.php:195 |
| 10 | SearchViewSearch->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_search/controller.php:34 |
| 8 | SearchController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_search/search.php:13 |
| 6 | require_once JROOT/components/com_search/search.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 : 5.45 ms Après la dernière requête : 42.25 ms Mémoire de requête : 0.020 MB mémoire avant requête : 9.443 MB Rangées retournées : 1
SELECT folder.*
FROM `oqkiz_eventgallery_folder` AS folder
LEFT JOIN `oqkiz_eventgallery_file` AS file
ON folder.folder = file.folder
and file.published=1
and file.ismainimage=0
WHERE file.file IS NULL
AND (folder.foldertypeid=1 OR folder.foldertypeid=2 OR folder.foldertypeid=4)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | folder | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | file | ALL | file,index_folder | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | Using where; Not exists; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.36 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 2.28 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.29 ms |
| Optimizing | 0.15 ms |
| Statistics | 0.18 ms |
| Preparing | 0.29 ms |
| Executing | 0.03 ms |
| Sending data | 0.87 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/picasaupdater/picasaupdater.php:80 |
| 7 | plgSystemPicasaupdater->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 : 1.85 ms Après la dernière requête : 21.37 ms Mémoire de requête : 0.021 MB mémoire avant requête : 9.468 MB Rangées retournées : 1
SELECT f.*
FROM oqkiz_eventgallery_folder f
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | |
| Status | Duration |
|---|
| Starting | 0.19 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.16 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.07 ms |
| Preparing | 0.08 ms |
| Executing | 0.02 ms |
| Sending data | 0.43 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/folder.php:102 |
| 10 | EventgalleryLibraryFactoryFolder->getAllFoldersFromDatabase() | JROOT/components/com_eventgallery/library/factory/folder.php:67 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 2.63 ms Après la dernière requête : 54.74 ms Mémoire de requête : 0.021 MB mémoire avant requête : 9.570 MB Rangées retournées : 3
SELECT *
FROM oqkiz_eventgallery_imagetypeset
ORDER BY `default` DESC,ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_eventgallery_imagetypeset | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 3 | Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| Starting | 0.21 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.84 ms |
| After opening tables | 0.04 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.11 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.07 ms |
| Preparing | 0.06 ms |
| Sorting result | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| Creating sort index | 0.48 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:129 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 4.72 ms Après la dernière requête : 14.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.594 MB Rangées retournées : 3
SELECT t.*
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
WHERE tsta.imagetypesetid='2'
ORDER BY tsta.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tsta | ref | PRIMARY | PRIMARY | 4 | const | 3 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.tsta.imagetypeid | 1 | |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 1.60 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.20 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.40 ms |
| Preparing | 0.15 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.17 ms |
| Creating sort index | 0.89 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:66 |
| 15 | EventgalleryLibraryFactoryImagetypeset->getImagetypes() | JROOT/components/com_eventgallery/library/imagetypeset.php:59 |
| 14 | EventgalleryLibraryImagetypeset->__construct() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 2.00 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.025 MB mémoire avant requête : 9.607 MB Rangées retournées : 6
SELECT *
FROM oqkiz_eventgallery_imagetype
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_eventgallery_imagetype | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 6 | |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.14 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.07 ms |
| Preparing | 0.08 ms |
| Executing | 0.02 ms |
| Sending data | 0.88 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 5.36 ms |
| Reset for next command | 0.04 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetype.php:51 |
| 17 | EventgalleryLibraryFactoryImagetype->getImageTypes() | JROOT/components/com_eventgallery/library/factory/imagetype.php:27 |
| 16 | EventgalleryLibraryFactoryImagetype->getImagetypeById() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:70 |
| 15 | EventgalleryLibraryFactoryImagetypeset->getImagetypes() | JROOT/components/com_eventgallery/library/imagetypeset.php:59 |
| 14 | EventgalleryLibraryImagetypeset->__construct() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 2.79 ms Après la dernière requête : 21.96 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.725 MB Rangées retournées : 2
SELECT t.*
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
WHERE tsta.imagetypesetid='2'
AND published=1
ORDER BY tsta.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tsta | ref | PRIMARY | PRIMARY | 4 | const | 3 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.tsta.imagetypeid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.32 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.22 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.33 ms |
| Preparing | 0.18 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.17 ms |
| Creating sort index | 0.50 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:66 |
| 15 | EventgalleryLibraryFactoryImagetypeset->getImagetypes() | JROOT/components/com_eventgallery/library/imagetypeset.php:60 |
| 14 | EventgalleryLibraryImagetypeset->__construct() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 3.23 ms Après la dernière requête : 0.89 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.731 MB Rangées retournées : 3
SELECT t.*, tsta.default as defaultimagetype
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
WHERE tsta.imagetypesetid='2'
ORDER BY tsta.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tsta | ref | PRIMARY | PRIMARY | 4 | const | 3 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.tsta.imagetypeid | 1 | |
| Status | Duration |
|---|
| Starting | 0.36 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.20 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.30 ms |
| Preparing | 0.14 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.17 ms |
| Creating sort index | 0.62 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:93 |
| 15 | EventgalleryLibraryFactoryImagetypeset->getDefaultImagetype() | JROOT/components/com_eventgallery/library/imagetypeset.php:61 |
| 14 | EventgalleryLibraryImagetypeset->__construct() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 2.83 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.024 MB mémoire avant requête : 9.738 MB Rangées retournées : 4
SELECT t.*
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
WHERE tsta.imagetypesetid='1'
ORDER BY tsta.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tsta | ref | PRIMARY | PRIMARY | 4 | const | 4 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.tsta.imagetypeid | 1 | |
| Status | Duration |
|---|
| Starting | 0.39 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.20 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.31 ms |
| Preparing | 0.14 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.34 ms |
| Creating sort index | 0.59 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.04 ms |
| Updating status | 1.11 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:66 |
| 15 | EventgalleryLibraryFactoryImagetypeset->getImagetypes() | JROOT/components/com_eventgallery/library/imagetypeset.php:59 |
| 14 | EventgalleryLibraryImagetypeset->__construct() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 3.30 ms Après la dernière requête : 0.85 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.745 MB Rangées retournées : 3
SELECT t.*
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
WHERE tsta.imagetypesetid='1'
AND published=1
ORDER BY tsta.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tsta | ref | PRIMARY | PRIMARY | 4 | const | 4 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.tsta.imagetypeid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.39 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.18 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.22 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.32 ms |
| Preparing | 0.17 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.55 ms |
| Creating sort index | 0.59 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.04 ms |
| Updating status | 1.22 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:66 |
| 15 | EventgalleryLibraryFactoryImagetypeset->getImagetypes() | JROOT/components/com_eventgallery/library/imagetypeset.php:60 |
| 14 | EventgalleryLibraryImagetypeset->__construct() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 2.92 ms Après la dernière requête : 0.88 ms Mémoire de requête : 0.024 MB mémoire avant requête : 9.751 MB Rangées retournées : 4
SELECT t.*, tsta.default as defaultimagetype
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
WHERE tsta.imagetypesetid='1'
ORDER BY tsta.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tsta | ref | PRIMARY | PRIMARY | 4 | const | 4 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.tsta.imagetypeid | 1 | |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.20 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.31 ms |
| Preparing | 0.14 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.36 ms |
| Creating sort index | 0.60 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.04 ms |
| Updating status | 2.34 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:93 |
| 15 | EventgalleryLibraryFactoryImagetypeset->getDefaultImagetype() | JROOT/components/com_eventgallery/library/imagetypeset.php:61 |
| 14 | EventgalleryLibraryImagetypeset->__construct() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 2.99 ms Après la dernière requête : 1.67 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.758 MB Rangées retournées : 1
SELECT t.*
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
WHERE tsta.imagetypesetid='3'
ORDER BY tsta.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tsta | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.tsta.imagetypeid | 1 | |
| Status | Duration |
|---|
| Starting | 0.26 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.20 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.30 ms |
| Preparing | 0.14 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.34 ms |
| Creating sort index | 0.42 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.04 ms |
| Updating status | 1.07 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:66 |
| 15 | EventgalleryLibraryFactoryImagetypeset->getImagetypes() | JROOT/components/com_eventgallery/library/imagetypeset.php:59 |
| 14 | EventgalleryLibraryImagetypeset->__construct() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 2.82 ms Après la dernière requête : 0.79 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.764 MB Rangées retournées : 1
SELECT t.*
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
WHERE tsta.imagetypesetid='3'
AND published=1
ORDER BY tsta.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tsta | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.tsta.imagetypeid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.21 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.31 ms |
| Preparing | 0.17 ms |
| Sorting result | 0.16 ms |
| Executing | 0.02 ms |
| Sending data | 0.33 ms |
| Creating sort index | 0.42 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 1.00 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:66 |
| 15 | EventgalleryLibraryFactoryImagetypeset->getImagetypes() | JROOT/components/com_eventgallery/library/imagetypeset.php:60 |
| 14 | EventgalleryLibraryImagetypeset->__construct() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 2.61 ms Après la dernière requête : 0.76 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.771 MB Rangées retournées : 1
SELECT t.*, tsta.default as defaultimagetype
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
WHERE tsta.imagetypesetid='3'
ORDER BY tsta.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tsta | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.tsta.imagetypeid | 1 | |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.20 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.30 ms |
| Preparing | 0.14 ms |
| Sorting result | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.35 ms |
| Creating sort index | 0.41 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.04 ms |
| Updating status | 14.33 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:93 |
| 15 | EventgalleryLibraryFactoryImagetypeset->getDefaultImagetype() | JROOT/components/com_eventgallery/library/imagetypeset.php:61 |
| 14 | EventgalleryLibraryImagetypeset->__construct() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138 |
| 13 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSets() | JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169 |
| 12 | EventgalleryLibraryFactoryImagetypeset->getImageTypeSet() | JROOT/components/com_eventgallery/library/folder.php:177 |
| 11 | EventgalleryLibraryFolder->_prepareData() | JROOT/components/com_eventgallery/library/folder.php:94 |
| 10 | EventgalleryLibraryFolder->__construct() | JROOT/components/com_eventgallery/library/factory/folder.php:83 |
| 9 | EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject() | JROOT/components/com_eventgallery/library/factory/folder.php:38 |
| 8 | EventgalleryLibraryFactoryFolder->getFolder() | JROOT/plugins/system/picasaupdater/picasaupdater.php:93 |
| 7 | plgSystemPicasaupdater->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 : 16.86 ms Après la dernière requête : 227.89 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.901 MB Rangées retournées : 9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM oqkiz_modules AS m
LEFT JOIN oqkiz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN oqkiz_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 <= '2024-11-01 02:29:23')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-01 02:29:23')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 13 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | tiroyenT.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | tiroyenT.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.57 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 2.64 ms |
| After opening tables | 0.06 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.30 ms |
| Optimizing | 0.24 ms |
| Statistics | 0.42 ms |
| Preparing | 0.32 ms |
| Sorting result | 0.07 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| Creating sort index | 2.98 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | Même appel que celui de la ligne ci-dessous. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
| 11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
| 8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/protostar/index.php:91 |
| 7 | require JROOT/templates/protostar/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 : 3.17 ms Après la dernière requête : 269.70 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.265 MB Rangées retournées : 5
SELECT id AS nbevt
FROM `oqkiz_icagenda_events` AS e
WHERE e.state = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | ref | idx_state | idx_state | 1 | const | 5 | Using index |
| Status | Duration |
|---|
| Starting | 0.26 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.21 ms |
| After opening tables | 0.06 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.10 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.23 ms |
| Preparing | 0.12 ms |
| Executing | 0.02 ms |
| Sending data | 0.21 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 12 | JDatabaseDriver->loadResult() | JROOT/modules/mod_iccalendar/helper.php:132 |
| 11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 |
| 10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.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 : 4.65 ms Après la dernière requête : 1.15 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.278 MB Rangées retournées : 1
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `oqkiz_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_menu | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 39 | Using where |
| Status | Duration |
|---|
| Starting | 0.28 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.24 ms |
| After opening tables | 0.05 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.14 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.46 ms |
| Preparing | 0.15 ms |
| Executing | 0.02 ms |
| Sending data | 1.50 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 |
| 12 | iCutilities\Menus\Menus::iClistMenuItemsInfo() | JROOT/modules/mod_iccalendar/helper.php:167 |
| 11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 |
| 10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.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 : 10.67 ms Après la dernière requête : 2.81 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.294 MB Rangées retournées : 0
SELECT e.*,
e.place as place_name,
c.title as cat_title,
c.alias as cat_alias,
c.color as cat_color,
c.ordering as cat_order
,feat.count AS features,r.count AS reg_people, r.date AS reg_date
FROM `oqkiz_icagenda_events` AS e
LEFT JOIN `oqkiz_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count
FROM `oqkiz_icagenda_feature_xref` AS fx
INNER JOIN `oqkiz_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN (
SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `oqkiz_icagenda_registration` AS r
WHERE r.state > 0
GROUP BY r.eventid) AS r
ON e.id=r.eventid
WHERE c.state = 1
AND e.state = 1
AND e.approval = 0
AND ((`e`.`next` >= '2024-11-01') OR (`e`.`startdate` <= '2024-11-01'
AND `e`.`enddate` >= '2024-11-01'
AND `e`.`weekdays` = ""))
AND e.access IN (1, 1)
AND e.language IN ('fr-FR','*')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | e | ALL | idx_state,idx_approval,idx_language,idx_catid | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 5 | Using where |
| 1 | PRIMARY | c | eq_ref | PRIMARY,idx_state | PRIMARY | 4 | tiroyenT.e.catid | 1 | Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | tiroyenT.e.id | 2 | Using where |
| 1 | PRIMARY | <derived3> | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | Using where; Using join buffer (flat, BNL join) |
| 3 | DERIVED | r | range | idx_state,idx_eventid | idx_state | 1 | NULL | 2 | Using index condition; Using temporary; Utilisation du tri complet de type filesort |
| 2 | DERIVED | fx | ALL | idx_event_id,idx_feature_id | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | Using temporary; Utilisation du tri complet de type filesort |
| 2 | DERIVED | f | eq_ref | PRIMARY,idx_state | PRIMARY | 4 | tiroyenT.fx.feature_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.85 ms |
| Checking permissions | 0.05 ms |
| Opening tables | 3.67 ms |
| After opening tables | 0.06 ms |
| System lock | 0.03 ms |
| Table lock | 0.04 ms |
| Init | 0.84 ms |
| Optimizing | 0.24 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.59 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.44 ms |
| Statistics | 0.95 ms |
| Preparing | 0.17 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.07 ms |
| Preparing | 0.08 ms |
| Creating tmp table | 0.11 ms |
| Sorting result | 0.04 ms |
| Preparing | 0.26 ms |
| Executing | 0.03 ms |
| Sending data | 1.07 ms |
| Removing tmp table | 0.05 ms |
| Sending data | 0.02 ms |
| Removing tmp table | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Removing tmp table | 0.02 ms |
| Closing tables | 0.01 ms |
| Removing tmp table | 0.02 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.06 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.09 ms |
| Updating status | 5.95 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_iccalendar/helper.php:285 |
| 11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 |
| 10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.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 : 2.29 ms Après la dernière requête : 25.77 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.449 MB Rangées retournées : 2
SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people
FROM oqkiz_icagenda_registration AS r
WHERE r.status = 1
AND r.state = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | ref | idx_state,idx_status | idx_state | 1 | const | 2 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.11 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.49 ms |
| Preparing | 0.16 ms |
| Executing | 0.02 ms |
| Sending data | 0.28 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/src/Utilities/Events/EventsData.php:1582 |
| 12 | iCutilities\Events\EventsData::registeredList() | JROOT/modules/mod_iccalendar/helper.php:287 |
| 11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 |
| 10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.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.03 ms Après la dernière requête : 397.06 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.522 MB Rangées retournées : 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM oqkiz_fields AS a
LEFT JOIN `oqkiz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN oqkiz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN oqkiz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN oqkiz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN oqkiz_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | tiroyenT.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.group_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.84 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 5.00 ms |
| After opening tables | 0.06 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.41 ms |
| Optimizing | 0.32 ms |
| Statistics | 0.97 ms |
| Preparing | 0.30 ms |
| Creating tmp table | 0.36 ms |
| Sorting result | 0.10 ms |
| Executing | 0.02 ms |
| Sending data | 1.21 ms |
| Creating sort index | 0.20 ms |
| Removing tmp table | 0.41 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.07 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 6.10 ms |
| Reset for next command | 0.05 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 14 | JHtmlContent::prepare() | Même appel que celui de la ligne ci-dessous. |
| 13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
| 11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.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 : 9.29 ms Après la dernière requête : 374.44 ms Mémoire de requête : 0.028 MB mémoire avant requête : 11.384 MB Rangées retournées : 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `oqkiz_assets`
WHERE `name` IN ('root.1','com_aclsfgpl','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventgallery','com_fields','com_finder','com_icagenda','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_oziogallery3','com_plugins','com_postinstall','com_privacy','com_redirect','com_scriptmerge','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_assets | ALL | idx_asset_name | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 202 | Using where |
| Status | Duration |
|---|
| Starting | 0.49 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 1.23 ms |
| After opening tables | 0.06 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.58 ms |
| Optimizing | 0.08 ms |
| Statistics | 1.36 ms |
| Preparing | 0.11 ms |
| Executing | 0.02 ms |
| Sending data | 4.81 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.04 ms |
| Updating status | 6.06 ms |
| Reset for next command | 0.04 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 23 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 22 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 21 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 20 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 19 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/articles.php:442 |
| 18 | ContentModelArticles->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
| 17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
| 15 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_category/helper.php:224 |
| 14 | ModArticlesCategoryHelper::getList() | Même appel que celui de la ligne ci-dessous. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:566 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.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 : 19.80 ms Après la dernière requête : 15.63 ms Mémoire de requête : 0.046 MB mémoire avant requête : 11.450 MB Rangées retournées : 7
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM oqkiz_content AS a
LEFT JOIN oqkiz_categories AS c
ON c.id = a.catid
LEFT JOIN oqkiz_users AS ua
ON ua.id = a.created_by
LEFT JOIN oqkiz_users AS uam
ON uam.id = a.modified_by
LEFT JOIN oqkiz_categories as parent
ON parent.id = c.parent_id
LEFT JOIN oqkiz_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid IN (10)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-01 02:29:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-01 02:29:23')
ORDER BY a.title ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | a | index_merge | idx_state,idx_catid | idx_catid,idx_state | 4,1 | NULL | 3 | Using intersect(idx_catid,idx_state); Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.created_by | 1 | Using where |
| 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.modified_by | 1 | Using where |
| 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
| 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | tiroyenT.a.id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 1.34 ms |
| Checking permissions | 0.05 ms |
| Opening tables | 4.03 ms |
| After opening tables | 0.06 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.63 ms |
| Optimizing | 0.27 ms |
| Statistics | 0.77 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.20 ms |
| Sorting result | 0.09 ms |
| Executing | 0.02 ms |
| Sending data | 0.49 ms |
| Creating sort index | 11.15 ms |
| End of update loop | 0.06 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.07 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.09 ms |
| Updating status | 7.52 ms |
| Reset for next command | 0.06 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
| 15 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_category/helper.php:224 |
| 14 | ModArticlesCategoryHelper::getList() | Même appel que celui de la ligne ci-dessous. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:566 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.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 : 4.79 ms Après la dernière requête : 45.40 ms Mémoire de requête : 0.021 MB mémoire avant requête : 11.442 MB Rangées retournées : 10
SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year
FROM oqkiz_content
WHERE state = 2
GROUP BY YEAR(`created`), MONTH(`created`)
ORDER BY YEAR(`created`) DESC, MONTH(`created`) DESC
LIMIT 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | oqkiz_content | ref | idx_state | idx_state | 1 | const | 50 | Using where; Using temporary; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| Starting | 0.34 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.17 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.25 ms |
| Preparing | 0.12 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 2.50 ms |
| Creating sort index | 0.20 ms |
| Removing tmp table | 0.04 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_articles_archive/helper.php:51 |
| 11 | ModArchiveHelper::getList() | JROOT/modules/mod_articles_archive/mod_articles_archive.php:17 |
| 10 | include JROOT/modules/mod_articles_archive/mod_articles_archive.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 |
22 × SELECT fv.value
FROM oqkiz_fields_values as fv
LEFT JOIN oqkiz_fields as f
on fv.field_id = f.id
6 × SELECT t.*
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
4 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `oqkiz_categories` AS `s`
INNER JOIN `oqkiz_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
3 × SELECT t.*, tsta.default as defaultimagetype
FROM oqkiz_eventgallery_imagetypeset_imagetype tsta
left join oqkiz_eventgallery_imagetype t
on tsta.imagetypeid=t.id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oqkiz_extensions`
2 × SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `oqkiz_menu`
2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM oqkiz_fields AS a
LEFT JOIN `oqkiz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN oqkiz_users AS uc
ON uc.id=a.checked_out
LEFT JOIN oqkiz_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN oqkiz_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN oqkiz_fields_groups AS g
ON g.id = a.group_id
1 × SELECT `session_id`
FROM `oqkiz_session`
1 × SELECT id, rules
FROM `oqkiz_viewlevels
1 × SELECT b.id
FROM oqkiz_usergroups AS a
LEFT JOIN oqkiz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM oqkiz_extensions
1 × SELECT `name`
FROM `oqkiz_extensions`
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 oqkiz_menu AS m
LEFT JOIN oqkiz_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM oqkiz_languages
1 × SELECT id, home, template, s.params
FROM oqkiz_template_styles as s
LEFT JOIN oqkiz_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT a.title, a.description AS text, a.created_time AS created, '2' AS browsernav, a.id AS catid,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM oqkiz_categories AS a
1 × SELECT a.name AS title, '' AS created, a.con_position, a.misc,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(',', a.name, a.con_position, a.misc) AS text,CONCAT_WS(' / ', 'Contacts', c.title) AS section,'2' AS browsernav
FROM oqkiz_contact_details AS a
INNER JOIN oqkiz_categories AS c
ON c.id = a.catid
1 × SELECT cfv.item_id
FROM oqkiz_fields_values AS cfv
LEFT JOIN oqkiz_fields AS f
ON f.id = cfv.field_id
1 × SELECT
CASE WHEN LOWER(a.title) LIKE LOWER('%championnats%') THEN 5 ELSE 0 END AS relevance,a.title AS title, a.metadesc, a.metakey, a.created AS created, a.language, a.catid,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav
FROM oqkiz_content AS a
INNER JOIN oqkiz_categories AS c
ON c.id=a.catid
1 × SELECT
CASE WHEN LOWER(a.title) LIKE LOWER('%championnats%') THEN 5 ELSE 0 END AS relevance,a.title AS title, a.metadesc, a.metakey, a.created AS created, a.language, a.catid,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav
FROM oqkiz_content AS a
INNER JOIN oqkiz_categories AS c
ON c.id=a.catid
AND c.access IN (1,1)
1 × SELECT a.name AS title, '' AS created, a.link AS text,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Fils d\'actualité', c.title) AS section,'1' AS browsernav
FROM oqkiz_newsfeeds AS a
INNER JOIN oqkiz_categories as c
ON c.id = a.catid
1 × SELECT a.title AS title, a.created AS created, a.url, a.description AS text,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Recherche - Liens web', c.title) AS section,'1' AS browsernav
FROM oqkiz_weblinks AS a
INNER JOIN oqkiz_categories as c
ON c.id = a.catid
1 × SELECT DISTINCT(user_id)
FROM oqkiz_usergroups as ug1
INNER JOIN oqkiz_usergroups AS ug2
ON ug2.lft=ug1.lft
AND ug1.rgt=ug2.rgt
INNER JOIN oqkiz_user_usergroup_map AS m
ON ug2.id=m.group_id
1 × SELECT e.title AS title, e.created AS created, e.next AS next, e.displaytime AS displaytime, e.alias AS alias, e.desc AS text, e.id AS eventID, c.id AS catid, c.title AS cattitle, e.language AS language, "0" AS browsernav
FROM oqkiz_icagenda_events AS e
INNER JOIN `oqkiz_icagenda_category` AS `c`
ON (`c`.`id` = `e`.`catid`)
1 × SELECT folder.*
FROM `oqkiz_eventgallery_folder` AS folder
LEFT JOIN `oqkiz_eventgallery_file` AS file
ON folder.folder = file.folder
and file.published=1
and file.ismainimage=0
1 × SELECT f.*
FROM oqkiz_eventgallery_folder
1 × SELECT *
FROM oqkiz_eventgallery_imagetypeset
1 × SELECT *
FROM oqkiz_eventgallery_imagetyp
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM oqkiz_modules AS m
LEFT JOIN oqkiz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN oqkiz_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT id AS nbevt
FROM `oqkiz_icagenda_events` AS e
1 × SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order ,feat.count AS features,r.count AS reg_people, r.date AS reg_date
FROM `oqkiz_icagenda_events` AS e
LEFT JOIN `oqkiz_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `oqkiz_icagenda_feature_xref` AS fx
INNER JOIN `oqkiz_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `oqkiz_icagenda_registration` AS r
1 × SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people
FROM oqkiz_icagenda_registration AS r
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `oqkiz_assets`
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM oqkiz_content AS a
LEFT JOIN oqkiz_categories AS c
ON c.id = a.catid
LEFT JOIN oqkiz_users AS ua
ON ua.id = a.created_by
LEFT JOIN oqkiz_users AS uam
ON uam.id = a.modified_by
LEFT JOIN oqkiz_categories as parent
ON parent.id = c.parent_id
LEFT JOIN oqkiz_content_rating AS v
ON a.id = v.content_id
1 × SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year
FROM oqkiz_content
