Les membres de l'association
Artisans, commerçants, c'est grâce à eux que nous pouvons vous proposer les animations de l'année.
Informations
1ère Chasse aux oeufs de Pâques le Samedi 30 Mars 2024
Le 09 mars 2024Cette année l’ACASA organise une chasse aux oeufs de Pâques le Samedi 30 Mars !
Une chasse placée sous le signe de la découverte des commerces de notre ville.
A l’aide d'un plan les chasseurs partiront sur les traces d’énigmes déposées dans certaines vitrines, et profiteront de leur balade pour découvrir vos jolies vitrines de Pâques. Le Top départ sera donné au Parc Arsonneauà 10h30.Chaque petit chasseur repartira avec un sachet de chocolats et biscuits de pâques offert par Manon (D events by Maon), Camille (Cam'patisse), Michel Marina (La cave des Remparts), Laurent Meyer (Century21), Mr & Mme Auger (U Express) et Emilie Ducastel (La cabane d'Elsandre)
Une tombola sera organisée sur place, pour remporter des Chocolats Offerts par nos 2 boulangers et Pâtissiers, Un Grand merci à eux pour leur participation !Nous communiquerons sur cet évènement sur les réseaux sociaux (à partager sans modération) ainsi que par affichage dans les commerces qui accepteront nos affiches et écoles de la ville.
Nous comptons sur votre soutien et participation pour cette magnifique Chasse aux OEufs
Merci à Manon (D’eventby manon), Laurent Meyer (century21) , Mr & Mme Auger (U Express) et EmilieDucastel(La cabane d’Elsandre) pour l’organisation.
Concert Nova - Max Pinto le samedi 9 mars 2024 au Cratère
Le 29 janvier 2024La première manifestation au programme 2024 de nos Acteurs Économiques est un concert réunissant sur la scène du Cratère deux artistes arnolphiens Max Pinto et Nova. Une centaine de places sont à gagner à l’occasion des fêtes de fin d’année et de la Saint-Valentin.
Max Pinto
Multi-instrumentiste et compositeur, Max Pinto remporte de nombreuses récompenses avec son quartet jazz. Directeur musical et producteur avec son label Blow Prod, il a composé près de 800 morceaux pour le cinéma, la tv, la radio et pour de nombreux artistes. Saxophoniste et trompettiste régulièrement sollicité dans la pop (Vanessa Paradis, Benjamin Biolay, Pascal Obispo,…), il a également de nombreuses tournées à son actif dans les styles hip-hop, salsa, et électro (Gaël Faye, Beat Assailant, Hippocame Fou, Ray de La Paz, Camilo Azuquita, etc.).
Nova
À 13 ans, le jeune Arnolphien Dylan Marina monte pour la première fois sur une scène, celle du Cratère en clôture du spectacle de fin d’année du conservatoire Gabriel Fauré pour y interpréter Mamma Mia. Il est repéré par le producteur Laurent Bertaud présent dans la salle qui le recommande au producteur de The Voice Kids. Le début d’une aventure.
En 2017, il sort ½ finaliste de la compétition pour intégrer les Kids United dans la version « Sardou et nous », puis en 2018 « Kids United nouvelle génération ». En 2023, Dylan Marina a débuté une carrière solo sous le nom de Nova et a sorti le 20 septembre son 1er single « Insolente ».
Grand jeu Fête des Mères Fête des Pères 2023
Le 29 mai 2023Console de débogage Joomla!
{ "__default": { "session": { "counter": 1, "timer": { "start": 1728618031, "last": 1728618031, "now": 1728618031 }, "client": { "forwarded": "35.170.81.33" } }, "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
68 requêtes exécutées 159.19 ms
- Temps de requête : 3.00 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.046 MB Rangées retournées : 0
SELECT `data`
FROM `acasa78_session`
WHERE `session_id` = X'3237303766643739633266626535393230376663333937356462643861636332'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 2.52 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.04 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 0.44 ms Après la dernière requête : 1.43 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.154 MB Rangées retournées : 0
SELECT `session_id`
FROM `acasa78_session`
WHERE `session_id` = X'3237303766643739633266626535393230376663333937356462643861636332'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_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.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 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.03 ms cleaning up 0.04 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 : 2.19 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.004 MB mémoire avant requête : 4.159 MB
INSERT INTO `acasa78_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3237303766643739633266626535393230376663333937356462643861636332', 1, 1728618031, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `acasa78_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3237303766643739633266626535393230376663333937356462643861636332', 1, 1728618031, 0, '', 0)Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms update 0.11 ms end 0.00 ms query end 0.00 ms waiting for handler commit 1.69 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 3.41 ms Après la dernière requête : 3.31 ms Mémoire de requête : 0.040 MB mémoire avant requête : 4.366 MB Rangées retournées : 38
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `acasa78_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 acasa78_extensions NULL ref extension extension 82 const 38 1.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 2.16 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.30 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 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 : 12.15 ms Après la dernière requête : 2.96 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.648 MB Rangées retournées : 5
SELECT id, rules
FROM `acasa78_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_viewlevels NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 5 100.00 NULL Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 2.42 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.05 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 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 : 3.50 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.660 MB Rangées retournées : 2
SELECT b.id
FROM acasa78_usergroups AS a
LEFT JOIN acasa78_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 2 100.00 Using where; Using index Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.69 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.04 ms executing 0.05 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.09 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 : 2.96 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.730 MB Rangées retournées : 107
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM acasa78_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 acasa78_extensions NULL ref extension extension 82 const 110 0.60 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.61 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.05 ms executing 1.44 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.01 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Même appel que celui de la ligne ci-dessous. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 4.58 ms Après la dernière requête : 42.47 ms Mémoire de requête : 0.064 MB mémoire avant requête : 7.594 MB Rangées retournées : 26
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 acasa78_menu AS m
LEFT JOIN acasa78_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 27 10.00 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.m.component_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.01 ms checking permissions 0.00 ms Opening tables 2.91 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.04 ms executing 0.57 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.02 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/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.98 ms Après la dernière requête : 12.68 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.266 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `acasa78_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.03 ms executing 0.11 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Même appel que celui de la ligne ci-dessous. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 3.23 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.005 MB mémoire avant requête : 8.257 MB
UPDATE `acasa78_extensions`
SET `params` = '{\"mediaversion\":\"e69e54596a076b4cce3fce8ce336770b\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `acasa78_extensions` SET `params` = '{\"mediaversion\":\"e69e54596a076b4cce3fce8ce336770b\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.14 ms updating 0.18 ms end 0.01 ms query end 0.00 ms waiting for handler commit 2.34 ms closing tables 0.02 ms freeing items 0.05 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 : 3.56 ms Après la dernière requête : 1.83 ms Mémoire de requête : 0.020 MB mémoire avant requête : 8.463 MB Rangées retournées : 2
SELECT *
FROM acasa78_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_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.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 2.86 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.03 ms executing 0.08 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 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 : 3.82 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.476 MB Rangées retournées : 3
SELECT id, home, template, s.params
FROM acasa78_template_styles as s
LEFT JOIN acasa78_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 5 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 gcvkaim78.e.element 1 60.00 Using index condition; Using where Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 2.83 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.12 ms preparing 0.04 ms executing 0.18 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 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 : 5.11 ms Après la dernière requête : 7.77 ms Mémoire de requête : 0.027 MB mémoire avant requête : 8.977 MB Rangées retournées : 38
SELECT `id`,`name`,`rules`,`parent_id`
FROM `acasa78_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_adirectory','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_vlogs','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_assets NULL ALL idx_asset_name INDEX N'A PU ÊTRE UTILISÉ NULL NULL 110 35.45 Using where Status Duration starting 0.27 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms Opening tables 3.50 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.28 ms preparing 0.02 ms executing 0.33 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.07 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.14 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.029 MB Rangées retournées : 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `acasa78_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_assets NULL ALL idx_asset_name,idx_parent_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 110 26.15 Using where Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 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.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 4.85 ms Après la dernière requête : 1.75 ms Mémoire de requête : 0.031 MB mémoire avant requête : 9.145 MB Rangées retournées : 31
SHOW FULL COLUMNS
FROM `acasa78_content`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `acasa78_content`Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 2.01 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.90 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.09 ms preparing 0.03 ms Creating tmp table 0.05 ms executing 0.11 ms checking permissions 0.08 ms checking permissions 0.11 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.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.09 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.04 ms freeing items 0.10 ms cleaning up 0.01 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/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.44 ms Après la dernière requête : 4.05 ms Mémoire de requête : 0.005 MB mémoire avant requête : 9.408 MB
UPDATE acasa78_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1'EXPLAIN impossible sur la requête : UPDATE acasa78_content SET `hits` = (`hits` + 1) WHERE `id` = '1'Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.31 ms init 0.01 ms System lock 0.04 ms updating 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.58 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 5.61 ms Après la dernière requête : 2.05 ms Mémoire de requête : 0.024 MB mémoire avant requête : 9.546 MB Rangées retournées : 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM acasa78_content AS a
INNER JOIN acasa78_categories AS c
on c.id = a.catid
LEFT JOIN acasa78_users AS u
on u.id = a.created_by
LEFT JOIN acasa78_categories as parent
ON parent.id = c.parent_id
LEFT JOIN acasa78_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 1
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-11 03:40:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-11 03:40:31')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.23 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 4.56 ms init 0.04 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.14 ms preparing 0.03 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 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:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->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.24 ms Après la dernière requête : 2.27 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.746 MB Rangées retournées : 1
SELECT `m`.`tag_id`,`t`.*
FROM `acasa78_contentitem_tag_map` AS m
INNER JOIN `acasa78_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 gcvkaim78.m.tag_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 3.39 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.08 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/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 3.81 ms Après la dernière requête : 10.61 ms Mémoire de requête : 0.027 MB mémoire avant requête : 10.386 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 `acasa78_categories` AS `s`
INNER JOIN `acasa78_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 = 2
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 2 80.00 Using index condition; Using where Status Duration starting 0.51 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.49 ms init 0.02 ms System lock 0.02 ms optimizing 0.09 ms statistics 0.44 ms preparing 0.10 ms executing 0.38 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.15 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->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 : 13.07 ms Après la dernière requête : 0.53 ms Mémoire de requête : 0.025 MB mémoire avant requête : 10.433 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 acasa78_fields AS a
LEFT JOIN `acasa78_languages` AS l
ON l.lang_code = a.language
LEFT JOIN acasa78_users AS uc
ON uc.id=a.checked_out
LEFT JOIN acasa78_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN acasa78_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN acasa78_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `acasa78_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 (2,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 gcvkaim78.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 gcvkaim78.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.47 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.06 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 11.16 ms init 0.01 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.23 ms preparing 0.05 ms Creating tmp table 0.09 ms executing 0.10 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.06 ms freeing items 0.17 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/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/article/view.html.php:193 10 ContentViewArticle->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 : 6.79 ms Après la dernière requête : 52.13 ms Mémoire de requête : 0.024 MB mémoire avant requête : 13.749 MB Rangées retournées : 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM acasa78_modules AS m
LEFT JOIN acasa78_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN acasa78_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 <= '2024-10-11 03:40:31')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-11 03:40:31')
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 range PRIMARY,published,newsfeeds published 5 NULL 10 4.17 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 gcvkaim78.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 gcvkaim78.m.id 1 40.00 Using where; Using index Status Duration starting 0.28 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 5.25 ms init 0.01 ms System lock 0.01 ms optimizing 0.06 ms statistics 0.14 ms preparing 0.06 ms executing 0.35 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.09 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() Même appel que celui de la ligne ci-dessous. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/admonasso/layouts/block/header.php:54 8 include JROOT/templates/admonasso/layouts/block/header.php JROOT/templates/admonasso/index.php:35 7 require JROOT/templates/admonasso/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 : 3.75 ms Après la dernière requête : 5.80 ms Mémoire de requête : 0.042 MB mémoire avant requête : 12.230 MB Rangées retournées : 3
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM acasa78_content AS a
LEFT JOIN acasa78_categories AS c
ON c.id = a.catid
LEFT JOIN acasa78_users AS ua
ON ua.id = a.created_by
LEFT JOIN acasa78_users AS uam
ON uam.id = a.modified_by
LEFT JOIN acasa78_categories as parent
ON parent.id = c.parent_id
LEFT JOIN acasa78_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (9,11)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-11 03:40:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-11 03:40:31')
ORDER BY a.created DESC
LIMIT 3id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_state 1 const 12 9.14 Using where; Utilisation du tri complet de type filesort 1 SIMPLE c NULL eq_ref PRIMARY,idx_access PRIMARY 4 gcvkaim78.a.catid 1 10.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.c.parent_id 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.id 1 100.00 Using where Status Duration starting 0.40 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 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.01 ms Opening tables 1.59 ms init 0.01 ms System lock 0.01 ms optimizing 0.12 ms statistics 0.27 ms preparing 0.09 ms executing 0.45 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.04 ms freeing items 0.11 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 12 ContentModelArticles->getItems() JROOT/modules/mod_articles_news/helper.php:100 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.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.38 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.028 MB mémoire avant requête : 12.307 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 `acasa78_categories` AS `s`
INNER JOIN `acasa78_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 8 80.00 Using index condition; Using where Status Duration starting 0.19 ms Executing hook on transaction 0.00 ms starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.21 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.03 ms executing 0.09 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 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 20 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 19 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 18 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 17 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_news/helper.php:113 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.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.54 ms Après la dernière requête : 0.55 ms Mémoire de requête : 0.027 MB mémoire avant requête : 12.327 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 acasa78_fields AS a
LEFT JOIN `acasa78_languages` AS l
ON l.lang_code = a.language
LEFT JOIN acasa78_users AS uc
ON uc.id=a.checked_out
LEFT JOIN acasa78_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN acasa78_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN acasa78_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_articles_news.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 gcvkaim78.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.group_id 1 100.00 Using where Status Duration starting 0.37 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 checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 1.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.20 ms preparing 0.05 ms Creating tmp table 0.07 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 18 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 15 JHtmlContent::prepare() Même appel que celui de la ligne ci-dessous. 14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_articles_news/helper.php:123 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.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.66 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.339 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 acasa78_fields AS a
LEFT JOIN `acasa78_languages` AS l
ON l.lang_code = a.language
LEFT JOIN acasa78_users AS uc
ON uc.id=a.checked_out
LEFT JOIN acasa78_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN acasa78_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN acasa78_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `acasa78_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 (9,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 gcvkaim78.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 gcvkaim78.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.18 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.52 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.04 ms Creating tmp table 0.07 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 18 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 16 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 15 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 12 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/modules/mod_articles_news/helper.php:164 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.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.91 ms Après la dernière requête : 9.54 ms Mémoire de requête : 0.047 MB mémoire avant requête : 13.070 MB Rangées retournées : 9
SELECT i.*,c.access
FROM acasa78_adiritems AS i
LEFT JOIN `acasa78_adircategories` AS c
ON i.catid=c.id
LEFT JOIN `acasa78_adiritemscategories` AS x
ON i.id=x.itemid
AND x.catid=1
WHERE i.published>0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-10-11 03:40:31')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-10-11 03:40:31')
AND i.access IN(1,1,5)
AND c.access IN(1,1,5)
AND (i.catid = 1 OR x.catid = 1)
ORDER BY RAND()
LIMIT 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE i NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 81 1.60 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.i.catid 1 30.00 Using where 1 SIMPLE x NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 131 100.00 Using where; Using join buffer (hash join) Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 6.99 ms init 0.01 ms System lock 0.01 ms optimizing 0.06 ms statistics 0.09 ms preparing 0.05 ms Creating tmp table 0.22 ms executing 2.53 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.03 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_adirectory/helpers/directory.php:1506 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.45 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.116 MB Rangées retournées : 1
SELECT *
FROM acasa78_adirpictures
WHERE ownerid = 16
AND ownertype='items'
AND published>0
ORDER BY mainthumb DESC, ordering ASC
LIMIT 1;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adirpictures NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 0.81 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 1.62 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.03 ms executing 0.26 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_adirectory/helpers/directory.php:428 14 dirManager->getPictures() JROOT/administrator/components/com_adirectory/helpers/directory.php:1523 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.87 ms Après la dernière requête : 3.48 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.124 MB Rangées retournées : 1
SELECT marker
FROM acasa78_adircategories
WHERE id=15id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adircategories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 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.30 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_adirectory/helpers/directory.php:1974 14 dirManager->getMarker() JROOT/administrator/components/com_adirectory/helpers/directory.php:1524 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.83 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.132 MB Rangées retournées : 1
SELECT *
FROM acasa78_adirpictures
WHERE ownerid = 61
AND ownertype='items'
AND published>0
ORDER BY mainthumb DESC, ordering ASC
LIMIT 1;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adirpictures NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 0.81 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.05 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.27 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_adirectory/helpers/directory.php:428 14 dirManager->getPictures() JROOT/administrator/components/com_adirectory/helpers/directory.php:1523 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.70 ms Après la dernière requête : 6.01 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.140 MB Rangées retournées : 1
SELECT marker
FROM acasa78_adircategories
WHERE id=11id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adircategories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.01 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_adirectory/helpers/directory.php:1974 14 dirManager->getMarker() JROOT/administrator/components/com_adirectory/helpers/directory.php:1524 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.04 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.148 MB Rangées retournées : 1
SELECT *
FROM acasa78_adirpictures
WHERE ownerid = 49
AND ownertype='items'
AND published>0
ORDER BY mainthumb DESC, ordering ASC
LIMIT 1;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adirpictures NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 0.81 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.04 ms executing 0.33 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_adirectory/helpers/directory.php:428 14 dirManager->getPictures() JROOT/administrator/components/com_adirectory/helpers/directory.php:1523 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.57 ms Après la dernière requête : 5.94 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.156 MB Rangées retournées : 1
SELECT marker
FROM acasa78_adircategories
WHERE id=8id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adircategories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.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.02 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_adirectory/helpers/directory.php:1974 14 dirManager->getMarker() JROOT/administrator/components/com_adirectory/helpers/directory.php:1524 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.98 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 13.170 MB Rangées retournées : 1
SELECT *
FROM acasa78_adirpictures
WHERE ownerid = 87
AND ownertype='items'
AND published>0
ORDER BY mainthumb DESC, ordering ASC
LIMIT 1;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adirpictures NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 0.81 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.04 ms executing 0.38 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_adirectory/helpers/directory.php:428 14 dirManager->getPictures() JROOT/administrator/components/com_adirectory/helpers/directory.php:1523 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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 : 2.84 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.180 MB Rangées retournées : 1
SELECT marker
FROM acasa78_adircategories
WHERE id=16id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adircategories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 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.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_adirectory/helpers/directory.php:1974 14 dirManager->getMarker() JROOT/administrator/components/com_adirectory/helpers/directory.php:1524 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.04 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.188 MB Rangées retournées : 1
SELECT *
FROM acasa78_adirpictures
WHERE ownerid = 70
AND ownertype='items'
AND published>0
ORDER BY mainthumb DESC, ordering ASC
LIMIT 1;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adirpictures NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 0.81 Using where; Utilisation du tri complet de type filesort 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.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.03 ms executing 0.40 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.05 ms closing tables 0.01 ms freeing items 0.14 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_adirectory/helpers/directory.php:428 14 dirManager->getPictures() JROOT/administrator/components/com_adirectory/helpers/directory.php:1523 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.57 ms Après la dernière requête : 3.12 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.196 MB Rangées retournées : 1Requêtes dupliquées: #40
SELECT marker
FROM acasa78_adircategories
WHERE id=9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adircategories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 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.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.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_adirectory/helpers/directory.php:1974 14 dirManager->getMarker() JROOT/administrator/components/com_adirectory/helpers/directory.php:1524 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.99 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.204 MB Rangées retournées : 1
SELECT *
FROM acasa78_adirpictures
WHERE ownerid = 20
AND ownertype='items'
AND published>0
ORDER BY mainthumb DESC, ordering ASC
LIMIT 1;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adirpictures NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 0.81 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.41 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_adirectory/helpers/directory.php:428 14 dirManager->getPictures() JROOT/administrator/components/com_adirectory/helpers/directory.php:1523 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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 : 3.44 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.213 MB Rangées retournées : 1
SELECT marker
FROM acasa78_adircategories
WHERE id=21id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adircategories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.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.09 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_adirectory/helpers/directory.php:1974 14 dirManager->getMarker() JROOT/administrator/components/com_adirectory/helpers/directory.php:1524 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.99 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.220 MB Rangées retournées : 1
SELECT *
FROM acasa78_adirpictures
WHERE ownerid = 71
AND ownertype='items'
AND published>0
ORDER BY mainthumb DESC, ordering ASC
LIMIT 1;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adirpictures NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 0.81 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.43 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_adirectory/helpers/directory.php:428 14 dirManager->getPictures() JROOT/administrator/components/com_adirectory/helpers/directory.php:1523 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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 : 2.28 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.229 MB Rangées retournées : 1Requêtes dupliquées: #36
SELECT marker
FROM acasa78_adircategories
WHERE id=9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adircategories 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.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.03 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_adirectory/helpers/directory.php:1974 14 dirManager->getMarker() JROOT/administrator/components/com_adirectory/helpers/directory.php:1524 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.80 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.236 MB Rangées retournées : 1
SELECT *
FROM acasa78_adirpictures
WHERE ownerid = 5
AND ownertype='items'
AND published>0
ORDER BY mainthumb DESC, ordering ASC
LIMIT 1;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adirpictures NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 0.81 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.29 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_adirectory/helpers/directory.php:428 14 dirManager->getPictures() JROOT/administrator/components/com_adirectory/helpers/directory.php:1523 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.73 ms Après la dernière requête : 7.82 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.245 MB Rangées retournées : 1
SELECT *
FROM acasa78_adirpictures
WHERE ownerid = 82
AND ownertype='items'
AND published>0
ORDER BY mainthumb DESC, ordering ASC
LIMIT 1;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adirpictures NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 0.81 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.18 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_adirectory/helpers/directory.php:428 14 dirManager->getPictures() JROOT/administrator/components/com_adirectory/helpers/directory.php:1523 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.43 ms Après la dernière requête : 3.01 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.253 MB Rangées retournées : 1
SELECT marker
FROM acasa78_adircategories
WHERE id=7id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adircategories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.65 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.05 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/administrator/components/com_adirectory/helpers/directory.php:1974 14 dirManager->getMarker() JROOT/administrator/components/com_adirectory/helpers/directory.php:1524 13 dirManager->getItemList() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:83 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.98 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.367 MB Rangées retournées : 1
SELECT alias
FROM acasa78_adiritems
WHERE id=16id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adiritems NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.08 ms Opening tables 0.92 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.06 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.05 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/components/com_adirectory/router.php:89 20 AdirectoryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:167 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.00 ms Après la dernière requête : 0.91 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.414 MB Rangées retournées : 1
SELECT alias
FROM acasa78_adiritems
WHERE id=61id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adiritems NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.12 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/components/com_adirectory/router.php:89 20 AdirectoryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:167 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.09 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.430 MB Rangées retournées : 1
SELECT alias
FROM acasa78_adiritems
WHERE id=49id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adiritems NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.06 ms freeing items 0.11 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/components/com_adirectory/router.php:89 20 AdirectoryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:167 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.98 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.447 MB Rangées retournées : 1
SELECT alias
FROM acasa78_adiritems
WHERE id=87id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adiritems NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.21 ms preparing 0.02 ms executing 0.02 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.12 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/components/com_adirectory/router.php:89 20 AdirectoryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:167 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.12 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.463 MB Rangées retournées : 1
SELECT alias
FROM acasa78_adiritems
WHERE id=70id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adiritems NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.15 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/components/com_adirectory/router.php:89 20 AdirectoryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:167 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.94 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.479 MB Rangées retournées : 1
SELECT alias
FROM acasa78_adiritems
WHERE id=20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adiritems NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.13 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 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.02 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/components/com_adirectory/router.php:89 20 AdirectoryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:167 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.12 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.496 MB Rangées retournées : 1
SELECT alias
FROM acasa78_adiritems
WHERE id=71id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adiritems NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.05 ms checking permissions 0.05 ms Opening tables 0.06 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.02 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.21 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/components/com_adirectory/router.php:89 20 AdirectoryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:167 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.97 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.512 MB Rangées retournées : 1
SELECT alias
FROM acasa78_adiritems
WHERE id=5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adiritems NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.20 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.08 ms preparing 0.04 ms executing 0.02 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.12 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/components/com_adirectory/router.php:89 20 AdirectoryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:167 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.86 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.529 MB Rangées retournées : 1
SELECT alias
FROM acasa78_adiritems
WHERE id=82id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE acasa78_adiritems NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 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.16 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/components/com_adirectory/router.php:89 20 AdirectoryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_joomladnews/sources/joomlannuaire.php:167 12 getAdirItems() JROOT/modules/mod_joomladnews/helper.php:71 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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 : 5.99 ms Après la dernière requête : 116.68 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.528 MB Rangées retournées : 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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM acasa78_content AS a
LEFT JOIN acasa78_categories AS c
ON c.id = a.catid
LEFT JOIN acasa78_users AS ua
ON ua.id = a.created_by
LEFT JOIN acasa78_users AS uam
ON uam.id = a.modified_by
LEFT JOIN acasa78_categories as parent
ON parent.id = c.parent_id
LEFT JOIN acasa78_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.id <> 1
AND a.catid IN (8)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-11 03:40:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-11 03:40:31')
ORDER BY a.publish_up ASC
LIMIT 3id 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 range PRIMARY,idx_access,idx_state,idx_catid idx_catid 8 NULL 3 2.86 Using index condition; Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 gcvkaim78.a.id 1 100.00 Using where Status Duration starting 0.57 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 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.01 ms Opening tables 3.05 ms init 0.03 ms System lock 0.02 ms optimizing 0.17 ms statistics 0.68 ms preparing 0.17 ms executing 0.53 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.07 ms freeing items 0.15 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/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/modules/mod_joomladnews/sources/joomla.php:118 12 getJoomlaItems() JROOT/modules/mod_joomladnews/helper.php:59 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.90 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.564 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `acasa78_contentitem_tag_map` AS m
INNER JOIN `acasa78_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 3
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 gcvkaim78.m.tag_id 1 100.00 Using where Status Duration starting 0.21 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.41 ms init 0.05 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.23 ms preparing 0.08 ms executing 0.12 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.06 ms closing tables 0.02 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/Helper/TagsHelper.php:454 14 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 13 ContentModelArticles->getItems() JROOT/modules/mod_joomladnews/sources/joomla.php:118 12 getJoomlaItems() JROOT/modules/mod_joomladnews/helper.php:59 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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.85 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.028 MB mémoire avant requête : 13.573 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 `acasa78_categories` AS `s`
INNER JOIN `acasa78_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 = 8
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 80.00 Using index condition; Using where Status Duration starting 0.28 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.33 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.29 ms preparing 0.06 ms executing 0.17 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 22 ContentRouter->getCategorySegment() Même appel que celui de la ligne ci-dessous. 21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_joomladnews/sources/joomla.php:169 12 getJoomlaItems() JROOT/modules/mod_joomladnews/helper.php:59 11 modJoomladnewsHelper::getNews() JROOT/modules/mod_joomladnews/mod_joomladnews.php:34 10 include JROOT/modules/mod_joomladnews/mod_joomladnews.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 : 4.10 ms Après la dernière requête : 0.34 ms Mémoire de requête : 0.027 MB mémoire avant requête : 13.585 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 acasa78_fields AS a
LEFT JOIN `acasa78_languages` AS l
ON l.lang_code = a.language
LEFT JOIN acasa78_users AS uc
ON uc.id=a.checked_out
LEFT JOIN acasa78_viewlevels AS ag