Maurice CHALAYER interviewé au micro de FRANCE INFO
140ème anniversaire des Lozériens de Paris
Un anniversaire des Lozériens de Paris placé sous le signe du courage et de la transmission.
Le 11 août 2021 s’est déroulé à Mende « Lozère Estivale », qui célébrait d’une part les 140 ans de l’Association des Lozériens de Paris et d'autre part la remise du 39e Prix du Genêt d’Or attribué à Christian Boulet dit « Kiki » (Kiki Boulet). Le salon littéraire : "Nos plumes Lozériennes et Arvernes" cliquez ici
Le stage de St Flour fête son 50ème anniversaire !
Qu’obtient-on lorsque l’on mélange l’Institution Saint-Joseph, des musiciens de tous âges, une semaine ensoleillé et un brin de folie ? Et bien vous obtiendrez le Stage de Musique Traditionnelle de Saint-Flour 2021.
C'est donc sous un temps estival que s'est déroulé le 50ème stage de musique traditionnelle, organisé par l'Association Cabrettes et Cabrettaïres, du lundi 19 au vendredi 23 juillet 2021 malgré une année d’interruption suite à la crise sanitaire.
ACCROCH'TOI... un nom prémonitoire...
Aventure... Île paradisiaque... Dépassement de soi️... Grand gagnant du cœur de tous les téléspectateurs et surtout... Amoureux de nos paysages du Massif Central... c'est... Jonathan JULIEN (Jo pour les intimes !) Bien sûr !!!
Finaliste de l'émission de téléréalité KOH-LANTA, Les Armes Secrètes, qui était pour la toute première fois en Polynésie française, il nous a accordé une interview exclusive !
L'occasion de revenir sur cette formidable aventure humaine et également sur ses activités de guide d'escalade dans ses belles montagnes de Millau ! ICI
Bravo et merci à lui d'avoir répondu présent à notre sollicitation !
La Nuit des Burons 2021
Notre partenaire, le Parc naturel régional de l'Aubrac organise pour la 4e année consécutive la Nuit des Burons, le 19 juin 2021, à partir de 18h30. 5 burons de l'Aubrac accueilleront plusieurs artistes. Réservation : Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser.
1. Buron de Mandilhac | Thérondels (12)
En partenariat avec la coopérative de Thérondels.
Projet Newton : cabaret swing burlesque avec costumes accompagné d’un répertoire de chanson à texte des années 20 à 50 (Boris Vian, Magali Noel, Jeanne Moreau…) et de standards de jazz revisités. RDV au buron par la D18 puis suivez les panneaux Pique-nique partagé et vente d’aligot au buron.
Le 15ème Prix Arverne a livré son verdict
Sous la houlette de Michel BESSIERES, responsable Sports et Prix Arverne au sein du COMEX, au siège de la Ligue Auvergnate à Paris, les membres du jury du Prix Arverne se sont réunis le 1er juin 2021, à 17h00 autour de leur présidente Josyane DELMAS-BOUCHARD. Cette dernière réunion de la saison, qui a pu se dérouler, pour la grande joie des participants, enfin en présentiel, constituait un moment décisif pour l'attribution de ce 15ème Prix Arverne.
Rejoints à 19h00, par le bureau de La Ligue Auvergnate et par sa présidente Isabelle CAZALS, le jury a décerné, avec une large majorité, le Prix Arverne 2021 à Maurice CHALAYER pour son roman : « Le porteur de joie » au Ed. De Borée.
![]()
La Ligue Auvergnate et du Massif-Central est une confédération internationale des associations originaires du Massif-Central créée en 1886. Elle a été fondée par Louis Bonnet pour défendre et unir les Auvergnats de Paris. Contact mail : Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser.
Site Internet de la Ligue Auvergnate et du Massif Central
Copyright © 2009-2026
Mentions légales
Console de débogage Joomla!
{
"__default": {
"session": {
"counter": 33,
"timer": {
"start": 1782334007,
"last": 1782334039,
"now": 1782334039
},
"client": {
"forwarded": "216.73.216.192"
},
"token": "BREvqfil3DgErvBIqlX3jpyJDMt5yEN6"
},
"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
71 requêtes exécutées 92.04 ms
25 doubles découverts!
- Temps de requête : 0.53 ms Mémoire de requête : 0.020 MB mémoire avant requête : 0.795 MB Rangées retournées : 1
SELECT `session_id`
FROM `LAMC75_session`
WHERE `session_id` = X'3636663866313965313031613432636161303965633131393766636234346633'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 0.93 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.037 MB mémoire avant requête : 0.824 MB Rangées retournées : 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `LAMC75_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 LAMC75_extensions NULL ref extension extension 82 const 44 1.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.21 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.10 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.43 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.020 MB mémoire avant requête : 0.848 MB Rangées retournées : 5
SELECT id, rules
FROM `LAMC75_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_viewlevels NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 5 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.11 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.54 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.020 MB mémoire avant requête : 0.857 MB Rangées retournées : 2
SELECT b.id
FROM LAMC75_usergroups AS a
LEFT JOIN LAMC75_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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 8 100.00 Using where; Using index Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.03 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.47 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.022 MB mémoire avant requête : 0.878 MB Rangées retournées : 96
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM LAMC75_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_extensions NULL ref extension extension 82 const 134 0.60 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.71 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 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.48 ms Après la dernière requête : 1.45 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.150 MB Rangées retournées : 0
SELECT `path`
FROM LAMC75_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_rsfirewall_ignored NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.01 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:56 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:22 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:164 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:42 7 plgSystemRsfirewall->__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 : 0.59 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.155 MB Rangées retournées : 0
SELECT `file`
FROM LAMC75_rsfirewall_hashes
WHERE `type`='protect'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_rsfirewall_hashes NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 223 10.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.17 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:63 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:22 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:164 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:42 7 plgSystemRsfirewall->__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 : 0.51 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.022 MB mémoire avant requête : 1.160 MB Rangées retournées : 66
SELECT *
FROM LAMC75_rsfirewall_configurationid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_rsfirewall_configuration NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 66 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 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.01 ms preparing 0.01 ms executing 0.11 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/config.php:71 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:22 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:164 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:42 7 plgSystemRsfirewall->__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 : 1.76 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.022 MB mémoire avant requête : 1.306 MB Rangées retournées : 10
SHOW FULL COLUMNS
FROM `LAMC75_rsfirewall_logs`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `LAMC75_rsfirewall_logs`Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.60 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms Creating tmp table 0.06 ms executing 0.09 ms checking permissions 0.07 ms checking permissions 0.03 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 checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->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/administrator/components/com_rsfirewall/tables/logs.php:38 11 RsfirewallTableLogs->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_rsfirewall/helpers/log.php:31 9 RSFirewallLogger->__construct() JROOT/administrator/components/com_rsfirewall/helpers/log.php:84 8 RSFirewallLogger::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:61 7 plgSystemRsfirewall->__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.95 ms Après la dernière requête : 3.53 ms Mémoire de requête : 0.246 MB mémoire avant requête : 1.460 MB Rangées retournées : 217
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 LAMC75_menu AS m
LEFT JOIN LAMC75_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language INDEX N'A PU ÊTRE UTILISÉ NULL NULL 296 7.94 Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.m.component_id 1 100.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 2.32 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Même appel que celui de la ligne ci-dessous. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.70 ms Après la dernière requête : 2.66 ms Mémoire de requête : 0.020 MB mémoire avant requête : 2.058 MB Rangées retournées : 4
SELECT *
FROM LAMC75_rsfirewall_hashes
WHERE (`type`='3.10.12' OR `type`='protect')
AND (`flag`!='C' OR `flag` IS NULL)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_rsfirewall_hashes NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 223 17.29 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.23 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.08 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/plugins/system/rsfirewall/rsfirewall.php:1300 9 plgSystemRsfirewall->runProtections() JROOT/plugins/system/rsfirewall/rsfirewall.php:1167 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.41 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.067 MB Rangées retournées : 0
SELECT *
FROM LAMC75_rsfirewall_snapshots
WHERE `type`='protect'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_rsfirewall_snapshots NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 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/administrator/components/com_rsfirewall/helpers/snapshot.php:49 10 RSFirewallSnapshot::get() JROOT/plugins/system/rsfirewall/rsfirewall.php:1323 9 plgSystemRsfirewall->runProtections() JROOT/plugins/system/rsfirewall/rsfirewall.php:1167 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.49 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.073 MB Rangées retournées : 0
SELECT `ip`,`reason`
FROM LAMC75_rsfirewall_lists
WHERE (`ip`='216.73.216.192' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_rsfirewall_lists NULL ref published,type,ip published 1 const 1 100.00 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:176 11 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:155 10 plgSystemRsfirewall->isWhitelisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1359 9 plgSystemRsfirewall->runProtections() JROOT/plugins/system/rsfirewall/rsfirewall.php:1167 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.47 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.079 MB Rangées retournées : 0
SELECT `ip`,`reason`
FROM LAMC75_rsfirewall_lists
WHERE (`ip`='216.73.216.192' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_rsfirewall_lists NULL ref published,type,ip published 1 const 1 100.00 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:176 11 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:145 10 plgSystemRsfirewall->isBlacklisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1363 9 plgSystemRsfirewall->runProtections() JROOT/plugins/system/rsfirewall/rsfirewall.php:1167 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.42 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.084 MB Rangées retournées : 0
SELECT *
FROM LAMC75_rsfirewall_exceptions
WHERE `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_rsfirewall_exceptions NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:938 10 plgSystemRsfirewall->isException() JROOT/plugins/system/rsfirewall/rsfirewall.php:1525 9 plgSystemRsfirewall->runProtections() JROOT/plugins/system/rsfirewall/rsfirewall.php:1167 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.49 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.105 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `LAMC75_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 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 : 1.31 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.005 MB mémoire avant requête : 2.096 MB
UPDATE `LAMC75_extensions`
SET `params` = '{\"mediaversion\":\"d709659eb647873fdd06c27966813277\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `LAMC75_extensions` SET `params` = '{\"mediaversion\":\"d709659eb647873fdd06c27966813277\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.07 ms updating 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.80 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 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 : 0.49 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.019 MB mémoire avant requête : 2.116 MB Rangées retournées : 2
SELECT *
FROM LAMC75_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_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.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.59 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.018 MB mémoire avant requête : 2.192 MB Rangées retournées : 1
SELECT id, home, template, s.params
FROM LAMC75_template_styles as s
LEFT JOIN LAMC75_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 s NULL ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 1 100.00 NULL 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 ligueauvergnat.s.template,const 1 4.27 Using index condition; Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.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.01 ms Après la dernière requête : 1.04 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.320 MB Rangées retournées : 44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `LAMC75_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_arrange2drive','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_icagenda','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilemenuck','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_search','com_slideshowck','com_tags','com_templateck','com_templates','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_assets NULL range idx_asset_name idx_asset_name 202 NULL 45 100.00 Using index condition Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.12 ms preparing 0.02 ms executing 0.38 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 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/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/articles.php:115 14 ContentModelArticles->populateState() JROOT/components/com_content/models/featured.php:45 13 ContentModelFeatured->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:55 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 4.26 ms Après la dernière requête : 0.58 ms Mémoire de requête : 0.087 MB mémoire avant requête : 2.409 MB Rangées retournées : 11
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM LAMC75_content AS a
LEFT JOIN LAMC75_categories AS c
ON c.id = a.catid
LEFT JOIN LAMC75_users AS ua
ON ua.id = a.created_by
LEFT JOIN LAMC75_users AS uam
ON uam.id = a.modified_by
LEFT JOIN LAMC75_categories as parent
ON parent.id = c.parent_id
WHERE a.featured = 1
AND a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-24 20:47:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-24 20:47:19')
AND a.catid IN (10)
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 222, 11id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Utilisation du tri complet de type filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid,idx_featured_catid idx_featured_catid 5 const,const 327 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.19 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.15 ms preparing 0.05 ms executing 3.34 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.11 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:126 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.30 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.658 MB Rangées retournées : 1
SELECT COUNT(*)
FROM LAMC75_content AS a
LEFT JOIN LAMC75_categories AS c
ON c.id = a.catid
LEFT JOIN LAMC75_users AS ua
ON ua.id = a.created_by
LEFT JOIN LAMC75_users AS uam
ON uam.id = a.modified_by
LEFT JOIN LAMC75_categories as parent
ON parent.id = c.parent_id
WHERE a.featured = 1
AND a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-24 20:47:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-24 20:47:19')
AND a.catid IN (10)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid,idx_featured_catid idx_featured_catid 5 const,const 327 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where; Using index Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.14 ms preparing 0.05 ms executing 1.59 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 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_content/views/featured/view.html.php:57 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.79 ms Après la dernière requête : 0.78 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.678 MB Rangées retournées : 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `LAMC75_categories` AS `s`
INNER JOIN `LAMC75_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 = 10
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 8 58.33 Using index condition; Using where Status Duration starting 0.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/featured/view.html.php:102 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.96 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.694 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 LAMC75_fields AS a
LEFT JOIN `LAMC75_languages` AS l
ON l.lang_code = a.language
LEFT JOIN LAMC75_users AS uc
ON uc.id=a.checked_out
LEFT JOIN LAMC75_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN LAMC75_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN LAMC75_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `LAMC75_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 (10,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 ligueauvergnat.a.language 1 100.00 Using index condition 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 ligueauvergnat.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.13 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.05 ms Creating tmp table 0.08 ms executing 0.08 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/featured/view.html.php:102 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.51 ms Après la dernière requête : 6.10 ms Mémoire de requête : 0.081 MB mémoire avant requête : 2.853 MB Rangées retournées : 29
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM LAMC75_modules AS m
LEFT JOIN LAMC75_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN LAMC75_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 <= '2026-06-24 20:47:19')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-24 20:47:19')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL PRIMARY,published,newsfeeds INDEX N'A PU ÊTRE UTILISÉ NULL NULL 57 1.75 Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 ligueauvergnat.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 ligueauvergnat.m.id 1 40.00 Using where; Using index Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.10 ms preparing 0.05 ms executing 0.82 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Même appel que celui de la ligne ci-dessous. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/ligue2021/index.php:53 7 require JROOT/templates/ligue2021/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.99 ms Après la dernière requête : 6.62 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.292 MB Rangées retournées : 137
SHOW TABLES
EXPLAIN impossible sur la requête : SHOW TABLESStatus Duration 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 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 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.04 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 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 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 checking permissions 0.01 ms checking permissions 0.01 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.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 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 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 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 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 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 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 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 checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.10 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 10 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/mobilemenuck/helpers/helper.php:186 9 Mobilemenuck\Helper::searchTable() JROOT/plugins/system/mobilemenuck/helpers/helper.php:174 8 Mobilemenuck\Helper::checkIsProVersion() JROOT/plugins/system/mobilemenuck/mobilemenuck.php:621 7 PlgSystemMobilemenuck->onBeforeRender() 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:1102 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.95 ms Après la dernière requête : 3.14 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.342 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 LAMC75_fields AS a
LEFT JOIN `LAMC75_languages` AS l
ON l.lang_code = a.language
LEFT JOIN LAMC75_users AS uc
ON uc.id=a.checked_out
LEFT JOIN LAMC75_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN LAMC75_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN LAMC75_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 ligueauvergnat.a.language 1 100.00 Using index condition 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 ligueauvergnat.a.group_id 1 100.00 Using where Status Duration starting 0.14 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.03 ms Creating tmp table 0.06 ms executing 0.05 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 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/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() Même appel que celui de la ligne ci-dessous. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.58 ms Après la dernière requête : 1.68 ms Mémoire de requête : 0.029 MB mémoire avant requête : 4.416 MB Rangées retournées : 316
SELECT id AS nbevt
FROM `LAMC75_icagenda_events` AS e
WHERE e.state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref idx_state idx_state 1 const 316 100.00 Using index Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.12 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/modules/mod_iccalendar/helper.php:134 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.11 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.424 MB Rangées retournées : 0
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `LAMC75_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 236 3.33 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms executing 0.66 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 12 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/modules/mod_iccalendar/helper.php:169 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.82 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.054 MB mémoire avant requête : 4.501 MB Rangées retournées : 14
SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order ,feat.count AS features,r.count AS reg_people, r.date AS reg_date
FROM `LAMC75_icagenda_events` AS e
LEFT JOIN `LAMC75_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `LAMC75_icagenda_feature_xref` AS fx
INNER JOIN `LAMC75_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `LAMC75_icagenda_registration` AS r
WHERE r.state > 0
GROUP BY r.eventid) AS r
ON e.id=r.eventid
WHERE c.state = 1
AND e.state = 1
AND e.approval = 0
AND ((`e`.`next` >= '2026-06-01') OR (`e`.`startdate` <= '2026-06-01'
AND `e`.`enddate` >= '2026-06-01'
AND `e`.`weekdays` = ""))
AND e.access IN (1, 1, 5)
AND e.language IN ('fr-FR','*')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c NULL ref PRIMARY,idx_state idx_state 1 const 6 100.00 NULL 1 PRIMARY e NULL ALL idx_state,idx_approval,idx_language,idx_catid INDEX N'A PU ÊTRE UTILISÉ NULL NULL 323 1.00 Using where; Using join buffer (hash join) 1 PRIMARY <derived2> NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 100.00 Using where; Using join buffer (hash join) 1 PRIMARY <derived3> NULL ref <auto_key0> <auto_key0> 4 ligueauvergnat.e.id 9 100.00 Using where 3 DERIVED r NULL index idx_state,idx_eventid idx_eventid 4 NULL 117 84.62 Using where 2 DERIVED fx NULL ALL idx_event_id,idx_feature_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using temporary 2 DERIVED f NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.fx.feature_id 1 100.00 Using where Status Duration starting 0.14 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.04 ms statistics 0.12 ms preparing 0.18 ms executing 1.63 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.11 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_iccalendar/helper.php:287 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.72 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.574 MB Rangées retournées : 99
SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people
FROM LAMC75_icagenda_registration AS r
WHERE r.status = 1
AND r.state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r NULL ref idx_state,idx_status idx_state 1 const 99 100.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.21 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/EventsData.php:1582 12 iCutilities\Events\EventsData::registeredList() JROOT/modules/mod_iccalendar/helper.php:289 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.46 ms Après la dernière requête : 2.23 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.664 MB Rangées retournées : 1
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 338id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.39 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.675 MB Rangées retournées : 1
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 339id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.43 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.682 MB Rangées retournées : 1
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 340id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.40 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.690 MB Rangées retournées : 1
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 341id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.46 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.699 MB Rangées retournées : 1
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 342id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.43 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.708 MB Rangées retournées : 1Requêtes dupliquées: #50
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 350id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.41 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.715 MB Rangées retournées : 1Requêtes dupliquées: #53
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 351id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.45 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.722 MB Rangées retournées : 1Requêtes dupliquées: #62
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 352id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.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:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.50 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.730 MB Rangées retournées : 1Requêtes dupliquées: #65
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 353id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.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:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.48 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.737 MB Rangées retournées : 1Requêtes dupliquées: #68
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 354id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.03 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:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.38 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.744 MB Rangées retournées : 1Requêtes dupliquées: #59
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 356id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.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:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.38 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.752 MB Rangées retournées : 1
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 357id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.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:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.39 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.759 MB Rangées retournées : 1
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 358id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.55 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.767 MB Rangées retournées : 1Requêtes dupliquées: #56
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 359id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 10.84 ms Après la dernière requête : 4.62 ms Mémoire de requête : 0.469 MB mémoire avant requête : 4.790 MB Rangées retournées : 316Requêtes dupliquées: #49
SELECT e.*
FROM LAMC75_icagenda_events AS e
LEFT JOIN LAMC75_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN LAMC75_icagenda_customfields_data AS cfd
ON cfd.parent_id = e.id
WHERE c.state = 1
AND e.state = 1
AND TRUE
AND e.language IN ('fr-FR','*')
AND e.access IN (1, 1, 5)
AND e.approval <> 1
GROUP BY e.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref PRIMARY,idx_state,idx_approval,idx_language,idx_catid,idx_checkout idx_state 1 const 316 30.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.e.catid 1 100.00 Using where 1 SIMPLE cfd NULL ref idx_parent_id idx_parent_id 4 ligueauvergnat.e.id 1 100.00 Using where; Using index Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.06 ms executing 10.12 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/utilities/events/data.php:259 16 icagendaEventsData::getAllDates() JROOT/components/com_icagenda/models/events.php:256 15 iCagendaModelEvents->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_icagenda/models/events.php:297 12 iCagendaModelEvents->getItems() JROOT/modules/mod_ic_event_list/helper.php:143 11 modiCEventListHelper::getList() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:115 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.48 ms Après la dernière requête : 14.20 ms Mémoire de requête : 0.039 MB mémoire avant requête : 5.168 MB Rangées retournées : 11
SELECT e.*,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc, c.title AS category, c.color AS catcolor,feat.count AS features
FROM `LAMC75_icagenda_events` AS e
LEFT JOIN LAMC75_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM LAMC75_icagenda_feature_xref AS fx
INNER JOIN LAMC75_icagenda_feature AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
WHERE c.state = 1
AND e.state = 1
AND e.approval <> 1
AND e.access IN (1,1,5)
AND e.id IN (358,357,342,341,354,353,352,356,359,351,350)
ORDER BY e.next ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY e NULL range PRIMARY,idx_state,idx_approval,idx_catid PRIMARY 4 NULL 11 10.00 Using where; Utilisation du tri complet de type filesort 1 PRIMARY c NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.e.catid 1 100.00 Using where 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 ligueauvergnat.e.id 2 100.00 Using where 2 DERIVED fx NULL ALL idx_event_id,idx_feature_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using temporary 2 DERIVED f NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.fx.feature_id 1 100.00 Using where Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.04 ms statistics 0.14 ms preparing 0.04 ms executing 0.44 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.05 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_icagenda/models/events.php:297 12 iCagendaModelEvents->getItems() JROOT/modules/mod_ic_event_list/helper.php:143 11 modiCEventListHelper::getList() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:115 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.26 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.224 MB Rangées retournées : 0
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `LAMC75_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 236 3.33 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.73 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 11 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:127 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 10.32 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.467 MB mémoire avant requête : 5.232 MB Rangées retournées : 316Requêtes dupliquées: #46
SELECT e.*
FROM LAMC75_icagenda_events AS e
LEFT JOIN LAMC75_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN LAMC75_icagenda_customfields_data AS cfd
ON cfd.parent_id = e.id
WHERE c.state = 1
AND e.state = 1
AND TRUE
AND e.language IN ('fr-FR','*')
AND e.access IN (1, 1, 5)
AND e.approval <> 1
GROUP BY e.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref PRIMARY,idx_state,idx_approval,idx_language,idx_catid,idx_checkout idx_state 1 const 316 30.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.e.catid 1 100.00 Using where 1 SIMPLE cfd NULL ref idx_parent_id idx_parent_id 4 ligueauvergnat.e.id 1 100.00 Using where; Using index Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.05 ms executing 9.60 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/EventsData.php:268 11 iCutilities\Events\EventsData::getAllDates() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:209 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.55 ms Après la dernière requête : 11.61 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.243 MB Rangées retournées : 1Requêtes dupliquées: #37
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 350id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 12 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 11 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:267 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.59 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.250 MB Rangées retournées : 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `LAMC75_icagenda_feature_xref` AS fx
INNER JOIN `LAMC75_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=350
ORDER BY f.ordering DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fx NULL ref idx_event_id,idx_feature_id idx_event_id 4 const 1 100.00 Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE f NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.fx.feature_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/Events.php:89 11 iCutilities\Events\Events::featureIcons() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:330 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.08 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.256 MB Rangées retournées : 0
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `LAMC75_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 236 3.33 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.58 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 12 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:168 11 iCutilities\Menus\Menus::thisEventItemid() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:411 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.96 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.263 MB Rangées retournées : 1Requêtes dupliquées: #38
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 351id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.23 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.28 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 12 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 11 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:267 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.60 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.270 MB Rangées retournées : 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `LAMC75_icagenda_feature_xref` AS fx
INNER JOIN `LAMC75_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=351
ORDER BY f.ordering DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fx NULL ref idx_event_id,idx_feature_id idx_event_id 4 const 1 100.00 Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE f NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.fx.feature_id 1 100.00 Using where Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/Events.php:89 11 iCutilities\Events\Events::featureIcons() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:330 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.03 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.275 MB Rangées retournées : 0
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `LAMC75_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 236 3.33 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.56 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 12 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:168 11 iCutilities\Menus\Menus::thisEventItemid() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:411 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.46 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.282 MB Rangées retournées : 1Requêtes dupliquées: #45
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 359id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.11 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 12 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 11 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:267 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.60 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.289 MB Rangées retournées : 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `LAMC75_icagenda_feature_xref` AS fx
INNER JOIN `LAMC75_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=359
ORDER BY f.ordering DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fx NULL ref idx_event_id,idx_feature_id idx_event_id 4 const 1 100.00 Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE f NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.fx.feature_id 1 100.00 Using where Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/Events.php:89 11 iCutilities\Events\Events::featureIcons() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:330 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.14 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.294 MB Rangées retournées : 0
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `LAMC75_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 236 3.33 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.65 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 12 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:168 11 iCutilities\Menus\Menus::thisEventItemid() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:411 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.48 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.300 MB Rangées retournées : 1Requêtes dupliquées: #42
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 356id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 12 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 11 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:267 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.56 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.307 MB Rangées retournées : 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `LAMC75_icagenda_feature_xref` AS fx
INNER JOIN `LAMC75_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=356
ORDER BY f.ordering DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fx NULL ref idx_event_id,idx_feature_id idx_event_id 4 const 1 100.00 Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE f NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.fx.feature_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/Events.php:89 11 iCutilities\Events\Events::featureIcons() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:330 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.53 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.312 MB Rangées retournées : 0
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `LAMC75_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 236 3.33 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.99 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 12 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:168 11 iCutilities\Menus\Menus::thisEventItemid() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:411 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.46 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.319 MB Rangées retournées : 1Requêtes dupliquées: #39
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 352id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 12 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 11 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:267 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.56 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.326 MB Rangées retournées : 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `LAMC75_icagenda_feature_xref` AS fx
INNER JOIN `LAMC75_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=352
ORDER BY f.ordering DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fx NULL ref idx_event_id,idx_feature_id idx_event_id 4 const 1 100.00 Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE f NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.fx.feature_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/Events.php:89 11 iCutilities\Events\Events::featureIcons() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:330 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.02 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.331 MB Rangées retournées : 0
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `LAMC75_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 236 3.33 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms executing 0.54 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 12 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:168 11 iCutilities\Menus\Menus::thisEventItemid() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:411 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.42 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.023 MB mémoire avant requête : 5.344 MB Rangées retournées : 1Requêtes dupliquées: #40
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 353id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.05 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 12 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 11 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:267 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.55 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.352 MB Rangées retournées : 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `LAMC75_icagenda_feature_xref` AS fx
INNER JOIN `LAMC75_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=353
ORDER BY f.ordering DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fx NULL ref idx_event_id,idx_feature_id idx_event_id 4 const 1 100.00 Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE f NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.fx.feature_id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/Events.php:89 11 iCutilities\Events\Events::featureIcons() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:330 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.02 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.357 MB Rangées retournées : 0
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `LAMC75_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 236 3.33 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms executing 0.54 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 12 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:168 11 iCutilities\Menus\Menus::thisEventItemid() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:411 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.17 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.364 MB Rangées retournées : 1Requêtes dupliquées: #41
SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`
WHERE `e`.`id` = 354id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.38 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.35 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 12 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:620 11 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:267 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.66 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.371 MB Rangées retournées : 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `LAMC75_icagenda_feature_xref` AS fx
INNER JOIN `LAMC75_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=354
ORDER BY f.ordering DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fx NULL ref idx_event_id,idx_feature_id idx_event_id 4 const 1 100.00 Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE f NULL eq_ref PRIMARY,idx_state PRIMARY 4 ligueauvergnat.fx.feature_id 1 100.00 Using where Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/Events.php:89 11 iCutilities\Events\Events::featureIcons() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:330 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.13 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.376 MB Rangées retournées : 0
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `LAMC75_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE LAMC75_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 236 3.33 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.64 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 1.56 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 12 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:168 11 iCutilities\Menus\Menus::thisEventItemid() JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:411 10 include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 9.93 ms Après la dernière requête : 12.26 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.634 MB Rangées retournées : 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `LAMC75_categories` AS `s`
INNER JOIN `LAMC75_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 = 9
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 7 58.33 Using index condition; Using where Status Duration starting 6.56 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 2.20 ms statistics 0.16 ms preparing 0.03 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 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/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:173 15 ContentRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
33 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
21 × SELECT e.params
FROM `LAMC75_icagenda_events` AS `e`9 × SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `LAMC75_menu`7 × SELECT DISTINCT f.icon, f.icon_alt
FROM `LAMC75_icagenda_feature_xref` AS fx
INNER JOIN `LAMC75_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `LAMC75_extensions`2 × SELECT `ip`,`reason`
FROM LAMC75_rsfirewall_lists2 × 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 `LAMC75_categories` AS `s`
INNER JOIN `LAMC75_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 e.*
FROM LAMC75_icagenda_events AS e
LEFT JOIN LAMC75_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN LAMC75_icagenda_customfields_data AS cfd
ON cfd.parent_id = e.id1 × SELECT `session_id`
FROM `LAMC75_session`1 × SELECT id, rules
FROM `LAMC75_viewlevels1 × SELECT b.id
FROM LAMC75_usergroups AS a
LEFT JOIN LAMC75_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM LAMC75_extensions1 × SELECT `path`
FROM LAMC75_rsfirewall_ignored1 × SELECT `file`
FROM LAMC75_rsfirewall_hashes1 × SELECT *
FROM LAMC75_rsfirewall_configuratio1 × 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 LAMC75_menu AS m
LEFT JOIN LAMC75_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM LAMC75_rsfirewall_hashes1 × SELECT *
FROM LAMC75_rsfirewall_snapshots1 × SELECT *
FROM LAMC75_rsfirewall_exceptions1 × SELECT *
FROM LAMC75_languages1 × SELECT id, home, template, s.params
FROM LAMC75_template_styles as s
LEFT JOIN LAMC75_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `LAMC75_assets`1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM LAMC75_content AS a
LEFT JOIN LAMC75_categories AS c
ON c.id = a.catid
LEFT JOIN LAMC75_users AS ua
ON ua.id = a.created_by
LEFT JOIN LAMC75_users AS uam
ON uam.id = a.modified_by
LEFT JOIN LAMC75_categories as parent
ON parent.id = c.parent_id1 × SELECT COUNT(*)
FROM LAMC75_content AS a
LEFT JOIN LAMC75_categories AS c
ON c.id = a.catid
LEFT JOIN LAMC75_users AS ua
ON ua.id = a.created_by
LEFT JOIN LAMC75_users AS uam
ON uam.id = a.modified_by
LEFT JOIN LAMC75_categories as parent
ON parent.id = c.parent_id1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM LAMC75_fields AS a
LEFT JOIN `LAMC75_languages` AS l
ON l.lang_code = a.language
LEFT JOIN LAMC75_users AS uc
ON uc.id=a.checked_out
LEFT JOIN LAMC75_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN LAMC75_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN LAMC75_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `LAMC75_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM LAMC75_modules AS m
LEFT JOIN LAMC75_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN LAMC75_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM LAMC75_fields AS a
LEFT JOIN `LAMC75_languages` AS l
ON l.lang_code = a.language
LEFT JOIN LAMC75_users AS uc
ON uc.id=a.checked_out
LEFT JOIN LAMC75_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN LAMC75_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN LAMC75_fields_groups AS g
ON g.id = a.group_id1 × SELECT id AS nbevt
FROM `LAMC75_icagenda_events` AS e1 × SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order ,feat.count AS features,r.count AS reg_people, r.date AS reg_date
FROM `LAMC75_icagenda_events` AS e
LEFT JOIN `LAMC75_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `LAMC75_icagenda_feature_xref` AS fx
INNER JOIN `LAMC75_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `LAMC75_icagenda_registration` AS r1 × SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people
FROM LAMC75_icagenda_registration AS r1 × SELECT e.*,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc, c.title AS category, c.color AS catcolor,feat.count AS features
FROM `LAMC75_icagenda_events` AS e
LEFT JOIN LAMC75_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM LAMC75_icagenda_feature_xref AS fx
INNER JOIN LAMC75_icagenda_feature AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
Autres tables :
1 × SHOW FULL COLUMNS
FROM `LAMC75_rsfirewall_logs1 × UPDATE `LAMC75_extensions`
SET `params` = '{\"mediaversion\":\"d709659eb647873fdd06c27966813277\"}'1 × SHOW TABLE