A l'épiphanie, chaque année, on entend beaucoup parler de "galette des rois", cette croustade feuilletée à la frangipane.
En Provence, celui qui remporte les suffrages, c'est non pas la croustade, mais le GATEAU DES ROIS ,véritable œuvre d'art dans son résultat! attention, il faut aimer les fruits confits,et si vous les faites vous-mêmes, c'est encore meilleur.
Mais surtout, laissez-vous aller à faire de jolis décors, vous avez jusqu'au 6 janvier, car la tradition veut que ce gâteau se mange pour "l'épiphanie".
Publié par Administrator le 15 janvier 2007 .
Recette du gâteau des rois, par Catou
Auteur Martine Acknin
Pour 4 couronnes et 8 brioches:
200+500g farine type55
1 cube de levure de boulanger (42g)
4+1 oeufs moyens
180g de sucre en poudre
200g de beurre ramolli mais non fondu
1 pincée de sel
4 bouchons d’eau de fleur d’oranger
2 zestes d’orange
1 fève
1 emporte-pièces Ø6cm ou un petit verre
3 c.à.s gelée de coing
160g de sucre à brioche
Difficulté: Moyen Préparation: 7 heures Cuisson: 9 minutes Repos: 5h30
C'est une couronne briochée traditionnellement servie pour l'Epiphanie, le 6ème jour de Janvier. C'est l'occasion de "tirer les rois", c'est à dire couper la couronne en nombre de parts égal au nombre de convives, puis faire attribuer chacune par le plus jeune enfant. Celui qui a la fève est désigné comme roi.
Liens utiles
Console de débogage Joomla! {
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1685454498,
"last": 1685454498,
"now": 1685454498
}
},
"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
},
"plg_system_languagefilter": {
"language": "fr-FR"
}
}
}
12,32 MB (12 917 976 Bytes )
26 requêtes exécutées 69.76 ms 2 doubles découverts! 2 requêtes dupliquées:
#18 #23 Temps de requête : 3.25 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.162 MB Rangées retournées : 0
SELECT `data`
FROM `gpv25_session `
WHERE `session_id` = X'3665663739353435643731363336306437363836666330383839303534636463'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL
Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
Temps de requête : 0.43 ms Après la dernière requête : 1.57 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.257 MB Rangées retournées : 0
SELECT `session_id`
FROM `gpv25_session `
WHERE `session_id` = X'3665663739353435643731363336306437363836666330383839303534636463' LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index
Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# Appel Fichier et numéro de ligne 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
Temps de requête : 3.13 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.004 MB mémoire avant requête : 4.262 MB
INSERT INTO `gpv25_session `
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3665663739353435643731363336306437363836666330383839303534636463', 1, 1685454498, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `gpv25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3665663739353435643731363336306437363836666330383839303534636463', 1, 1685454498, 0, '', 0)
Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms update 0.12 ms end 0.01 ms query end 2.71 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms
# Appel Fichier et numéro de ligne 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
Temps de requête : 3.16 ms Après la dernière requête : 3.08 ms Mémoire de requête : 0.024 MB mémoire avant requête : 4.451 MB Rangées retournées : 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `gpv25_extensions `
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_extensions NULL ref extension extension 82 const 41 1.00 Using where
Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.06 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.46 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Même appel que celui de la ligne ci-dessous. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 0.55 ms Après la dernière requête : 2.89 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.704 MB Rangées retournées : 4
SELECT id, rules
FROM `gpv25_viewlevels `id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_viewlevels NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 4 100.00 NULL
Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 0.47 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.715 MB Rangées retournées : 1
SELECT b.id
FROM gpv25_usergroups AS a
LEFT JOIN gpv25_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 100.00 Using where; Using index
Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 1.54 ms Après la dernière requête : 0.83 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.784 MB Rangées retournées : 92
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM gpv25_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_extensions NULL ref extension extension 82 const 190 0.40 Using index condition; Using where; Utilisation du tri complet de type filesort
Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.99 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms
# Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Même appel que celui de la ligne ci-dessous. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 0.57 ms Après la dernière requête : 1.35 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.898 MB Rangées retournées : 2
SELECT *
FROM gpv25_languages
WHERE published= 1
ORDER BY ordering ASC id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_languages NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 50.00 Using where; Utilisation du tri complet de type filesort
Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms
# Appel Fichier et numéro de ligne 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Language/LanguageHelper.php:67 4 Joomla\CMS\Language\LanguageHelper::detectLanguage() JROOT/libraries/src/Application/SiteApplication.php:653 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.67 ms Après la dernière requête : 7.70 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.503 MB Rangées retournées : 4
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `gpv25_extensions `
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_extensions NULL ref extension extension 82 const 4 1.25 Using where
Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 2.71 ms Après la dernière requête : 14.64 ms Mémoire de requête : 0.085 MB mémoire avant requête : 6.615 MB Rangées retournées : 40
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM gpv25_menu AS m
LEFT JOIN gpv25_extensions AS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 63 10.00 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 db462563782.m.component_id 1 100.00 Using where
Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.06 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.04 ms Sorting result 0.04 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 1.62 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.03 ms
# Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Même appel que celui de la ligne ci-dessous. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 0.70 ms Après la dernière requête : 13.96 ms Mémoire de requête : 0.021 MB mémoire avant requête : 7.702 MB Rangées retournées : 1
SELECT id
FROM `gpv25_tags `
WHERE `alias` = 'gateaux-des-rois'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_tags NULL ref idx_alias idx_alias 402 const 1 100.00 Using where
Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_tags/router.php:179 10 TagsRouter->fixSegment() JROOT/components/com_tags/router.php:147 9 TagsRouter->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.71 ms Après la dernière requête : 0.60 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.741 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `gpv25_extensions `
WHERE `type` = 'library' AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL
Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.19 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Même appel que celui de la ligne ci-dessous. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 3.19 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.005 MB mémoire avant requête : 7.794 MB
UPDATE `gpv25_extensions `
SET `params` = '{\"mediaversion\":\"b5c3583e78f43ee9c85d32db1ff4bebb\"}'
WHERE `type` = 'library' AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE gpv25_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where
Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.11 ms updating 0.13 ms end 0.02 ms query end 2.53 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 1.12 ms Après la dernière requête : 2.45 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.970 MB Rangées retournées : 11
SELECT id, home, template, s.params
FROM gpv25_template_styles as s
LEFT JOIN gpv25_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id
WHERE s.client_id = 0 AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 15 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 db462563782.e.element 1 78.57 Using index condition; Using where
Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.05 ms System lock 0.03 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms executing 0.01 ms Sending data 0.29 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 1.79 ms Après la dernière requête : 55.06 ms Mémoire de requête : 0.043 MB mémoire avant requête : 8.702 MB Rangées retournées : 15
SELECT *
FROM `gpv25_content_types `id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_content_types NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 15 100.00 NULL
Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.47 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.77 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 18 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Helper/TagsHelper.php:794 17 Joomla\CMS\Helper\TagsHelper::getTypes() JROOT/libraries/src/Helper/TagsHelper.php:628 16 Joomla\CMS\Helper\TagsHelper->getTagItemsQuery() JROOT/components/com_tags/models/tag.php:149 15 TagsModelTag->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 14 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_tags/models/tag.php:86 12 TagsModelTag->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:93 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 : 5.99 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.041 MB mémoire avant requête : 8.713 MB Rangées retournées : 4
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX (m.tag_date) as tag_date, MAX (c.core_title) AS core_title, MAX (c.core_params) AS core_params,MAX (c.core_alias) AS core_alias, MAX (c.core_body) AS core_body, MAX (c.core_state) AS core_state, MAX (c.core_access) AS core_access,MAX (c.core_metadata) AS core_metadata, MAX (c.core_created_user_id) AS core_created_user_id, MAX (c.core_created_by_alias) AS core_created_by_alias,MAX (c.core_created_time) as core_created_time, MAX (c.core_images) as core_images,CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX (c.core_language) AS core_language, MAX (c.core_catid) AS core_catid,MAX (c.core_publish_up) AS core_publish_up, MAX (c.core_publish_down) as core_publish_down,MAX (ct.type_title) AS content_type_title, MAX (ct.router) AS router,CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM gpv25_contentitem_tag_map AS m
INNER JOIN gpv25_ucm_content AS c ON m.type_alias = c.core_type_alias AND m.core_content_id = c.core_content_id AND c.core_state IN (1) AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2023-05-30 13:48:18') AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2023-05-30 13:48:18')
INNER JOIN gpv25_content_types AS ct ON ct.type_alias = m.type_alias
LEFT JOIN gpv25_categories AS tc ON tc.id = c.core_catid
LEFT JOIN gpv25_users AS ua ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (7) AND (c.core_catid = 0 OR tc.published = 1) AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_weblinks.weblink','com_weblinks.category') AND c.core_access IN (0,1)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
ORDER BY MAX (`c`.`core_title`) ASC LIMIT 30id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref idx_tag_type,idx_core_content_id idx_tag_type 4 const 4 50.00 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE ct NULL ref idx_alias idx_alias 402 db462563782.m.type_alias 1 100.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY,tag_idx,idx_access,idx_content_type PRIMARY 4 db462563782.m.core_content_id 1 5.00 Using where 1 SIMPLE tc NULL eq_ref PRIMARY PRIMARY 4 db462563782.c.core_catid 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db462563782.c.core_created_user_id 1 100.00 Using where
Status Duration starting 0.40 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.22 ms init 0.35 ms System lock 0.03 ms optimizing 0.04 ms statistics 0.29 ms preparing 0.07 ms Creating tmp table 0.15 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.99 ms Creating sort index 0.17 ms end 0.01 ms query end 0.01 ms removing tmp table 0.19 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_tags/models/tag.php:86 12 TagsModelTag->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:93 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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.46 ms Après la dernière requête : 17.55 ms Mémoire de requête : 0.034 MB mémoire avant requête : 9.002 MB Rangées retournées : 30
SHOW FULL COLUMNS FROM `gpv25_tags `EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `gpv25_tags`
Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.42 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.02 ms Opening tables 0.09 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms Sending data 0.16 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.17 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_tags/tables/tag.php:29 14 TagsTableTag->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_tags/models/tag.php:282 12 TagsModelTag->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:94 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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.47 ms Après la dernière requête : 1.51 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.099 MB Rangées retournées : 1
SELECT *
FROM gpv25_tags
WHERE `id` = '7'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_tags NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 13 Joomla\CMS\Table\Table->load() JROOT/components/com_tags/models/tag.php:291 12 TagsModelTag->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:94 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 : 6.53 ms Après la dernière requête : 1.49 ms Mémoire de requête : 0.040 MB mémoire avant requête : 9.204 MB Rangées retournées : 4
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX (m.tag_date) as tag_date, MAX (c.core_title) AS core_title, MAX (c.core_params) AS core_params,MAX (c.core_alias) AS core_alias, MAX (c.core_body) AS core_body, MAX (c.core_state) AS core_state, MAX (c.core_access) AS core_access,MAX (c.core_metadata) AS core_metadata, MAX (c.core_created_user_id) AS core_created_user_id, MAX (c.core_created_by_alias) AS core_created_by_alias,MAX (c.core_created_time) as core_created_time, MAX (c.core_images) as core_images,CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX (c.core_language) AS core_language, MAX (c.core_catid) AS core_catid,MAX (c.core_publish_up) AS core_publish_up, MAX (c.core_publish_down) as core_publish_down,MAX (ct.type_title) AS content_type_title, MAX (ct.router) AS router,CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM gpv25_contentitem_tag_map AS m
INNER JOIN gpv25_ucm_content AS c ON m.type_alias = c.core_type_alias AND m.core_content_id = c.core_content_id AND c.core_state IN (1) AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2023-05-30 13:48:18') AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2023-05-30 13:48:18')
INNER JOIN gpv25_content_types AS ct ON ct.type_alias = m.type_alias
LEFT JOIN gpv25_categories AS tc ON tc.id = c.core_catid
LEFT JOIN gpv25_users AS ua ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (7) AND (c.core_catid = 0 OR tc.published = 1) AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_weblinks.weblink','com_weblinks.category') AND c.core_access IN (0,1)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_emailid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref idx_tag_type,idx_core_content_id idx_tag_type 4 const 4 50.00 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE ct NULL ref idx_alias idx_alias 402 db462563782.m.type_alias 1 100.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY,tag_idx,idx_access,idx_content_type PRIMARY 4 db462563782.m.core_content_id 1 5.00 Using where 1 SIMPLE tc NULL eq_ref PRIMARY PRIMARY 4 db462563782.c.core_catid 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db462563782.c.core_created_user_id 1 100.00 Using where
Status Duration starting 0.34 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.31 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.27 ms preparing 0.07 ms Creating tmp table 0.11 ms Sorting result 0.01 ms executing 0.01 ms Sending data 1.13 ms Creating sort index 0.32 ms end 0.01 ms query end 0.02 ms removing tmp table 0.21 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.03 ms
# Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 13 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 12 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:97 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 : 5.51 ms Après la dernière requête : 10.49 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.740 MB Rangées retournées : 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH (c.alias) != 0 THEN CONCAT_WS (':', c.id, c.alias) ELSE c.id END as slug
FROM `gpv25_categories ` AS `s`
INNER JOIN `gpv25_categories ` AS `c` ON (s.lft < c.lft AND c.lft < s.rgt AND c.language IN ('fr-FR ','* ')) OR (c.lft <= s.lft AND s.rgt <= c.rgt)
WHERE (c.extension= 'com_content' OR c.extension= 'system') AND c.access IN (1,1) AND c.published = 1 AND s.id = 257
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Utilisation du tri complet de type filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right,idx_language INDEX N'A PU ÊTRE UTILISÉ NULL NULL 119 20.45 Using where
Status Duration starting 0.25 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.12 ms System lock 0.06 ms optimizing 0.03 ms statistics 0.26 ms preparing 0.05 ms Sorting result 0.06 ms executing 0.01 ms Sending data 0.05 ms Creating sort index 0.56 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.03 ms
# Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:140 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 3.30 ms Après la dernière requête : 0.72 ms Mémoire de requête : 0.025 MB mémoire avant requête : 9.789 MB Rangées retournées : 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM gpv25_fields AS a
LEFT JOIN `gpv25_languages ` AS l ON l.lang_code = a.language
LEFT JOIN gpv25_users AS uc ON uc.id= a.checked_out
LEFT JOIN gpv25_viewlevels AS ag ON ag.id = a.access
LEFT JOIN gpv25_users AS ua ON ua.id = a.created_user_id
LEFT JOIN gpv25_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `gpv25_fields_categories ` AS fc ON fc.field_id = a.id
WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (257,0,86)) AND a.access IN (1,1) AND (a.group_id = 0 OR g.access IN (1,1)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1) AND a.language in ('* ','fr-FR ')
ORDER BY a.ordering ASC id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_language,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 db462563782.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 db462563782.a.id 1 100.00 Using where; Using index; Distinct
Status Duration starting 0.24 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.13 ms System lock 0.04 ms optimizing 0.05 ms statistics 0.33 ms preparing 0.08 ms Creating tmp table 0.16 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.47 ms Creating sort index 0.05 ms end 0.01 ms query end 0.02 ms removing tmp table 0.15 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.08 ms cleaning up 0.03 ms
# Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:140 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 : 5.97 ms Après la dernière requête : 5.94 ms Mémoire de requête : 0.006 MB mémoire avant requête : 10.161 MB
UPDATE gpv25_tags
SET `hits` = (`hits` + 1)
WHERE `id` = '7'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE gpv25_tags NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where
Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.08 ms updating 0.26 ms end 0.02 ms query end 2.78 ms closing tables 0.03 ms freeing items 0.11 ms cleaning up 0.02 ms
# Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 12 Joomla\CMS\Table\Table->hit() JROOT/components/com_tags/models/tag.php:346 11 TagsModelTag->hit() JROOT/components/com_tags/views/tag/view.html.php:239 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 3.88 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.169 MB Rangées retournées : 1
SELECT *
FROM gpv25_tags
WHERE `id` = '7'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE gpv25_tags NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.08 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.03 ms
# Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 12 Joomla\CMS\Table\Table->load() JROOT/components/com_tags/models/tag.php:349 11 TagsModelTag->hit() JROOT/components/com_tags/views/tag/view.html.php:239 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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.55 ms Après la dernière requête : 22.91 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.773 MB Rangées retournées : 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM gpv25_fields AS a
LEFT JOIN `gpv25_languages ` AS l ON l.lang_code = a.language
LEFT JOIN gpv25_users AS uc ON uc.id= a.checked_out
LEFT JOIN gpv25_viewlevels AS ag ON ag.id = a.access
LEFT JOIN gpv25_users AS ua ON ua.id = a.created_user_id
LEFT JOIN gpv25_fields_groups AS g ON g.id = a.group_id
WHERE a.context = 'com_tag.tag' AND a.access IN (1,1) AND (a.group_id = 0 OR g.access IN (1,1)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1) AND a.language in ('* ','fr-FR ')
ORDER BY a.ordering ASC id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_language,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 db462563782.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.group_id 1 100.00 Using where
Status Duration starting 0.32 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.13 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.31 ms preparing 0.06 ms Creating tmp table 0.12 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.53 ms Creating sort index 0.05 ms end 0.01 ms query end 0.02 ms removing tmp table 0.18 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.12 ms cleaning up 0.04 ms
# Appel Fichier et numéro de ligne 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 24 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 23 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 22 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 21 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 20 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 19 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 18 JHtmlContent::prepare() Même appel que celui de la ligne ci-dessous. 17 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 16 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 15 Joomla\CMS\HTML\HTMLHelper::_() JROOT/templates/yoo_eat/warp/systems/joomla/layouts/com_tags/tag/default.php:25 14 include JROOT/templates/yoo_eat/warp/systems/joomla/layouts/com_tags/tag/default.php JROOT/templates/yoo_eat/html/com_tags/tag/default.php:12 13 include JROOT/templates/yoo_eat/html/com_tags/tag/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:243 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.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 : 5.03 ms Après la dernière requête : 39.71 ms Mémoire de requête : 0.043 MB mémoire avant requête : 11.295 MB Rangées retournées : 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gpv25_modules AS m
LEFT JOIN gpv25_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN gpv25_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-05-30 13:48:18') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-30 13:48:18') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 0 OR mm.menuid <= 0) AND m.language IN ('fr-FR ','* ')
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds,idx_language published 5 NULL 27 1.60 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 db462563782.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 db462563782.m.id 2 40.00 Using where; Using index
Status Duration starting 0.23 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.17 ms System lock 0.05 ms optimizing 0.05 ms statistics 0.23 ms preparing 0.06 ms Sorting result 0.03 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 1.23 ms end 0.02 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.13 ms cleaning up 0.03 ms
# Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() Même appel que celui de la ligne ci-dessous. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54 11 Warp\Joomla\Helper\WidgetsHelper->count() JROOT/templates/yoo_eat/layouts/theme.config.php:26 10 include JROOT/templates/yoo_eat/layouts/theme.config.php JROOT/templates/yoo_eat/layouts/theme.php:10 9 include JROOT/templates/yoo_eat/layouts/theme.php JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/yoo_eat/index.php:16 7 require JROOT/templates/yoo_eat/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Temps de requête : 2.07 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.029 MB mémoire avant requête : 11.346 MB Rangées retournées : 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM gpv25_fields AS a
LEFT JOIN `gpv25_languages ` AS l ON l.lang_code = a.language
LEFT JOIN gpv25_users AS uc ON uc.id= a.checked_out
LEFT JOIN gpv25_viewlevels AS ag ON ag.id = a.access
LEFT JOIN gpv25_users AS ua ON ua.id = a.created_user_id
LEFT JOIN gpv25_fields_groups AS g ON g.id = a.group_id
WHERE a.context = 'mod_custom.content' AND a.access IN (1,1) AND (a.group_id = 0 OR g.access IN (1,1)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1) AND a.language in ('* ','fr-FR ')
ORDER BY a.ordering ASC id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_language,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 db462563782.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db462563782.a.group_id 1 100.00 Using where
Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms Opening tables 0.07 ms init 0.10 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.21 ms preparing 0.05 ms Creating tmp table 0.09 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.45 ms Creating sort index 0.04 ms end 0.01 ms query end 0.01 ms removing tmp table 0.12 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.04 ms
# Appel Fichier et numéro de ligne 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 24 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 23 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 22 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 21 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 20 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 19 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 18 JHtmlContent::prepare() Même appel que celui de la ligne ci-dessous. 17 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 16 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 15 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 14 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 13 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 12 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 11 Warp\Joomla\Helper\WidgetsHelper->load() JROOT/templates/yoo_eat/layouts/theme.config.php:73 10 include JROOT/templates/yoo_eat/layouts/theme.config.php JROOT/templates/yoo_eat/layouts/theme.php:10 9 include JROOT/templates/yoo_eat/layouts/theme.php JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/yoo_eat/index.php:16 7 require JROOT/templates/yoo_eat/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
22 types de requêtes exécutées, triées par occurrences. Tables sélectionnées : 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `gpv25_extensions ` 2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM gpv25_fields AS a LEFT JOIN `gpv25_languages ` AS l ON l.lang_code = a.language LEFT JOIN gpv25_users AS uc ON uc.id= a.checked_out LEFT JOIN gpv25_viewlevels AS ag ON ag.id = a.access LEFT JOIN gpv25_users AS ua ON ua.id = a.created_user_id LEFT JOIN gpv25_fields_groups AS g ON g.id = a.group_id 2 × SELECT * FROM gpv25_tags 2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX (m.tag_date) as tag_date, MAX (c.core_title) AS core_title, MAX (c.core_params) AS core_params,MAX (c.core_alias) AS core_alias, MAX (c.core_body) AS core_body, MAX (c.core_state) AS core_state, MAX (c.core_access) AS core_access,MAX (c.core_metadata) AS core_metadata, MAX (c.core_created_user_id) AS core_created_user_id, MAX (c.core_created_by_alias) AS core_created_by_alias,MAX (c.core_created_time) as core_created_time, MAX (c.core_images) as core_images,CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX (c.core_language) AS core_language, MAX (c.core_catid) AS core_catid,MAX (c.core_publish_up) AS core_publish_up, MAX (c.core_publish_down) as core_publish_down,MAX (ct.type_title) AS content_type_title, MAX (ct.router) AS router,CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email FROM gpv25_contentitem_tag_map AS m INNER JOIN gpv25_ucm_content AS c ON m.type_alias = c.core_type_alias AND m.core_content_id = c.core_content_id AND c.core_state IN (1) AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2023-05-30 13:48:18') AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2023-05-30 13:48:18') INNER JOIN gpv25_content_types AS ct ON ct.type_alias = m.type_alias LEFT JOIN gpv25_categories AS tc ON tc.id = c.core_catid LEFT JOIN gpv25_users AS ua ON ua.id = c.core_created_user_id 1 × SELECT `data` FROM `gpv25_session ` 1 × SELECT id, home, template, s.params FROM gpv25_template_styles as s LEFT JOIN gpv25_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id 1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM gpv25_fields AS a LEFT JOIN `gpv25_languages ` AS l ON l.lang_code = a.language LEFT JOIN gpv25_users AS uc ON uc.id= a.checked_out LEFT JOIN gpv25_viewlevels AS ag ON ag.id = a.access LEFT JOIN gpv25_users AS ua ON ua.id = a.created_user_id LEFT JOIN gpv25_fields_groups AS g ON g.id = a.group_id LEFT JOIN `gpv25_fields_categories ` AS fc ON fc.field_id = a.id 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH (c.alias) != 0 THEN CONCAT_WS (':', c.id, c.alias) ELSE c.id END as slug FROM `gpv25_categories ` AS `s` INNER JOIN `gpv25_categories ` AS `c` ON (s.lft < c.lft AND c.lft < s.rgt AND c.language IN ('fr-FR ','* ')) OR (c.lft <= s.lft AND s.rgt <= c.rgt) 1 × SELECT * FROM `gpv25_content_types 1 × SELECT id FROM `gpv25_tags ` 1 × SELECT `session_id` FROM `gpv25_session ` 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM gpv25_menu AS m LEFT JOIN gpv25_extensions AS e ON m.component_id = e.extension_id 1 × SELECT `element`,`name`,`client_id`,`extension_id` FROM `gpv25_extensions ` 1 × SELECT * FROM gpv25_languages 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM gpv25_extensions 1 × SELECT b.id FROM gpv25_usergroups AS a LEFT JOIN gpv25_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1 × SELECT id, rules FROM `gpv25_viewlevels 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM gpv25_modules AS m LEFT JOIN gpv25_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN gpv25_extensions AS e ON e.element = m.module AND e.client_id = m.client_id Autres tables : 1 × INSERT INTO `gpv25_session ` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3665663739353435643731363336306437363836666330383839303534636463', 1, 1685454498, 0, '', 0 1 × UPDATE `gpv25_extensions ` SET `params` = '{\"mediaversion\":\"b5c3583e78f43ee9c85d32db1ff4bebb\"}' 1 × SHOW FULL COLUMNS FROM `gpv25_tags 1 × UPDATE gpv25_tags SET `hits` = (`hits` + 1)
