Contact
Besoin de plus d'information, de nous contacter ? Merci de remplir le formulaire.
Inscrivez-vous à notre "Info Lettre" gratuite
pour recevoir nos dernières informations.
 |
AdresseMairie deMESNIL SELLIERES.
41, Grande rue. 10220 MESNIL SELLIERES. 03 25 80 20 30 Ouverture.
Le Mardi de 16h à 18h Le Samedi de 10h à 12h Mr le Maire Le Samedi de 10h30 à 12h |
En visitant ce site, vous acceptez l'utilisation de cookies afin de vous proposer les meilleurs services possibles.
Console de débogage Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1685242694,
"last": 1685242694,
"now": 1685242694
},
"token": "fElzblyMYeNfGfbOlMFZVQT0jhoDNtCv"
},
"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: 14.85 ms / 14.85 ms Mémoire: 2.003 MB / 2.39 MB Application: afterLoad
Temps: 95.57 ms / 110.41 ms Mémoire: 6.540 MB / 8.93 MB Application: afterInitialise
Temps: 9.58 ms / 120.00 ms Mémoire: 0.815 MB / 9.75 MB Application: afterRoute
Temps: 0.52 ms / 120.52 ms Mémoire: 0.029 MB / 9.77 MB Application: beforeRenderComponent com_content
Temps: 5.13 ms / 125.64 ms Mémoire: 0.552 MB / 10.33 MB Application: Before Access::preloadComponents (all components)
Temps: 0.88 ms / 126.53 ms Mémoire: 0.061 MB / 10.39 MB Application: After Access::preloadComponents (all components)
Temps: 0.02 ms / 126.55 ms Mémoire: -0.003 MB / 10.39 MB Application: Before Access::preloadPermissions (com_content)
Temps: 0.66 ms / 127.21 ms Mémoire: 0.105 MB / 10.49 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.03 ms / 127.24 ms Mémoire: -0.007 MB / 10.48 MB Application: Before Access::getAssetRules (id:255 name:com_content.article.80)
Temps: 0.46 ms / 127.70 ms Mémoire: 0.027 MB / 10.51 MB Application: After Access::getAssetRules (id:255 name:com_content.article.80)
Temps: 23.10 ms / 150.80 ms Mémoire: 1.877 MB / 12.39 MB Application: afterRenderComponent com_content
Temps: 5.08 ms / 155.89 ms Mémoire: 0.409 MB / 12.80 MB Application: afterDispatch
Temps: 12.28 ms / 168.17 ms Mémoire: 1.450 MB / 14.25 MB Application: beforeRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 2.11 ms / 170.28 ms Mémoire: 0.163 MB / 14.41 MB Application: afterRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 0.23 ms / 170.51 ms Mémoire: 0.021 MB / 14.43 MB Application: beforeRenderModule mod_custom (Mentions légales)
Temps: 0.45 ms / 170.95 ms Mémoire: 0.005 MB / 14.43 MB Application: afterRenderModule mod_custom (Mentions légales)
Temps: 0.19 ms / 171.14 ms Mémoire: -0.020 MB / 14.41 MB Application: beforeRenderModule mod_hobosm (Map Module)
Temps: 212.85 ms / 383.99 ms Mémoire: 0.045 MB / 14.46 MB Application: afterRenderModule mod_hobosm (Map Module)
Temps: 0.58 ms / 384.56 ms Mémoire: 0.034 MB / 14.49 MB Application: beforeRenderModule mod_parallax_scroll (Photo avant contact)
Temps: 0.88 ms / 385.45 ms Mémoire: 0.027 MB / 14.52 MB Application: afterRenderModule mod_parallax_scroll (Photo avant contact)
Temps: 0.40 ms / 385.84 ms Mémoire: 0.003 MB / 14.52 MB Application: beforeRenderModule mod_slider_nice_multi_item (Liens Utiles)
Temps: 3.76 ms / 389.60 ms Mémoire: 0.255 MB / 14.78 MB Application: afterRenderModule mod_slider_nice_multi_item (Liens Utiles)
Temps: 0.36 ms / 389.97 ms Mémoire: -0.023 MB / 14.76 MB Application: beforeRenderModule mod_sp_portfolio (Démarches administratives)
Temps: 1.88 ms / 391.85 ms Mémoire: 0.169 MB / 14.93 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Temps: 0.02 ms / 391.87 ms Mémoire: 0.002 MB / 14.93 MB Application: After Access::getAssetRules (id:8 name:com_content)
Temps: 10.18 ms / 402.04 ms Mémoire: 0.289 MB / 15.22 MB Application: afterRenderModule mod_sp_portfolio (Démarches administratives)
Temps: 8.27 ms / 410.31 ms Mémoire: 0.025 MB / 15.24 MB Application: afterRender
Total de requêtes base de données : 28.23 ms
15,60 MB (16 354 152 Bytes)
21 requêtes exécutées 28.23 ms
- Temps de requête : 0.28 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.161 MB Rangées retournées : 0
SELECT `data`
FROM `wjf2o_session`
WHERE `session_id` = X'3266373462663432393138356563353938636638336339363539303365633633'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 0.20 ms Après la dernière requête : 1.02 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.256 MB Rangées retournées : 0
SELECT `session_id`
FROM `wjf2o_session`
WHERE `session_id` = X'3266373462663432393138356563353938636638336339363539303365633633'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 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 : 15.16 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.004 MB mémoire avant requête : 4.261 MB
INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3266373462663432393138356563353938636638336339363539303365633633', 1, 1685242694, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3266373462663432393138356563353938636638336339363539303365633633', 1, 1685242694, 0, '', 0)Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init for update 0.01 ms Update 0.05 ms Waiting for query cache lock 0.01 ms Update 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 14.91 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 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 : 0.25 ms Après la dernière requête : 5.03 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.823 MB Rangées retournées : 5
SELECT id, rules
FROM `wjf2o_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_viewlevels ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 5 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.26 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.836 MB Rangées retournées : 1
SELECT b.id
FROM wjf2o_usergroups AS a
LEFT JOIN wjf2o_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 3.55 ms Après la dernière requête : 26.73 ms Mémoire de requête : 0.007 MB mémoire avant requête : 7.751 MB
UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"0d045b95bfe397c73747bc41f22b02de\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `wjf2o_extensions` SET `params` = '{\"mediaversion\":\"0d045b95bfe397c73747bc41f22b02de\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.08 ms Updating 0.07 ms End of update loop 0.01 ms Waiting for query cache lock 0.00 ms End of update loop 0.01 ms Query end 0.01 ms Commit 3.14 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 15 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 14 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/helix/core/helix.php:50 10 Helix::getDocument() JROOT/plugins/system/helix/core/helix.php:36 9 Helix::getInstance() JROOT/plugins/system/helix/helix.php:21 8 plgSystemHelix->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.70 ms Après la dernière requête : 43.70 ms Mémoire de requête : 0.029 MB mémoire avant requête : 10.332 MB Rangées retournées : 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `wjf2o_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyslider','com_fields','com_finder','com_hobosm','com_icagenda','com_installer','com_jaextmanager','com_joomlaupdate','com_languages','com_login','com_mailjet','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','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 wjf2o_assets ALL idx_asset_name INDEX N'A PU ÊTRE UTILISÉ NULL NULL 257 Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.24 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 20 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 19 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 18 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 17 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 16 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 15 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 13 ContentModelArticle->getItem() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394 12 JViewLegacy->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.45 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.035 MB mémoire avant requête : 10.386 MB Rangées retournées : 100
SELECT `id`,`name`,`rules`,`parent_id`
FROM `wjf2o_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_assets ALL idx_asset_name,idx_parent_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 257 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 20 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 19 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 18 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 17 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 16 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 15 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 13 ContentModelArticle->getItem() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394 12 JViewLegacy->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.60 ms Après la dernière requête : 0.96 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.526 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 wjf2o_content AS a
INNER JOIN wjf2o_categories AS c
on c.id = a.catid
LEFT JOIN wjf2o_users AS u
on u.id = a.created_by
LEFT JOIN wjf2o_categories as parent
ON parent.id = c.parent_id
LEFT JOIN wjf2o_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 80
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-05-28 02:58:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-28 02:58:14')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394 12 JViewLegacy->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.38 ms Après la dernière requête : 2.74 ms Mémoire de requête : 0.022 MB mémoire avant requête : 10.776 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `wjf2o_contentitem_tag_map` AS m
INNER JOIN `wjf2o_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 80
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 thevenin_commune10.m.tag_id 1 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.56 ms Après la dernière requête : 9.93 ms Mémoire de requête : 0.030 MB mémoire avant requête : 11.753 MB Rangées retournées : 7
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 `wjf2o_categories` AS `s`
INNER JOIN `wjf2o_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 = 17
ORDER BY c.lftid 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 32 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.09 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->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/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.87 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.025 MB mémoire avant requête : 11.820 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 wjf2o_fields AS a
LEFT JOIN `wjf2o_languages` AS l
ON l.lang_code = a.language
LEFT JOIN wjf2o_users AS uc
ON uc.id=a.checked_out
LEFT JOIN wjf2o_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN wjf2o_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN wjf2o_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `wjf2o_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 (17,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 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 thevenin_commune10.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 thevenin_commune10.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.21 ms Creating sort index 0.02 ms Removing tmp table 0.05 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 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:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.57 ms Après la dernière requête : 7.48 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.403 MB Rangées retournées : 8
SHOW FULL COLUMNS
FROM `wjf2o_template_styles`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `wjf2o_template_styles`Status Duration Starting 0.03 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.15 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.06 ms closing tables 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.06 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 12 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 11 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 10 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_templates/tables/style.php:30 9 TemplatesTableStyle->__construct() JROOT/libraries/src/Table/Table.php:328 8 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/helix/helix.php:83 7 plgSystemHelix->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 : 0.29 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.021 MB mémoire avant requête : 12.436 MB Rangées retournées : 1
SELECT *
FROM wjf2o_template_styles
WHERE `id` = '18'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_template_styles const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 9 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 8 Joomla\CMS\Table\Table->load() JROOT/plugins/system/helix/helix.php:84 7 plgSystemHelix->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 : 0.97 ms Après la dernière requête : 12.03 ms Mémoire de requête : 0.042 MB mémoire avant requête : 14.190 MB Rangées retournées : 10
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM wjf2o_modules AS m
LEFT JOIN wjf2o_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN wjf2o_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 <= '2023-05-28 02:58:14')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-28 02:58:14')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 181 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds INDEX N'A PU ÊTRE UTILISÉ NULL NULL 90 Using where; Utilisation du tri complet de type filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 thevenin_commune10.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 thevenin_commune10.m.module,const 1 Using index condition; Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.50 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() Même appel que celui de la ligne ci-dessous. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/helix/core/helix.php:735 11 Helix::countModules() JROOT/plugins/system/helix/core/helix.php:351 10 Helix::showRow() JROOT/plugins/system/helix/core/helix.php:448 9 Helix::generatelayout() JROOT/plugins/system/helix/core/helix.php:713 8 Helix::layout() JROOT/templates/shaper_xeon/index.php:49 7 require JROOT/templates/shaper_xeon/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 : 0.18 ms Après la dernière requête : 6.34 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.467 MB Rangées retournées : 0
SELECT *
FROM `wjf2o_hobosm_license_active`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_hobosm_license_active system NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 Const row not found Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/modules/mod_hobosm/helper.php:99 11 ModHobOsmHelper::getLicense() JROOT/modules/mod_hobosm/mod_hobosm.php:23 10 include JROOT/modules/mod_hobosm/mod_hobosm.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.39 ms Après la dernière requête : 211.48 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.476 MB Rangées retournées : 1
SELECT h.greeting, h.params, h.image as image, c.title as category, h.latitude as latitude, h.longitude as longitude, h.zoom as zoom, h.scale as scale, h.width as width, h.position_horizontal as position_horizontal, h.position_vertical as position_vertical
FROM wjf2o_hobosm as h
LEFT JOIN wjf2o_categories as c
ON h.catid=c.id
WHERE h.id=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE h system PRIMARY INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/modules/mod_hobosm/helper.php:115 11 ModHobOsmHelper::getData() JROOT/modules/mod_hobosm/mod_hobosm.php:28 10 include JROOT/modules/mod_hobosm/mod_hobosm.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.27 ms Après la dernière requête : 6.87 ms Mémoire de requête : 0.024 MB mémoire avant requête : 14.824 MB Rangées retournées : 5Requêtes dupliquées: #20
SELECT id
FROM wjf2o_categories
WHERE `parent_id`='17'
AND `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_categories ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 32 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 16 JDatabaseDriver->loadColumn() JROOT/modules/mod_sp_portfolio/helper.php:155 15 modSPPortfolioJHelper::categories() JROOT/modules/mod_sp_portfolio/helper.php:32 14 modSPPortfolioJHelper::getList() JROOT/modules/mod_sp_portfolio/mod_sp_portfolio.php:54 13 include JROOT/modules/mod_sp_portfolio/mod_sp_portfolio.php JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190 12 JModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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 : 1.05 ms Après la dernière requête : 1.00 ms Mémoire de requête : 0.084 MB mémoire avant requête : 14.930 MB Rangées retournées : 15
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 wjf2o_content AS a
LEFT JOIN wjf2o_categories AS c
ON c.id = a.catid
LEFT JOIN wjf2o_users AS ua
ON ua.id = a.created_by
LEFT JOIN wjf2o_users AS uam
ON uam.id = a.modified_by
LEFT JOIN wjf2o_categories as parent
ON parent.id = c.parent_id
LEFT JOIN wjf2o_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid IN (18,19,20,21,22)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-05-28 02:58:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-28 02:58:14')
ORDER BY a.title DESC
LIMIT 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range idx_access,idx_state,idx_catid idx_catid 4 NULL 15 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.modified_by 1 Using where 1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 thevenin_commune10.a.catid 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 thevenin_commune10.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.id 1 Using where Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.39 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 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_sp_portfolio/helper.php:78 14 modSPPortfolioJHelper::getList() JROOT/modules/mod_sp_portfolio/mod_sp_portfolio.php:54 13 include JROOT/modules/mod_sp_portfolio/mod_sp_portfolio.php JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190 12 JModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.30 ms Après la dernière requête : 6.60 ms Mémoire de requête : 0.024 MB mémoire avant requête : 15.196 MB Rangées retournées : 5Requêtes dupliquées: #18
SELECT id
FROM wjf2o_categories
WHERE `parent_id`='17'
AND `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_categories ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 32 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 16 JDatabaseDriver->loadColumn() JROOT/modules/mod_sp_portfolio/helper.php:155 15 modSPPortfolioJHelper::categories() JROOT/modules/mod_sp_portfolio/helper.php:107 14 modSPPortfolioJHelper::getTotal() JROOT/modules/mod_sp_portfolio/mod_sp_portfolio.php:55 13 include JROOT/modules/mod_sp_portfolio/mod_sp_portfolio.php JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190 12 JModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.95 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.083 MB mémoire avant requête : 15.214 MB Rangées retournées : 15
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 wjf2o_content AS a
LEFT JOIN wjf2o_categories AS c
ON c.id = a.catid
LEFT JOIN wjf2o_users AS ua
ON ua.id = a.created_by
LEFT JOIN wjf2o_users AS uam
ON uam.id = a.modified_by
LEFT JOIN wjf2o_categories as parent
ON parent.id = c.parent_id
LEFT JOIN wjf2o_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid IN (18,19,20,21,22)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-05-28 02:58:14')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-28 02:58:14')
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range idx_access,idx_state,idx_catid idx_catid 4 NULL 15 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.modified_by 1 Using where 1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 thevenin_commune10.a.catid 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 thevenin_commune10.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.id 1 Using where Status Duration Starting 0.15 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.38 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 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_sp_portfolio/helper.php:144 14 modSPPortfolioJHelper::getTotal() JROOT/modules/mod_sp_portfolio/mod_sp_portfolio.php:55 13 include JROOT/modules/mod_sp_portfolio/mod_sp_portfolio.php JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190 12 JModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:628 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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
18 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `wjf2o_assets`2 × SELECT id
FROM wjf2o_categories2 × 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 wjf2o_content AS a
LEFT JOIN wjf2o_categories AS c
ON c.id = a.catid
LEFT JOIN wjf2o_users AS ua
ON ua.id = a.created_by
LEFT JOIN wjf2o_users AS uam
ON uam.id = a.modified_by
LEFT JOIN wjf2o_categories as parent
ON parent.id = c.parent_id
LEFT JOIN wjf2o_content_rating AS v
ON a.id = v.content_id1 × SELECT `data`
FROM `wjf2o_session`1 × SELECT `session_id`
FROM `wjf2o_session`1 × SELECT id, rules
FROM `wjf2o_viewlevels1 × SELECT b.id
FROM wjf2o_usergroups AS a
LEFT JOIN wjf2o_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × 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 wjf2o_content AS a
INNER JOIN wjf2o_categories AS c
on c.id = a.catid
LEFT JOIN wjf2o_users AS u
on u.id = a.created_by
LEFT JOIN wjf2o_categories as parent
ON parent.id = c.parent_id
LEFT JOIN wjf2o_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `wjf2o_contentitem_tag_map` AS m
INNER JOIN `wjf2o_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × 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 `wjf2o_categories` AS `s`
INNER JOIN `wjf2o_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × 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 wjf2o_fields AS a
LEFT JOIN `wjf2o_languages` AS l
ON l.lang_code = a.language
LEFT JOIN wjf2o_users AS uc
ON uc.id=a.checked_out
LEFT JOIN wjf2o_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN wjf2o_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN wjf2o_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `wjf2o_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT *
FROM wjf2o_template_styles1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM wjf2o_modules AS m
LEFT JOIN wjf2o_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN wjf2o_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM `wjf2o_hobosm_license_active1 × SELECT h.greeting, h.params, h.image as image, c.title as category, h.latitude as latitude, h.longitude as longitude, h.zoom as zoom, h.scale as scale, h.width as width, h.position_horizontal as position_horizontal, h.position_vertical as position_vertical
FROM wjf2o_hobosm as h
LEFT JOIN wjf2o_categories as c
ON h.catid=c.id
Autres tables :
1 × INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3266373462663432393138356563353938636638336339363539303365633633', 1, 1685242694, 0, '', 01 × UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"0d045b95bfe397c73747bc41f22b02de\"}'1 × SHOW FULL COLUMNS
FROM `wjf2o_template_styles