Eurl Lemaire
6 impasse des myosotis
02800 Charmes
tel : 06.08.80.16.39
Le Service est notre priorité
La qualité notre Force
Console de débogage Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1714086018,
"last": 1714086018,
"now": 1714086018
},
"client": {
"forwarded": "18.222.240.21"
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Temps
Mémoire
Temps: 97.13 ms / 97.13 ms Mémoire: 1.306 MB / 1.44 MB Application: afterLoad
Temps: 201.62 ms / 298.75 ms Mémoire: 3.572 MB / 5.01 MB Application: afterInitialise
Temps: 80.84 ms / 379.59 ms Mémoire: 0.782 MB / 5.80 MB Application: afterRoute
Temps: 47.67 ms / 427.26 ms Mémoire: 0.269 MB / 6.06 MB Application: beforeRenderComponent com_content
Temps: 23.46 ms / 450.72 ms Mémoire: 0.473 MB / 6.54 MB Application: Before Access::preloadComponents (all components)
Temps: 0.98 ms / 451.70 ms Mémoire: 0.050 MB / 6.59 MB Application: After Access::preloadComponents (all components)
Temps: 0.07 ms / 451.78 ms Mémoire: 0.000 MB / 6.58 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Temps: 2.01 ms / 453.78 ms Mémoire: 0.031 MB / 6.62 MB Application: After Access::getAssetRules (id:8 name:com_content)
Temps: 139.37 ms / 593.15 ms Mémoire: 1.951 MB / 8.57 MB Application: afterRenderComponent com_content
Temps: 7.36 ms / 600.51 ms Mémoire: 0.104 MB / 8.67 MB Application: afterDispatch
Temps: 16.84 ms / 617.35 ms Mémoire: 0.184 MB / 8.85 MB Application: beforeRenderModule mod_custom (Footer)
Temps: 5.26 ms / 622.61 ms Mémoire: 0.024 MB / 8.88 MB Application: afterRenderModule mod_custom (Footer)
Temps: 0.18 ms / 622.79 ms Mémoire: 0.000 MB / 8.88 MB Application: beforeRenderModule mod_custom (Partenaire)
Temps: 0.37 ms / 623.16 ms Mémoire: 0.004 MB / 8.88 MB Application: afterRenderModule mod_custom (Partenaire)
Temps: 0.13 ms / 623.29 ms Mémoire: 0.000 MB / 8.88 MB Application: beforeRenderModule mod_custom (Adresse)
Temps: 0.36 ms / 623.64 ms Mémoire: 0.004 MB / 8.88 MB Application: afterRenderModule mod_custom (Adresse)
Temps: 0.13 ms / 623.78 ms Mémoire: 0.000 MB / 8.88 MB Application: beforeRenderModule mod_menu (Menu activité bas)
Temps: 10.08 ms / 633.86 ms Mémoire: 0.103 MB / 8.99 MB Application: afterRenderModule mod_menu (Menu activité bas)
Temps: 0.11 ms / 633.97 ms Mémoire: 0.000 MB / 8.98 MB Application: beforeRenderModule mod_menu (Menu Eurl lemaire Bas)
Temps: 2.87 ms / 636.84 ms Mémoire: 0.031 MB / 9.01 MB Application: afterRenderModule mod_menu (Menu Eurl lemaire Bas)
Temps: 0.30 ms / 637.14 ms Mémoire: 0.010 MB / 9.02 MB Application: beforeRenderModule mod_slideshowck (Nos Réalisations (3))
Temps: 35.04 ms / 672.19 ms Mémoire: 0.303 MB / 9.33 MB Application: afterRenderModule mod_slideshowck (Nos Réalisations (3))
Temps: 0.22 ms / 672.41 ms Mémoire: 0.000 MB / 9.31 MB Application: beforeRenderModule mod_slideshowck (Nos Réalisations (4))
Temps: 26.44 ms / 698.84 ms Mémoire: 0.028 MB / 9.33 MB Application: afterRenderModule mod_slideshowck (Nos Réalisations (4))
Temps: 0.20 ms / 699.04 ms Mémoire: 0.000 MB / 9.31 MB Application: beforeRenderModule mod_slideshowck (Nos Réalisations (5))
Temps: 19.03 ms / 718.08 ms Mémoire: 0.028 MB / 9.34 MB Application: afterRenderModule mod_slideshowck (Nos Réalisations (5))
Temps: 0.20 ms / 718.27 ms Mémoire: 0.000 MB / 9.31 MB Application: beforeRenderModule mod_maximenuck (Maximenu CK)
Temps: 31.19 ms / 749.46 ms Mémoire: 0.869 MB / 10.18 MB Application: afterRenderModule mod_maximenuck (Maximenu CK)
Temps: 0.16 ms / 749.62 ms Mémoire: 0.000 MB / 10.16 MB Application: beforeRenderModule mod_custom (Logo open-bar)
Temps: 0.25 ms / 749.87 ms Mémoire: 0.004 MB / 10.16 MB Application: afterRenderModule mod_custom (Logo open-bar)
Temps: 0.04 ms / 749.91 ms Mémoire: 0.000 MB / 10.16 MB Application: beforeRenderModule mod_custom (Slogan)
Temps: 0.22 ms / 750.13 ms Mémoire: 0.004 MB / 10.17 MB Application: afterRenderModule mod_custom (Slogan)
Temps: 6.03 ms / 756.16 ms Mémoire: 0.125 MB / 10.29 MB Application: afterRender
Total de requêtes base de données : 39.61 ms
10,58 MB (11 090 304 Bytes)
23 requêtes exécutées 39.61 ms
- Temps de requête : 1.67 ms Mémoire de requête : 0.011 MB mémoire avant requête : 3.111 MB Rangées retournées : 0
SELECT `data`
FROM `jom_session`
WHERE `session_id` = '877dab79590ac75e5e149e46e038a402'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_session NULL const PRIMARY PRIMARY 575 const 1 100.00 NULL Status Duration starting 0.03 ms Waiting for query cache lock 0.03 ms starting 0.01 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.27 ms init 0.05 ms System lock 0.01 ms Waiting for query cache lock 0.01 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.05 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.01 ms Waiting for query cache lock 0.01 ms freeing items 0.52 ms Waiting for query cache lock 0.01 ms freeing items 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:831 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 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 : 1.65 ms Après la dernière requête : 10.08 ms Mémoire de requête : 0.006 MB mémoire avant requête : 3.225 MB Rangées retournées : 0
SELECT `session_id`
FROM `jom_session`
WHERE `session_id` = '877dab79590ac75e5e149e46e038a402'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_session NULL const PRIMARY PRIMARY 575 const 1 100.00 Using index Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms Waiting for query cache lock 0.01 ms System lock 0.05 ms optimizing 0.01 ms statistics 0.04 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms Waiting for query cache lock 0.01 ms freeing items 0.82 ms Waiting for query cache lock 0.02 ms freeing items 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 7 JDatabaseDriver->loadResult() JROOT/libraries/src/Application/CMSApplication.php:178 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:833 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 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 : 1.55 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.005 MB mémoire avant requête : 3.234 MB
INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('877dab79590ac75e5e149e46e038a402', 1, '1714086018', 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('877dab79590ac75e5e149e46e038a402', 1, '1714086018', 0, '', 0)Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.12 ms Waiting for query cache lock 0.01 ms update 0.02 ms end 0.01 ms query end 0.86 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 7 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Application/CMSApplication.php:218 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:833 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:415 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 : 1.75 ms Après la dernière requête : 21.60 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.486 MB Rangées retournées : 36
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jom_extensions`
WHERE `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions NULL ref extension extension 62 const 36 100.00 NULL Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.10 ms checking permissions 0.01 ms Opening tables 0.34 ms init 0.05 ms System lock 0.01 ms Waiting for query cache lock 0.01 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.02 ms Sending data 0.31 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.02 ms Waiting for query cache lock 0.01 ms freeing items 0.15 ms Waiting for query cache lock 0.01 ms freeing items 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:422 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:430 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:496 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:596 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.70 ms Après la dernière requête : 9.29 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.701 MB Rangées retournées : 4
SELECT id, rules
FROM `jom_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_viewlevels NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 4 100.00 NULL Status Duration starting 0.17 ms Waiting for query cache lock 0.02 ms starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms sending cached result to clien 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 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:310 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:606 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.53 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.715 MB Rangées retournées : 1
SELECT b.id
FROM jom_usergroups AS a
LEFT JOIN jom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 100.00 Using where; Using index Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.04 ms checking permissions 0.01 ms sending cached result to clien 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 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:310 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:606 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.97 ms Après la dernière requête : 2.30 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.787 MB Rangées retournées : 70
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jom_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions NULL ref extension extension 62 const 87 0.51 Using index condition; Using where; Utilisation du tri complet de type filesort Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms Waiting for query cache lock 0.01 ms System lock 0.04 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.72 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.01 ms Waiting for query cache lock 0.01 ms freeing items 0.26 ms Waiting for query cache lock 0.01 ms freeing items 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:343 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:348 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:606 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.14 ms Après la dernière requête : 35.43 ms Mémoire de requête : 0.007 MB mémoire avant requête : 4.524 MB Rangées retournées : 1
SELECT `enabled`
FROM `jom_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where Status Duration starting 0.03 ms Waiting for query cache lock 0.03 ms starting 0.01 ms checking query cache for query 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms Waiting for query cache lock 0.01 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms Waiting for query cache lock 0.01 ms freeing items 0.34 ms Waiting for query cache lock 0.01 ms freeing items 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/plugins/system/backuponupdate/backuponupdate.php:74 7 require_once JROOT/plugins/system/backuponupdate/backuponupdate.php JROOT/libraries/src/Plugin/PluginHelper.php:253 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:685 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.91 ms Après la dernière requête : 49.80 ms Mémoire de requête : 0.013 MB mémoire avant requête : 5.238 MB Rangées retournées : 17
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 jom_menu AS m
LEFT JOIN jom_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 30 3.33 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 4379423-1.m.component_id 1 100.00 Using where Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.29 ms init 0.04 ms System lock 0.01 ms Waiting for query cache lock 0.01 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.27 ms Waiting for query cache lock 0.01 ms Creating sort index 0.20 ms Waiting for query cache lock 0.01 ms Creating sort index 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.01 ms Waiting for query cache lock 0.01 ms freeing items 0.18 ms Waiting for query cache lock 0.01 ms freeing items 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:76 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:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:446 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:64 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:551 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1146 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.90 ms Après la dernière requête : 99.95 ms Mémoire de requête : 0.010 MB mémoire avant requête : 5.837 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jom_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions NULL ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 NULL Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms Waiting for query cache lock 0.01 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms Waiting for query cache lock 0.01 ms freeing items 0.07 ms Waiting for query cache lock 0.01 ms freeing items 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Même appel que celui de la ligne ci-dessous. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.26 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.007 MB mémoire avant requête : 5.832 MB
UPDATE `jom_extensions`
SET `params` = '{\"mediaversion\":\"270e600f1d03568aaa5130b6479a687d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jom_extensions NULL range element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.03 ms Opening tables 0.02 ms init 0.03 ms System lock 0.11 ms updating 0.10 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.72 ms query end 0.82 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.45 ms Après la dernière requête : 11.97 ms Mémoire de requête : 0.005 MB mémoire avant requête : 6.042 MB Rangées retournées : 1
SELECT *
FROM jom_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_languages NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.34 ms Après la dernière requête : 0.58 ms Mémoire de requête : 0.004 MB mémoire avant requête : 6.057 MB Rangées retournées : 3
SELECT id, home, template, s.params
FROM jom_template_styles as s
LEFT JOIN jom_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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template INDEX N'A PU ÊTRE UTILISÉ NULL NULL 5 20.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 303 4379423-1.s.template,const 1 4.59 Using index condition; Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.28 ms init 0.06 ms System lock 0.01 ms Waiting for query cache lock 0.01 ms System lock 0.06 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms Waiting for query cache lock 0.01 ms freeing items 0.06 ms Waiting for query cache lock 0.01 ms freeing items 0.01 ms storing result in query cache 0.45 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.47 ms Après la dernière requête : 24.47 ms Mémoire de requête : 0.013 MB mémoire avant requête : 6.541 MB Rangées retournées : 36
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jom_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_flippingbook','com_foxcontact','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_assets NULL ALL idx_asset_name INDEX N'A PU ÊTRE UTILISÉ NULL NULL 165 22.42 Using where Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:248 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.71 ms Après la dernière requête : 4.74 ms Mémoire de requête : 0.011 MB mémoire avant requête : 6.675 MB Rangées retournées : 30
SHOW FULL COLUMNS
FROM `jom_content`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `jom_content`Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.32 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.05 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:250 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.22 ms Après la dernière requête : 20.38 ms Mémoire de requête : 0.009 MB mémoire avant requête : 6.948 MB Rangées retournées : 1
SELECT *
FROM jom_content
WHERE `id` = '86'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.07 ms System lock 0.02 ms Waiting for query cache lock 0.01 ms System lock 0.04 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.02 ms Waiting for query cache lock 0.01 ms freeing items 0.08 ms Waiting for query cache lock 0.01 ms freeing items 0.01 ms storing result in query cache 0.21 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.37 ms Après la dernière requête : 0.34 ms Mémoire de requête : 0.008 MB mémoire avant requête : 6.957 MB
UPDATE jom_content
SET `hits` = (`hits` + 1)
WHERE `id` = '86'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jom_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.06 ms updating 0.09 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.81 ms query end 0.90 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1241 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:252 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 4.03 ms Après la dernière requête : 4.50 ms Mémoire de requête : 0.010 MB mémoire avant requête : 7.110 MB Rangées retournées : 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jom_content AS a
INNER JOIN jom_categories AS c
on c.id = a.catid
LEFT JOIN jom_users AS u
on u.id = a.created_by
LEFT JOIN jom_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jom_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 86
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 23:00:18')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 23:00:18')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.23 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.70 ms init 0.10 ms System lock 0.01 ms Waiting for query cache lock 0.01 ms System lock 0.05 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.02 ms Waiting for query cache lock 0.01 ms freeing items 0.06 ms Waiting for query cache lock 0.01 ms freeing items 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.56 ms Après la dernière requête : 6.00 ms Mémoire de requête : 0.009 MB mémoire avant requête : 7.238 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `jom_contentitem_tag_map` AS m
INNER JOIN `jom_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 86
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 4379423-1.m.tag_id 1 100.00 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:180 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.58 ms Après la dernière requête : 64.98 ms Mémoire de requête : 0.015 MB mémoire avant requête : 7.832 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 jom_categories as c
LEFT JOIN jom_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Utilisation du tri complet de type filesort 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right cat_idx 157 NULL 4 55.55 Using index condition; Using where Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.02 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms sending cached result to clien 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:197 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:400 14 PlgSystemFields->onContentPrepare() Même appel que celui de la ligne ci-dessous. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:190 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.61 ms Après la dernière requête : 1.38 ms Mémoire de requête : 0.014 MB mémoire avant requête : 7.894 MB Rangées retournées : 0
SELECT 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
FROM jom_fields AS a
LEFT JOIN `jom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jom_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jom_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (9,0))
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 ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 21 4379423-1.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 4379423-1.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 4379423-1.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 4379423-1.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 4379423-1.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 4379423-1.a.id 1 100.00 Using where; Using index Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.02 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:400 14 PlgSystemFields->onContentPrepare() Même appel que celui de la ligne ci-dessous. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:190 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 9.15 ms Après la dernière requête : 38.67 ms Mémoire de requête : 0.010 MB mémoire avant requête : 8.819 MB Rangées retournées : 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jom_modules AS m
LEFT JOIN jom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jom_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-04-25 23:00:18')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 23:00:18')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 530 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 30 1.82 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 303 4379423-1.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 4379423-1.m.id 1 40.00 Using where; Using index Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms checking query cache for query 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.76 ms init 0.07 ms System lock 0.02 ms Waiting for query cache lock 0.01 ms System lock 0.04 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.69 ms Waiting for query cache lock 0.01 ms Creating sort index 0.08 ms Waiting for query cache lock 0.01 ms Creating sort index 0.06 ms Waiting for query cache lock 0.01 ms Creating sort index 0.25 ms end 0.01 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.02 ms Waiting for query cache lock 0.01 ms freeing items 0.05 ms Waiting for query cache lock 0.01 ms freeing items 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:433 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:363 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:581 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/guyle/index.php:45 7 require JROOT/templates/guyle/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.11 ms Après la dernière requête : 121.56 ms Mémoire de requête : 0.010 MB mémoire avant requête : 10.050 MB Rangées retournées : 40
SELECT *
FROM jom_modules
WHERE published=1
ORDER BY id ;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_modules NULL ref published published 1 const 40 100.00 Using index condition; Utilisation du tri complet de type filesort Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.42 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_maximenuck/helper.php:444 12 modMaximenuckHelper::CreateModulesList() JROOT/modules/mod_maximenuck/helper.php:62 11 modMaximenuckHelper::getItems() JROOT/modules/mod_maximenuck/mod_maximenuck.php:44 10 include JROOT/modules/mod_maximenuck/mod_maximenuck.php JROOT/libraries/src/Helper/ModuleHelper.php:201 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
22 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jom_extensions`1 × SELECT `m`.`tag_id`,`t`.*
FROM `jom_contentitem_tag_map` AS m
INNER JOIN `jom_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jom_content AS a
INNER JOIN jom_categories AS c
on c.id = a.catid
LEFT JOIN jom_users AS u
on u.id = a.created_by
LEFT JOIN jom_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jom_content_rating AS v
ON a.id = v.content_id1 × 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 jom_categories as c
LEFT JOIN jom_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)1 × SELECT *
FROM jom_content1 × SELECT 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
FROM jom_fields AS a
LEFT JOIN `jom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jom_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jom_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT *
FROM jom_modules1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jom_modules AS m
LEFT JOIN jom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jom_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jom_assets`1 × SELECT *
FROM jom_languages1 × SELECT b.id
FROM jom_usergroups AS a
LEFT JOIN jom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `jom_viewlevels1 × SELECT `session_id`
FROM `jom_session`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jom_extensions1 × SELECT `enabled`
FROM `jom_extensions`1 × SELECT `data`
FROM `jom_session`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jom_menu AS m
LEFT JOIN jom_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, home, template, s.params
FROM jom_template_styles as s
LEFT JOIN jom_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
Autres tables :
1 × UPDATE jom_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `jom_content1 × UPDATE `jom_extensions`
SET `params` = '{\"mediaversion\":\"270e600f1d03568aaa5130b6479a687d\"}'1 × INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('877dab79590ac75e5e149e46e038a402', 1, '1714086018', 0, '', 0