La deuxième parite des championnats scolaires du Finistère Nord s'est déroulée au collège de Penn Ar C'hleuz de Brest.
Chez les écoliers, Sébastien Lefebvre se classe deuxième, derrière Mathilde Le Hénaff (Plougastel).
Du côté des collégiens, Victor Lemarchand l'emporte devant Matthieu Lefebvre et Étienne Lefebvre.
Les classements :
| Championnat scolaire 15/16 - Écoles 29N Grille américaine après la ronde 8 |
|||||||||||||||||||
| Pl | Nom | Rapide | Cat. | Fede | Ligue | R 1 | R 2 | R 3 | R 4 | R 5 | R 6 | R 7 | R 8 | Pts | Tr. | NV | Cu. | ||
| 1 | LE HENAFF Mathilde | 1200 R | PouF | FRA | BRE | + 19N | + 7B | - 3N | + 8B | + 13N | + 5B | + 2B | = 4N | 6½ | 32½ | 6 | 29½ | 1326 | |
| 2 | LEFEBVRE Sebastien | 1340 R | PouM | FRA | BRE | + 25N | + 13B | + 10N | + 3B | = 5N | + 4B | - 1N | + 7B | 6½ | 32 | 6 | 32 | 1340 | |
| 3 | BOUY-GUEST Leandre | 799 E | PouM | FRA | BRE | + 26N | + 18B | + 1B | - 2N | - 4B | + 13N | + 5N | + 8B | 6 | 31½ | 6 | 27 | 1250 | |
| 4 | BALCON Alexis | 1050 R | PouM | FRA | BRE | + 20N | + 6B | - 5N | + 19B | + 3N | - 2N | + 9B | = 1B | 5½ | 34 | 5 | 26½ | 1247 | |
| 5 | NOBE-RICHARD Esto | 1250 R | PouM | FRA | BRE | + 27B | + 14N | + 4B | + 6N | = 2B | - 1N | - 3B | + 10N | 5½ | 33½ | 5 | 29 | 1273 | |
| 6 | JOFFRE Sylvain | 1340 R | PouM | FRA | BRE | + 15B | - 4N | + 25B | - 5B | + 10N | + 11N | - 7B | + 12N | 5 | 27 | 5 | 22 | 1111 | |
| 7 | ENGONE-MINTOGHE Lucas | 960 R | PouM | FRA | BRE | + 23B | - 1N | + 12B | + 10B | - 8N | = 9B | + 6N | - 2N | 4½ | 31 | 4 | 22½ | 1118 | |
| 8 | L'HOSTIS Lucie | 799 E | PouF | FRA | BRE | - 14B | + 15N | + 24B | - 1N | + 7B | = 12N | + 11B | - 3N | 4½ | 28 | 4 | 20½ | 1038 | |
| 9 | NOBE-RICHARD Viggo | 799 E | PpoM | FRA | BRE | - 11B | - 27N | + 17B | + 25N | + 18B | = 7N | - 4N | + 13B | 4½ | 23 | 4 | 17½ | 928 | |
| 10 | LAMBERT Arthur | 1070 R | PpoM | FRA | BRE | + 12B | + 11N | - 2B | - 7N | - 6B | + 14N | + 13B | - 5B | 4 | 29 | 4 | 20 | 1093 | |
| 11 | GUEGUEN Paul | 900 R | PupM | FRA | BRE | + 9N | - 10B | + 20N | - 13B | + 12N | - 6B | - 8N | + 17B | 4 | 25½ | 4 | 19 | 1004 | |
| 12 | GABRIELCZYK Harold | 799 E | PouM | FRA | BRE | - 10N | + 26B | - 7N | + 14N | - 11B | = 8B | + 18N | - 6B | 3½ | 25 | 3 | 15½ | 917 | |
| 13 | QUANTIN Baptiste | 1010 R | PupM | FRA | BRE | + 17B | - 2N | + 27B | + 11N | - 1B | - 3B | - 10N | - 9N | 3 | 31½ | 3 | 19 | 951 | |
| 14 | LE BIAN CASTEL Vassily | 999 E | PupM | FRA | BRE | + 8N | - 5B | - 19N | - 12B | + 15N | - 10B | - 21N | + 18B | 3 | 25½ | 3 | 13 | 863 | |
| 15 | CADINOT Matheo | 799 E | PpoM | FRA | BRE | - 6N | - 8B | + 18N | - 20B | - 14B | + 16N | - 17B | + 26N | 3 | 24½ | 3 | 10 | 859 | |
| 16 | CHAMPS Aurelien | 799 E | PouM | FRA | BRE | + 26N | - 15B | + 22N | + 21B | 3 | 23 | 3 | 7 | 998 | |||||
| 17 | JACQ Theo | 799 E | PpoM | FRA | BRE | - 13N | - 19B | - 9N | - 18B | + 28N | + 26B | + 15N | - 11N | 3 | 21 | 3 | 9 | 754 | |
| 18 | ASQUOET Titouan | 840 R | PpoM | FRA | BRE | = 24B | - 3N | - 15B | + 17N | - 9N | + 22B | - 12B | - 14N | 2½ | 24½ | 2 | 12 | 819 | |
| 19 | FERNANDEZ Lucas | 799 E | PouM | FRA | BRE | - 1B | + 17N | + 14B | - 4N | 2 | 27 | 2 | 13 | 1063 | |||||
| 20 | GUILLOU Naelle | 799 E | PpoF | FRA | BRE | - 4B | + 23N | - 11B | + 15N | 2 | 25½ | 2 | 12 | 936 | |||||
| 21 | LE BARON Emrick | 799 E | PouM | FRA | BRE | - 22N | + 28B | + 14B | - 16N | 2 | 24 | 2 | 5 | 796 | |||||
| 22 | BOURCIN Clement | 799 E | PpoM | FRA | BRE | + 21B | - 18N | - 16B | + 28N | 2 | 24 | 2 | 5 | 754 | |||||
| 23 | LE JEAN Enora | 799 E | PpoF | FRA | BRE | - 7N | - 20B | + 26N | + 27N | 2 | 23½ | 2 | 11 | 758 | |||||
| 24 | RAGUENNES Annabelle | 799 E | PouF | FRA | BRE | = 18N | - 25B | - 8N | + 26B | 1½ | 20½ | 1 | 9 | 682 | |||||
| 25 | CONQ Enzo | 799 E | PouM | FRA | BRE | - 2B | + 24N | - 6N | - 9B | 1 | 26 | 1 | 7 | 749 | |||||
| 26 | SOITHOUX Gaetan | 799 E | PpoM | FRA | BRE | - 3B | - 12N | - 23B | - 24N | - 16B | - 17N | + 28B | - 15B | 1 | 25 | 1 | 2 | 522 | |
| 27 | CORRIGOU Baptiste | 799 E | PouM | FRA | BRE | - 5N | + 9B | - 13N | - 23B | 1 | 23½ | 1 | 7 | 756 | |||||
| 28 | LOAEC Morgane | 999 E | PupF | FRA | BRE | - 17B | - 21N | - 26N | - 22B | 0 | 23 | 0 | 0 | 8 | |||||
Console de débogage Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713487725,
"last": 1713487725,
"now": 1713487725
},
"token": "HdFtiz9aI8MC0O2HPEO869itcPGPjyTn"
},
"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
},
"com_mailto": {
"links": {
"e7a6882084a8a256c6c160ef9ccda83ef361dcb5": {
"link": "http://echiquiergouesnousien.fr/index.php/les-archives/saison-2015-2016/791-championnats-scolaires-du-finistere-nord-suite-et-fin",
"expiry": 1713487725
}
}
}
}
}
Temps
Mémoire
Temps: 21.18 ms / 21.18 ms Mémoire: 2.483 MB / 2.71 MB Application: afterLoad
Temps: 80.53 ms / 101.71 ms Mémoire: 7.502 MB / 10.22 MB Application: afterInitialise
Temps: 18.01 ms / 119.72 ms Mémoire: 1.589 MB / 11.80 MB Application: Before Access::preloadComponents (all components)
Temps: 1.38 ms / 121.11 ms Mémoire: 0.102 MB / 11.91 MB Application: After Access::preloadComponents (all components)
Temps: 0.06 ms / 121.17 ms Mémoire: -0.006 MB / 11.90 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Temps: 0.75 ms / 121.92 ms Mémoire: 0.051 MB / 11.95 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Temps: 11.37 ms / 133.29 ms Mémoire: 0.956 MB / 12.91 MB Application: afterRoute
Temps: 1.46 ms / 134.75 ms Mémoire: 0.058 MB / 12.97 MB Application: beforeRenderComponent com_content
Temps: 6.67 ms / 141.42 ms Mémoire: 0.716 MB / 13.68 MB Application: Before Access::preloadPermissions (com_content)
Temps: 5.59 ms / 147.01 ms Mémoire: 1.639 MB / 15.32 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.33 ms / 147.34 ms Mémoire: -0.102 MB / 15.22 MB Application: Before Access::getAssetRules (id:914 name:com_content.article.791)
Temps: 0.10 ms / 147.44 ms Mémoire: 0.010 MB / 15.23 MB Application: After Access::getAssetRules (id:914 name:com_content.article.791)
Temps: 40.95 ms / 188.39 ms Mémoire: 2.535 MB / 17.76 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Temps: 0.08 ms / 188.47 ms Mémoire: 0.009 MB / 17.77 MB Application: After Access::getAssetRules (id:1 name:root.1)
Temps: 126.49 ms / 314.96 ms Mémoire: 2.349 MB / 20.12 MB Application: afterRenderComponent com_content
Temps: 3.46 ms / 318.42 ms Mémoire: 0.068 MB / 20.19 MB Application: afterDispatch
Temps: 26.43 ms / 344.86 ms Mémoire: 1.012 MB / 21.20 MB Application: beforeRenderModule mod_menu (Administration)
Temps: 12.00 ms / 356.85 ms Mémoire: 0.138 MB / 21.34 MB Application: afterRenderRawModule mod_menu (Administration)
Temps: 0.03 ms / 356.89 ms Mémoire: -0.004 MB / 21.34 MB Application: beforeRenderModule mod_menu (Administration)
Temps: 1.45 ms / 358.34 ms Mémoire: 0.065 MB / 21.40 MB Application: afterRenderModule mod_menu (Administration)
Temps: 0.94 ms / 359.28 ms Mémoire: 0.003 MB / 21.40 MB Application: beforeRenderModule mod_breadcrumbs (Fil d'Ariane)
Temps: 2.43 ms / 361.70 ms Mémoire: 0.038 MB / 21.44 MB Application: afterRenderRawModule mod_breadcrumbs (Fil d'Ariane)
Temps: 0.02 ms / 361.72 ms Mémoire: -0.008 MB / 21.43 MB Application: beforeRenderModule mod_breadcrumbs (Fil d'Ariane)
Temps: 0.48 ms / 362.21 ms Mémoire: 0.004 MB / 21.44 MB Application: afterRenderModule mod_breadcrumbs (Fil d'Ariane)
Temps: 0.74 ms / 362.95 ms Mémoire: 0.007 MB / 21.44 MB Application: beforeRenderModule mod_articles_latest (Dernières modifications)
Temps: 3.78 ms / 366.73 ms Mémoire: 0.363 MB / 21.81 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Temps: 0.12 ms / 366.84 ms Mémoire: 0.010 MB / 21.82 MB Application: After Access::getAssetRules (id:8 name:com_content)
Temps: 17.82 ms / 384.66 ms Mémoire: 0.379 MB / 22.20 MB Application: afterRenderRawModule mod_articles_latest (Dernières modifications)
Temps: 0.07 ms / 384.73 ms Mémoire: -0.145 MB / 22.05 MB Application: beforeRenderModule mod_articles_latest (Dernières modifications)
Temps: 0.54 ms / 385.28 ms Mémoire: 0.004 MB / 22.06 MB Application: afterRenderModule mod_articles_latest (Dernières modifications)
Temps: 0.41 ms / 385.69 ms Mémoire: -0.021 MB / 22.03 MB Application: beforeRenderModule mod_login (Identification)
Temps: 4.73 ms / 390.42 ms Mémoire: 0.198 MB / 22.23 MB Application: afterRenderRawModule mod_login (Identification)
Temps: 0.02 ms / 390.43 ms Mémoire: -0.004 MB / 22.23 MB Application: beforeRenderModule mod_login (Identification)
Temps: 0.36 ms / 390.79 ms Mémoire: 0.004 MB / 22.23 MB Application: afterRenderModule mod_login (Identification)
Temps: 0.10 ms / 390.89 ms Mémoire: -0.002 MB / 22.23 MB Application: beforeRenderModule mod_whosonline (Sur le site :)
Temps: 2.52 ms / 393.41 ms Mémoire: 0.173 MB / 22.40 MB Application: afterRenderRawModule mod_whosonline (Sur le site :)
Temps: 0.02 ms / 393.42 ms Mémoire: -0.004 MB / 22.40 MB Application: beforeRenderModule mod_whosonline (Sur le site :)
Temps: 0.38 ms / 393.81 ms Mémoire: 0.004 MB / 22.40 MB Application: afterRenderModule mod_whosonline (Sur le site :)
Temps: 0.45 ms / 394.25 ms Mémoire: 0.028 MB / 22.43 MB Application: beforeRenderModule mod_custom (Liens institutionnels)
Temps: 0.92 ms / 395.18 ms Mémoire: 0.009 MB / 22.44 MB Application: afterRenderRawModule mod_custom (Liens institutionnels)
Temps: 0.02 ms / 395.19 ms Mémoire: -0.002 MB / 22.44 MB Application: beforeRenderModule mod_custom (Liens institutionnels)
Temps: 0.42 ms / 395.61 ms Mémoire: 0.004 MB / 22.44 MB Application: afterRenderModule mod_custom (Liens institutionnels)
Temps: 0.70 ms / 396.32 ms Mémoire: 0.009 MB / 22.45 MB Application: beforeRenderModule mod_search (Recherche)
Temps: 1.60 ms / 397.92 ms Mémoire: 0.027 MB / 22.48 MB Application: afterRenderRawModule mod_search (Recherche)
Temps: 0.02 ms / 397.94 ms Mémoire: -0.005 MB / 22.47 MB Application: beforeRenderModule mod_search (Recherche)
Temps: 0.43 ms / 398.37 ms Mémoire: 0.004 MB / 22.48 MB Application: afterRenderModule mod_search (Recherche)
Temps: 71.96 ms / 470.33 ms Mémoire: 3.887 MB / 26.36 MB Application: afterRender
Total de requêtes base de données : 29.40 ms
26,99 MB (28 300 776 Bytes)
29 requêtes exécutées 29.40 ms
- Temps de requête : 0.47 ms
SELECT `data`
FROM `rbywh_session`
WHERE `session_id` = X'336432736a373770676337626a336c3171726532667530693035'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysql->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.42 ms Après la dernière requête : 1.65 ms
SELECT `session_id`
FROM `rbywh_session`
WHERE `session_id` = X'336432736a373770676337626a336c3171726532667530693035'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 9 JDatabaseDriverMysql->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 : 0.39 ms Après la dernière requête : 0.19 ms
INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'336432736a373770676337626a336c3171726532667530693035', 1, 1713487725, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'336432736a373770676337626a336c3171726532667530693035', 1, 1713487725, 0, '', 0)Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.04 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 8 JDatabaseDriverMysql->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.40 ms Après la dernière requête : 6.56 ms
SELECT id, rules
FROM `rbywh_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_viewlevels ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 4 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysql->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.45 ms Après la dernière requête : 0.19 ms
SELECT b.id
FROM rbywh_usergroups AS a
LEFT JOIN rbywh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysql->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 : 0.66 ms Après la dernière requête : 65.71 ms
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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_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,5)
AND c.published = 1
AND s.id = 791
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 12 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 11 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:350 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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.37 ms Après la dernière requête : 0.17 ms
SELECT `alias`,`catid`
FROM `rbywh_content`
WHERE `id` = 791id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/components/com_content/helpers/legacyrouter.php:366 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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.83 ms Après la dernière requête : 0.79 ms
SELECT `id`,`name`,`rules`,`parent_id`
FROM `rbywh_assets`
WHERE `name` IN ('root.1','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_autotweet','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailjet','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_sendinblue','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_assets range idx_asset_name idx_asset_name 402 NULL 45 Using index condition Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.02 ms Statistics 0.14 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.26 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/plugins/system/advancedmodules/src/Document.php:28 11 RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() JROOT/plugins/system/advancedmodules/advancedmodules.php:78 10 PlgSystemAdvancedModules->handleOnAfterRoute() JROOT/libraries/regularlabs/src/Plugin.php:95 9 RegularLabs\Library\Plugin->onAfterRoute() Même appel que celui de la ligne ci-dessous. 8 call_user_func_array() 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.46 ms Après la dernière requête : 3.44 ms
UPDATE `rbywh_extensions`
SET `params` = '{\"mediaversion\":\"4fcce903d7005d8276c26599f6672531\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `rbywh_extensions` SET `params` = '{\"mediaversion\":\"4fcce903d7005d8276c26599f6672531\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.07 ms Updating 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.05 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysql->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jcomments/jcomments.php:111 9 plgSystemJComments->onAfterRoute() Même appel que celui de la ligne ci-dessous. 8 call_user_func_array() 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.79 ms Après la dernière requête : 16.80 ms
SELECT `id`,`name`,`rules`,`parent_id`
FROM `rbywh_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_assets ALL idx_asset_name,idx_parent_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1163 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.01 ms Sending data 1.39 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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.84 ms Après la dernière requête : 4.80 ms
SHOW FULL COLUMNS
FROM `rbywh_content`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `rbywh_content`Status Duration Starting 0.03 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.19 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.12 ms closing tables 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.07 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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.44 ms Après la dernière requête : 4.24 ms
UPDATE rbywh_content
SET `hits` = (`hits` + 1)
WHERE `id` = '791'EXPLAIN impossible sur la requête : UPDATE rbywh_content SET `hits` = (`hits` + 1) WHERE `id` = '791'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.05 ms Updating 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.05 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysql->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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.74 ms Après la dernière requête : 14.20 ms
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM rbywh_content AS a
INNER JOIN rbywh_categories AS c
on c.id = a.catid
LEFT JOIN rbywh_users AS u
on u.id = a.created_by
LEFT JOIN rbywh_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rbywh_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 791
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 00:48:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 00:48:45')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.03 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425 12 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.81 ms Après la dernière requête : 2.78 ms
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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_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,5)
AND c.published = 1
AND s.id = 140
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right INDEX N'A PU ÊTRE UTILISÉ NULL NULL 88 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.12 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 25 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 20 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 19 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 18 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 17 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.55 ms Après la dernière requête : 1.36 ms
SELECT `m`.`tag_id`,`t`.*
FROM `rbywh_contentitem_tag_map` AS m
INNER JOIN `rbywh_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 791
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 gouesnou_joom976.m.tag_id 1 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.05 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.38 ms Après la dernière requête : 66.82 ms
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM rbywh_content AS a
LEFT JOIN rbywh_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 140
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 00:48:45')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 00:48:45')
ORDER BY a.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 17 Using intersect(idx_catid,idx_state); Using where; Utilisation du tri complet de type filesort 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.69 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/content/pagenavigation/pagenavigation.php:161 15 PlgContentPagenavigation->onContentBeforeDisplay() Même appel que celui de la ligne ci-dessous. 14 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:199 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.88 ms Après la dernière requête : 85.06 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM rbywh_modules AS m
LEFT JOIN rbywh_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN rbywh_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m range published,newsfeeds published 5 NULL 15 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE am eq_ref PRIMARY PRIMARY 4 gouesnou_joom976.m.id 1 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 gouesnou_joom976.m.module,const 1 Using index condition; Using where Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.25 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:413 20 PlgSystemAdvancedModuleHelper->getModuleList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:127 19 PlgSystemAdvancedModuleHelper->onPrepareModuleList() Même appel que celui de la ligne ci-dessous. 18 call_user_func_array() JROOT/libraries/joomla/event/dispatcher.php:165 17 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 16 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:366 15 Joomla\CMS\Helper\_ModuleHelper::load() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87 14 Joomla\CMS\Helper\_ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 13 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/t3/includes/core/template.php:641 12 T3Template->countModules() JROOT/templates/t3_blank/tpls/blocks/header.php:37 11 include JROOT/templates/t3_blank/tpls/blocks/header.php JROOT/plugins/system/t3/includes/core/template.php:200 10 T3Template->loadBlock() JROOT/templates/t3_blank/tpls/default.php:29 9 include JROOT/templates/t3_blank/tpls/default.php JROOT/plugins/system/t3/includes/core/template.php:226 8 T3Template->loadLayout() JROOT/templates/t3_blank/index.php:34 7 require JROOT/templates/t3_blank/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 : 11.20 ms Après la dernière requête : 38.85 ms
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 rbywh_content AS a
LEFT JOIN rbywh_categories AS c
ON c.id = a.catid
LEFT JOIN rbywh_users AS ua
ON ua.id = a.created_by
LEFT JOIN rbywh_users AS uam
ON uam.id = a.modified_by
LEFT JOIN rbywh_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rbywh_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 00:48:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 00:48:45')
ORDER BY
CASE WHEN (a.modified = '0000-00-00 00:00:00') THEN a.created ELSE a.modified END DESC
LIMIT 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL PRIMARY INDEX N'A PU ÊTRE UTILISÉ NULL NULL 88 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE a ref|filter idx_state,idx_catid idx_catid|idx_state 4|1 gouesnou_joom976.c.id 7 (66%) Using index condition; Using where; Using rowid filter 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 gouesnou_joom976.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 gouesnou_joom976.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 gouesnou_joom976.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 gouesnou_joom976.a.id 1 Using where Status Duration Starting 0.22 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.05 ms Creating tmp table 0.17 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 8.06 ms Creating sort index 0.78 ms Removing tmp table 1.32 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 16 ContentModelArticles->getItems() JROOT/modules/mod_articles_latest/helper.php:123 15 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 14 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 13 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:611 9 Joomla\CMS\Helper\_ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.76 ms Après la dernière requête : 1.57 ms
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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_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,5)
AND c.published = 1
AND s.id = 80
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right INDEX N'A PU ÊTRE UTILISÉ NULL NULL 88 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 29 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 27 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 26 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 25 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 24 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 23 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 22 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 21 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 20 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 17 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 16 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_latest/helper.php:135 15 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 14 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 13 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:611 9 Joomla\CMS\Helper\_ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.71 ms Après la dernière requête : 0.66 ms
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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_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,5)
AND c.published = 1
AND s.id = 79
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range|filter cat_idx,idx_access,idx_left_right idx_left_right|cat_idx 4|207 NULL 11 (55%) Using index condition; Using where; Using rowid filter Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.16 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 29 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 27 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 26 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 25 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 24 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 23 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 22 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 21 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 20 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 17 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 16 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_latest/helper.php:135 15 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 14 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 13 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:611 9 Joomla\CMS\Helper\_ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.72 ms Après la dernière requête : 1.17 ms
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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_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,5)
AND c.published = 1
AND s.id = 81
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right INDEX N'A PU ÊTRE UTILISÉ NULL NULL 88 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.06 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 29 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 27 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 26 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 25 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 24 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 23 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 22 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 21 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 20 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 17 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 16 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_latest/helper.php:135 15 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 14 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 13 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:611 9 Joomla\CMS\Helper\_ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.49 ms Après la dernière requête : 8.20 ms
SELECT guest, client_id
FROM rbywh_session
WHERE client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_session ref client_id_guest client_id_guest 2 const 242 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_whosonline/helper.php:45 12 ModWhosonlineHelper::getOnlineCount() JROOT/modules/mod_whosonline/mod_whosonline.php:19 11 include JROOT/modules/mod_whosonline/mod_whosonline.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 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 : 1.27 ms Après la dernière requête : 65.43 ms
SHOW TABLES
EXPLAIN impossible sur la requête : SHOW TABLESStatus Duration Starting 0.07 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms checking permissions 0.67 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.04 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1550 20 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 19 JDatabaseDriverMysqli->getTableList() JROOT/libraries/f0f/database/driver/joomla.php:251 18 F0FDatabaseDriverJoomla->getTableList() JROOT/libraries/f0f/table/table.php:2070 17 F0FTable->getTableFields() JROOT/libraries/f0f/table/table.php:536 16 F0FTable->__construct() JROOT/administrator/components/com_autotweet/tables/automator.php:33 15 AutotweetTableAutomator->__construct() JROOT/libraries/f0f/table/table.php:433 14 F0FTable::getAnInstance() JROOT/libraries/f0f/model/model.php:2037 13 F0FModel->_createTable() JROOT/libraries/f0f/model/model.php:1994 12 F0FModel->getTable() JROOT/administrator/components/com_autotweet/models/automators.php:91 11 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 10 AutotweetModelAutomators->lastRunCheck() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102 9 PlgSystemAutotweetAutomator->_onAfterRender() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214 8 PlgSystemAutotweetAutomator->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.72 ms Après la dernière requête : 0.30 ms
SHOW FULL COLUMNS
FROM `rbywh_autotweet_automator`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `rbywh_autotweet_automator`Status Duration Starting 0.03 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.17 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.06 ms closing tables 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.06 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 19 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/f0f/database/driver/joomla.php:229 18 F0FDatabaseDriverJoomla->getTableColumns() JROOT/libraries/f0f/table/table.php:2155 17 F0FTable->getTableFields() JROOT/libraries/f0f/table/table.php:536 16 F0FTable->__construct() JROOT/administrator/components/com_autotweet/tables/automator.php:33 15 AutotweetTableAutomator->__construct() JROOT/libraries/f0f/table/table.php:433 14 F0FTable::getAnInstance() JROOT/libraries/f0f/model/model.php:2037 13 F0FModel->_createTable() JROOT/libraries/f0f/model/model.php:1994 12 F0FModel->getTable() JROOT/administrator/components/com_autotweet/models/automators.php:91 11 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 10 AutotweetModelAutomators->lastRunCheck() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102 9 PlgSystemAutotweetAutomator->_onAfterRender() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214 8 PlgSystemAutotweetAutomator->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.44 ms Après la dernière requête : 1.37 ms
SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator
WHERE `rbywh_autotweet_automator`.`plugin` = 'automator'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_autotweet_automator ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 Using where Status Duration Starting 0.04 ms checking permissions 0.03 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/f0f/database/driver/joomla.php:291 13 F0FDatabaseDriverJoomla->loadAssoc() JROOT/libraries/f0f/table/table.php:949 12 F0FTable->load() JROOT/administrator/components/com_autotweet/models/automators.php:96 11 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 10 AutotweetModelAutomators->lastRunCheck() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102 9 PlgSystemAutotweetAutomator->_onAfterRender() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214 8 PlgSystemAutotweetAutomator->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.40 ms Après la dernière requête : 0.27 ms
SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator
WHERE `rbywh_autotweet_automator`.`id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_autotweet_automator const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/libraries/f0f/database/driver/joomla.php:291 14 F0FDatabaseDriverJoomla->loadAssoc() JROOT/libraries/f0f/table/table.php:949 13 F0FTable->load() JROOT/libraries/f0f/model/model.php:1154 12 F0FModel->getItem() JROOT/administrator/components/com_autotweet/models/automators.php:100 11 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 10 AutotweetModelAutomators->lastRunCheck() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102 9 PlgSystemAutotweetAutomator->_onAfterRender() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214 8 PlgSystemAutotweetAutomator->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.16 ms Après la dernière requête : 0.45 ms
SET sql_big_selects=1EXPLAIN impossible sur la requête : SET sql_big_selects=1Status Duration Starting 0.03 ms Opening tables 0.02 ms After opening tables 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/database.php:33 10 JDatabase->query() JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:236 9 PlgAutotweetBase->onContentPolling() JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446 8 PlgSystemAutotweetContent->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.34 ms Après la dernière requête : 0.67 ms
SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator
WHERE `rbywh_autotweet_automator`.`plugin` = 'content'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_autotweet_automator ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/libraries/f0f/database/driver/joomla.php:291 14 F0FDatabaseDriverJoomla->loadAssoc() JROOT/libraries/f0f/table/table.php:949 13 F0FTable->load() JROOT/administrator/components/com_autotweet/models/automators.php:96 12 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 11 AutotweetModelAutomators->lastRunCheck() JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648 10 PlgAutotweetBase->executeContentPolling() JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238 9 PlgAutotweetBase->onContentPolling() JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446 8 PlgSystemAutotweetContent->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.33 ms Après la dernière requête : 0.24 ms
SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator
WHERE `rbywh_autotweet_automator`.`id` = '2'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_autotweet_automator const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/libraries/f0f/database/driver/joomla.php:291 15 F0FDatabaseDriverJoomla->loadAssoc() JROOT/libraries/f0f/table/table.php:949 14 F0FTable->load() JROOT/libraries/f0f/model/model.php:1154 13 F0FModel->getItem() JROOT/administrator/components/com_autotweet/models/automators.php:100 12 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 11 AutotweetModelAutomators->lastRunCheck() JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648 10 PlgAutotweetBase->executeContentPolling() JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238 9 PlgAutotweetBase->onContentPolling() JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446 8 PlgSystemAutotweetContent->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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
21 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
5 × 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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)4 × SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `rbywh_assets`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM rbywh_modules AS m
LEFT JOIN rbywh_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN rbywh_advancedmodules as am
ON am.moduleid = m.id1 × 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 rbywh_content AS a
LEFT JOIN rbywh_categories AS c
ON c.id = a.catid
LEFT JOIN rbywh_users AS ua
ON ua.id = a.created_by
LEFT JOIN rbywh_users AS uam
ON uam.id = a.modified_by
LEFT JOIN rbywh_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rbywh_content_rating AS v
ON a.id = v.content_id1 × SELECT guest, client_id
FROM rbywh_session1 × SELECT `session_id`
FROM `rbywh_session`1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM rbywh_content AS a
LEFT JOIN rbywh_categories AS cc
ON cc.id = a.catid1 × SELECT `m`.`tag_id`,`t`.*
FROM `rbywh_contentitem_tag_map` AS m
INNER JOIN `rbywh_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT id, rules
FROM `rbywh_viewlevels1 × SELECT `alias`,`catid`
FROM `rbywh_content`1 × SELECT `data`
FROM `rbywh_session`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM rbywh_content AS a
INNER JOIN rbywh_categories AS c
on c.id = a.catid
LEFT JOIN rbywh_users AS u
on u.id = a.created_by
LEFT JOIN rbywh_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rbywh_content_rating AS v
ON a.id = v.content_id1 × SELECT b.id
FROM rbywh_usergroups AS a
LEFT JOIN rbywh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
Autres tables :
1 × SHOW FULL COLUMNS
FROM `rbywh_autotweet_automator1 ×
SET sql_big_selects=1 × SHOW TABLE
1 × UPDATE rbywh_content
SET `hits` = (`hits` + 1)1 × UPDATE `rbywh_extensions`
SET `params` = '{\"mediaversion\":\"4fcce903d7005d8276c26599f6672531\"}'1 × SHOW FULL COLUMNS
FROM `rbywh_content1 × INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'336432736a373770676337626a336c3171726532667530693035', 1, 1713487725, 0, '', 0
| Championnat scolaire 15/16 - Collèges 29N Grille américaine après la ronde 8 |
|||||||||||||||||||
| Pl | Nom | Rapide | Cat. | Fede | Ligue | R 1 | R 2 | R 3 | R 4 | R 5 | R 6 | R 7 | R 8 | Pts | Tr. | NV | Cu. | ||
| 1 | LEMARCHAND Victor | 1550 R | BenM | FRA | BRE | + 43B | + 13N | + 30B | + 3N | + 2B | + 9N | + 4B | - 5N | 7 | 35 | 7 | 35 | 1645 | |
| 2 | LEFEBVRE Matthieu | 1600 R | BenM | FRA | BRE | + 37N | + 58B | + 4N | + 25B | - 1N | + 8B | + 7N | + 3B | 7 | 32½ | 7 | 32 | 1615 | |
| 3 | LEFEBVRE Etienne | 1450 R | PupM | FRA | BRE | + 57N | + 11B | + 8N | - 1B | + 5N | + 6B | + 18N | - 2N | 6 | 36 | 6 | 30 | 1500 | |
| 4 | GUERMEUR Teo | 1260 R | BenM | FRA | BRE | + 19B | + 26N | - 2B | + 44N | + 10N | + 5B | - 1N | + 8B | 6 | 34 | 6 | 28 | 1442 | |
| 5 | AUTRET Iwan | 1340 R | BenM | FRA | BRE | + 55B | + 15N | + 7B | + 31N | - 3B | - 4N | + 21B | + 1B | 6 | 33½ | 6 | 29 | 1460 | |
| 6 | TANNEAU Erwann | 1190 R | PupM | FRA | BRE | - 26B | + 19N | + 43B | + 20N | + 22B | - 3N | + 9B | + 7B | 6 | 28 | 6 | 25 | 1326 | |
| 7 | BASTARDIE-CONTE Lara | 1230 R | BenF | FRA | BRE | + 51N | + 45B | - 5N | + 11B | + 13N | + 25B | - 2B | - 6N | 5 | 33 | 5 | 27 | 1273 | |
| 8 | MANDON Youenn | 1200 R | BenM | FRA | BRE | + 28B | + 20N | - 3B | + 27N | + 21B | - 2N | + 10B | - 4N | 5 | 32 | 5 | 26 | 1251 | |
| 9 | TAHER Bilel | 1280 R | PupM | FRA | BRE | + 12B | + 44N | - 17N | + 46B | + 25N | - 1B | - 6N | + 18B | 5 | 32 | 5 | 25 | 1305 | |
| 10 | BALCON Clement | 1190 R | PupM | FRA | BRE | + 14N | - 17B | + 16N | + 38N | - 4B | + 35B | - 8N | + 11B | 5 | 31½ | 5 | 23 | 1270 | |
| 11 | ROYER Maxendre | 1170 R | PupM | FRA | BRE | + 46B | - 3N | + 26B | - 7N | + 20B | + 12N | + 16B | - 10N | 5 | 29½ | 5 | 23 | 1213 | |
| 12 | HAUWAERT Simon | 999 E | BenM | FRA | BRE | - 9N | + 34B | + 58N | - 17B | + 40N | - 11B | + 36N | + 20B | 5 | 26 | 5 | 20 | 1228 | |
| 13 | MUSSET Arthur | 1180 R | PupM | FRA | BRE | + 47N | - 1B | + 37N | + 41N | - 7B | - 18B | + 32N | + 19N | 5 | 25½ | 5 | 22 | 1257 | |
| 14 | N'GUYEN Benoit | 999 E | PupM | FRA | BRE | - 10B | + 32N | - 44B | = 15N | = 19B | + 29N | + 22B | + 21N | 5 | 25½ | 4 | 17½ | 1179 | |
| 15 | JEFFROY Dylan | 1170 R | PupM | FRA | BRE | + 24N | - 5B | - 18N | = 14B | + 41N | - 16B | + 40N | + 27B | 4½ | 27 | 4 | 17½ | 1158 | |
| 16 | AUVIGNE Hugo | 999 E | PupM | FRA | BRE | - 38B | + 42N | - 10B | + 58N | = 27B | + 15N | - 11N | + 35B | 4½ | 24 | 4 | 18 | 1085 | |
| 17 | KEBER Yanis | 1660 R | BenM | FRA | BRE | + 32B | + 10N | + 9B | + 12N | 4 | 33 | 4 | 26 | 1942 | |||||
| 18 | HORELLOU Thomas | 999 E | BenM | FRA | BRE | - 30B | + 29N | + 15B | - 21N | + 38B | + 13N | - 3B | - 9N | 4 | 29½ | 4 | 20 | 1146 | |
| 19 | JOUAN Eliott | 999 E | PupM | FRA | BRE | - 4N | - 6B | + 34N | = 54B | = 14N | + 24B | + 35N | - 13B | 4 | 29½ | 3 | 15½ | 1118 | |
| 20 | GAUVIN Clement | 910 R | BenM | FRA | BRE | + 36N | - 8B | + 35N | - 6B | - 11N | + 28B | + 25N | - 12N | 4 | 28 | 4 | 19 | 1081 | |
| 21 | ROPARS Youenn | 1150 R | BenM | FRA | BRE | - 40N | + 51B | + 45N | + 18B | - 8N | + 32B | - 5N | - 14B | 4 | 26½ | 4 | 21 | 1141 | |
| 22 | BARBEITOS Loic | 1050 R | PupM | FRA | BRE | = 41N | - 40B | = 24N | + 57B | - 6N | + 26B | - 14N | + 32B | 4 | 23½ | 3 | 16 | 1070 | |
| 23 | NOBE-RICHARD Amos | 1390 R | PupM | FRA | BRE | + 53N | + 57B | + 47N | + 33B | 4 | 22 | 4 | 10 | 1744 | |||||
| 24 | TRAPENARD Alexis | 999 E | PupM | FRA | BRE | - 15B | = 55N | = 22B | - 32N | + 56B | - 19N | + 37N | + 36B | 4 | 22 | 3 | 13½ | 1100 | |
| 25 | LE GALL Mathieu | 1199 E | MinM | FRA | BRE | + 42B | + 38N | + 41B | - 2N | - 9B | - 7N | - 20B | = 26N | 3½ | 27½ | 3 | 21½ | 965 | |
| 26 | PUSNEL-PORACCHIA Jules | 999 E | PupM | FRA | BRE | + 6N | - 4B | - 11N | - 35B | + 57N | - 22N | + 38B | = 25B | 3½ | 27½ | 3 | 14½ | 1016 | |
| 27 | HINCELIN Maitena | 870 R | BenF | FRA | BRE | - 35N | + 53B | + 54N | - 8B | = 16N | - 36B | + 41N | - 15N | 3½ | 23½ | 3 | 17 | 1027 | |
| 28 | LEON Theo | 999 E | PupM | FRA | BRE | - 8N | - 36B | - 50B | + 34N | + 43B | - 20N | = 29B | + 42N | 3½ | 22½ | 3 | 11 | 968 | |
| 29 | MINGANT Ewen | 830 R | PupM | FRA | BRE | - 54N | - 18B | + 51N | + 37B | - 35N | - 14B | = 28N | + 40B | 3½ | 22 | 3 | 13 | 1002 | |
| 30 | PENNEC Antoine | 1270 R | MinM | FRA | BRE | + 18N | + 54B | - 1N | + 40B | 3 | 30 | 3 | 20 | 1378 | |||||
| 31 | ROUDAUT Florian | 1330 R | MinM | FRA | BRE | + 53N | + 35B | + 40N | - 5B | 3 | 28 | 3 | 21 | 1275 | |||||
| 32 | BAINIER Johan | 999 E | PupM | FRA | BRE | - 17N | - 14B | + 47N | + 24B | > 46N | - 21N | - 13B | - 22N | 3 | 28 | 3 | 15 | 1030 | |
| 33 | ASQUOET Yoann | 1040 R | BenM | FRA | BRE | + 48B | + 49N | + 42B | - 23N | 3 | 26½ | 3 | 9 | 1303 | |||||
| 34 | PREMEL Matthieu | 850 R | PupM | FRA | BRE | - 44B | - 12N | - 19B | - 28B | + 39N | + 43N | - 49B | + 52N | 3 | 26½ | 3 | 8 | 980 | |
| 35 | CHOPIN Lenny | 1030 R | BenM | FRA | BRE | + 27B | - 31N | - 20B | + 26N | + 29B | - 10N | - 19B | - 16N | 3 | 26 | 3 | 17 | 957 | |
| 36 | ROUDAUT Aziliz | 1150 R | BenF | FRA | BRE | - 20B | + 28N | - 46B | - 50N | + 51B | + 27N | - 12B | - 24N | 3 | 24½ | 3 | 14 | 947 | |
| 37 | BERG Killian | 999 E | PupM | FRA | BRE | - 2B | + 56N | - 13B | - 29N | - 42B | + 51N | - 24B | + 41B | 3 | 24½ | 3 | 11 | 991 | |
| 38 | MAKSUTI Bleona | 800 R | BenF | FRA | BRE | + 16N | - 25B | + 55N | - 10B | - 18N | - 41B | - 26N | + 51B | 3 | 24 | 3 | 15 | 935 | |
| 39 | FOURRE Tristan | 999 E | PupM | FRA | BRE | - 34B | + 48N | + 43B | + 47N | 3 | 22 | 3 | 6 | 1203 | |||||
| 40 | RODRIGUES Hugo | 960 R | BenM | FRA | BRE | + 21B | + 22N | - 31B | - 30N | - 12B | = 42N | - 15B | - 29N | 2½ | 27½ | 2 | 16½ | 982 | |
| 41 | LEON Thimotee | 890 R | PupM | FRA | BRE | = 22B | + 50N | - 25N | - 13B | - 15B | + 38N | - 27B | - 37N | 2½ | 24½ | 2 | 14 | 888 | |
| 42 | LORET Corentin | 999 E | PupM | FRA | BRE | - 25N | - 16B | - 57N | + 47B | + 37N | = 40B | - 33N | - 28B | 2½ | 22 | 2 | 10½ | 886 | |
| 43 | BERLIVET Clement | 999 E | BenM | FRA | BRE | - 1N | + 47B | - 6N | - 45B | - 28N | - 34B | - 39N | + 56B | 2 | 28½ | 2 | 8 | 884 | |
| 44 | AUBRET Martin | 1020 R | BenM | FRA | BRE | + 34N | - 9B | + 14N | - 4B | 2 | 28 | 2 | 14 | 1150 | |||||
| 45 | LEOSTIC Shawn | 999 E | BenM | FRA | BRE | + 50B | - 7N | - 21B | + 43N | 2 | 25 | 2 | 13 | 1161 | |||||
| 46 | REBOUT- BERNARD Victor | 970 R | PupM | FRA | BRE | - 11N | + 57B | + 36N | - 9N | < 32B | 2 | 25 | 2 | 13 | 1192 | ||||
| 47 | RAMONET Simon | 999 E | PupM | FRA | BRE | - 13B | - 43N | - 32B | - 42N | + 52B | + 56N | - 23B | - 39B | 2 | 25 | 2 | 7 | 910 | |
| 48 | MONTREER Lucas | 999 E | PupM | FRA | BRE | - 33N | - 39B | + 53N | + 59B | 2 | 25 | 2 | 3 | 982 | |||||
| 49 | CORRE Louis | 999 E | BenM | FRA | BRE | + 59B | - 33B | + 34N | 2 | 23 | 2 | 6 | 1026 | ||||||
| 50 | SALAUN Kenta | 1200 R | MinM | FRA | BRE | - 45N | - 41B | + 28N | + 36B | 2 | 22½ | 2 | 11 | 988 | |||||
| 51 | LE COZ Mathias | 999 E | BenM | FRA | BRE | - 7B | - 21N | - 29B | + 53B | - 36N | - 37B | + 57N | - 38N | 2 | 21½ | 2 | 7 | 856 | |
| 52 | CLOAREC Dorian | 999 E | PupM | FRA | BRE | - 47N | + 53B | + 59N | - 34B | 2 | 20½ | 2 | 5 | 933 | |||||
| 53 | COLIN Mathis | 999 E | BenM | FRA | BRE | - 31B | - 27N | = 56B | - 51N | - 23B | - 52N | - 48B | + 57B | 1½ | 24½ | 1 | 4 | 868 | |
| 54 | AURIOL Thomas | 999 E | BenM | FRA | BRE | + 29B | - 30N | - 27B | = 19N | 1½ | 23½ | 1 | 10½ | 960 | |||||
| 55 | BONNIORD Jonathan | 999 E | BenM | FRA | BRE | - 5N | = 24B | - 38B | + 56N | 1½ | 23½ | 1 | 8½ | 1020 | |||||
| 56 | SABALY Aliou | 999 E | PupM | FRA | BRE | - 58N | - 37B | = 53N | - 55B | - 24N | - 47B | EXE | - 43N | 1½ | 17½ | 1 | 5 | 680 | |
| 57 | BITTARD Quentin | 999 E | PupM | FRA | BRE | - 3B | - 46N | + 42B | - 22N | - 26B | - 23N | - 51B | - 53N | 1 | 26 | 1 | 6 | 758 | |
| 58 | GUEGUEN Jean | 1170 R | PupM | FRA | BRE | + 56B | - 2N | - 12B | - 16B | 1 | 25½ | 1 | 8 | 1062 | |||||
| 59 | VIRAMA Yorann | 999 E | PupM | FRA | BRE | - 49N | EXE | - 52B | - 48N | 1 | 24½ | 1 | 3 | 386 | |||||
Console de débogage Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713487725,
"last": 1713487725,
"now": 1713487725
},
"token": "HdFtiz9aI8MC0O2HPEO869itcPGPjyTn"
},
"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
},
"com_mailto": {
"links": {
"e7a6882084a8a256c6c160ef9ccda83ef361dcb5": {
"link": "http://echiquiergouesnousien.fr/index.php/les-archives/saison-2015-2016/791-championnats-scolaires-du-finistere-nord-suite-et-fin",
"expiry": 1713487725
}
}
}
}
}
Temps
Mémoire
Temps: 21.18 ms / 21.18 ms Mémoire: 2.483 MB / 2.71 MB Application: afterLoad
Temps: 80.53 ms / 101.71 ms Mémoire: 7.502 MB / 10.22 MB Application: afterInitialise
Temps: 18.01 ms / 119.72 ms Mémoire: 1.589 MB / 11.80 MB Application: Before Access::preloadComponents (all components)
Temps: 1.38 ms / 121.11 ms Mémoire: 0.102 MB / 11.91 MB Application: After Access::preloadComponents (all components)
Temps: 0.06 ms / 121.17 ms Mémoire: -0.006 MB / 11.90 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Temps: 0.75 ms / 121.92 ms Mémoire: 0.051 MB / 11.95 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Temps: 11.37 ms / 133.29 ms Mémoire: 0.956 MB / 12.91 MB Application: afterRoute
Temps: 1.46 ms / 134.75 ms Mémoire: 0.058 MB / 12.97 MB Application: beforeRenderComponent com_content
Temps: 6.67 ms / 141.42 ms Mémoire: 0.716 MB / 13.68 MB Application: Before Access::preloadPermissions (com_content)
Temps: 5.59 ms / 147.01 ms Mémoire: 1.639 MB / 15.32 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.33 ms / 147.34 ms Mémoire: -0.102 MB / 15.22 MB Application: Before Access::getAssetRules (id:914 name:com_content.article.791)
Temps: 0.10 ms / 147.44 ms Mémoire: 0.010 MB / 15.23 MB Application: After Access::getAssetRules (id:914 name:com_content.article.791)
Temps: 40.95 ms / 188.39 ms Mémoire: 2.535 MB / 17.76 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Temps: 0.08 ms / 188.47 ms Mémoire: 0.009 MB / 17.77 MB Application: After Access::getAssetRules (id:1 name:root.1)
Temps: 126.49 ms / 314.96 ms Mémoire: 2.349 MB / 20.12 MB Application: afterRenderComponent com_content
Temps: 3.46 ms / 318.42 ms Mémoire: 0.068 MB / 20.19 MB Application: afterDispatch
Temps: 26.43 ms / 344.86 ms Mémoire: 1.012 MB / 21.20 MB Application: beforeRenderModule mod_menu (Administration)
Temps: 12.00 ms / 356.85 ms Mémoire: 0.138 MB / 21.34 MB Application: afterRenderRawModule mod_menu (Administration)
Temps: 0.03 ms / 356.89 ms Mémoire: -0.004 MB / 21.34 MB Application: beforeRenderModule mod_menu (Administration)
Temps: 1.45 ms / 358.34 ms Mémoire: 0.065 MB / 21.40 MB Application: afterRenderModule mod_menu (Administration)
Temps: 0.94 ms / 359.28 ms Mémoire: 0.003 MB / 21.40 MB Application: beforeRenderModule mod_breadcrumbs (Fil d'Ariane)
Temps: 2.43 ms / 361.70 ms Mémoire: 0.038 MB / 21.44 MB Application: afterRenderRawModule mod_breadcrumbs (Fil d'Ariane)
Temps: 0.02 ms / 361.72 ms Mémoire: -0.008 MB / 21.43 MB Application: beforeRenderModule mod_breadcrumbs (Fil d'Ariane)
Temps: 0.48 ms / 362.21 ms Mémoire: 0.004 MB / 21.44 MB Application: afterRenderModule mod_breadcrumbs (Fil d'Ariane)
Temps: 0.74 ms / 362.95 ms Mémoire: 0.007 MB / 21.44 MB Application: beforeRenderModule mod_articles_latest (Dernières modifications)
Temps: 3.78 ms / 366.73 ms Mémoire: 0.363 MB / 21.81 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Temps: 0.12 ms / 366.84 ms Mémoire: 0.010 MB / 21.82 MB Application: After Access::getAssetRules (id:8 name:com_content)
Temps: 17.82 ms / 384.66 ms Mémoire: 0.379 MB / 22.20 MB Application: afterRenderRawModule mod_articles_latest (Dernières modifications)
Temps: 0.07 ms / 384.73 ms Mémoire: -0.145 MB / 22.05 MB Application: beforeRenderModule mod_articles_latest (Dernières modifications)
Temps: 0.54 ms / 385.28 ms Mémoire: 0.004 MB / 22.06 MB Application: afterRenderModule mod_articles_latest (Dernières modifications)
Temps: 0.41 ms / 385.69 ms Mémoire: -0.021 MB / 22.03 MB Application: beforeRenderModule mod_login (Identification)
Temps: 4.73 ms / 390.42 ms Mémoire: 0.198 MB / 22.23 MB Application: afterRenderRawModule mod_login (Identification)
Temps: 0.02 ms / 390.43 ms Mémoire: -0.004 MB / 22.23 MB Application: beforeRenderModule mod_login (Identification)
Temps: 0.36 ms / 390.79 ms Mémoire: 0.004 MB / 22.23 MB Application: afterRenderModule mod_login (Identification)
Temps: 0.10 ms / 390.89 ms Mémoire: -0.002 MB / 22.23 MB Application: beforeRenderModule mod_whosonline (Sur le site :)
Temps: 2.52 ms / 393.41 ms Mémoire: 0.173 MB / 22.40 MB Application: afterRenderRawModule mod_whosonline (Sur le site :)
Temps: 0.02 ms / 393.42 ms Mémoire: -0.004 MB / 22.40 MB Application: beforeRenderModule mod_whosonline (Sur le site :)
Temps: 0.38 ms / 393.81 ms Mémoire: 0.004 MB / 22.40 MB Application: afterRenderModule mod_whosonline (Sur le site :)
Temps: 0.45 ms / 394.25 ms Mémoire: 0.028 MB / 22.43 MB Application: beforeRenderModule mod_custom (Liens institutionnels)
Temps: 0.92 ms / 395.18 ms Mémoire: 0.009 MB / 22.44 MB Application: afterRenderRawModule mod_custom (Liens institutionnels)
Temps: 0.02 ms / 395.19 ms Mémoire: -0.002 MB / 22.44 MB Application: beforeRenderModule mod_custom (Liens institutionnels)
Temps: 0.42 ms / 395.61 ms Mémoire: 0.004 MB / 22.44 MB Application: afterRenderModule mod_custom (Liens institutionnels)
Temps: 0.70 ms / 396.32 ms Mémoire: 0.009 MB / 22.45 MB Application: beforeRenderModule mod_search (Recherche)
Temps: 1.60 ms / 397.92 ms Mémoire: 0.027 MB / 22.48 MB Application: afterRenderRawModule mod_search (Recherche)
Temps: 0.02 ms / 397.94 ms Mémoire: -0.005 MB / 22.47 MB Application: beforeRenderModule mod_search (Recherche)
Temps: 0.43 ms / 398.37 ms Mémoire: 0.004 MB / 22.48 MB Application: afterRenderModule mod_search (Recherche)
Temps: 71.96 ms / 470.33 ms Mémoire: 3.887 MB / 26.36 MB Application: afterRender
Total de requêtes base de données : 29.40 ms
26,99 MB (28 300 776 Bytes)
29 requêtes exécutées 29.40 ms
- Temps de requête : 0.47 ms
SELECT `data`
FROM `rbywh_session`
WHERE `session_id` = X'336432736a373770676337626a336c3171726532667530693035'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysql->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.42 ms Après la dernière requête : 1.65 ms
SELECT `session_id`
FROM `rbywh_session`
WHERE `session_id` = X'336432736a373770676337626a336c3171726532667530693035'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 9 JDatabaseDriverMysql->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 : 0.39 ms Après la dernière requête : 0.19 ms
INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'336432736a373770676337626a336c3171726532667530693035', 1, 1713487725, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'336432736a373770676337626a336c3171726532667530693035', 1, 1713487725, 0, '', 0)Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.04 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 8 JDatabaseDriverMysql->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.40 ms Après la dernière requête : 6.56 ms
SELECT id, rules
FROM `rbywh_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_viewlevels ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 4 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysql->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.45 ms Après la dernière requête : 0.19 ms
SELECT b.id
FROM rbywh_usergroups AS a
LEFT JOIN rbywh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysql->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 : 0.66 ms Après la dernière requête : 65.71 ms
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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_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,5)
AND c.published = 1
AND s.id = 791
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 12 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 11 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:350 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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.37 ms Après la dernière requête : 0.17 ms
SELECT `alias`,`catid`
FROM `rbywh_content`
WHERE `id` = 791id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/components/com_content/helpers/legacyrouter.php:366 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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.83 ms Après la dernière requête : 0.79 ms
SELECT `id`,`name`,`rules`,`parent_id`
FROM `rbywh_assets`
WHERE `name` IN ('root.1','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_autotweet','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailjet','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_sendinblue','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_assets range idx_asset_name idx_asset_name 402 NULL 45 Using index condition Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.02 ms Statistics 0.14 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.26 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/plugins/system/advancedmodules/src/Document.php:28 11 RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() JROOT/plugins/system/advancedmodules/advancedmodules.php:78 10 PlgSystemAdvancedModules->handleOnAfterRoute() JROOT/libraries/regularlabs/src/Plugin.php:95 9 RegularLabs\Library\Plugin->onAfterRoute() Même appel que celui de la ligne ci-dessous. 8 call_user_func_array() 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.46 ms Après la dernière requête : 3.44 ms
UPDATE `rbywh_extensions`
SET `params` = '{\"mediaversion\":\"4fcce903d7005d8276c26599f6672531\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `rbywh_extensions` SET `params` = '{\"mediaversion\":\"4fcce903d7005d8276c26599f6672531\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.07 ms Updating 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.05 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysql->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jcomments/jcomments.php:111 9 plgSystemJComments->onAfterRoute() Même appel que celui de la ligne ci-dessous. 8 call_user_func_array() 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.79 ms Après la dernière requête : 16.80 ms
SELECT `id`,`name`,`rules`,`parent_id`
FROM `rbywh_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_assets ALL idx_asset_name,idx_parent_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1163 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.01 ms Sending data 1.39 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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.84 ms Après la dernière requête : 4.80 ms
SHOW FULL COLUMNS
FROM `rbywh_content`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `rbywh_content`Status Duration Starting 0.03 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.19 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.12 ms closing tables 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.07 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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.44 ms Après la dernière requête : 4.24 ms
UPDATE rbywh_content
SET `hits` = (`hits` + 1)
WHERE `id` = '791'EXPLAIN impossible sur la requête : UPDATE rbywh_content SET `hits` = (`hits` + 1) WHERE `id` = '791'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.05 ms Updating 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.05 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysql->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 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.74 ms Après la dernière requête : 14.20 ms
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM rbywh_content AS a
INNER JOIN rbywh_categories AS c
on c.id = a.catid
LEFT JOIN rbywh_users AS u
on u.id = a.created_by
LEFT JOIN rbywh_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rbywh_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 791
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 00:48:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 00:48:45')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.03 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425 12 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.81 ms Après la dernière requête : 2.78 ms
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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_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,5)
AND c.published = 1
AND s.id = 140
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right INDEX N'A PU ÊTRE UTILISÉ NULL NULL 88 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.12 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 25 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 20 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 19 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 18 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 17 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.55 ms Après la dernière requête : 1.36 ms
SELECT `m`.`tag_id`,`t`.*
FROM `rbywh_contentitem_tag_map` AS m
INNER JOIN `rbywh_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 791
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 gouesnou_joom976.m.tag_id 1 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.05 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.38 ms Après la dernière requête : 66.82 ms
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM rbywh_content AS a
LEFT JOIN rbywh_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 140
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 00:48:45')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 00:48:45')
ORDER BY a.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 17 Using intersect(idx_catid,idx_state); Using where; Utilisation du tri complet de type filesort 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.69 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/content/pagenavigation/pagenavigation.php:161 15 PlgContentPagenavigation->onContentBeforeDisplay() Même appel que celui de la ligne ci-dessous. 14 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:199 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.88 ms Après la dernière requête : 85.06 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM rbywh_modules AS m
LEFT JOIN rbywh_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN rbywh_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m range published,newsfeeds published 5 NULL 15 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE am eq_ref PRIMARY PRIMARY 4 gouesnou_joom976.m.id 1 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 gouesnou_joom976.m.module,const 1 Using index condition; Using where Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.25 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:413 20 PlgSystemAdvancedModuleHelper->getModuleList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:127 19 PlgSystemAdvancedModuleHelper->onPrepareModuleList() Même appel que celui de la ligne ci-dessous. 18 call_user_func_array() JROOT/libraries/joomla/event/dispatcher.php:165 17 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 16 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:366 15 Joomla\CMS\Helper\_ModuleHelper::load() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87 14 Joomla\CMS\Helper\_ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 13 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/t3/includes/core/template.php:641 12 T3Template->countModules() JROOT/templates/t3_blank/tpls/blocks/header.php:37 11 include JROOT/templates/t3_blank/tpls/blocks/header.php JROOT/plugins/system/t3/includes/core/template.php:200 10 T3Template->loadBlock() JROOT/templates/t3_blank/tpls/default.php:29 9 include JROOT/templates/t3_blank/tpls/default.php JROOT/plugins/system/t3/includes/core/template.php:226 8 T3Template->loadLayout() JROOT/templates/t3_blank/index.php:34 7 require JROOT/templates/t3_blank/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 : 11.20 ms Après la dernière requête : 38.85 ms
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 rbywh_content AS a
LEFT JOIN rbywh_categories AS c
ON c.id = a.catid
LEFT JOIN rbywh_users AS ua
ON ua.id = a.created_by
LEFT JOIN rbywh_users AS uam
ON uam.id = a.modified_by
LEFT JOIN rbywh_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rbywh_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 00:48:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 00:48:45')
ORDER BY
CASE WHEN (a.modified = '0000-00-00 00:00:00') THEN a.created ELSE a.modified END DESC
LIMIT 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL PRIMARY INDEX N'A PU ÊTRE UTILISÉ NULL NULL 88 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE a ref|filter idx_state,idx_catid idx_catid|idx_state 4|1 gouesnou_joom976.c.id 7 (66%) Using index condition; Using where; Using rowid filter 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 gouesnou_joom976.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 gouesnou_joom976.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 gouesnou_joom976.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 gouesnou_joom976.a.id 1 Using where Status Duration Starting 0.22 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.05 ms Creating tmp table 0.17 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 8.06 ms Creating sort index 0.78 ms Removing tmp table 1.32 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 16 ContentModelArticles->getItems() JROOT/modules/mod_articles_latest/helper.php:123 15 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 14 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 13 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:611 9 Joomla\CMS\Helper\_ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.76 ms Après la dernière requête : 1.57 ms
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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_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,5)
AND c.published = 1
AND s.id = 80
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right INDEX N'A PU ÊTRE UTILISÉ NULL NULL 88 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 29 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 27 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 26 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 25 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 24 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 23 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 22 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 21 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 20 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 17 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 16 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_latest/helper.php:135 15 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 14 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 13 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:611 9 Joomla\CMS\Helper\_ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.71 ms Après la dernière requête : 0.66 ms
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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_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,5)
AND c.published = 1
AND s.id = 79
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range|filter cat_idx,idx_access,idx_left_right idx_left_right|cat_idx 4|207 NULL 11 (55%) Using index condition; Using where; Using rowid filter Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.16 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 29 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 27 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 26 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 25 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 24 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 23 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 22 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 21 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 20 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 17 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 16 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_latest/helper.php:135 15 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 14 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 13 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:611 9 Joomla\CMS\Helper\_ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.72 ms Après la dernière requête : 1.17 ms
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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_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,5)
AND c.published = 1
AND s.id = 81
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right INDEX N'A PU ÊTRE UTILISÉ NULL NULL 88 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.06 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 29 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 27 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 26 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 25 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 24 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 23 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 22 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 21 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 20 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 17 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 16 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_latest/helper.php:135 15 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 14 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 13 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:611 9 Joomla\CMS\Helper\_ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.49 ms Après la dernière requête : 8.20 ms
SELECT guest, client_id
FROM rbywh_session
WHERE client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_session ref client_id_guest client_id_guest 2 const 242 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_whosonline/helper.php:45 12 ModWhosonlineHelper::getOnlineCount() JROOT/modules/mod_whosonline/mod_whosonline.php:19 11 include JROOT/modules/mod_whosonline/mod_whosonline.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256 10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 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 : 1.27 ms Après la dernière requête : 65.43 ms
SHOW TABLES
EXPLAIN impossible sur la requête : SHOW TABLESStatus Duration Starting 0.07 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms checking permissions 0.67 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.04 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1550 20 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 19 JDatabaseDriverMysqli->getTableList() JROOT/libraries/f0f/database/driver/joomla.php:251 18 F0FDatabaseDriverJoomla->getTableList() JROOT/libraries/f0f/table/table.php:2070 17 F0FTable->getTableFields() JROOT/libraries/f0f/table/table.php:536 16 F0FTable->__construct() JROOT/administrator/components/com_autotweet/tables/automator.php:33 15 AutotweetTableAutomator->__construct() JROOT/libraries/f0f/table/table.php:433 14 F0FTable::getAnInstance() JROOT/libraries/f0f/model/model.php:2037 13 F0FModel->_createTable() JROOT/libraries/f0f/model/model.php:1994 12 F0FModel->getTable() JROOT/administrator/components/com_autotweet/models/automators.php:91 11 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 10 AutotweetModelAutomators->lastRunCheck() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102 9 PlgSystemAutotweetAutomator->_onAfterRender() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214 8 PlgSystemAutotweetAutomator->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.72 ms Après la dernière requête : 0.30 ms
SHOW FULL COLUMNS
FROM `rbywh_autotweet_automator`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `rbywh_autotweet_automator`Status Duration Starting 0.03 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.17 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.06 ms closing tables 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.06 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 19 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/f0f/database/driver/joomla.php:229 18 F0FDatabaseDriverJoomla->getTableColumns() JROOT/libraries/f0f/table/table.php:2155 17 F0FTable->getTableFields() JROOT/libraries/f0f/table/table.php:536 16 F0FTable->__construct() JROOT/administrator/components/com_autotweet/tables/automator.php:33 15 AutotweetTableAutomator->__construct() JROOT/libraries/f0f/table/table.php:433 14 F0FTable::getAnInstance() JROOT/libraries/f0f/model/model.php:2037 13 F0FModel->_createTable() JROOT/libraries/f0f/model/model.php:1994 12 F0FModel->getTable() JROOT/administrator/components/com_autotweet/models/automators.php:91 11 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 10 AutotweetModelAutomators->lastRunCheck() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102 9 PlgSystemAutotweetAutomator->_onAfterRender() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214 8 PlgSystemAutotweetAutomator->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.44 ms Après la dernière requête : 1.37 ms
SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator
WHERE `rbywh_autotweet_automator`.`plugin` = 'automator'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_autotweet_automator ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 Using where Status Duration Starting 0.04 ms checking permissions 0.03 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/f0f/database/driver/joomla.php:291 13 F0FDatabaseDriverJoomla->loadAssoc() JROOT/libraries/f0f/table/table.php:949 12 F0FTable->load() JROOT/administrator/components/com_autotweet/models/automators.php:96 11 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 10 AutotweetModelAutomators->lastRunCheck() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102 9 PlgSystemAutotweetAutomator->_onAfterRender() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214 8 PlgSystemAutotweetAutomator->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.40 ms Après la dernière requête : 0.27 ms
SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator
WHERE `rbywh_autotweet_automator`.`id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_autotweet_automator const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/libraries/f0f/database/driver/joomla.php:291 14 F0FDatabaseDriverJoomla->loadAssoc() JROOT/libraries/f0f/table/table.php:949 13 F0FTable->load() JROOT/libraries/f0f/model/model.php:1154 12 F0FModel->getItem() JROOT/administrator/components/com_autotweet/models/automators.php:100 11 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 10 AutotweetModelAutomators->lastRunCheck() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102 9 PlgSystemAutotweetAutomator->_onAfterRender() JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214 8 PlgSystemAutotweetAutomator->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.16 ms Après la dernière requête : 0.45 ms
SET sql_big_selects=1EXPLAIN impossible sur la requête : SET sql_big_selects=1Status Duration Starting 0.03 ms Opening tables 0.02 ms After opening tables 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/database.php:33 10 JDatabase->query() JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:236 9 PlgAutotweetBase->onContentPolling() JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446 8 PlgSystemAutotweetContent->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.34 ms Après la dernière requête : 0.67 ms
SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator
WHERE `rbywh_autotweet_automator`.`plugin` = 'content'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_autotweet_automator ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/libraries/f0f/database/driver/joomla.php:291 14 F0FDatabaseDriverJoomla->loadAssoc() JROOT/libraries/f0f/table/table.php:949 13 F0FTable->load() JROOT/administrator/components/com_autotweet/models/automators.php:96 12 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 11 AutotweetModelAutomators->lastRunCheck() JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648 10 PlgAutotweetBase->executeContentPolling() JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238 9 PlgAutotweetBase->onContentPolling() JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446 8 PlgSystemAutotweetContent->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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 - Temps de requête : 0.33 ms Après la dernière requête : 0.24 ms
SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator
WHERE `rbywh_autotweet_automator`.`id` = '2'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_autotweet_automator const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/libraries/f0f/database/driver/joomla.php:291 15 F0FDatabaseDriverJoomla->loadAssoc() JROOT/libraries/f0f/table/table.php:949 14 F0FTable->load() JROOT/libraries/f0f/model/model.php:1154 13 F0FModel->getItem() JROOT/administrator/components/com_autotweet/models/automators.php:100 12 AutotweetModelAutomators->lastRun() JROOT/administrator/components/com_autotweet/models/automators.php:35 11 AutotweetModelAutomators->lastRunCheck() JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648 10 PlgAutotweetBase->executeContentPolling() JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238 9 PlgAutotweetBase->onContentPolling() JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446 8 PlgSystemAutotweetContent->onAfterRender() Même appel que celui de la ligne ci-dessous. 7 call_user_func_array() 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
21 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
5 × 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 `rbywh_categories` AS `s`
INNER JOIN `rbywh_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)4 × SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `rbywh_assets`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM rbywh_modules AS m
LEFT JOIN rbywh_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN rbywh_advancedmodules as am
ON am.moduleid = m.id1 × 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 rbywh_content AS a
LEFT JOIN rbywh_categories AS c
ON c.id = a.catid
LEFT JOIN rbywh_users AS ua
ON ua.id = a.created_by
LEFT JOIN rbywh_users AS uam
ON uam.id = a.modified_by
LEFT JOIN rbywh_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rbywh_content_rating AS v
ON a.id = v.content_id1 × SELECT guest, client_id
FROM rbywh_session1 × SELECT `session_id`
FROM `rbywh_session`1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM rbywh_content AS a
LEFT JOIN rbywh_categories AS cc
ON cc.id = a.catid1 × SELECT `m`.`tag_id`,`t`.*
FROM `rbywh_contentitem_tag_map` AS m
INNER JOIN `rbywh_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT id, rules
FROM `rbywh_viewlevels1 × SELECT `alias`,`catid`
FROM `rbywh_content`1 × SELECT `data`
FROM `rbywh_session`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM rbywh_content AS a
INNER JOIN rbywh_categories AS c
on c.id = a.catid
LEFT JOIN rbywh_users AS u
on u.id = a.created_by
LEFT JOIN rbywh_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rbywh_content_rating AS v
ON a.id = v.content_id1 × SELECT b.id
FROM rbywh_usergroups AS a
LEFT JOIN rbywh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
Autres tables :
1 × SHOW FULL COLUMNS
FROM `rbywh_autotweet_automator1 ×
SET sql_big_selects=1 × SHOW TABLE
1 × UPDATE rbywh_content
SET `hits` = (`hits` + 1)1 × UPDATE `rbywh_extensions`
SET `params` = '{\"mediaversion\":\"4fcce903d7005d8276c26599f6672531\"}'1 × SHOW FULL COLUMNS
FROM `rbywh_content1 × INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'336432736a373770676337626a336c3171726532667530693035', 1, 1713487725, 0, '', 0
