105 joueurs ont participé aux 5 tournois organisés durant ces 3 jours.
- Le tournoi principal (56 participants) est remporté par Franck Guézennec de l'Échiquier Gouesnousien. La seconde place revient à Vladimir Khudovekov (Smolensk). Bertrand Valuet (la Tour de Juvisy) prend la 3e place.La première féminine,4e au général, est Marine André (USAM Échiquier Brestois). Noël Rannou (Échiquier du Léon-Lesneven) est le premier vétéran et Alexandre Troubat (Échiquier Gouesnousien) meilleur jeune.
- Le tournoi Jeunes (20 participants) a été dominé par l'Échiquier Lannionnais qui truste les trois premières places avec, dans l'ordre, Cyril Caro, Hoël Loudier et Nathanael Combaudon.
- Le Rapide Jeunes (17 participants) est gagné par Victor Lemarchand (Échiquier Gouesnousien) devant Amos Nobé-Richard (Échiquier du Léon-Lesneven) et Justin Lemarchand (Échiquier Gouesnousien).
- Franck Guézennec remporte le très disputé tournoi de Blitz (36 participants).
- Le tournoi Loisirs (10 participants) est remporté par Nicolas Cumunel à égalité de point avec Patrick Gac.
Un grand merci à tous les bénévoles qui ont permis la réussite de cette 18ème édition.
Gaël Woerly n'a pas fait que jouer aux échecs. Il a pris de superbes photos que l'on peut admirer sur son compte Flickr. Profitez -en pour parcourir ses autres albums. Toutes les photos sont téléchargeables, comme sur ce site d'ailleurs.
Merci également à Anne Le Bris qui a contribué à la galeire de photos ci-desous.
Les résultats complets sur le site fédéral : L'Open FIDE, le tournoi Jeunes et le Rapide Jeunes.
Résultas du Blitz et du tournoi Loisirs ci dessous :
| Blitz de Noël Grille américaine après la ronde 7 |
||||||||||||||||||
| Pl | Nom | Rapide | Cat. | Fede | Ligue | R 1 | R 2 | R 3 | R 4 | R 5 | R 6 | R 7 | Pts | Tr. | Bu. | Cu. | ||
| 1 | GUEZENNEC Franck | 2220 R | SenM | FRA | BRE | + 16N | + 13B | + 5N | - 3B | + 9N | + 11B | + 4N | 6 | 28 | 32 | 24 | 2302 | |
| 2 | NINEUIL Vincent | 2060 R | SenM | FRA | LYO | + 21N | + 15B | - 4N | + 14B | + 7N | + 3N | + 8B | 6 | 28 | 31 | 23 | 2184 | |
| 3 | LE BRIS Yann | 2050 R | JunM | FRA | BRE | + 29B | + 14N | + 6B | + 1N | + 4N | - 2B | = 5N | 5½ | 31 | 33 | 25½ | 2236 | |
| 4 | SERRALTA Michel | 2240 R | SenM | FRA | BRE | + 22B | + 8N | + 2B | + 11N | - 3B | + 12N | - 1B | 5 | 30 | 33 | 24 | 2190 | |
| 5 | COGAN Nicolas | 1940 R | JunM | FRA | BRE | + 20B | + 23N | - 1B | + 10N | + 11B | = 8N | = 3B | 5 | 27½ | 30½ | 21½ | 2059 | |
| 6 | f | VALUET Bertrand | 2290 R | SenM | FRA | IDF | + 19N | + 7B | - 3N | - 13B | + 16N | + 14B | + 17N | 5 | 26½ | 30 | 19 | 2079 |
| 7 | JOURDREN Kevin | 1920 R | SenM | FRA | BRE | + 32B | - 6N | + 9B | + 20N | - 2B | + 18N | + 12B | 5 | 26½ | 28½ | 19 | 2023 | |
| 8 | LESCOP Etienne | 1910 R | SenM | FRA | BRE | + 24N | - 4B | + 19N | + 28B | + 15N | = 5B | - 2N | 4½ | 26½ | 29 | 20 | 1886 | |
| 9 | LE ROUX Yann-Erle | 1930 R | SenM | FRA | IDF | + 26N | + 28B | - 7N | + 17B | - 1B | = 10N | + 13N | 4½ | 26½ | 29 | 19 | 1880 | |
| 10 | GAC Benjamin | 1810 R | SenM | FRA | BRE | + 34N | - 11B | + 16N | - 5B | + 21N | = 9B | + 19N | 4½ | 24 | 25 | 17 | 1771 | |
| 11 | BLEUZEN Erwan | 2110 R | SenM | FRA | BRE | + 27B | + 10N | + 12B | - 4B | - 5N | - 1N | + 23B | 4 | 27½ | 30½ | 19 | 2000 | |
| 12 | LAVANANT Alexandre | 2010 R | SenM | FRA | BRE | + 31N | + 17B | - 11N | + 15B | + 13N | - 4B | - 7N | 4 | 26 | 28 | 20 | 1920 | |
| 13 | DODART Guillaume | 1890 R | MinM | FRA | BRE | + 35B | - 1N | + 22B | + 6N | - 12B | + 23N | - 9B | 4 | 25½ | 26½ | 18 | 1918 | |
| 14 | GINOVART Camille | 1670 R | PupF | FRA | BRE | + 33B | - 3B | + 31N | - 2N | + 22B | - 6N | + 27B | 4 | 24½ | 26½ | 16 | 1702 | |
| 15 | CHETAIL Guillaume | 1700 R | SenM | FRA | BRE | + 25B | - 2N | + 27B | - 12N | - 8B | + 29N | + 20B | 4 | 23½ | 25½ | 15 | 1660 | |
| 16 | LEFEBVRE Matthieu | 1380 R | BenM | FRA | BRE | - 1B | + 35N | - 10B | + 29N | - 6B | + 25N | + 28B | 4 | 23 | 24 | 13 | 1468 | |
| 17 | LEFEBVRE Alexandre | 1530 R | MinM | FRA | BRE | + 36B | - 12N | + 29B | - 9N | + 20B | + 28N | - 6B | 4 | 21 | 22 | 17 | 1564 | |
| 18 | MARTIN Yvon | 1700 R | SenM | FRA | BRE | - 28N | + 26B | + 21N | - 19B | + 30N | - 7B | + 24N | 4 | 20 | 22 | 15 | 1472 | |
| 19 | CARDINAL Samuel | 1460 R | MinM | FRA | BRE | - 6B | + 32N | - 8B | + 18N | = 28B | + 22N | - 10B | 3½ | 23½ | 25½ | 13½ | 1577 | |
| 20 | LEMARCHAND Victor | 1150 R | BenM | FRA | BRE | - 5N | + 30B | + 26N | - 7B | - 17N | + 21B | - 15N | 3 | 24 | 26 | 13 | 1349 | |
| 21 | LECORNU Laurent | 1370 R | SenM | FRA | BRE | - 2B | + 25N | - 18B | + 33N | - 10B | - 20N | + 29B | 3 | 22½ | 24½ | 11 | 1327 | |
| 22 | CHETAIL Jean-Louis | 1460 R | SenM | FRA | BRE | - 4N | + 24B | - 13N | + 34B | - 14N | - 19B | + 30N | 3 | 21½ | 22½ | 11 | 1394 | |
| 23 | COGAN Guillaume | 1640 R | SenM | FRA | BRE | + 30N | - 5B | - 28N | + 31B | + 24N | - 13B | - 11N | 3 | 20½ | 22½ | 14 | 1491 | |
| 24 | LEMARCHAND Justin | 1090 R | PupM | FRA | BRE | - 8B | - 22N | + 25B | + 27N | - 23B | + 31N | - 18B | 3 | 20½ | 22½ | 11 | 1303 | |
| 25 | LEFEBVRE Sebastien | 1010 R | PouM | FRA | BRE | - 15N | - 21B | - 24N | + 26B | + 31N | - 16B | + 34N | 3 | 19 | 20 | 8 | 1175 | |
| 26 | VIARD Matteo | 1140 R | BenM | FRA | BRE | - 9B | - 18N | - 20B | - 25N | + 32B | + 36N | + 33B | 3 | 18½ | 19½ | 6 | 1143 | |
| 27 | OTTL Eric | 1380 R | SenM | FRA | BRE | - 11N | + 34B | - 15N | - 24B | + 36N | + 30B | - 14N | 3 | 18 | 19 | 11 | 1297 | |
| 28 | COMBAUDON Nathanael | 999 E | BenM | FRA | BRE | + 18B | - 9N | + 23B | - 8N | = 19N | - 17B | - 16N | 2½ | 24½ | 27½ | 13½ | 1447 | |
| 29 | LEFEBVRE Etienne | 1290 R | PupM | FRA | BRE | - 3N | + 33B | - 17N | - 16B | + 34N | - 15B | - 21N | 2 | 22½ | 23½ | 9 | 1222 | |
| 30 | COMBAUDON Cyprien | 799 E | PouM | FRA | BRE | - 23B | - 20N | + 35B | + 32N | - 18B | - 27N | - 22B | 2 | 18 | 19 | 9 | 1160 | |
| 31 | BALCON Clement | 1190 R | PupM | FRA | BRE | - 12B | + 36N | - 14B | - 23N | - 25B | - 24B | + 35N | 2 | 18 | 19 | 7 | 1118 | |
| 32 | LEMARCHAND Agathe | 1120 R | BenF | FRA | BRE | - 7N | - 19B | - 33N | - 30B | - 26N | + 35B | + 36B | 2 | 16½ | 17½ | 3 | 1031 | |
| 33 | THIERY Mathieu | 990 R | SenM | FRA | BRE | - 14N | - 29N | + 32B | - 21B | - 35N | + 34B | - 26N | 2 | 15 | 16 | 7 | 1037 | |
| 34 | ASQUOET Yoann | 1040 R | BenM | FRA | BRE | - 10B | - 27N | + 36B | - 22N | - 29B | - 33N | - 25B | 1 | 17½ | 18½ | 5 | 928 | |
| 35 | BALCON Alexis | 1050 R | PouM | FRA | BRE | - 13N | - 16B | - 30N | - 36B | + 33B | - 32N | - 31B | 1 | 16 | 17 | 3 | 889 | |
| 36 | COMBAUDON Timothee | 799 E | PouM | FRA | BRE | - 17N | - 31B | - 34N | + 35N | - 27B | - 26B | - 32N | 1 | 15 | 16 | 4 | 895 | |
Console de débogage Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713536838,
"last": 1713536838,
"now": 1713536838
},
"token": "id4zrVLutVz0aU1gYeexljp8NXCgEmYl"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Temps
Mémoire
Temps: 22.56 ms / 22.56 ms Mémoire: 2.483 MB / 2.72 MB Application: afterLoad
Temps: 89.70 ms / 112.26 ms Mémoire: 7.504 MB / 10.22 MB Application: afterInitialise
Temps: 18.57 ms / 130.83 ms Mémoire: 1.590 MB / 11.81 MB Application: Before Access::preloadComponents (all components)
Temps: 1.39 ms / 132.22 ms Mémoire: 0.102 MB / 11.91 MB Application: After Access::preloadComponents (all components)
Temps: 0.07 ms / 132.29 ms Mémoire: -0.006 MB / 11.91 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Temps: 0.83 ms / 133.12 ms Mémoire: 0.051 MB / 11.96 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Temps: 12.65 ms / 145.76 ms Mémoire: 0.955 MB / 12.91 MB Application: afterRoute
Temps: 1.48 ms / 147.24 ms Mémoire: 0.060 MB / 12.97 MB Application: beforeRenderComponent com_content
Temps: 6.82 ms / 154.06 ms Mémoire: 0.716 MB / 13.69 MB Application: Before Access::preloadPermissions (com_content)
Temps: 5.79 ms / 159.85 ms Mémoire: 1.639 MB / 15.33 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.30 ms / 160.15 ms Mémoire: -0.102 MB / 15.22 MB Application: Before Access::getAssetRules (id:905 name:com_content.article.784)
Temps: 0.13 ms / 160.28 ms Mémoire: 0.010 MB / 15.24 MB Application: After Access::getAssetRules (id:905 name:com_content.article.784)
Temps: 49.51 ms / 209.79 ms Mémoire: 2.541 MB / 17.78 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Temps: 0.07 ms / 209.86 ms Mémoire: 0.009 MB / 17.79 MB Application: After Access::getAssetRules (id:1 name:root.1)
Temps: 181.46 ms / 391.31 ms Mémoire: 3.496 MB / 21.28 MB Application: afterRenderComponent com_content
Temps: 3.06 ms / 394.37 ms Mémoire: 0.066 MB / 21.35 MB Application: afterDispatch
Temps: 61.48 ms / 455.85 ms Mémoire: 3.166 MB / 24.51 MB Application: afterRender
Total de requêtes base de données : 17.28 ms
25,04 MB (26 251 768 Bytes)
26 requêtes exécutées 17.28 ms
- Temps de requête : 0.41 ms
SELECT `data`
FROM `rbywh_session`
WHERE `session_id` = X'6664706e6c696f67367636357561633632746a6c366135726d36'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.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.04 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.34 ms Après la dernière requête : 1.75 ms
SELECT `session_id`
FROM `rbywh_session`
WHERE `session_id` = X'6664706e6c696f67367636357561633632746a6c366135726d36'
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.02 ms Reset for next command 0.01 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.37 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'6664706e6c696f67367636357561633632746a6c366135726d36', 1, 1713536838, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6664706e6c696f67367636357561633632746a6c366135726d36', 1, 1713536838, 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.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.03 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 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.38 ms Après la dernière requête : 7.26 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.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.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 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 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.42 ms Après la dernière requête : 0.18 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.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.02 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 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.03 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/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.64 ms Après la dernière requête : 73.60 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 = 784
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.15 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.01 ms Executing 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.02 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.34 ms Après la dernière requête : 0.17 ms
SELECT `alias`,`catid`
FROM `rbywh_content`
WHERE `id` = 784id 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.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 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.78 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.06 ms Optimizing 0.02 ms Statistics 0.15 ms Preparing 0.02 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.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 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.51 ms Après la dernière requête : 3.79 ms
UPDATE `rbywh_extensions`
SET `params` = '{\"mediaversion\":\"763d7ec52f01607c78c76710e4c16d21\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `rbywh_extensions` SET `params` = '{\"mediaversion\":\"763d7ec52f01607c78c76710e4c16d21\"}' 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.02 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.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.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.85 ms Après la dernière requête : 17.94 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.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 1.42 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 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.81 ms Après la dernière requête : 4.94 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.18 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.03 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.13 ms closing tables 0.01 ms Executing 0.01 ms Sending data 0.05 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.02 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.43 ms Après la dernière requête : 4.49 ms
UPDATE rbywh_content
SET `hits` = (`hits` + 1)
WHERE `id` = '784'EXPLAIN impossible sur la requête : UPDATE rbywh_content SET `hits` = (`hits` + 1) WHERE `id` = '784'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.01 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.76 ms Après la dernière requête : 22.80 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 = 784
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 14:27:18')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 14:27:18')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.02 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 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.76 ms Après la dernière requête : 2.92 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.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.09 ms Preparing 0.01 ms Unlocking tables 0.03 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.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 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.52 ms Après la dernière requête : 1.34 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` = 784
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.02 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.03 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 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 : 0.51 ms Après la dernière requête : 109.13 ms
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM rbywh_phocagallery_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 4 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.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.06 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.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 18 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736 16 PhocaGalleryRenderFront::renderAllCSS() JROOT/plugins/content/phocagallery/phocagallery.php:102 15 plgContentPhocaGallery->onContentPrepare() 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:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.04 ms Après la dernière requête : 14.57 ms
SELECT cc.*, a.catid, COUNT(a.id) AS numlinks,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
FROM rbywh_phocagallery_categories AS cc
LEFT JOIN rbywh_phocagallery AS a
ON a.catid = cc.id
WHERE a.published = 1
AND cc.published = 1
AND cc.approved = 1
AND a.approved = 1
AND cc.id != 0
AND cc.id = 233
GROUP BY cc.id
ORDER BY cc.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref catid catid 5 const,const 170 Using where Status Duration Starting 0.09 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.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.04 ms Executing 0.01 ms Sending data 1.43 ms End of update loop 0.03 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/phocagallery/phocagallery.php:846 15 plgContentPhocaGallery->onContentPrepare() 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:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.73 ms Après la dernière requête : 0.15 ms
SELECT cc.title AS text, cc.id AS value, cc.parent_id as parentid
FROM rbywh_phocagallery_categories AS cc
WHERE cc.published = 1
AND cc.approved = 1
ORDER BY cc.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 268 Using where; Utilisation du tri complet de type filesort 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.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.32 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 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 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/content/phocagallery/phocagallery.php:849 15 plgContentPhocaGallery->onContentPrepare() 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:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.07 ms Après la dernière requête : 30.27 ms
SELECT filename, extm, exts, extw, exth, extid
FROM rbywh_phocagallery
WHERE catid=233
AND published = 1
AND approved = 1
ORDER BY ordering
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_phocagallery ref catid catid 5 const,const 170 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.64 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:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/content/phocagallery/phocagallery.php:898 15 plgContentPhocaGallery->onContentPrepare() 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:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.28 ms Après la dernière requête : 91.26 ms
SHOW TABLES
EXPLAIN impossible sur la requête : SHOW TABLESStatus Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 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 checking permissions 0.71 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.02 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.32 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.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms checking permissions 0.06 ms closing tables 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 Removing tmp table 0.06 ms closing tables 0.02 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 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.40 ms Après la dernière requête : 1.51 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.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.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.02 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.33 ms Après la dernière requête : 0.30 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.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.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 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.18 ms Après la dernière requête : 0.39 ms
SET sql_big_selects=1EXPLAIN impossible sur la requête : SET sql_big_selects=1Status Duration Starting 0.03 ms Opening tables 0.01 ms After opening tables 0.01 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.02 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.35 ms Après la dernière requête : 0.75 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.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.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.30 ms Après la dernière requête : 0.28 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.03 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 :
4 × SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator2 × 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)2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `rbywh_assets`1 × SELECT cc.*, a.catid, COUNT(a.id) AS numlinks,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
FROM rbywh_phocagallery_categories AS cc
LEFT JOIN rbywh_phocagallery AS a
ON a.catid = cc.id1 × SELECT cc.title AS text, cc.id AS value, cc.parent_id as parentid
FROM rbywh_phocagallery_categories AS cc1 × SELECT filename, extm, exts, extw, exth, extid
FROM rbywh_phocagallery1 × SELECT `session_id`
FROM `rbywh_session`1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM rbywh_phocagallery_styles AS a1 × 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\":\"763d7ec52f01607c78c76710e4c16d21\"}'1 × SHOW FULL COLUMNS
FROM `rbywh_content1 × INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6664706e6c696f67367636357561633632746a6c366135726d36', 1, 1713536838, 0, '', 0
| Loisirs 2015 Grille américaine après la ronde 7 |
||||||||||||||||||
| Pl | Nom | Rapide | Cat. | Fede | Ligue | R 1 | R 2 | R 3 | R 4 | R 5 | R 6 | R 7 | Pts | Bu. | Tr. | Cu. | ||
| 1 | CUMUNEL Nicolas | 1450 R | SenM | FRA | BRE | + 4N | + 5B | + 3N | - 2B | + 7B | + 6N | + 9N | 6 | 27 | 26 | 24 | 1632 | |
| 2 | GAC Patrick | 1450 R | SenM | FRA | BRE | + 8N | - 3B | + 7N | + 1N | + 5B | + 4N | + 6B | 6 | 27 | 26 | 22 | 1632 | |
| 3 | FUSCIELLO Jean-Marie | 1530 R | SenM | FRA | BRE | + 6B | + 2N | - 1B | + 10N | = 4B | + 9B | + 8N | 5½ | 22½ | 21½ | 21½ | 1504 | |
| 4 | TANGUY Ronan | 1399 E | SenM | FRA | BRE | - 1B | + 9N | + 8B | + 6N | = 3N | - 2B | + 10N | 4½ | 23½ | 22½ | 17½ | 1347 | |
| 5 | COMBAUDON Cyrille | 1399 E | SenM | FRA | BRE | + 9B | - 1N | - 6B | + 8N | - 2N | + 10B | + 7N | 4 | 21 | 20 | 14 | 1252 | |
| 6 | TOUSCH Jacky | 1399 E | SenM | FRA | BRE | - 3N | + 7B | + 5N | - 4B | + 10N | - 1B | - 2N | 3 | 30 | 29 | 14 | 1293 | |
| 7 | TROADEC Pascal | 1399 E | SenM | FRA | BRE | + 10B | - 6N | - 2B | + 9B | - 1N | + 8N | - 5B | 3 | 22 | 21 | 13 | 1160 | |
| 8 | CHAMPS Aymeric | 799 E | PouM | FRA | BRE | - 2B | + 10N | - 4N | - 5B | - 9N | - 7B | - 3B | 1 | 25 | 24 | 6 | 961 | |
| 9 | FAVRE-FELIX Thomas | 1199 E | CadM | FRA | - 5N | - 4B | - 10B | - 7N | + 8B | - 3N | - 1B | 1 | 25 | 24 | 3 | 961 | ||
| 10 | CAROFF Laurent | 1399 E | SenM | FRA | BRE | - 7N | - 8B | + 9N | - 3B | - 6B | - 5N | - 4B | 1 | 22 | 21 | 5 | 938 | |
Console de débogage Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713536838,
"last": 1713536838,
"now": 1713536838
},
"token": "id4zrVLutVz0aU1gYeexljp8NXCgEmYl"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Temps
Mémoire
Temps: 22.56 ms / 22.56 ms Mémoire: 2.483 MB / 2.72 MB Application: afterLoad
Temps: 89.70 ms / 112.26 ms Mémoire: 7.504 MB / 10.22 MB Application: afterInitialise
Temps: 18.57 ms / 130.83 ms Mémoire: 1.590 MB / 11.81 MB Application: Before Access::preloadComponents (all components)
Temps: 1.39 ms / 132.22 ms Mémoire: 0.102 MB / 11.91 MB Application: After Access::preloadComponents (all components)
Temps: 0.07 ms / 132.29 ms Mémoire: -0.006 MB / 11.91 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Temps: 0.83 ms / 133.12 ms Mémoire: 0.051 MB / 11.96 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Temps: 12.65 ms / 145.76 ms Mémoire: 0.955 MB / 12.91 MB Application: afterRoute
Temps: 1.48 ms / 147.24 ms Mémoire: 0.060 MB / 12.97 MB Application: beforeRenderComponent com_content
Temps: 6.82 ms / 154.06 ms Mémoire: 0.716 MB / 13.69 MB Application: Before Access::preloadPermissions (com_content)
Temps: 5.79 ms / 159.85 ms Mémoire: 1.639 MB / 15.33 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.30 ms / 160.15 ms Mémoire: -0.102 MB / 15.22 MB Application: Before Access::getAssetRules (id:905 name:com_content.article.784)
Temps: 0.13 ms / 160.28 ms Mémoire: 0.010 MB / 15.24 MB Application: After Access::getAssetRules (id:905 name:com_content.article.784)
Temps: 49.51 ms / 209.79 ms Mémoire: 2.541 MB / 17.78 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Temps: 0.07 ms / 209.86 ms Mémoire: 0.009 MB / 17.79 MB Application: After Access::getAssetRules (id:1 name:root.1)
Temps: 181.46 ms / 391.31 ms Mémoire: 3.496 MB / 21.28 MB Application: afterRenderComponent com_content
Temps: 3.06 ms / 394.37 ms Mémoire: 0.066 MB / 21.35 MB Application: afterDispatch
Temps: 61.48 ms / 455.85 ms Mémoire: 3.166 MB / 24.51 MB Application: afterRender
Total de requêtes base de données : 17.28 ms
25,04 MB (26 251 768 Bytes)
26 requêtes exécutées 17.28 ms
- Temps de requête : 0.41 ms
SELECT `data`
FROM `rbywh_session`
WHERE `session_id` = X'6664706e6c696f67367636357561633632746a6c366135726d36'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.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.04 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.34 ms Après la dernière requête : 1.75 ms
SELECT `session_id`
FROM `rbywh_session`
WHERE `session_id` = X'6664706e6c696f67367636357561633632746a6c366135726d36'
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.02 ms Reset for next command 0.01 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.37 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'6664706e6c696f67367636357561633632746a6c366135726d36', 1, 1713536838, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6664706e6c696f67367636357561633632746a6c366135726d36', 1, 1713536838, 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.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.03 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 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.38 ms Après la dernière requête : 7.26 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.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.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 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 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.42 ms Après la dernière requête : 0.18 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.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.02 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 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.03 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/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.64 ms Après la dernière requête : 73.60 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 = 784
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.15 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.01 ms Executing 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.02 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.34 ms Après la dernière requête : 0.17 ms
SELECT `alias`,`catid`
FROM `rbywh_content`
WHERE `id` = 784id 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.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 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.78 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.06 ms Optimizing 0.02 ms Statistics 0.15 ms Preparing 0.02 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.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 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.51 ms Après la dernière requête : 3.79 ms
UPDATE `rbywh_extensions`
SET `params` = '{\"mediaversion\":\"763d7ec52f01607c78c76710e4c16d21\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `rbywh_extensions` SET `params` = '{\"mediaversion\":\"763d7ec52f01607c78c76710e4c16d21\"}' 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.02 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.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.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.85 ms Après la dernière requête : 17.94 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.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 1.42 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 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.81 ms Après la dernière requête : 4.94 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.18 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.03 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.13 ms closing tables 0.01 ms Executing 0.01 ms Sending data 0.05 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.02 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.43 ms Après la dernière requête : 4.49 ms
UPDATE rbywh_content
SET `hits` = (`hits` + 1)
WHERE `id` = '784'EXPLAIN impossible sur la requête : UPDATE rbywh_content SET `hits` = (`hits` + 1) WHERE `id` = '784'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.01 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.76 ms Après la dernière requête : 22.80 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 = 784
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 14:27:18')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 14:27:18')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.02 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 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.76 ms Après la dernière requête : 2.92 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.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.09 ms Preparing 0.01 ms Unlocking tables 0.03 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.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 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.52 ms Après la dernière requête : 1.34 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` = 784
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.02 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.03 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 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 : 0.51 ms Après la dernière requête : 109.13 ms
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM rbywh_phocagallery_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 4 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.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.06 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.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 18 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736 16 PhocaGalleryRenderFront::renderAllCSS() JROOT/plugins/content/phocagallery/phocagallery.php:102 15 plgContentPhocaGallery->onContentPrepare() 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:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.04 ms Après la dernière requête : 14.57 ms
SELECT cc.*, a.catid, COUNT(a.id) AS numlinks,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
FROM rbywh_phocagallery_categories AS cc
LEFT JOIN rbywh_phocagallery AS a
ON a.catid = cc.id
WHERE a.published = 1
AND cc.published = 1
AND cc.approved = 1
AND a.approved = 1
AND cc.id != 0
AND cc.id = 233
GROUP BY cc.id
ORDER BY cc.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref catid catid 5 const,const 170 Using where Status Duration Starting 0.09 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.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.04 ms Executing 0.01 ms Sending data 1.43 ms End of update loop 0.03 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/phocagallery/phocagallery.php:846 15 plgContentPhocaGallery->onContentPrepare() 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:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.73 ms Après la dernière requête : 0.15 ms
SELECT cc.title AS text, cc.id AS value, cc.parent_id as parentid
FROM rbywh_phocagallery_categories AS cc
WHERE cc.published = 1
AND cc.approved = 1
ORDER BY cc.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 268 Using where; Utilisation du tri complet de type filesort 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.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.32 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 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 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/content/phocagallery/phocagallery.php:849 15 plgContentPhocaGallery->onContentPrepare() 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:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.07 ms Après la dernière requête : 30.27 ms
SELECT filename, extm, exts, extw, exth, extid
FROM rbywh_phocagallery
WHERE catid=233
AND published = 1
AND approved = 1
ORDER BY ordering
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE rbywh_phocagallery ref catid catid 5 const,const 170 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.64 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:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/content/phocagallery/phocagallery.php:898 15 plgContentPhocaGallery->onContentPrepare() 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:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.28 ms Après la dernière requête : 91.26 ms
SHOW TABLES
EXPLAIN impossible sur la requête : SHOW TABLESStatus Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 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 checking permissions 0.71 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.02 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.32 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.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms checking permissions 0.06 ms closing tables 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 Removing tmp table 0.06 ms closing tables 0.02 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 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.40 ms Après la dernière requête : 1.51 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.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.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.02 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.33 ms Après la dernière requête : 0.30 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.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.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 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.18 ms Après la dernière requête : 0.39 ms
SET sql_big_selects=1EXPLAIN impossible sur la requête : SET sql_big_selects=1Status Duration Starting 0.03 ms Opening tables 0.01 ms After opening tables 0.01 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.02 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.35 ms Après la dernière requête : 0.75 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.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.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.30 ms Après la dernière requête : 0.28 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.03 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 :
4 × SELECT rbywh_autotweet_automator.*
FROM rbywh_autotweet_automator2 × 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)2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `rbywh_assets`1 × SELECT cc.*, a.catid, COUNT(a.id) AS numlinks,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
FROM rbywh_phocagallery_categories AS cc
LEFT JOIN rbywh_phocagallery AS a
ON a.catid = cc.id1 × SELECT cc.title AS text, cc.id AS value, cc.parent_id as parentid
FROM rbywh_phocagallery_categories AS cc1 × SELECT filename, extm, exts, extw, exth, extid
FROM rbywh_phocagallery1 × SELECT `session_id`
FROM `rbywh_session`1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM rbywh_phocagallery_styles AS a1 × 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\":\"763d7ec52f01607c78c76710e4c16d21\"}'1 × SHOW FULL COLUMNS
FROM `rbywh_content1 × INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6664706e6c696f67367636357561633632746a6c366135726d36', 1, 1713536838, 0, '', 0