Temps de requête : 3.44 ms Mémoire de requête : 0.019 MB mémoire avant requête : 3.557 MB Rangées retournées : 0
SELECT `session_id`
FROM `oqkiz_session`
WHERE `session_id` = X'3565333932323034396330306233653734353161346532643831373136336437'
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.75 ms |
After opening tables | 0.14 ms |
System lock | 0.02 ms |
Table lock | 0.04 ms |
Init | 0.10 ms |
Optimizing | 0.07 ms |
Statistics | 0.21 ms |
Preparing | 0.03 ms |
Executing | 0.28 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.03 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 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 : 59.84 ms Après la dernière requête : 0.91 ms Mémoire de requête : 0.003 MB mémoire avant requête : 3.561 MB
INSERT INTO `oqkiz_session`
(`session_id`,`guest`,`time`,`userid`,`username`)
VALUES
(X'3565333932323034396330306233653734353161346532643831373136336437', 1, 1730418639, 0, '')
EXPLAIN impossible sur la requête : INSERT INTO `oqkiz_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'3565333932323034396330306233653734353161346532643831373136336437', 1, 1730418639, 0, '')
Status | Duration |
---|
Starting | 0.25 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.61 ms |
End of update loop | 0.04 ms |
Query end | 0.02 ms |
Commit | 58.20 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.95 ms Après la dernière requête : 54.23 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.724 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.29 ms |
Checking permissions | 0.03 ms |
Opening tables | 1.31 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.34 ms |
Preparing | 0.17 ms |
Executing | 0.02 ms |
Sending data | 2.98 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.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 ms |
Updating status | 3.26 ms |
Reset for next command | 0.05 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 : 2.80 ms Après la dernière requête : 52.76 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.878 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.07 ms |
After opening tables | 0.06 ms |
System lock | 0.03 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.32 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.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 : 7.73 ms Après la dernière requête : 0.82 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.887 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.30 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.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.03 ms |
Sending data | 4.40 ms |
End of update loop | 0.07 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.04 ms |
Updating status | 4.02 ms |
Reset for next command | 0.05 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 : 11.54 ms Après la dernière requête : 7.61 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.945 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.35 ms |
Checking permissions | 0.04 ms |
Opening tables | 0.08 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.18 ms |
Optimizing | 0.12 ms |
Statistics | 0.34 ms |
Preparing | 0.17 ms |
Sorting result | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 9.58 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.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 ms |
Updating status | 4.93 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.06 ms Après la dernière requête : 390.53 ms Mémoire de requête : 0.020 MB mémoire avant requête : 5.473 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.25 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.53 ms |
Preparing | 0.15 ms |
Executing | 0.02 ms |
Sending data | 0.17 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 |
---|
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.45 ms Après la dernière requête : 248.04 ms Mémoire de requête : 0.062 MB mémoire avant requête : 6.058 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.49 ms |
Checking permissions | 0.04 ms |
Opening tables | 1.26 ms |
After opening tables | 0.06 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.20 ms |
Optimizing | 0.12 ms |
Statistics | 0.44 ms |
Preparing | 0.21 ms |
Sorting result | 0.06 ms |
Executing | 0.02 ms |
Sending data | 0.11 ms |
Creating sort index | 4.88 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.01 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 13.43 ms |
Reset for next command | 0.08 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.22 ms Après la dernière requête : 681.66 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.685 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.08 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.13 ms |
Optimizing | 0.09 ms |
Statistics | 0.50 ms |
Preparing | 0.15 ms |
Executing | 0.03 ms |
Sending data | 0.29 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.02 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 |
---|
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 : 262.08 ms Après la dernière requête : 1.30 ms Mémoire de requête : 0.005 MB mémoire avant requête : 6.676 MB
UPDATE `oqkiz_extensions`
SET `params` = '{\"mediaversion\":\"84c63bba463d8d35c25f1d8191b94e61\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN impossible sur la requête : UPDATE `oqkiz_extensions`
SET `params` = '{\"mediaversion\":\"84c63bba463d8d35c25f1d8191b94e61\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.41 ms |
Checking permissions | 0.04 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.69 ms |
Updating | 0.64 ms |
End of update loop | 0.05 ms |
Query end | 0.02 ms |
Commit | 259.53 ms |
Closing tables | 0.06 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 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.48 ms Après la dernière requête : 66.28 ms Mémoire de requête : 0.019 MB mémoire avant requête : 6.855 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.22 ms |
After opening tables | 0.05 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.15 ms |
Optimizing | 0.20 ms |
Statistics | 0.10 ms |
Preparing | 0.10 ms |
Sorting result | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.10 ms |
Creating sort index | 0.58 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.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 |
---|
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.68 ms Après la dernière requête : 2.61 ms Mémoire de requête : 0.018 MB mémoire avant requête : 6.862 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.36 ms |
Checking permissions | 0.03 ms |
Opening tables | 1.32 ms |
After opening tables | 0.05 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.26 ms |
Optimizing | 0.14 ms |
Statistics | 0.53 ms |
Preparing | 0.21 ms |
Executing | 0.03 ms |
Sending data | 1.09 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.04 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.79 ms Après la dernière requête : 356.09 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.825 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.62 ms |
Checking permissions | 0.04 ms |
Opening tables | 0.15 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.78 ms |
Preparing | 0.13 ms |
Sorting result | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
Creating sort index | 0.82 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.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.38 ms Après la dernière requête : 4.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.834 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.93 ms |
Checking permissions | 0.04 ms |
Opening tables | 1.72 ms |
After opening tables | 0.07 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.42 ms |
Optimizing | 0.20 ms |
Statistics | 0.94 ms |
Preparing | 0.24 ms |
Sorting result | 0.07 ms |
Executing | 0.02 ms |
Sending data | 0.07 ms |
Creating sort index | 1.03 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.02 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 8.01 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/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.52 ms Après la dernière requête : 7.68 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.842 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.41 ms |
Checking permissions | 0.04 ms |
Opening tables | 2.72 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.03 ms |
Sending data | 0.69 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.02 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 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: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 : 20.04 ms Après la dernière requête : 1.02 ms Mémoire de requête : 0.040 MB mémoire avant requête : 7.854 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-10-31 23:50:41')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-31 23:50:41')
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.18 ms |
Checking permissions | 0.04 ms |
Opening tables | 1.72 ms |
After opening tables | 0.07 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.56 ms |
Optimizing | 0.25 ms |
Statistics | 0.62 ms |
Preparing | 0.34 ms |
Creating tmp table | 0.27 ms |
Sorting result | 0.07 ms |
Executing | 0.02 ms |
Sending data | 12.00 ms |
Creating sort index | 1.34 ms |
Removing tmp table | 0.65 ms |
Creating sort index | 0.30 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.12 ms |
Updating status | 3.87 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 : 20.60 ms Après la dernière requête : 3.58 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.889 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-10-31 23:50:41')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-31 23:50:41')
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 | 2.04 ms |
Checking permissions | 0.05 ms |
Opening tables | 0.28 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 1.70 ms |
Optimizing | 4.04 ms |
Statistics | 1.74 ms |
Preparing | 0.30 ms |
Sorting result | 0.06 ms |
Executing | 0.02 ms |
Sending data | 0.10 ms |
Creating sort index | 9.47 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.01 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.11 ms |
Updating status | 1.32 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: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.93 ms Après la dernière requête : 1.09 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.913 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.27 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.14 ms |
Optimizing | 0.11 ms |
Statistics | 0.55 ms |
Preparing | 0.18 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.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.47 ms |
Updating status | 8.72 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.34 ms Après la dernière requête : 14.71 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.936 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.31 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.40 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.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.36 ms Après la dernière requête : 1.28 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.943 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.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.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.43 ms Après la dernière requête : 3.40 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.949 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.11 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.51 ms |
Preparing | 0.18 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.47 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.956 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.17 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.14 ms |
Optimizing | 0.11 ms |
Statistics | 0.39 ms |
Preparing | 0.17 ms |
Executing | 0.03 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.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 : 2.37 ms Après la dernière requête : 2.36 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.962 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.31 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.12 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.08 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.39 ms Après la dernière requête : 1.30 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.969 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.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.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.12 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.39 ms Après la dernière requête : 2.10 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.975 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.30 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.47 ms |
Preparing | 0.18 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.30 ms Après la dernière requête : 1.41 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.982 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.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.40 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.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.42 ms Après la dernière requête : 1.52 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.988 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.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.31 ms |
Executing | 0.03 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.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 : 2.29 ms Après la dernière requête : 2.65 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.995 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.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.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.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 |
---|
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.38 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.002 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.30 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.49 ms |
Preparing | 0.18 ms |
Executing | 0.03 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.37 ms Après la dernière requête : 1.28 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.008 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.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.47 ms |
Preparing | 0.17 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 : 2.35 ms Après la dernière requête : 1.38 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.015 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.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.03 ms |
Sending data | 0.38 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.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.36 ms Après la dernière requête : 1.38 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.021 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.30 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.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.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.32 ms Après la dernière requête : 1.55 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.031 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.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.03 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 : 3.29 ms Après la dernière requête : 1.88 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.038 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.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 | 1.30 ms |
Preparing | 0.19 ms |
Executing | 0.02 ms |
Sending data | 0.22 ms |
End of update loop | 0.03 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.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.81 ms Après la dernière requête : 1.67 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.045 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.31 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.14 ms |
Optimizing | 0.19 ms |
Statistics | 0.83 ms |
Preparing | 0.20 ms |
Executing | 0.02 ms |
Sending data | 0.39 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.03 ms |
Updating status | 1.55 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 : 2.27 ms Après la dernière requête : 1.26 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.051 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.27 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.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 | 1.82 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.27 ms Après la dernière requête : 1.55 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.058 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.27 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.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 | 1.71 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.26 ms Après la dernière requête : 1.45 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.065 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.27 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.39 ms |
Preparing | 0.17 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 | 1.85 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.36 ms Après la dernière requête : 1.59 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.071 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.27 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.14 ms |
Optimizing | 0.11 ms |
Statistics | 0.39 ms |
Preparing | 0.17 ms |
Executing | 0.02 ms |
Sending data | 0.45 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 | 3.84 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.86 ms Après la dernière requête : 3.54 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.072 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.67 ms |
Checking permissions | 0.04 ms |
Opening tables | 1.58 ms |
After opening tables | 0.06 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.29 ms |
Optimizing | 0.15 ms |
Statistics | 0.47 ms |
Preparing | 0.17 ms |
Sorting result | 0.06 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
Creating sort index | 0.59 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.06 ms |
Updating status | 1.64 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 : 5.51 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.080 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.70 ms |
Checking permissions | 0.04 ms |
Opening tables | 1.63 ms |
After opening tables | 0.15 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.38 ms |
Optimizing | 0.15 ms |
Statistics | 0.56 ms |
Preparing | 0.25 ms |
Sorting result | 0.06 ms |
Executing | 0.02 ms |
Sending data | 0.07 ms |
Creating sort index | 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.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 4.36 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.29 ms Après la dernière requête : 15.35 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.115 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.30 ms |
Checking permissions | 0.03 ms |
Opening tables | 1.46 ms |
After opening tables | 0.06 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.15 ms |
Optimizing | 0.11 ms |
Statistics | 0.29 ms |
Preparing | 0.15 ms |
Executing | 0.02 ms |
Sending data | 2.17 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.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 3.70 ms |
Reset for next command | 0.04 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 : 14.47 ms Après la dernière requête : 4.20 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.125 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.04 ms |
Opening tables | 2.28 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.24 ms |
Creating tmp table | 0.21 ms |
Executing | 0.03 ms |
Sending data | 9.55 ms |
Removing tmp table | 0.11 ms |
Sending data | 0.30 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.04 ms |
Updating status | 1.20 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 : 10.62 ms Après la dernière requête : 0.92 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.134 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.80 ms |
Checking permissions | 0.04 ms |
Opening tables | 2.58 ms |
After opening tables | 0.06 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.55 ms |
Optimizing | 0.20 ms |
Statistics | 0.45 ms |
Preparing | 0.22 ms |
Creating tmp table | 0.16 ms |
Sorting for group | 0.05 ms |
Sorting result | 0.06 ms |
Executing | 0.02 ms |
Sending data | 1.42 ms |
Creating sort index | 0.19 ms |
Removing tmp table | 0.39 ms |
Creating sort index | 0.31 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.08 ms |
Updating status | 25.95 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/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.88 ms Après la dernière requête : 272.01 ms Mémoire de requête : 0.024 MB mémoire avant requête : 8.998 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.90 ms |
Checking permissions | 0.04 ms |
Opening tables | 6.90 ms |
After opening tables | 0.06 ms |
System lock | 0.04 ms |
Table lock | 0.03 ms |
Init | 0.42 ms |
Optimizing | 0.30 ms |
Statistics | 1.17 ms |
Preparing | 0.32 ms |
Creating tmp table | 0.37 ms |
Sorting result | 0.16 ms |
Executing | 0.03 ms |
Sending data | 1.36 ms |
Creating sort index | 0.22 ms |
Removing tmp table | 0.42 ms |
Creating sort index | 0.43 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.01 ms |
Closing tables | 0.07 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.08 ms |
Updating status | 7.73 ms |
Reset for next command | 0.07 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 : 6.91 ms Après la dernière requête : 463.17 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.338 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.77 ms |
Checking permissions | 0.04 ms |
Opening tables | 2.01 ms |
After opening tables | 0.06 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.37 ms |
Optimizing | 0.30 ms |
Statistics | 1.12 ms |
Preparing | 0.05 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 | 1.26 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.06 ms |
Updating status | 5.50 ms |
Reset for next command | 0.05 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.74 ms Après la dernière requête : 16.32 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.385 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.79 ms |
Checking permissions | 0.08 ms |
Opening tables | 0.21 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.37 ms |
Optimizing | 0.20 ms |
Statistics | 0.76 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 | 1.08 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.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 : 4.53 ms Après la dernière requête : 3.47 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.401 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.77 ms |
Checking permissions | 0.04 ms |
Opening tables | 0.20 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.37 ms |
Optimizing | 0.20 ms |
Statistics | 0.77 ms |
Preparing | 0.04 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.28 ms |
Sorting result | 0.07 ms |
Executing | 0.02 ms |
Sending data | 1.19 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.07 ms |
Updating status | 3.99 ms |
Reset for next command | 0.05 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.79 ms Après la dernière requête : 4.68 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.417 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.76 ms |
Checking permissions | 0.04 ms |
Opening tables | 0.20 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.37 ms |
Optimizing | 0.20 ms |
Statistics | 0.76 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 | 1.18 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 |
---|
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.54 ms Après la dernière requête : 40.96 ms Mémoire de requête : 0.020 MB mémoire avant requête : 9.442 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.38 ms |
Checking permissions | 0.03 ms |
Opening tables | 2.36 ms |
After opening tables | 0.06 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.30 ms |
Optimizing | 0.16 ms |
Statistics | 0.18 ms |
Preparing | 0.80 ms |
Executing | 0.04 ms |
Sending data | 1.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.01 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 5.13 ms |
Reset for next command | 0.05 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 : 2.14 ms Après la dernière requête : 21.91 ms Mémoire de requête : 0.021 MB mémoire avant requête : 9.466 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.17 ms |
Optimizing | 0.06 ms |
Statistics | 0.07 ms |
Preparing | 0.08 ms |
Executing | 0.02 ms |
Sending data | 0.68 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 |
---|
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.90 ms Après la dernière requête : 46.22 ms Mémoire de requête : 0.021 MB mémoire avant requête : 9.568 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 | 1.02 ms |
After opening tables | 0.05 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.34 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 |
---|
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 : 5.17 ms Après la dernière requête : 15.88 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.593 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.31 ms |
Checking permissions | 0.03 ms |
Opening tables | 1.59 ms |
After opening tables | 0.05 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.47 ms |
Optimizing | 0.10 ms |
Statistics | 0.31 ms |
Preparing | 0.15 ms |
Sorting result | 0.06 ms |
Executing | 0.02 ms |
Sending data | 0.17 ms |
Creating sort index | 1.35 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.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: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.47 ms Après la dernière requête : 0.75 ms Mémoire de requête : 0.025 MB mémoire avant requête : 9.606 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.18 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.15 ms |
Optimizing | 0.05 ms |
Statistics | 0.07 ms |
Preparing | 0.08 ms |
Executing | 0.02 ms |
Sending data | 1.22 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 | 3.53 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/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 : 3.49 ms Après la dernière requête : 23.38 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.723 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.37 ms |
Checking permissions | 0.04 ms |
Opening tables | 0.10 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.25 ms |
Optimizing | 0.13 ms |
Statistics | 0.33 ms |
Preparing | 0.40 ms |
Sorting result | 0.07 ms |
Executing | 0.02 ms |
Sending data | 0.17 ms |
Creating sort index | 0.84 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 |
---|
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.07 ms Après la dernière requête : 0.81 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.730 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.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.09 ms |
Statistics | 0.39 ms |
Preparing | 0.15 ms |
Sorting result | 0.06 ms |
Executing | 0.02 ms |
Sending data | 0.17 ms |
Creating sort index | 0.78 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 | 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 : 3.12 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.737 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.30 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.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.95 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.04 ms |
Updating status | 1.12 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.18 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.743 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.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.23 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.35 ms |
Creating sort index | 0.83 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 | 1.14 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 : 3.17 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.024 MB mémoire avant requête : 9.750 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.22 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.85 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 | 1.15 ms |
Reset for next command | 0.13 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 : 3.03 ms Après la dernière requête : 0.88 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.757 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.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.21 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.67 ms |
End of update loop | 0.04 ms |
Query end | 0.02 ms |
Commit | 0.06 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 | 1.02 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.05 ms Après la dernière requête : 0.77 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.763 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.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.35 ms |
Creating sort index | 0.72 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.01 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 : 3.00 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.770 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.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.10 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.74 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.02 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 ms |
Updating status | 20.62 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 : 12.38 ms Après la dernière requête : 268.51 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.899 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-10-31 23:50:41')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-31 23:50:41')
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.61 ms |
Checking permissions | 0.04 ms |
Opening tables | 3.61 ms |
After opening tables | 0.06 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.31 ms |
Optimizing | 0.37 ms |
Statistics | 0.44 ms |
Preparing | 0.33 ms |
Sorting result | 0.07 ms |
Executing | 0.11 ms |
Sending data | 0.07 ms |
Creating sort index | 3.66 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.07 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.52 ms Après la dernière requête : 292.10 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.264 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.24 ms |
Checking permissions | 0.04 ms |
Opening tables | 1.55 ms |
After opening tables | 0.06 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.10 ms |
Optimizing | 0.07 ms |
Statistics | 0.23 ms |
Preparing | 0.12 ms |
Executing | 0.02 ms |
Sending data | 0.47 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 |
---|
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 : 5.17 ms Après la dernière requête : 1.16 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.277 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.04 ms |
Opening tables | 1.71 ms |
After opening tables | 0.05 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.15 ms |
Optimizing | 0.11 ms |
Statistics | 0.28 ms |
Preparing | 0.15 ms |
Executing | 0.02 ms |
Sending data | 1.82 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 | 3.18 ms |
Reset for next command | 0.05 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.59 ms Après la dernière requête : 2.88 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.292 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` >= '2021-03-01') OR (`e`.`startdate` <= '2021-03-01'
AND `e`.`enddate` >= '2021-03-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.86 ms |
Checking permissions | 0.05 ms |
Opening tables | 4.20 ms |
After opening tables | 0.06 ms |
System lock | 0.03 ms |
Table lock | 0.04 ms |
Init | 0.85 ms |
Optimizing | 0.25 ms |
Optimizing | 0.07 ms |
Statistics | 0.36 ms |
Optimizing | 0.06 ms |
Statistics | 0.15 ms |
Statistics | 0.77 ms |
Preparing | 0.16 ms |
Creating tmp table | 0.12 ms |
Sorting result | 0.07 ms |
Preparing | 0.07 ms |
Creating tmp table | 0.10 ms |
Sorting result | 0.04 ms |
Preparing | 0.29 ms |
Executing | 0.03 ms |
Sending data | 1.00 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.02 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.07 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.10 ms |
Updating status | 13.79 ms |
Reset for next command | 0.06 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.60 ms Après la dernière requête : 26.54 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.447 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.33 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.30 ms |
Preparing | 0.15 ms |
Executing | 0.02 ms |
Sending data | 0.79 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.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 |
---|
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 : 14.05 ms Après la dernière requête : 406.58 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.521 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.88 ms |
Checking permissions | 0.04 ms |
Opening tables | 7.22 ms |
After opening tables | 0.06 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.42 ms |
Optimizing | 0.22 ms |
Statistics | 0.98 ms |
Preparing | 0.31 ms |
Creating tmp table | 0.36 ms |
Sorting result | 0.10 ms |
Executing | 0.02 ms |
Sending data | 1.31 ms |
Creating sort index | 0.62 ms |
Removing tmp table | 0.44 ms |
Creating sort index | 0.32 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.01 ms |
Closing tables | 0.07 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.08 ms |
Updating status | 6.83 ms |
Reset for next command | 0.06 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.63 ms Après la dernière requête : 372.66 ms Mémoire de requête : 0.028 MB mémoire avant requête : 11.383 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.51 ms |
Checking permissions | 0.03 ms |
Opening tables | 1.40 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.35 ms |
Preparing | 0.11 ms |
Executing | 0.02 ms |
Sending data | 4.95 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.04 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 5.03 ms |
Reset for next command | 0.05 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 : 15.10 ms Après la dernière requête : 16.69 ms Mémoire de requête : 0.046 MB mémoire avant requête : 11.448 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-10-31 23:50:41')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-31 23:50:41')
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.40 ms |
Checking permissions | 0.05 ms |
Opening tables | 5.15 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.78 ms |
Preparing | 0.05 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.21 ms |
Sorting result | 0.09 ms |
Executing | 0.02 ms |
Sending data | 0.95 ms |
Creating sort index | 4.77 ms |
End of update loop | 0.07 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.10 ms |
Updating status | 8.33 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 : 5.45 ms Après la dernière requête : 37.14 ms Mémoire de requête : 0.021 MB mémoire avant requête : 11.441 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.35 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.17 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.13 ms |
Optimizing | 0.08 ms |
Statistics | 0.26 ms |
Preparing | 0.22 ms |
Creating tmp table | 0.13 ms |
Sorting result | 0.06 ms |
Executing | 0.02 ms |
Sending data | 2.14 ms |
Creating sort index | 0.19 ms |
Removing tmp table | 0.08 ms |
Creating sort index | 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.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