
Dans notre belle forêt de Fontainebleau, le parcours aventure de Franchard était considéré à son origine comme un circuit d’entrainement avant d’aller en montagne.
Quelques uns continuent à le parcourir avec cette idée et essaient de l’enchainer avec un casque et un sac à dos ! Mais la plupart des grimpeurs en réalisent une partie, puis une autre, puis… jusqu’à l’avoir parcouru dans sa totalité et le site en vaut la chandelle !
Il a été récemment entièrement repeint à l’initiative d’une équipe d’Ivry-sur-Seine. Un travail colossal : la boucle fait 8 kilomètres et franchit plus de 500 blocs !

Les difficultés sont généralement très abordables (1er ou 2ème degré), mais quelques blocs sont bien athlétiques, d’autres assez hauts et engagés. Quelques passages (peu) sont proches du 3ème degré.

Il avait été peint en rouge, en jaune, en orange,…
Au final, l’équipe a choisi de le peindre en orange.

A l'origine, les ouvreurs avaient numérotés plusieurs passages pour permettre aux grimpeurs de se repérer; cette numérotation n'a pas été reprise, mais des signes anciens demeurent.
Ce long parcours permet d’arpenter une majorité des buttes qui constituent le massif de Franchard. La fiche du circuit est ici. On peut l’aborder depuis différents parkings, mais les plus communs sont ceux de l’Isatis (1) ou de l’Ermitage (2).

Accès en voiture : Autoroute du Sud (A6), sortie en direction de Fontainebleau. Puis, soit :
- A 4 km direction Arbonne-la-Forêt, puis la D 409 en direction de Fontainebleau. À 3 kilomètres, prendre à droite le chemin d’accès au parking de l’Isatis.
- Ou depuis la Fontainebleau la N7 (D607), prendre la direction Etampes/Milly-la-Forêt, puis les Gorges de Franchard et l’Ermitage.
Accès pédestre :
- Depuis le parking, prendre la Route de l’Isatis jusqu’à La Cuisinière ; repérer le GR qui coupe le parcours orange.
- Depuis le parking, prendre la Route de l’Ermitage pendant 400 mètres. Prendre une sente à gauche en direction des rochers.
- Détails
- Affichages : 7636
Console de débogage Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1766920797,
"last": 1766920797,
"now": 1766920797
},
"client": {
"forwarded": "216.73.216.44"
},
"token": "twfjNGM9uvI98CXy37lAxXKQ67yAQSqe"
},
"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
},
"fabrik": {
"js": {
"scripts": null,
"cacheids": null,
"head": {
"scripts": null,
"cache": {
"d505f1e593016f6d7120db1cee4a037c": "{\"\\/components\\/com_jcomments\\/js\\/jcomments-v2.3.js?v=12\":{\"type\":\"text\\/javascript\",\"options\":[]},\"\\/components\\/com_jcomments\\/libraries\\/joomlatune\\/ajax.js?v=4\":{\"type\":\"text\\/javascript\",\"options\":[]},\"\\/media\\/sigplus\\/js\\/initialization.min.js?v=ff9209edd7aaded4585815a2ef79c266\":{\"defer\":true,\"type\":\"text\\/javascript\",\"options\":[]},\"\\/media\\/sigplus\\/engines\\/boxplusx\\/js\\/boxplusx.min.js?v=90aef7691cedfcbdd5536f3de3b99f2d\":{\"defer\":true,\"type\":\"text\\/javascript\",\"options\":[]},\"\\/media\\/sigplus\\/engines\\/boxplusx\\/js\\/exif.min.js?v=384b56d3b198d95c1cf41d25d919c748\":{\"defer\":true,\"type\":\"text\\/javascript\",\"options\":[]},\"\\/media\\/sigplus\\/engines\\/slideplus\\/js\\/slideplus.min.js?v=dac28dfe81e6eabcf76d9a175695b884\":{\"defer\":true,\"type\":\"text\\/javascript\",\"options\":[]},\"\\/media\\/jui\\/js\\/jquery.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\/media\\/jui\\/js\\/jquery-noconflict.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\/media\\/jui\\/js\\/jquery-migrate.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\/media\\/system\\/js\\/caption-uncompressed.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\/media\\/jui\\/js\\/bootstrap.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\/templates\\/protostar\\/js\\/template.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\/media\\/jui\\/js\\/html5-uncompressed.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"conditional\":\"lt IE 9\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\/media\\/system\\/js\\/core-uncompressed.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\/media\\/system\\/js\\/polyfill.event-uncompressed.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"conditional\":\"lt IE 9\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\/media\\/system\\/js\\/keepalive-uncompressed.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\/media\\/system\\/js\\/html5fallback-uncompressed.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"conditional\":\"lt IE 9\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}}}"
}
},
"config": null,
"shim": null,
"jlayouts": null
}
}
}
}
Temps
Mémoire
54 requêtes exécutées 53.09 ms
18 doubles découverts!
- Temps de requête : 0.56 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.811 MB Rangées retournées : 0
SELECT `data`
FROM `bcos_session`
WHERE `session_id` = X'3732333332363837623932326330346634313230363563643338313034396561'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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.46 ms Après la dernière requête : 0.76 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.919 MB Rangées retournées : 0
SELECT `session_id`
FROM `bcos_session`
WHERE `session_id` = X'3732333332363837623932326330346634313230363563643338313034396561'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 1.01 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.003 MB mémoire avant requête : 3.924 MB
INSERT INTO `bcos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3732333332363837623932326330346634313230363563643338313034396561', 1, 1766920797, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `bcos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3732333332363837623932326330346634313230363563643338313034396561', 1, 1766920797, 0, '', 0)Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms update 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.61 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 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.84 ms Après la dernière requête : 1.35 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.131 MB Rangées retournées : 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `bcos_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_extensions NULL ref extension extension 82 const 43 1.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.26 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Même appel que celui de la ligne ci-dessous. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.47 ms Après la dernière requête : 1.27 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.392 MB Rangées retournées : 10
SELECT id, rules
FROM `bcos_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_viewlevels NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 10 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.11 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 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.51 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.403 MB Rangées retournées : 1
SELECT b.id
FROM bcos_usergroups AS a
LEFT JOIN bcos_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.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.53 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.472 MB Rangées retournées : 145
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM bcos_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 bcos_extensions NULL ref extension extension 82 const 187 0.40 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.91 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Même appel que celui de la ligne ci-dessous. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.39 ms Après la dernière requête : 23.19 ms Mémoire de requête : 0.004 MB mémoire avant requête : 9.132 MB
SET SQL_BIG_SELECTS=1, GROUP_CONCAT_MAX_LEN=10240EXPLAIN impossible sur la requête : SET SQL_BIG_SELECTS=1, GROUP_CONCAT_MAX_LEN=10240Status Duration starting 0.05 ms Opening tables 0.01 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.11 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/fabrik/fabrik/Helpers/Worker.php:1870 9 Fabrik\Helpers\Worker::bigSelects() JROOT/plugins/system/fabrik/fabrik.php:404 8 PlgSystemFabrik->setBigSelects() JROOT/plugins/system/fabrik/fabrik.php:126 7 PlgSystemFabrik->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 4.31 ms Après la dernière requête : 9.31 ms Mémoire de requête : 0.183 MB mémoire avant requête : 10.365 MB Rangées retournées : 189
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 bcos_menu AS m
LEFT JOIN bcos_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 ALL idx_client_id_parent_id_alias_language INDEX N'A PU ÊTRE UTILISÉ NULL NULL 357 8.04 Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.m.component_id 1 100.00 Using where Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.05 ms executing 3.51 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.05 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Même appel que celui de la ligne ci-dessous. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.63 ms Après la dernière requête : 6.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.561 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `bcos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Même appel que celui de la ligne ci-dessous. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jcomments/jcomments.php:111 8 plgSystemJComments->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.28 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.006 MB mémoire avant requête : 11.553 MB
UPDATE `bcos_extensions`
SET `params` = '{\"mediaversion\":\"b2d5781a7b6eaaac59fc8f10cc7bb0eb\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `bcos_extensions` SET `params` = '{\"mediaversion\":\"b2d5781a7b6eaaac59fc8f10cc7bb0eb\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.34 ms updating 0.35 ms end 0.01 ms query end 0.18 ms waiting for handler commit 0.75 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jcomments/jcomments.php:111 8 plgSystemJComments->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.65 ms Après la dernière requête : 1.65 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.907 MB Rangées retournées : 97
SELECT *
FROM `bcos_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_jcomments_settings NULL ref PRIMARY PRIMARY 214 const,const 97 100.00 NULL Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.14 ms end 0.00 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jcomments/classes/config.php:140 14 JCommentsCfg::_load() 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/components/com_jcomments/classes/config.php:159 11 JCommentsCfg->load() JROOT/components/com_jcomments/classes/config.php:47 10 JCommentsCfg::getInstance() JROOT/components/com_jcomments/helpers/system.php:39 9 JCommentsSystemPluginHelper::getCSS() JROOT/plugins/system/jcomments/jcomments.php:139 8 plgSystemJComments->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.87 ms Après la dernière requête : 0.87 ms Mémoire de requête : 0.021 MB mémoire avant requête : 12.022 MB Rangées retournées : 2
SELECT id, home, template, s.params
FROM bcos_template_styles as s
LEFT JOIN bcos_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 e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 4 1.25 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 cosirocdev.e.element 1 50.00 Using index condition; Using where Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/components/com_jcomments/helpers/system.php:46 9 JCommentsSystemPluginHelper::getCSS() JROOT/plugins/system/jcomments/jcomments.php:139 8 plgSystemJComments->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.49 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.019 MB mémoire avant requête : 12.043 MB Rangées retournées : 2
SELECT *
FROM bcos_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_languages NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 50.00 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.11 ms Après la dernière requête : 3.09 ms Mémoire de requête : 0.025 MB mémoire avant requête : 12.520 MB Rangées retournées : 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `bcos_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_aicontactsafe','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_fabrik','com_fields','com_finder','com_geoportalapi','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sptransfer','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_assets NULL range idx_asset_name idx_asset_name 202 NULL 44 100.00 Using index condition Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.00 ms System lock 0.04 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.02 ms executing 0.38 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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 : 1.81 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.098 MB mémoire avant requête : 12.571 MB Rangées retournées : 621
SELECT `id`,`name`,`rules`,`parent_id`
FROM `bcos_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_assets NULL ALL idx_asset_name,idx_parent_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 732 21.57 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.04 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 1.11 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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 : 1.27 ms Après la dernière requête : 1.36 ms Mémoire de requête : 0.024 MB mémoire avant requête : 13.193 MB Rangées retournées : 3
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,( SELECT COUNT(i.`id`)
FROM `bcos_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `bcos_categories` AS `s`
INNER JOIN `bcos_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.published = 1
AND s.id = 125
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 PRIMARY c NULL range cat_idx,idx_left_right idx_left_right 4 NULL 8 19.86 Using index condition; Using where 2 DEPENDENT SUBQUERY i NULL ref idx_state,idx_catid idx_catid 4 cosirocdev.c.id 13 100.00 Using index condition; Using where Status Duration starting 0.17 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.03 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.06 ms executing 0.03 ms executing 0.12 ms executing 0.24 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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 : 1.85 ms Après la dernière requête : 1.15 ms Mémoire de requête : 0.056 MB mémoire avant requête : 13.381 MB Rangées retournées : 9
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 bcos_content AS a
LEFT JOIN bcos_categories AS c
ON c.id = a.catid
LEFT JOIN bcos_users AS ua
ON ua.id = a.created_by
LEFT JOIN bcos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN bcos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bcos_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid = 125
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-28 11:19:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-28 11:19:57')
ORDER BY c.path, a.created DESC , a.created
LIMIT 15, 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 Utilisation du tri complet de type filesort 1 SIMPLE a NULL ref idx_state,idx_catid idx_catid 4 const 81 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.id 1 100.00 Using where Status Duration starting 0.19 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.13 ms preparing 0.05 ms executing 0.95 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.78 ms Après la dernière requête : 0.92 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.628 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 407
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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cosirocdev.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.73 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.97 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.650 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 386
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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cosirocdev.m.tag_id 1 100.00 Using where Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.76 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.670 MB Rangées retournées : 2
SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 385
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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cosirocdev.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.08 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.78 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.695 MB Rangées retournées : 2
SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 384
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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cosirocdev.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.72 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.719 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 376
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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cosirocdev.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.73 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.739 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 375
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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cosirocdev.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.96 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.759 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 369
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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cosirocdev.m.tag_id 1 100.00 Using where Status Duration starting 0.26 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.28 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.78 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.779 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 383
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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cosirocdev.m.tag_id 1 100.00 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.25 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.83 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.799 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 366
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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cosirocdev.m.tag_id 1 100.00 Using where Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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 : 1.39 ms Après la dernière requête : 0.82 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.897 MB Rangées retournées : 1
SELECT COUNT(*)
FROM bcos_content AS a
LEFT JOIN bcos_categories AS c
ON c.id = a.catid
LEFT JOIN bcos_users AS ua
ON ua.id = a.created_by
LEFT JOIN bcos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN bcos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bcos_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid = 125
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-28 11:19:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-28 11:19:57')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a NULL ref idx_state,idx_catid idx_catid 4 const 81 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where; Using index 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.id 1 100.00 Using where; Using index Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.07 ms statistics 0.12 ms preparing 0.05 ms executing 0.62 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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 : 0.11 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.906 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 125
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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cosirocdev.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.34 ms cleaning up 0.03 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/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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 : 10.82 ms Mémoire de requête : 0.025 MB mémoire avant requête : 16.023 MB Rangées retournées : 3
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 `bcos_categories` AS `s`
INNER JOIN `bcos_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 = 125
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 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 8 19.15 Using index condition; Using where Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.69 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.024 MB mémoire avant requête : 16.046 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 bcos_fields AS a
LEFT JOIN `bcos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN bcos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN bcos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN bcos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN bcos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `bcos_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 (125,0,123))
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 where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 cosirocdev.a.language 1 100.00 Using index condition 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 cosirocdev.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.02 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.00 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms Creating tmp table 0.04 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 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/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.30 ms Après la dernière requête : 9.39 ms Mémoire de requête : 0.024 MB mémoire avant requête : 17.116 MB Rangées retournées : 1Requêtes dupliquées: #41
SELECT `folderid`, `foldertime`, `entitytag`
FROM `bcos_sigplus_folder`
WHERE `folderurl` = '/home/cosiroc/develop/images/massifs/justice/photos_blocs'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_sigplus_folder NULL const folderurl folderurl 769 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.03 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 20 JDatabaseDriver->loadRow() JROOT/plugins/content/sigplus/core/core.php:3099 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.19 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.010 MB mémoire avant requête : 17.190 MBRequêtes dupliquées: #42
START TRANSACTION
EXPLAIN impossible sur la requête : START TRANSACTIONStatus Duration starting 0.01 ms Executing hook on transaction 0.00 ms starting 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:837 21 JDatabaseDriverMysqli->transactionStart() JROOT/plugins/content/sigplus/core/core.php:1081 20 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3107 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.26 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.026 MB mémoire avant requête : 17.201 MB Rangées retournées : 1Requêtes dupliquées: #43
SELECT viewid
FROM bcos_sigplus_view
WHERE folderid = 30
AND hash = 0x121b771b41e7c123846f15c47b1c1785id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_sigplus_view NULL const hash,bcos_FK_sigplus_view_folder hash 16 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms end 0.00 ms query end 0.02 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 25 JDatabaseDriver->loadResult() JROOT/plugins/content/sigplus/core/core.php:1229 24 SigPlusNovoGalleryBase->getView() JROOT/plugins/content/sigplus/core/core.php:1234 23 SigPlusNovoGalleryBase->insertView() JROOT/plugins/content/sigplus/core/core.php:1909 22 SigPlusNovoLocalGallery->populateFolderViews() JROOT/plugins/content/sigplus/core/core.php:1963 21 SigPlusNovoLocalGallery->populate() JROOT/plugins/content/sigplus/core/core.php:1083 20 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3107 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.65 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.026 MB mémoire avant requête : 17.211 MB Rangées retournées : 0Requêtes dupliquées: #44
SELECT i.`fileurl`, i.`imageid`
FROM `bcos_sigplus_image` AS i
INNER JOIN `bcos_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `bcos_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 30
AND NOT EXISTS (SELECT *
FROM `bcos_sigplus_imageview` AS v
WHERE i.`imageid` = v.`imageid`
AND v.`viewid` = 30)
AND depthnum <= 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE h NULL ref PRIMARY,bcos_FK_sigplus_hierarchy_descendant,bcos_IX_sigplus_hierarchy_depthnum PRIMARY 4 const 1 10.00 Using where 1 SIMPLE f NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.h.descendantid 1 100.00 Using index 1 SIMPLE i NULL ref bcos_FK_sigplus_image_folder bcos_FK_sigplus_image_folder 5 cosirocdev.h.descendantid 52 100.00 NULL 1 SIMPLE v NULL eq_ref PRIMARY,bcos_FK_sigplus_imageview_view PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 Using where; Not exists; Using index Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.29 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 24 JDatabaseDriver->loadRowList() JROOT/plugins/content/sigplus/core/core.php:1825 23 SigPlusNovoLocalBase->getMissingImageViews() JROOT/plugins/content/sigplus/core/core.php:1912 22 SigPlusNovoLocalGallery->populateFolderViews() JROOT/plugins/content/sigplus/core/core.php:1963 21 SigPlusNovoLocalGallery->populate() JROOT/plugins/content/sigplus/core/core.php:1083 20 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3107 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.20 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.009 MB mémoire avant requête : 17.220 MBRequêtes dupliquées: #45
COMMITEXPLAIN impossible sur la requête : COMMITStatus Duration starting 0.02 ms waiting for handler commit 0.01 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:777 21 JDatabaseDriverMysqli->transactionCommit() JROOT/plugins/content/sigplus/core/core.php:1089 20 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3107 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.25 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.025 MB mémoire avant requête : 17.229 MB Rangées retournées : 1Requêtes dupliquées: #46
SELECT `langid`
FROM `bcos_sigplus_language`
WHERE `lang` = 'fr'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_sigplus_language NULL const lang lang 2 const 1 100.00 Using index Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.00 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/plugins/content/sigplus/core/core.php:329 20 SigPlusNovoDatabase::getLanguageId() JROOT/plugins/content/sigplus/core/core.php:3185 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.24 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.025 MB mémoire avant requête : 17.238 MB Rangées retournées : 1Requêtes dupliquées: #47
SELECT `countryid`
FROM `bcos_sigplus_country`
WHERE `country` = 'FR'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_sigplus_country NULL const country country 2 const 1 100.00 Using index Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/plugins/content/sigplus/core/core.php:344 20 SigPlusNovoDatabase::getCountryId() JROOT/plugins/content/sigplus/core/core.php:3186 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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 : 3.28 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.074 MB mémoire avant requête : 17.252 MB Rangées retournées : 152
SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`title`
FROM `bcos_sigplus_foldercaption` AS p
WHERE p.`langid` = 48
AND p.`countryid` = 65
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `title`, COALESCE( c.`summary`, ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`summary`
FROM `bcos_sigplus_foldercaption` AS p
WHERE p.`langid` = 48
AND p.`countryid` = 65
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `summary`, `thumb_fileurl`, `thumb_width`, `thumb_height`, `preview_fileurl`, `preview_width`, `preview_height`, `retina_fileurl`, `retina_width`, `retina_height`, `watermark_fileurl`
FROM `bcos_sigplus_image` AS i
INNER JOIN `bcos_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `bcos_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `bcos_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `bcos_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `bcos_sigplus_caption` AS c
ON c.`imageid` = i.`imageid`
AND c.`langid` = 48
AND c.`countryid` = 65
WHERE a.`folderurl` = '/home/cosiroc/develop/images/massifs/justice/photos_blocs'
AND `viewid` = 30
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL const PRIMARY,folderurl folderurl 769 const 1 100.00 Using index; Using temporary; Utilisation du tri complet de type filesort 1 PRIMARY h NULL ref PRIMARY,bcos_FK_sigplus_hierarchy_descendant,bcos_IX_sigplus_hierarchy_depthnum PRIMARY 4 const 1 10.00 Using where 1 PRIMARY f NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.h.descendantid 1 100.00 Using index 1 PRIMARY i NULL ref PRIMARY,bcos_FK_sigplus_image_folder bcos_FK_sigplus_image_folder 5 cosirocdev.h.descendantid 52 100.00 NULL 1 PRIMARY v NULL eq_ref PRIMARY,bcos_FK_sigplus_imageview_view PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 1 PRIMARY c NULL eq_ref PRIMARY,bcos_FK_sigplus_caption_language,bcos_FK_sigplus_caption_country PRIMARY 8 cosirocdev.i.imageid,const,const 1 100.00 NULL 6 DEPENDENT SUBQUERY p NULL ref PRIMARY,bcos_FK_sigplus_foldercaption_language,bcos_FK_sigplus_foldercaption_country PRIMARY 4 cosirocdev.i.folderid 1 100.00 Using where; Utilisation du tri complet de type filesort 5 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 5 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 4 DEPENDENT SUBQUERY p NULL ref PRIMARY,bcos_FK_sigplus_foldercaption_language,bcos_FK_sigplus_foldercaption_country PRIMARY 4 cosirocdev.i.folderid 1 100.00 Using where; Utilisation du tri complet de type filesort 3 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 3 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 2 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 2 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL Status Duration executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.17 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.00 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/plugins/content/sigplus/core/core.php:3348 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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 : 3.04 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.074 MB mémoire avant requête : 17.263 MB Rangées retournées : 152
SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`title`
FROM `bcos_sigplus_foldercaption` AS p
WHERE p.`langid` = 48
AND p.`countryid` = 65
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `title`, COALESCE( c.`summary`, ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`summary`
FROM `bcos_sigplus_foldercaption` AS p
WHERE p.`langid` = 48
AND p.`countryid` = 65
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `summary`, `thumb_fileurl`, `thumb_width`, `thumb_height`, `preview_fileurl`, `preview_width`, `preview_height`, `retina_fileurl`, `retina_width`, `retina_height`, `watermark_fileurl`
FROM `bcos_sigplus_image` AS i
INNER JOIN `bcos_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `bcos_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `bcos_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `bcos_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `bcos_sigplus_caption` AS c
ON c.`imageid` = i.`imageid`
AND c.`langid` = 48
AND c.`countryid` = 65
WHERE a.`folderurl` = '/home/cosiroc/develop/images/massifs/justice/photos_blocs'
AND `viewid` = 30
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL const PRIMARY,folderurl folderurl 769 const 1 100.00 Using index; Using temporary; Utilisation du tri complet de type filesort 1 PRIMARY h NULL ref PRIMARY,bcos_FK_sigplus_hierarchy_descendant,bcos_IX_sigplus_hierarchy_depthnum PRIMARY 4 const 1 10.00 Using where 1 PRIMARY f NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.h.descendantid 1 100.00 Using index 1 PRIMARY i NULL ref PRIMARY,bcos_FK_sigplus_image_folder bcos_FK_sigplus_image_folder 5 cosirocdev.h.descendantid 52 100.00 NULL 1 PRIMARY v NULL eq_ref PRIMARY,bcos_FK_sigplus_imageview_view PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 1 PRIMARY c NULL eq_ref PRIMARY,bcos_FK_sigplus_caption_language,bcos_FK_sigplus_caption_country PRIMARY 8 cosirocdev.i.imageid,const,const 1 100.00 NULL 6 DEPENDENT SUBQUERY p NULL ref PRIMARY,bcos_FK_sigplus_foldercaption_language,bcos_FK_sigplus_foldercaption_country PRIMARY 4 cosirocdev.i.folderid 1 100.00 Using where; Utilisation du tri complet de type filesort 5 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 5 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 4 DEPENDENT SUBQUERY p NULL ref PRIMARY,bcos_FK_sigplus_foldercaption_language,bcos_FK_sigplus_foldercaption_country PRIMARY 4 cosirocdev.i.folderid 1 100.00 Using where; Utilisation du tri complet de type filesort 3 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 3 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 2 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 2 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL Status Duration executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.17 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 20 JDatabaseDriver->loadRowList() JROOT/plugins/content/sigplus/core/core.php:3355 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.35 ms Après la dernière requête : 13.84 ms Mémoire de requête : 0.024 MB mémoire avant requête : 17.382 MB Rangées retournées : 1Requêtes dupliquées: #32
SELECT `folderid`, `foldertime`, `entitytag`
FROM `bcos_sigplus_folder`
WHERE `folderurl` = '/home/cosiroc/develop/images/massifs/justice/photos_blocs'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_sigplus_folder NULL const folderurl folderurl 769 const 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.00 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 20 JDatabaseDriver->loadRow() JROOT/plugins/content/sigplus/core/core.php:3099 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.18 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.009 MB mémoire avant requête : 17.391 MBRequêtes dupliquées: #33
START TRANSACTION
EXPLAIN impossible sur la requête : START TRANSACTIONStatus Duration starting 0.01 ms Executing hook on transaction 0.00 ms starting 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:837 21 JDatabaseDriverMysqli->transactionStart() JROOT/plugins/content/sigplus/core/core.php:1081 20 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3107 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.30 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.026 MB mémoire avant requête : 17.402 MB Rangées retournées : 1Requêtes dupliquées: #34
SELECT viewid
FROM bcos_sigplus_view
WHERE folderid = 30
AND hash = 0x121b771b41e7c123846f15c47b1c1785id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_sigplus_view NULL const hash,bcos_FK_sigplus_view_folder hash 16 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.00 ms executing 0.00 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 25 JDatabaseDriver->loadResult() JROOT/plugins/content/sigplus/core/core.php:1229 24 SigPlusNovoGalleryBase->getView() JROOT/plugins/content/sigplus/core/core.php:1234 23 SigPlusNovoGalleryBase->insertView() JROOT/plugins/content/sigplus/core/core.php:1909 22 SigPlusNovoLocalGallery->populateFolderViews() JROOT/plugins/content/sigplus/core/core.php:1963 21 SigPlusNovoLocalGallery->populate() JROOT/plugins/content/sigplus/core/core.php:1083 20 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3107 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.65 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.026 MB mémoire avant requête : 17.411 MB Rangées retournées : 0Requêtes dupliquées: #35
SELECT i.`fileurl`, i.`imageid`
FROM `bcos_sigplus_image` AS i
INNER JOIN `bcos_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `bcos_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 30
AND NOT EXISTS (SELECT *
FROM `bcos_sigplus_imageview` AS v
WHERE i.`imageid` = v.`imageid`
AND v.`viewid` = 30)
AND depthnum <= 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE h NULL ref PRIMARY,bcos_FK_sigplus_hierarchy_descendant,bcos_IX_sigplus_hierarchy_depthnum PRIMARY 4 const 1 10.00 Using where 1 SIMPLE f NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.h.descendantid 1 100.00 Using index 1 SIMPLE i NULL ref bcos_FK_sigplus_image_folder bcos_FK_sigplus_image_folder 5 cosirocdev.h.descendantid 52 100.00 NULL 1 SIMPLE v NULL eq_ref PRIMARY,bcos_FK_sigplus_imageview_view PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 Using where; Not exists; Using index Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.30 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 24 JDatabaseDriver->loadRowList() JROOT/plugins/content/sigplus/core/core.php:1825 23 SigPlusNovoLocalBase->getMissingImageViews() JROOT/plugins/content/sigplus/core/core.php:1912 22 SigPlusNovoLocalGallery->populateFolderViews() JROOT/plugins/content/sigplus/core/core.php:1963 21 SigPlusNovoLocalGallery->populate() JROOT/plugins/content/sigplus/core/core.php:1083 20 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3107 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.21 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.009 MB mémoire avant requête : 17.421 MBRequêtes dupliquées: #36
COMMITEXPLAIN impossible sur la requête : COMMITStatus Duration starting 0.01 ms waiting for handler commit 0.01 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:777 21 JDatabaseDriverMysqli->transactionCommit() JROOT/plugins/content/sigplus/core/core.php:1089 20 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3107 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.29 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.025 MB mémoire avant requête : 17.430 MB Rangées retournées : 1Requêtes dupliquées: #37
SELECT `langid`
FROM `bcos_sigplus_language`
WHERE `lang` = 'fr'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_sigplus_language NULL const lang lang 2 const 1 100.00 Using index Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.00 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/plugins/content/sigplus/core/core.php:329 20 SigPlusNovoDatabase::getLanguageId() JROOT/plugins/content/sigplus/core/core.php:3185 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.25 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.025 MB mémoire avant requête : 17.439 MB Rangées retournées : 1Requêtes dupliquées: #38
SELECT `countryid`
FROM `bcos_sigplus_country`
WHERE `country` = 'FR'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bcos_sigplus_country NULL const country country 2 const 1 100.00 Using index Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/plugins/content/sigplus/core/core.php:344 20 SigPlusNovoDatabase::getCountryId() JROOT/plugins/content/sigplus/core/core.php:3186 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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 : 3.26 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.074 MB mémoire avant requête : 17.453 MB Rangées retournées : 152
SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`title`
FROM `bcos_sigplus_foldercaption` AS p
WHERE p.`langid` = 48
AND p.`countryid` = 65
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `title`, COALESCE( c.`summary`, ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`summary`
FROM `bcos_sigplus_foldercaption` AS p
WHERE p.`langid` = 48
AND p.`countryid` = 65
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `summary`, `thumb_fileurl`, `thumb_width`, `thumb_height`, `preview_fileurl`, `preview_width`, `preview_height`, `retina_fileurl`, `retina_width`, `retina_height`, `watermark_fileurl`
FROM `bcos_sigplus_image` AS i
INNER JOIN `bcos_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `bcos_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `bcos_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `bcos_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `bcos_sigplus_caption` AS c
ON c.`imageid` = i.`imageid`
AND c.`langid` = 48
AND c.`countryid` = 65
WHERE a.`folderurl` = '/home/cosiroc/develop/images/massifs/justice/photos_blocs'
AND `viewid` = 30
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL const PRIMARY,folderurl folderurl 769 const 1 100.00 Using index; Using temporary; Utilisation du tri complet de type filesort 1 PRIMARY h NULL ref PRIMARY,bcos_FK_sigplus_hierarchy_descendant,bcos_IX_sigplus_hierarchy_depthnum PRIMARY 4 const 1 10.00 Using where 1 PRIMARY f NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.h.descendantid 1 100.00 Using index 1 PRIMARY i NULL ref PRIMARY,bcos_FK_sigplus_image_folder bcos_FK_sigplus_image_folder 5 cosirocdev.h.descendantid 52 100.00 NULL 1 PRIMARY v NULL eq_ref PRIMARY,bcos_FK_sigplus_imageview_view PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 1 PRIMARY c NULL eq_ref PRIMARY,bcos_FK_sigplus_caption_language,bcos_FK_sigplus_caption_country PRIMARY 8 cosirocdev.i.imageid,const,const 1 100.00 NULL 6 DEPENDENT SUBQUERY p NULL ref PRIMARY,bcos_FK_sigplus_foldercaption_language,bcos_FK_sigplus_foldercaption_country PRIMARY 4 cosirocdev.i.folderid 1 100.00 Using where; Utilisation du tri complet de type filesort 5 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 5 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 4 DEPENDENT SUBQUERY p NULL ref PRIMARY,bcos_FK_sigplus_foldercaption_language,bcos_FK_sigplus_foldercaption_country PRIMARY 4 cosirocdev.i.folderid 1 100.00 Using where; Utilisation du tri complet de type filesort 3 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 3 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 2 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 2 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL Status Duration executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.02 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.16 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/plugins/content/sigplus/core/core.php:3348 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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 : 2.99 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.074 MB mémoire avant requête : 17.463 MB Rangées retournées : 152
SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`title`
FROM `bcos_sigplus_foldercaption` AS p
WHERE p.`langid` = 48
AND p.`countryid` = 65
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `title`, COALESCE( c.`summary`, ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`summary`
FROM `bcos_sigplus_foldercaption` AS p
WHERE p.`langid` = 48
AND p.`countryid` = 65
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `summary`, `thumb_fileurl`, `thumb_width`, `thumb_height`, `preview_fileurl`, `preview_width`, `preview_height`, `retina_fileurl`, `retina_width`, `retina_height`, `watermark_fileurl`
FROM `bcos_sigplus_image` AS i
INNER JOIN `bcos_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `bcos_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `bcos_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `bcos_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `bcos_sigplus_caption` AS c
ON c.`imageid` = i.`imageid`
AND c.`langid` = 48
AND c.`countryid` = 65
WHERE a.`folderurl` = '/home/cosiroc/develop/images/massifs/justice/photos_blocs'
AND `viewid` = 30
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL const PRIMARY,folderurl folderurl 769 const 1 100.00 Using index; Using temporary; Utilisation du tri complet de type filesort 1 PRIMARY h NULL ref PRIMARY,bcos_FK_sigplus_hierarchy_descendant,bcos_IX_sigplus_hierarchy_depthnum PRIMARY 4 const 1 10.00 Using where 1 PRIMARY f NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.h.descendantid 1 100.00 Using index 1 PRIMARY i NULL ref PRIMARY,bcos_FK_sigplus_image_folder bcos_FK_sigplus_image_folder 5 cosirocdev.h.descendantid 52 100.00 NULL 1 PRIMARY v NULL eq_ref PRIMARY,bcos_FK_sigplus_imageview_view PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 1 PRIMARY c NULL eq_ref PRIMARY,bcos_FK_sigplus_caption_language,bcos_FK_sigplus_caption_country PRIMARY 8 cosirocdev.i.imageid,const,const 1 100.00 NULL 6 DEPENDENT SUBQUERY p NULL ref PRIMARY,bcos_FK_sigplus_foldercaption_language,bcos_FK_sigplus_foldercaption_country PRIMARY 4 cosirocdev.i.folderid 1 100.00 Using where; Utilisation du tri complet de type filesort 5 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 5 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 4 DEPENDENT SUBQUERY p NULL ref PRIMARY,bcos_FK_sigplus_foldercaption_language,bcos_FK_sigplus_foldercaption_country PRIMARY 4 cosirocdev.i.folderid 1 100.00 Using where; Utilisation du tri complet de type filesort 3 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 3 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL 2 DEPENDENT SUBQUERY mp NULL const PRIMARY,propertyname propertyname 257 const 1 100.00 Using index 2 DEPENDENT SUBQUERY md NULL eq_ref PRIMARY,bcos_FK_sigplus_data_property PRIMARY 8 cosirocdev.i.imageid,const 1 100.00 NULL Status Duration executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.01 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.00 ms executing 0.21 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 20 JDatabaseDriver->loadRowList() JROOT/plugins/content/sigplus/core/core.php:3355 19 SigPlusNovoCore->getGalleryHTML() JROOT/plugins/content/sigplus/sigplus.php:364 18 plgContentSigPlusNovo->getGalleryReplacementSingle() JROOT/plugins/content/sigplus/sigplus.php:271 17 plgContentSigPlusNovo->getReplacements() JROOT/plugins/content/sigplus/sigplus.php:222 16 plgContentSigPlusNovo->{closure}() Même appel que celui de la ligne ci-dessous. 15 preg_replace_callback() JROOT/plugins/content/sigplus/sigplus.php:219 14 plgContentSigPlusNovo->parseContent() JROOT/plugins/content/sigplus/sigplus.php:132 13 plgContentSigPlusNovo->onContentPrepare() 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.63 ms Après la dernière requête : 18.39 ms Mémoire de requête : 0.026 MB mémoire avant requête : 17.885 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 bcos_fields AS a
LEFT JOIN `bcos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN bcos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN bcos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN bcos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN bcos_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
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 where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 cosirocdev.a.language 1 100.00 Using index condition 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.group_id 1 100.00 Using where Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.00 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.05 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.47 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.026 MB mémoire avant requête : 17.896 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 bcos_fields AS a
LEFT JOIN `bcos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN bcos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN bcos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN bcos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN bcos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `bcos_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (125,0,123))
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 where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 cosirocdev.a.language 1 100.00 Using index condition 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 cosirocdev.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:22 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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.81 ms Après la dernière requête : 9.95 ms Mémoire de requête : 0.039 MB mémoire avant requête : 18.644 MB Rangées retournées : 58
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM bcos_modules AS m
LEFT JOIN bcos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN bcos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-12-28 11:19:57')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-28 11:19:57')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 575 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 ALL PRIMARY,published,newsfeeds INDEX N'A PU ÊTRE UTILISÉ NULL NULL 58 1.72 Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 cosirocdev.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 cosirocdev.m.id 18 40.00 Using where; Using index Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.37 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Même appel que celui de la ligne ci-dessous. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/protostar/index.php:91 7 require JROOT/templates/protostar/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.14 ms Après la dernière requête : 1.21 ms Mémoire de requête : 0.082 MB mémoire avant requête : 18.691 MB Rangées retournées : 10
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 bcos_content AS a
LEFT JOIN bcos_categories AS c
ON c.id = a.catid
LEFT JOIN bcos_users AS ua
ON ua.id = a.created_by
LEFT JOIN bcos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN bcos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bcos_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid IN (125)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-28 11:19:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-28 11:19:57')
ORDER BY a.created DESC
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 Utilisation du tri complet de type filesort 1 SIMPLE a NULL ref idx_state,idx_catid idx_catid 4 const 81 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 cosirocdev.a.id 1 100.00 Using where Status Duration starting 0.12 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.00 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.47 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 12 ContentModelArticles->getItems() JROOT/modules/mod_articles_latest/helper.php:123 11 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 10 include JROOT/modules/mod_articles_latest/mod_articles_latest.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.60 ms Après la dernière requête : 10.47 ms Mémoire de requête : 0.024 MB mémoire avant requête : 19.729 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 `bcos_categories` AS `s`
INNER JOIN `bcos_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 = 99
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 207 NULL 27 65.96 Using index condition; Using where Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.11 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 17 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
30 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
10 × SELECT `m`.`tag_id`,`t`.*
FROM `bcos_contentitem_tag_map` AS m
INNER JOIN `bcos_tags` AS t
ON `m`.`tag_id` = `t`.`id`4 × SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT md.`textvalue`
FROM `bcos_sigplus_property` AS mp
INNER JOIN `bcos_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `bcos_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `bcos_assets`2 × 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 bcos_content AS a
LEFT JOIN bcos_categories AS c
ON c.id = a.catid
LEFT JOIN bcos_users AS ua
ON ua.id = a.created_by
LEFT JOIN bcos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN bcos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bcos_content_rating AS v
ON a.id = v.content_id2 × 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 `bcos_categories` AS `s`
INNER JOIN `bcos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM bcos_fields AS a
LEFT JOIN `bcos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN bcos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN bcos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN bcos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN bcos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `bcos_fields_categories` AS fc
ON fc.field_id = a.id2 × SELECT `folderid`, `foldertime`, `entitytag`
FROM `bcos_sigplus_folder`2 × SELECT viewid
FROM bcos_sigplus_view2 × SELECT i.`fileurl`, i.`imageid`
FROM `bcos_sigplus_image` AS i
INNER JOIN `bcos_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `bcos_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`2 × SELECT `langid`
FROM `bcos_sigplus_language`2 × SELECT `countryid`
FROM `bcos_sigplus_country`1 × SELECT `data`
FROM `bcos_session`1 × SELECT `session_id`
FROM `bcos_session`1 × SELECT id, rules
FROM `bcos_viewlevels1 × SELECT b.id
FROM bcos_usergroups AS a
LEFT JOIN bcos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM bcos_extensions1 × 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 bcos_menu AS m
LEFT JOIN bcos_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM `bcos_jcomments_settings`1 × SELECT id, home, template, s.params
FROM bcos_template_styles as s
LEFT JOIN bcos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM bcos_languages1 × 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,( SELECT COUNT(i.`id`)
FROM `bcos_content` AS `i`1 × SELECT COUNT(*)
FROM bcos_content AS a
LEFT JOIN bcos_categories AS c
ON c.id = a.catid
LEFT JOIN bcos_users AS ua
ON ua.id = a.created_by
LEFT JOIN bcos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN bcos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bcos_content_rating AS v
ON a.id = v.content_id1 × 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 bcos_fields AS a
LEFT JOIN `bcos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN bcos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN bcos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN bcos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN bcos_fields_groups AS g
ON g.id = a.group_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM bcos_modules AS m
LEFT JOIN bcos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN bcos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
Autres tables :
2 × START TRANSACTIO
2 × COMMI1 × INSERT INTO `bcos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3732333332363837623932326330346634313230363563643338313034396561', 1, 1766920797, 0, '', 01 ×
SET SQL_BIG_SELECTS=1, GROUP_CONCAT_MAX_LEN=10241 × UPDATE `bcos_extensions`
SET `params` = '{\"mediaversion\":\"b2d5781a7b6eaaac59fc8f10cc7bb0eb\"}'
- Détails
- Affichages : 693
Circuit orange AD/AD+
De longueur moyenne comme le jaune (ils sont quasi-strictement parallèles), il est assez inégal, avec des passages de type et de hauteur très variés. Il est conçu pour un enchaînement si possible sans pied sur le sable. Quelques passages sont hauts (n°13 Grande Dalle et 14, descente assez facile mais impressionnante du bloc de la Grande Dalle. Points d’assurage en place au sommet)) et/ou parfois avec des chutes à éviter. Il comporte plusieurs passages à la descente.
Nota : l’ancien circuit descendait l’ex n°16, voie dite du Talon d’Achille (descente de face un peu impressionnante) avec un pas sauté à l’arrivée. Actuellement numéroté 16bis, c’est le passage, peu engageant pour beaucoup, qui permet d’enchaîner réellement l’orange. L’ancien bis, le même itinéraire en sens inverse, a été numéroté 16. Le pas pour se dresser avec le pied dans le trou est assez exposé et une parade efficace peut y être utile.
Cliquer ici pour l'article complet d'Oleg sur le réaménagement du site en 2014.
Cliquer ici pour tout savoir sur l'origne du nom "Justice de Chambergeot".
- Détails
- Affichages : 4156
Circuit jaune PD
C’est un circuit de longueur moyenne avec 41 passages numérotés, le 26,2 ayant été ajouté alors que la numérotation était peinte (ce qui fonctionne bien lorsque l’on ajoute une sortie sur une autoroute devrait également réussir pour les circuits d’escalade). Les passages sont en général de faible hauteur avec peu de risque en cas de chute. Une parade sera quand même utile dans la Traversée Aveugle (n°38), pas bien haute, mais dont la pente d’atterrissage est suffisamment longue pour prendre de la vitesse.
Cliquer ici pour l'article complet d'Oleg sur le réaménagement du site en 2014.
Cliquer ici pour tout savoir sur l'origne du nom "Justice de Chambergeot".
- Détails
- Affichages : 4090
Le début du circuit jaune avait été partiellement entretenu il y quelques années. La fin du circuit était très peu visible.Jean-Jacques Naëls a eu pour projet de refondre un circuit jaune. Pour commencer il a éliminé les anciens trois premiers numéros aux trois quarts du temps humides. Il a repris la suite jusqu'à l'ancien n°18. La portion qui suivait partant en versant nord très boisé a été abandonnée. La recherche de beaux blocs bien exposés et limitant les risques d'érosion l'a conduit à faire un circuit de niveau AD donc peint en orange.
Une démarche analogue nous a conduits tracer en orange la nouvelle mouture de l'ancien jaune du Cul De Chien. Vu que l'ONF n'autorise pas la création de nouveaux circuits dans ces massifs on peut regretter la diminution du nombre de circuits jaunes dans les Trois Pignons, mais on a maintenant deux circuits orange d'un grand intérêt qui valent sans doute mieux que deux circuits jaunes médiocres.
Le circuit en images (les noms et les cotes sont ceux donnés par J.J. Naëls)
N.B. On peut cliquer n'importe quelle vignette, ce sera l'image de départ. On navigue ensuite à la souris ou par flèches gauche et droite du clavier.
- Détails
- Affichages : 3647
Page 4 sur 16