AG du 8 juillet 2023
Programme du jour Petit déjeuner de courageux dès 8h30Traditionnel tournoi entre adhérents en musique à partir de 9hPaëlla conviviale au tennis club de Peypin dès 13hBeachPétanque Assemb
Semaine Olympique 3 au 7 avril : Appel à bénévoles
Bonjour à toutes et à tous,
Durant la prochaine semaine Olympique, du 3 au 7 avril 2023, le Comité 13 sera sur tous les fronts pour animer le territoire :
- Le 3 avril, « Badminton pour Tous et Handicap » à Rognes ;
- Du mercredi 5 avril au vendredi 7 avril, Tournée Olympique à l’Hotel du Département, à Marseille ;
- Le 6 avril 2023, « Badminton pour Tous et Handicap » au collège André Malraux, à Marseille ;
Prochains Tournois badminton à proximité de Peypin
Badiste -
13 mai 2024
Les tournois de badminton sur Badiste --
Tournoi des Calanques 2024
Le 1 juin 2024 (durée : 2 jours). club : SMUC13 13. catégorie : Senior. tableaux : N1-NC. date limite d'inscription : 17 mai 2024.
Horaires des créneaux
HORAIRES DES SEANCES
Mardi : 18h30–20h30 (jeunes et adultes)
Mercredi : 20h00–22h00 (adultes et promobad)
Samedi : 9h00 à 11h00
11h00 à 13h00
(jeunes et adultes)
Lieu de pratique
Gymnase Jacky MONDET
Quai Bedelin,
Auberge Neuve,
13124 – Peypin
GPS 43.392082 5.5522106
Adresse postale
16 avenue des Termes
13124 Peypin
Partenaire carte collégien / e-Pass / Pass Sport
Calendrier
Patientez un instant pendant que nous affichons le calendrier
Console de débogage Joomla!
{ "__default": { "session": { "counter": 2, "timer": { "start": 1715725525, "last": 1715725525, "now": 1715725526 }, "client": { "forwarded": "13.58.118.119" }, "token": "lprLNm75H2LeEVD0ptGIax6bhosuzVco" }, "registry": {}, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "plg_system_languagefilter": { "language": "fr-FR" } } }
Temps
Mémoire
Temps: 2.40 ms / 2.40 ms Mémoire: 0.408 MB / 0.74 MB Application: afterLoad
Temps: 59.65 ms / 62.04 ms Mémoire: 3.539 MB / 4.28 MB Application: afterInitialise
Temps: 21.31 ms / 83.35 ms Mémoire: 0.246 MB / 4.53 MB Application: afterRoute
Temps: 2.34 ms / 85.69 ms Mémoire: 0.019 MB / 4.55 MB Application: beforeRenderComponent com_content
Temps: 12.83 ms / 98.52 ms Mémoire: 0.062 MB / 4.61 MB Application: Before Access::preloadComponents (all components)
Temps: 2.67 ms / 101.19 ms Mémoire: 0.065 MB / 4.67 MB Application: After Access::preloadComponents (all components)
Temps: 0.04 ms / 101.23 ms Mémoire: -0.003 MB / 4.67 MB Application: Before Access::preloadPermissions (com_content)
Temps: 1.47 ms / 102.69 ms Mémoire: 0.023 MB / 4.69 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.02 ms / 102.71 ms Mémoire: 0.001 MB / 4.69 MB Application: Before Access::getAssetRules (id:105 name:com_content.article.3)
Temps: 2.17 ms / 104.88 ms Mémoire: 0.009 MB / 4.70 MB Application: After Access::getAssetRules (id:105 name:com_content.article.3)
Temps: 458.68 ms / 563.56 ms Mémoire: 1.904 MB / 6.61 MB Application: afterRenderComponent com_content
Temps: 16.30 ms / 579.86 ms Mémoire: 0.048 MB / 6.65 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Temps: 0.02 ms / 579.88 ms Mémoire: 0.002 MB / 6.66 MB Application: After Access::getAssetRules (id:8 name:com_content)
Temps: 3.15 ms / 583.02 ms Mémoire: 0.014 MB / 6.67 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Temps: 0.04 ms / 583.06 ms Mémoire: 0.007 MB / 6.68 MB Application: After Access::getAssetRules (id:1 name:root.1)
Temps: 4.02 ms / 587.08 ms Mémoire: 0.003 MB / 6.68 MB Application: afterDispatch
Temps: 7.98 ms / 595.06 ms Mémoire: 0.089 MB / 6.77 MB Application: beforeRenderModule mod_easyblogcalendar (Calendrier)
Temps: 79.41 ms / 674.47 ms Mémoire: 0.816 MB / 7.59 MB Application: afterRenderModule mod_easyblogcalendar (Calendrier)
Temps: 4.55 ms / 679.02 ms Mémoire: 0.019 MB / 7.60 MB Application: beforeRenderModule mod_custom (Partenaire carte collégien / e-Pass / Pass Sport)
Temps: 3.49 ms / 682.51 ms Mémoire: 0.007 MB / 7.61 MB Application: afterRenderModule mod_custom (Partenaire carte collégien / e-Pass / Pass Sport)
Temps: 11.05 ms / 693.56 ms Mémoire: -0.002 MB / 7.61 MB Application: beforeRenderModule mod_custom (Lieu de pratique)
Temps: 0.24 ms / 693.80 ms Mémoire: 0.003 MB / 7.61 MB Application: afterRenderModule mod_custom (Lieu de pratique)
Temps: 2.17 ms / 695.97 ms Mémoire: -0.001 MB / 7.61 MB Application: beforeRenderModule mod_custom (Adresse postale)
Temps: 0.17 ms / 696.13 ms Mémoire: 0.003 MB / 7.62 MB Application: afterRenderModule mod_custom (Adresse postale)
Temps: 1.63 ms / 697.76 ms Mémoire: 0.000 MB / 7.62 MB Application: beforeRenderModule mod_custom (Horaires des créneaux)
Temps: 0.17 ms / 697.93 ms Mémoire: 0.003 MB / 7.62 MB Application: afterRenderModule mod_custom (Horaires des créneaux)
Temps: 2.03 ms / 699.96 ms Mémoire: 0.005 MB / 7.62 MB Application: beforeRenderModule mod_easyblogshowcase (EasyBlog - Showcase Module)
Temps: 194.11 ms / 894.06 ms Mémoire: 1.660 MB / 9.28 MB Application: afterRenderModule mod_easyblogshowcase (EasyBlog - Showcase Module)
Temps: 2.16 ms / 896.22 ms Mémoire: -0.158 MB / 9.13 MB Application: beforeRenderModule mod_feed (Prochains Tournois badminton à proximité de Peypin)
Temps: 363.76 ms / 1259.99 ms Mémoire: 0.082 MB / 9.21 MB Application: afterRenderModule mod_feed (Prochains Tournois badminton à proximité de Peypin)
Temps: 0.54 ms / 1260.53 ms Mémoire: -0.013 MB / 9.19 MB Application: beforeRenderModule mod_eb_events (Events Booking - Upcoming events)
Temps: 82.39 ms / 1342.91 ms Mémoire: 0.455 MB / 9.65 MB Application: afterRenderModule mod_eb_events (Events Booking - Upcoming events)
Temps: 0.89 ms / 1343.80 ms Mémoire: -0.005 MB / 9.65 MB Application: beforeRenderModule mod_custom (Liens Accueil)
Temps: 0.18 ms / 1343.98 ms Mémoire: 0.005 MB / 9.65 MB Application: afterRenderModule mod_custom (Liens Accueil)
Temps: 1.40 ms / 1345.38 ms Mémoire: -0.001 MB / 9.65 MB Application: beforeRenderModule mod_custom (Renouvellement)
Temps: 0.16 ms / 1345.55 ms Mémoire: 0.003 MB / 9.65 MB Application: afterRenderModule mod_custom (Renouvellement)
Temps: 1.38 ms / 1346.93 ms Mémoire: -0.000 MB / 9.65 MB Application: beforeRenderModule mod_custom (Nouvelle inscription)
Temps: 0.18 ms / 1347.11 ms Mémoire: 0.003 MB / 9.66 MB Application: afterRenderModule mod_custom (Nouvelle inscription)
Temps: 2.04 ms / 1349.15 ms Mémoire: 0.004 MB / 9.66 MB Application: beforeRenderModule mod_menu (Main Menu)
Temps: 9.71 ms / 1358.86 ms Mémoire: 0.065 MB / 9.72 MB Application: afterRenderModule mod_menu (Main Menu)
Temps: 14.37 ms / 1373.23 ms Mémoire: 0.065 MB / 9.79 MB Application: afterRender
Total de requêtes base de données : 84.08 ms
10,41 MB (10 916 264 Bytes)
50 requêtes exécutées 84.08 ms
- Temps de requête : 0.95 ms Mémoire de requête : 0.021 MB mémoire avant requête : 0.901 MB Rangées retournées : 7
SELECT id, rules
FROM `r0bco13_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_viewlevels NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 7 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.98 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.021 MB mémoire avant requête : 0.914 MB Rangées retournées : 2
SELECT b.id
FROM r0bco13_usergroups AS a
LEFT JOIN r0bco13_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.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.02 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:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.78 ms Après la dernière requête : 5.06 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.406 MB Rangées retournées : 1
SELECT config_value
FROM r0bco13_hikashop_config
WHERE config_namekey = 'version'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_hikashop_config NULL const PRIMARY PRIMARY 602 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 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:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/hikamarketoverrides/hikamarketoverrides.php:33 8 plgSystemHikamarketoverrides->init() JROOT/plugins/system/hikamarketoverrides/hikamarketoverrides.php:17 7 plgSystemHikamarketoverrides->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.74 ms Après la dernière requête : 21.73 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.341 MB
UPDATE `r0bco13_extensions`
SET `params` = '{\"mediaversion\":\"fc106f8a7cb757572f756d5b3481af15\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE r0bco13_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.02 ms System lock 0.08 ms updating 0.07 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 1.03 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 15 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 14 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/administrator/components/com_hikashop/helpers/helper.php:3308 10 include_once JROOT/administrator/components/com_hikashop/helpers/helper.php JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:184 9 plgSystemHikashopgeolocation->process() JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:63 8 plgSystemHikashopgeolocation->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.14 ms Après la dernière requête : 0.91 ms Mémoire de requête : 0.046 MB mémoire avant requête : 2.355 MB Rangées retournées : 365
SELECT *
FROM r0bco13_hikashop_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_hikashop_config NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 365 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.49 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/config.php:16 12 hikashopConfigClass->load() JROOT/administrator/components/com_hikashop/helpers/helper.php:1333 11 hikashop_config() JROOT/administrator/components/com_hikashop/helpers/helper.php:3310 10 include_once JROOT/administrator/components/com_hikashop/helpers/helper.php JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:184 9 plgSystemHikashopgeolocation->process() JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:63 8 plgSystemHikashopgeolocation->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.69 ms Après la dernière requête : 6.69 ms Mémoire de requête : 0.021 MB mémoire avant requête : 3.568 MB Rangées retournées : 1
SELECT custom_data
FROM r0bco13_extensions
WHERE element = 'yooessentials'
AND folder = 'system'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_extensions NULL ref element_clientid,element_folder_clientid element_clientid 402 const 1 10.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 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 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/plugins/system/yooessentials/helper.php:152 9 plgSystemYooessentialsHelper::fetchConfig() JROOT/plugins/system/yooessentials/yooessentials.php:57 8 plgSystemYooessentials->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.86 ms Après la dernière requête : 4.66 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.258 MB Rangées retournées : 59
SELECT *
FROM r0bco13_rsform_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_rsform_config NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 59 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.14 ms end 0.01 ms query end 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php:52 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php:19 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php:104 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:34 8 plgSystemRsformdeletesubmissions->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.98 ms Après la dernière requête : 38.07 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.615 MB Rangées retournées : 47
SELECT `id`,`name`,`rules`,`parent_id`
FROM `r0bco13_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cookiesck','com_cpanel','com_easyblog','com_eventbooking','com_fields','com_finder','com_hikamarket','com_hikashop','com_installer','com_jce','com_jdonation','com_joomlaupdate','com_languages','com_login','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_rstbox','com_search','com_slideshowck','com_tags','com_templateck','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_assets NULL ALL idx_asset_name INDEX N'A PU ÊTRE UTILISÉ NULL NULL 164 29.27 Using where Status Duration starting 0.12 ms checking permissions 0.02 ms Opening tables 0.29 ms init 0.09 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.26 ms preparing 0.02 ms executing 0.01 ms Sending data 0.55 ms end 0.01 ms query end 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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 20 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 19 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 18 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 17 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 16 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 15 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.94 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.673 MB Rangées retournées : 16
SELECT `id`,`name`,`rules`,`parent_id`
FROM `r0bco13_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 r0bco13_assets NULL ALL idx_asset_name,idx_parent_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 164 25.33 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.26 ms end 0.01 ms query end 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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 20 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 19 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 18 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 17 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 16 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 15 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.83 ms Après la dernière requête : 3.71 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.709 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 r0bco13_content AS a
INNER JOIN r0bco13_categories AS c
on c.id = a.catid
LEFT JOIN r0bco13_users AS u
on u.id = a.created_by
LEFT JOIN r0bco13_categories as parent
ON parent.id = c.parent_id
LEFT JOIN r0bco13_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 3
AND c.published > 0
AND a.language in ('fr-FR','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-14 22:25:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-14 22:25:26')
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,idx_language 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.24 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.89 ms init 0.13 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.61 ms preparing 0.03 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.09 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.53 ms Après la dernière requête : 10.12 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.802 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 `r0bco13_categories` AS `s`
INNER JOIN `r0bco13_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('fr-FR','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,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 Utilisation du tri complet de type filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right,idx_language INDEX N'A PU ÊTRE UTILISÉ NULL NULL 11 9.09 Using where Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.09 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.19 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.07 ms Creating sort index 0.14 ms end 0.01 ms query end 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 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/components/com_content/views/article/view.html.php:71 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.68 ms Après la dernière requête : 5.74 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.834 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `r0bco13_contentitem_tag_map` AS m
INNER JOIN `r0bco13_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 badmintotebcp13.m.tag_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.51 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.31 ms end 0.01 ms query end 0.01 ms closing tables 0.06 ms freeing items 0.09 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 4.42 ms Après la dernière requête : 49.61 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.019 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 r0bco13_fields AS a
LEFT JOIN `r0bco13_languages` AS l
ON l.lang_code = a.language
LEFT JOIN r0bco13_users AS uc
ON uc.id=a.checked_out
LEFT JOIN r0bco13_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN r0bco13_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN r0bco13_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `r0bco13_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 index condition; Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 badmintotebcp13.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 badmintotebcp13.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.22 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.83 ms init 0.12 ms System lock 0.02 ms optimizing 0.09 ms statistics 0.60 ms preparing 0.06 ms Creating tmp table 0.08 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.45 ms Creating sort index 0.06 ms end 0.01 ms query end 0.02 ms removing tmp table 0.05 ms query end 0.01 ms closing tables 0.11 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.10 ms Après la dernière requête : 284.52 ms Mémoire de requête : 0.054 MB mémoire avant requête : 6.415 MB Rangées retournées : 1
SELECT custom_data
FROM r0bco13_extensions
WHERE element = 'yooessentials'
AND folder = 'system'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_extensions NULL ref element_clientid,element_folder_clientid element_clientid 402 const 1 10.00 Using where Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.11 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 82 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 81 JDatabaseDriver->loadAssoc() JROOT/plugins/system/yooessentials/modules/core-joomla/src/Database.php:54 80 ZOOlanders\YOOessentials\Joomla\Database->fetchAssoc() JROOT/plugins/system/yooessentials/modules/core-joomla/src/ConfigRepository.php:52 79 ZOOlanders\YOOessentials\Joomla\ConfigRepository->load() JROOT/plugins/system/yooessentials/modules/core/src/Config.php:24 78 ZOOlanders\YOOessentials\Config->__construct() Même appel que celui de la ligne ci-dessous. 77 ReflectionClass->newInstanceArgs() JROOT/templates/yootheme/packages/container/src/Container/Service.php:184 76 YOOtheme\Container\Service->resolveClass() JROOT/templates/yootheme/packages/container/src/Container/Service.php:156 75 YOOtheme\Container\Service->resolveInstance() JROOT/templates/yootheme/packages/container/src/Container.php:343 74 YOOtheme\Container->resolveService() JROOT/templates/yootheme/packages/application/src/Application.php:146 73 YOOtheme\Application->YOOtheme\{closure}() JROOT/templates/yootheme/packages/utils/src/HookCollection.php:124 72 YOOtheme\HookCollection->YOOtheme\{closure}() JROOT/templates/yootheme/packages/utils/src/HookCollection.php:30 71 YOOtheme\HookCollection->call() JROOT/templates/yootheme/packages/utils/src/Hook.php:17 70 YOOtheme\Hook::call() JROOT/templates/yootheme/packages/application/src/Application.php:146 69 YOOtheme\Application->resolveService() JROOT/templates/yootheme/packages/container/src/Container.php:315 68 YOOtheme\Container->resolve() JROOT/templates/yootheme/packages/container/src/Container.php:91 67 YOOtheme\Container->get() JROOT/templates/yootheme/packages/container/src/Container.php:51 66 YOOtheme\Container->__invoke() JROOT/templates/yootheme/packages/application/functions.php:24 65 YOOtheme\app() JROOT/plugins/system/yooessentials/modules/dynamic/src/DynamicResolver.php:27 64 ZOOlanders\YOOessentials\Dynamic\DynamicResolver->__construct() Même appel que celui de la ligne ci-dessous. 63 ReflectionClass->newInstanceArgs() JROOT/templates/yootheme/packages/container/src/Container/Service.php:184 62 YOOtheme\Container\Service->resolveClass() JROOT/templates/yootheme/packages/container/src/Container/Service.php:156 61 YOOtheme\Container\Service->resolveInstance() JROOT/templates/yootheme/packages/container/src/Container.php:343 60 YOOtheme\Container->resolveService() JROOT/templates/yootheme/packages/application/src/Application.php:146 59 YOOtheme\Application->YOOtheme\{closure}() JROOT/templates/yootheme/packages/utils/src/HookCollection.php:124 58 YOOtheme\HookCollection->YOOtheme\{closure}() JROOT/templates/yootheme/packages/utils/src/HookCollection.php:30 57 YOOtheme\HookCollection->call() JROOT/templates/yootheme/packages/utils/src/Hook.php:17 56 YOOtheme\Hook::call() JROOT/templates/yootheme/packages/application/src/Application.php:146 55 YOOtheme\Application->resolveService() JROOT/templates/yootheme/packages/container/src/Container.php:315 54 YOOtheme\Container->resolve() JROOT/templates/yootheme/packages/container/src/Container.php:91 53 YOOtheme\Container->get() JROOT/templates/yootheme/packages/container/src/Container/ParameterResolver.php:84 52 YOOtheme\Container\ParameterResolver->resolveDependencies() JROOT/templates/yootheme/packages/container/src/Container/ParameterResolver.php:33 51 YOOtheme\Container\ParameterResolver->resolve() JROOT/templates/yootheme/packages/container/src/Container/Service.php:182 50 YOOtheme\Container\Service->resolveClass() JROOT/templates/yootheme/packages/container/src/Container/Service.php:156 49 YOOtheme\Container\Service->resolveInstance() JROOT/templates/yootheme/packages/container/src/Container.php:343 48 YOOtheme\Container->resolveService() JROOT/templates/yootheme/packages/application/src/Application.php:146 47 YOOtheme\Application->YOOtheme\{closure}() JROOT/templates/yootheme/packages/utils/src/HookCollection.php:124 46 YOOtheme\HookCollection->YOOtheme\{closure}() JROOT/templates/yootheme/packages/utils/src/HookCollection.php:30 45 YOOtheme\HookCollection->call() JROOT/templates/yootheme/packages/utils/src/Hook.php:17 44 YOOtheme\Hook::call() JROOT/templates/yootheme/packages/application/src/Application.php:146 43 YOOtheme\Application->resolveService() JROOT/templates/yootheme/packages/container/src/Container.php:315 42 YOOtheme\Container->resolve() JROOT/templates/yootheme/packages/container/src/Container.php:91 41 YOOtheme\Container->get() JROOT/templates/yootheme/packages/container/src/Container.php:51 40 YOOtheme\Container->__invoke() JROOT/plugins/system/yooessentials/modules/dynamic/bootstrap.php:29 39 YOOtheme\Application::ZOOlanders\YOOessentials\Dynamic\{closure}() JROOT/templates/yootheme/packages/container/src/Container.php:348 38 YOOtheme\Container->resolveService() JROOT/templates/yootheme/packages/application/src/Application.php:146 37 YOOtheme\Application->YOOtheme\{closure}() JROOT/templates/yootheme/packages/utils/src/HookCollection.php:124 36 YOOtheme\HookCollection->YOOtheme\{closure}() JROOT/templates/yootheme/packages/utils/src/HookCollection.php:30 35 YOOtheme\HookCollection->call() JROOT/templates/yootheme/packages/utils/src/Hook.php:17 34 YOOtheme\Hook::call() JROOT/templates/yootheme/packages/application/src/Application.php:146 33 YOOtheme\Application->resolveService() JROOT/templates/yootheme/packages/container/src/Container.php:315 32 YOOtheme\Container->resolve() JROOT/templates/yootheme/packages/container/src/Container.php:91 31 YOOtheme\Container->get() JROOT/templates/yootheme/packages/container/src/Container/ParameterResolver.php:84 30 YOOtheme\Container\ParameterResolver->resolveDependencies() JROOT/templates/yootheme/packages/container/src/Container/ParameterResolver.php:33 29 YOOtheme\Container\ParameterResolver->resolve() JROOT/templates/yootheme/packages/container/src/Container/Service.php:182 28 YOOtheme\Container\Service->resolveClass() JROOT/templates/yootheme/packages/container/src/Container/Service.php:156 27 YOOtheme\Container\Service->resolveInstance() JROOT/templates/yootheme/packages/container/src/Container.php:343 26 YOOtheme\Container->resolveService() JROOT/templates/yootheme/packages/application/src/Application.php:146 25 YOOtheme\Application->YOOtheme\{closure}() JROOT/templates/yootheme/packages/utils/src/HookCollection.php:124 24 YOOtheme\HookCollection->YOOtheme\{closure}() JROOT/templates/yootheme/packages/utils/src/HookCollection.php:30 23 YOOtheme\HookCollection->call() JROOT/templates/yootheme/packages/utils/src/Hook.php:17 22 YOOtheme\Hook::call() JROOT/templates/yootheme/packages/application/src/Application.php:146 21 YOOtheme\Application->resolveService() JROOT/templates/yootheme/packages/container/src/Container.php:315 20 YOOtheme\Container->resolve() JROOT/templates/yootheme/packages/container/src/Container.php:91 19 YOOtheme\Container->get() JROOT/templates/yootheme/packages/container/src/Container.php:230 18 YOOtheme\Container->callback() JROOT/templates/yootheme/packages/container/src/Container.php:252 17 YOOtheme\Container->call() JROOT/templates/yootheme/packages/application/src/Application/EventLoader.php:59 16 YOOtheme\Application\EventLoader->YOOtheme\Application\{closure}() JROOT/templates/yootheme/packages/utils/src/EventDispatcher.php:115 15 YOOtheme\EventDispatcher->handleDefault() JROOT/templates/yootheme/packages/utils/src/EventDispatcher.php:45 14 YOOtheme\EventDispatcher->dispatch() JROOT/templates/yootheme/packages/platform-joomla/src/Dispatcher.php:66 13 YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}() JROOT/libraries/joomla/event/dispatcher.php:165 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 3.37 ms Après la dernière requête : 73.68 ms Mémoire de requête : 0.042 MB mémoire avant requête : 6.552 MB Rangées retournées : 15
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM r0bco13_modules AS m
LEFT JOIN r0bco13_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN r0bco13_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-05-14 22:25:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-14 22:25:26')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
AND m.language IN ('fr-FR','*')
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds,idx_language published 5 NULL 21 1.60 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 badmintotebcp13.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 badmintotebcp13.m.id 1 40.00 Using where; Using index Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.46 ms init 0.09 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.38 ms preparing 0.06 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.53 ms end 0.02 ms query end 0.02 ms closing tables 0.06 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() Même appel que celui de la ligne ci-dessous. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 18 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 17 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:670 16 Joomla\CMS\Helper\ModuleHelper::getModuleById() JROOT/plugins/content/loadmodule/loadmodule.php:237 15 PlgContentLoadmodule->_loadid() JROOT/plugins/content/loadmodule/loadmodule.php:141 14 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.31 ms Après la dernière requête : 31.60 ms Mémoire de requête : 0.020 MB mémoire avant requête : 6.646 MB Rangées retournées : 1
SELECT language,id
FROM `r0bco13_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 77 1.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.32 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.31 ms end 0.01 ms query end 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 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 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.88 ms Après la dernière requête : 2.48 ms Mémoire de requête : 0.021 MB mémoire avant requête : 6.663 MB Rangées retournées : 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `r0bco13_content` AS `c`
INNER JOIN `r0bco13_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `r0bco13_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `r0bco13_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `r0bco13_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 3
AND c2.access IN (1,1,5)
AND c2.language != 'fr-FR'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2024-05-14 22:25:26')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2024-05-14 22:25:26')
AND c2.state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL no matching row in const table Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.79 ms init 0.09 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.21 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.05 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:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_content/helpers/association.php:76 8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:783 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.94 ms Après la dernière requête : 1.21 ms Mémoire de requête : 0.020 MB mémoire avant requête : 6.672 MB Rangées retournées : 0
SELECT `id`
FROM `r0bco13_rstbox`
WHERE `published` = 1
AND `testmode` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_rstbox NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 14 7.14 Using where Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.24 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 9 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:41 8 EngageBox\Boxes::render() JROOT/plugins/system/rstbox/rstbox.php:78 7 PlgSystemRstBox->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 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.42 ms Après la dernière requête : 23.20 ms Mémoire de requête : 0.086 MB mémoire avant requête : 6.917 MB Rangées retournées : 1
SELECT *
FROM r0bco13_easyblog_configs
WHERE `name` = 'config'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_easyblog_configs NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 3 33.33 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.03 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.21 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 15 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_easyblog/includes/easyblog.php:536 14 EB::config() JROOT/administrator/components/com_easyblog/includes/utils.php:51 13 EasyBlog->__construct() JROOT/administrator/components/com_easyblog/includes/modules/modules.php:33 12 EasyBlogModules->__construct() JROOT/administrator/components/com_easyblog/includes/easyblog.php:469 11 EB::modules() JROOT/modules/mod_easyblogcalendar/mod_easyblogcalendar.php:29 10 include JROOT/modules/mod_easyblogcalendar/mod_easyblogcalendar.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 : 6.91 ms Après la dernière requête : 110.80 ms Mémoire de requête : 0.291 MB mémoire avant requête : 7.733 MB Rangées retournées : 5
SELECT a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured`
FROM `r0bco13_easyblog_post` AS a
INNER JOIN `r0bco13_users` AS uu
ON a.`created_by` = uu.`id`
and uu.`block` = 0
LEFT JOIN `r0bco13_easyblog_featured` AS f
ON a.`id` = f.`content_id`
AND f.`type` = 'post'
WHERE a.`published`='1'
AND a.`state`='0'
AND a.`access` = '0'
AND (`a`.`language`='fr-FR' OR `a`.`language`='' OR `a`.`language`='*')
AND a.`blogpassword` = ""
AND ( NOT EXISTS ( select acp.post_id
from `r0bco13_easyblog_post_category` as acp
inner join `r0bco13_easyblog_category` as cat
on acp.`category_id` = cat.`id`
where acp.`post_id` = a.`id`
and ( ( cat.`private` = 1
and (0 = 0) ) OR ( cat.`private` = 2
and (select count(1)
from `r0bco13_easyblog_category_acl` as cacl
where cacl.`category_id` = cat.`id`
and cacl.`acl_id` = 1
and cacl.`content_id` IN (9)) = 0 ) )))
AND ((a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team'
and 1 <= (select count(1)
from `r0bco13_easyblog_team` as srcteam
where srcteam.`id` = a.`source_id`
and srcteam.`published` = 1
and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2
and (select count(1)
from `r0bco13_easyblog_team_groups` as srcteamgrp
where srcteamgrp.`team_id` = srcteam.`id`
and srcteamgrp.`group_id` IN (9) ) > 0)))))
ORDER BY a.`created` desc
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL range easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_post_searchnew,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1,idx_latest_posts easyblog_post_searchnew 5 NULL 68 1.39 Using index condition; Using where 1 PRIMARY uu NULL eq_ref PRIMARY,idx_block PRIMARY 4 badmintotebcp13.a.created_by 1 85.00 Using where 1 PRIMARY f NULL ref easyblog_featured_content_type,easyblog_content easyblog_featured_content_type 774 badmintotebcp13.a.id,const 1 100.00 Using where 4 DEPENDENT SUBQUERY srcteam NULL eq_ref PRIMARY,idx_viewable_team,idx_published,idx_access PRIMARY 4 badmintotebcp13.a.source_id 1 100.00 Using where 5 DEPENDENT SUBQUERY srcteamgrp NULL ref team_id,group_id,idx_team_group team_id 4 badmintotebcp13.srcteam.id 1 100.00 Using where 2 DEPENDENT SUBQUERY acp NULL ref eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post eb_post_category_post_cat 4 badmintotebcp13.a.id 1 100.00 Using where; Using index 2 DEPENDENT SUBQUERY cat NULL eq_ref PRIMARY,easyblog_cat_private PRIMARY 8 badmintotebcp13.acp.category_id 1 66.67 Using where 3 DEPENDENT SUBQUERY cacl NULL ref easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type,idx_cat_post_acl easyblog_category_acl 8 badmintotebcp13.cat.id 1 100.00 Using index condition; Using where Status Duration starting 0.33 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.80 ms init 0.17 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.85 ms preparing 0.12 ms Sorting result 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms optimizing 0.03 ms statistics 0.37 ms preparing 0.04 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.03 ms Sending data 0.11 ms executing 0.01 ms Sending data 0.52 ms executing 0.01 ms Sending data 1.03 ms executing 0.01 ms Sending data 0.07 ms executing 0.01 ms Sending data 0.05 ms executing 0.01 ms Sending data 0.12 ms end 0.01 ms query end 0.02 ms closing tables 0.13 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 16 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/blog.php:1179 15 EasyBlogModelBlog->getBlogsBy() JROOT/modules/mod_easyblogshowcase/helper.php:100 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.47 ms Après la dernière requête : 24.89 ms Mémoire de requête : 0.026 MB mémoire avant requête : 8.112 MB Rangées retournées : 0
SELECT COUNT(1) as `voted`, `uid`
FROM `r0bco13_easyblog_ratings`
WHERE `uid` IN (114,112,109,111,108)
AND `type`='entry'
AND `created_by`='0'
AND (`sessionid` = '4984ec0c144e40ec527acf4b1b68e7a5' OR `ip` = '13.58.118.119')
GROUP BY `uid`
ORDER BY NULLid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_easyblog_ratings NULL ref post_id,created_by,idx_uid_type,idx_uid_type_user,idx_uid_type_user_session,idx_uid_type_user_ipaddr created_by 4 const 1 100.00 Using index condition; Using where; Using temporary Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.37 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.20 ms preparing 0.04 ms Creating tmp table 0.04 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms removing tmp table 0.02 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 21 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/ratings.php:135 20 EasyBlogModelRatings->preloadUserPostRatings() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:452 19 EasyBlogCache->cacheVoted() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:357 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.90 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.026 MB mémoire avant requête : 8.123 MB Rangées retournées : 0
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid`
FROM `r0bco13_easyblog_ratings` AS a
WHERE a.`uid` IN(114,112,109,111,108)
AND `type`='entry'
GROUP BY `uid`
ORDER BY NULLid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index post_id,idx_uid_type,idx_uid_type_user,idx_uid_type_user_ipaddr post_id 4 NULL 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 21 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/ratings.php:176 20 EasyBlogModelRatings->preloadRatings() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:583 19 EasyBlogCache->cacheRatings() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:362 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.54 ms Après la dernière requête : 4.97 ms Mémoire de requête : 0.026 MB mémoire avant requête : 8.203 MB Rangées retournées : 0
SELECT a.*
FROM `r0bco13_easyblog_comment` AS a
LEFT JOIN `r0bco13_users` AS uu
ON a.`created_by` = uu.`id`
WHERE a.`post_id` IN(114,112,109,111,108)
AND a.`published`='1'
AND (uu.`block` = 0 OR uu.`id` IS NULL)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL easyblog_comment_postid,idx_comment_post_items INDEX N'A PU ÊTRE UTILISÉ NULL NULL 3 33.33 Using where 1 SIMPLE uu NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.a.created_by 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.35 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.07 ms executing 0.01 ms Sending data 0.09 ms end 0.02 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.11 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 21 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/comment.php:580 20 EasyBlogModelComment->preloadComments() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:615 19 EasyBlogCache->cacheComments() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:367 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.33 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.026 MB mémoire avant requête : 8.214 MB Rangées retournées : 0
SELECT a.`post_id`, COUNT(1) AS `count`
FROM `r0bco13_easyblog_comment` AS a
LEFT JOIN `r0bco13_users` AS uu
ON a.`created_by` = uu.`id`
WHERE a.`post_id` IN(114,112,109,111,108)
AND a.`published`='1'
AND (uu.`block` = 0 OR uu.`id` IS NULL)
GROUP BY a.`post_id`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL easyblog_comment_postid,idx_comment_post_items INDEX N'A PU ÊTRE UTILISÉ NULL NULL 3 33.33 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE uu NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.a.created_by 1 100.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.05 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.02 ms query end 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 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 21 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/comment.php:627 20 EasyBlogModelComment->preloadCommentCount() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:641 19 EasyBlogCache->cacheCommentCount() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:372 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.30 ms Après la dernière requête : 5.02 ms Mémoire de requête : 0.026 MB mémoire avant requête : 8.229 MB Rangées retournées : 5
select a.*, b.`post_id`, b.`primary`
from `r0bco13_easyblog_category` as a
inner join `r0bco13_easyblog_post_category` as b
on a.`id` = b.`category_id`
where b.`post_id` IN (114,112,109,111,108)
order by a.`lft` ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL range eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post eb_post_category_postid 4 NULL 5 100.00 Using index condition; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE a NULL ALL PRIMARY INDEX N'A PU ÊTRE UTILISÉ NULL NULL 3 33.33 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.07 ms checking permissions 0.03 ms checking permissions 0.01 ms Opening tables 0.56 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.03 ms Creating tmp table 0.07 ms Sorting result 0.03 ms executing 0.01 ms Sending data 0.36 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms removing tmp table 0.12 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 21 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/category.php:1972 20 EasyBlogModelCategory->preloadByPosts() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:728 19 EasyBlogCache->cacheCategories() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:377 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.43 ms Après la dernière requête : 6.89 ms Mémoire de requête : 0.026 MB mémoire avant requête : 8.334 MB Rangées retournées : 0
select a.*, b.`post_id`
from `r0bco13_easyblog_tag` as a
inner join `r0bco13_easyblog_post_tag` as b
on a.`id` = b.`tag_id`
where b.`post_id` IN (114,112,109,111,108)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL index easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id easyblog_post_tagpost_id 16 NULL 2 100.00 Using where; Using index 1 SIMPLE a NULL ALL PRIMARY INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 50.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.51 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 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 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 21 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/tags.php:929 20 EasyBlogModelTags->preloadByPosts() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:810 19 EasyBlogCache->cacheTags() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:382 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.13 ms Après la dernière requête : 2.77 ms Mémoire de requête : 0.214 MB mémoire avant requête : 8.388 MB Rangées retournées : 5
select a.*
from `r0bco13_easyblog_revisions` as a
where a.`id` IN ( 460,457,445,447,444)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL range PRIMARY PRIMARY 8 NULL 5 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.31 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms Sending data 0.37 ms end 0.01 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 21 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/revisions.php:624 20 EasyBlogModelRevisions->preload() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:704 19 EasyBlogCache->cacheRevisions() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.91 ms Après la dernière requête : 10.04 ms Mémoire de requête : 0.028 MB mémoire avant requête : 8.585 MB Rangées retournées : 1
select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering`
from `r0bco13_users` as u
left join `r0bco13_easyblog_users` as e
ON u.`id` = e.`id`
where u.`id` = 793id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE e NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL Status Duration starting 0.20 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.76 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.04 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.06 ms freeing items 0.10 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/administrator/components/com_easyblog/includes/utils.php:296 24 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/users.php:298 23 EasyBlogModelUsers->getUsersMeta() JROOT/administrator/components/com_easyblog/includes/user/user.php:139 22 EasyBlogUser::loadUsers() JROOT/administrator/components/com_easyblog/includes/user/user.php:36 21 EasyBlogUser::factory() JROOT/administrator/components/com_easyblog/includes/easyblog.php:1083 20 EB::user() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:791 19 EasyBlogCache->cacheAuthors() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:392 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.74 ms Après la dernière requête : 4.78 ms Mémoire de requête : 0.032 MB mémoire avant requête : 8.604 MB Rangées retournées : 17
SHOW FULL COLUMNS
FROM `r0bco13_users`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `r0bco13_users`Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.24 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.03 ms Opening tables 0.03 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.07 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 34 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 33 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 32 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 31 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 30 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 29 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 28 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 27 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 26 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 25 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 24 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 23 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_easyblog/includes/user/user.php:186 22 EasyBlogUser::loadUsers() JROOT/administrator/components/com_easyblog/includes/user/user.php:36 21 EasyBlogUser::factory() JROOT/administrator/components/com_easyblog/includes/easyblog.php:1083 20 EB::user() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:791 19 EasyBlogCache->cacheAuthors() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:392 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.92 ms Après la dernière requête : 0.56 ms Mémoire de requête : 0.029 MB mémoire avant requête : 8.640 MB Rangées retournées : 1
SELECT *
FROM `r0bco13_users`
WHERE `id` = 793id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.04 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.02 ms query end 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 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 28 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 27 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 26 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 25 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 24 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 23 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_easyblog/includes/user/user.php:186 22 EasyBlogUser::loadUsers() JROOT/administrator/components/com_easyblog/includes/user/user.php:36 21 EasyBlogUser::factory() JROOT/administrator/components/com_easyblog/includes/easyblog.php:1083 20 EB::user() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:791 19 EasyBlogCache->cacheAuthors() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:392 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.33 ms Après la dernière requête : 7.52 ms Mémoire de requête : 0.028 MB mémoire avant requête : 8.656 MB Rangées retournées : 3
SELECT `g`.`id`,`g`.`title`
FROM `r0bco13_usergroups` AS g
INNER JOIN `r0bco13_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 793id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 3 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.m.group_id 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.45 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.06 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 28 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 27 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 26 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 25 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 24 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 23 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_easyblog/includes/user/user.php:186 22 EasyBlogUser::loadUsers() JROOT/administrator/components/com_easyblog/includes/user/user.php:36 21 EasyBlogUser::factory() JROOT/administrator/components/com_easyblog/includes/easyblog.php:1083 20 EB::user() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:791 19 EasyBlogCache->cacheAuthors() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:392 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.50 ms Après la dernière requête : 2.54 ms Mémoire de requête : 0.027 MB mémoire avant requête : 8.671 MB Rangées retournées : 0
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value`
from `r0bco13_easyblog_category_fields_groups` as a
inner join `r0bco13_easyblog_post_category` as p
on `a`.`category_id` = `p`.`category_id`
inner join `r0bco13_easyblog_fields_groups` as fg
on `a`.`group_id` = `fg`.`id`
inner join `r0bco13_easyblog_fields` as f
on `fg`.`id` = `f`.`group_id`
left join `r0bco13_easyblog_fields_values` as fv
on `fv`.`field_id` = `f`.`id`
and `fv`.`post_id` = `p`.`post_id`
LEFT JOIN `r0bco13_easyblog_fields_groups_acl` AS acl
ON fg.`id` = acl.`group_id`
where p.post_id IN (114,112,109,111,108)
AND ( acl.`acl_id` IN(9)
AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index category_id,cat_id category_id 8 NULL 1 100.00 Using index 1 SIMPLE fg NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.a.group_id 1 100.00 NULL 1 SIMPLE f NULL ref group_id,idx_group_ordering group_id 4 badmintotebcp13.a.group_id 1 100.00 NULL 1 SIMPLE p NULL range eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post eb_post_category_post_cat 4 NULL 5 33.33 Using where; Using index; Using join buffer (Block Nested Loop) 1 SIMPLE fv NULL ALL field_id,post_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE acl NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.00 ms init 0.09 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.20 ms preparing 0.16 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.02 ms closing tables 0.12 ms freeing items 0.09 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 21 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/fields.php:305 20 EasyBlogModelFields->preloadFields() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:489 19 EasyBlogCache->cacheFields() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:397 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.44 ms Après la dernière requête : 1.80 ms Mémoire de requête : 0.027 MB mémoire avant requête : 8.753 MB Rangées retournées : 5
select *
from `r0bco13_easyblog_meta`
where `content_id` in (114,112,109,111,108)
and `type` = 'post'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_easyblog_meta NULL range idx_meta_content_type idx_meta_content_type 86 NULL 5 100.00 Using index condition Status Duration starting 0.07 ms checking permissions 0.04 ms Opening tables 0.27 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.28 ms preparing 0.03 ms executing 0.01 ms Sending data 0.16 ms end 0.01 ms query end 0.02 ms closing tables 0.11 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 21 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/metas.php:386 20 EasyBlogModelMetas->preloadPostMetas() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:418 19 EasyBlogCache->cacheMetas() JROOT/administrator/components/com_easyblog/includes/cache/cache.php:402 18 EasyBlogCache->insert() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.26 ms Après la dernière requête : 3.08 ms Mémoire de requête : 0.028 MB mémoire avant requête : 8.787 MB Rangées retournées : 51
SELECT *
FROM `r0bco13_easyblog_acl`
WHERE `published`='1'
ORDER BY `id` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_easyblog_acl NULL index idx_acl_published,idx_acl_published_id PRIMARY 8 NULL 51 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.23 ms end 0.01 ms query end 0.04 ms closing tables 0.03 ms freeing items 0.08 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/administrator/components/com_easyblog/includes/utils.php:296 23 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/includes/acl/acl.php:329 22 EasyBlogAcl::getRules() JROOT/administrator/components/com_easyblog/includes/acl/acl.php:36 21 EasyBlogAcl::getRuleSet() JROOT/administrator/components/com_easyblog/includes/easyblog.php:298 20 EB::acl() JROOT/administrator/components/com_easyblog/includes/post/post.php:245 19 EasyBlogPost->__construct() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3574 18 EB::post() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:50 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.51 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.029 MB mémoire avant requête : 8.830 MB Rangées retournées : 102
SELECT *
FROM `r0bco13_easyblog_acl_group`
WHERE `content_id` IN (1, 9)
AND `type`='
group'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_easyblog_acl_group NULL ALL easyblog_post_acl_content_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 561 18.18 Using where Status Duration starting 0.05 ms checking permissions 0.03 ms Opening tables 0.23 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.43 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.07 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/administrator/components/com_easyblog/includes/utils.php:296 23 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/includes/acl/acl.php:151 22 EasyBlogAcl::getEasyBlogAclGroups() JROOT/administrator/components/com_easyblog/includes/acl/acl.php:98 21 EasyBlogAcl::getRuleSet() JROOT/administrator/components/com_easyblog/includes/easyblog.php:298 20 EB::acl() JROOT/administrator/components/com_easyblog/includes/post/post.php:245 19 EasyBlogPost->__construct() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3574 18 EB::post() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:50 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.16 ms Après la dernière requête : 2.74 ms Mémoire de requête : 0.026 MB mémoire avant requête : 8.918 MB Rangées retournées : 0
SELECT a.`id`, a.`title`, a.`alias`
FROM `r0bco13_easyblog_tag` AS a
LEFT JOIN `r0bco13_easyblog_post_tag` AS b
ON a.`id`= b.`tag_id`
WHERE b.`post_id`='114'
AND b.`isrevision` IS NULL
AND a.`published`='1'
ORDER BY b.`id` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL ref easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id easyblog_post_tag_post_id 8 const 1 50.00 Using index condition; Using where 1 SIMPLE a NULL eq_ref PRIMARY,easyblog_tag_published,easyblog_tag_query1 PRIMARY 8 badmintotebcp13.b.tag_id 1 100.00 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.35 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 20 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/posttag.php:59 19 EasyBlogModelPostTag->getBlogTags() JROOT/administrator/components/com_easyblog/includes/post/post.php:7790 18 EasyBlogPost->getTags() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:107 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.93 ms Après la dernière requête : 1.81 ms Mémoire de requête : 0.026 MB mémoire avant requête : 9.024 MB Rangées retournées : 0
SELECT a.`id`, a.`title`, a.`alias`
FROM `r0bco13_easyblog_tag` AS a
LEFT JOIN `r0bco13_easyblog_post_tag` AS b
ON a.`id`= b.`tag_id`
WHERE b.`post_id`='112'
AND b.`isrevision` IS NULL
AND a.`published`='1'
ORDER BY b.`id` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL ref easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id easyblog_post_tag_post_id 8 const 1 50.00 Using index condition; Using where 1 SIMPLE a NULL eq_ref PRIMARY,easyblog_tag_published,easyblog_tag_query1 PRIMARY 8 badmintotebcp13.b.tag_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 20 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/posttag.php:59 19 EasyBlogModelPostTag->getBlogTags() JROOT/administrator/components/com_easyblog/includes/post/post.php:7790 18 EasyBlogPost->getTags() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:107 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.96 ms Après la dernière requête : 0.61 ms Mémoire de requête : 0.026 MB mémoire avant requête : 9.051 MB Rangées retournées : 0
SELECT a.`id`, a.`title`, a.`alias`
FROM `r0bco13_easyblog_tag` AS a
LEFT JOIN `r0bco13_easyblog_post_tag` AS b
ON a.`id`= b.`tag_id`
WHERE b.`post_id`='109'
AND b.`isrevision` IS NULL
AND a.`published`='1'
ORDER BY b.`id` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL ref easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id easyblog_post_tag_post_id 8 const 1 50.00 Using index condition; Using where 1 SIMPLE a NULL eq_ref PRIMARY,easyblog_tag_published,easyblog_tag_query1 PRIMARY 8 badmintotebcp13.b.tag_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 20 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/posttag.php:59 19 EasyBlogModelPostTag->getBlogTags() JROOT/administrator/components/com_easyblog/includes/post/post.php:7790 18 EasyBlogPost->getTags() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:107 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.87 ms Après la dernière requête : 0.49 ms Mémoire de requête : 0.026 MB mémoire avant requête : 9.077 MB Rangées retournées : 0
SELECT a.`id`, a.`title`, a.`alias`
FROM `r0bco13_easyblog_tag` AS a
LEFT JOIN `r0bco13_easyblog_post_tag` AS b
ON a.`id`= b.`tag_id`
WHERE b.`post_id`='111'
AND b.`isrevision` IS NULL
AND a.`published`='1'
ORDER BY b.`id` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL ref easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id easyblog_post_tag_post_id 8 const 1 50.00 Using index condition; Using where 1 SIMPLE a NULL eq_ref PRIMARY,easyblog_tag_published,easyblog_tag_query1 PRIMARY 8 badmintotebcp13.b.tag_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 20 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/posttag.php:59 19 EasyBlogModelPostTag->getBlogTags() JROOT/administrator/components/com_easyblog/includes/post/post.php:7790 18 EasyBlogPost->getTags() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:107 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.80 ms Après la dernière requête : 9.14 ms Mémoire de requête : 0.026 MB mémoire avant requête : 9.179 MB Rangées retournées : 0
SELECT a.`id`, a.`title`, a.`alias`
FROM `r0bco13_easyblog_tag` AS a
LEFT JOIN `r0bco13_easyblog_post_tag` AS b
ON a.`id`= b.`tag_id`
WHERE b.`post_id`='108'
AND b.`isrevision` IS NULL
AND a.`published`='1'
ORDER BY b.`id` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL ref easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id easyblog_post_tag_post_id 8 const 1 50.00 Using index condition; Using where 1 SIMPLE a NULL eq_ref PRIMARY,easyblog_tag_published,easyblog_tag_query1 PRIMARY 8 badmintotebcp13.b.tag_id 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.03 ms Opening tables 0.02 ms init 0.04 ms System lock 0.04 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 20 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/posttag.php:59 19 EasyBlogModelPostTag->getBlogTags() JROOT/administrator/components/com_easyblog/includes/post/post.php:7790 18 EasyBlogPost->getTags() JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:107 17 EasyBlogFormatterList->execute() JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55 16 EasyBlogFormatter->execute() JROOT/administrator/components/com_easyblog/includes/easyblog.php:3462 15 EB::formatter() JROOT/modules/mod_easyblogshowcase/helper.php:113 14 modEasyBlogShowcaseHelper->getPosts() JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:34 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.91 ms Après la dernière requête : 43.13 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.283 MB Rangées retournées : 1
SELECT *
FROM `r0bco13_menu`
WHERE `published`='1'
AND `link` LIKE 'index.php?option=com_easyblog%'
AND `client_id` = '0'
ORDER BY `id`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 77 1.11 Using index condition; Using where; Utilisation du tri complet de type filesort Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.40 ms init 0.06 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.04 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.60 ms end 0.02 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_easyblog/includes/utils.php:296 24 EasyBlogDbJoomla->__call() JROOT/administrator/components/com_easyblog/models/menu.php:64 23 EasyBlogModelMenu->getAssociatedMenus() JROOT/administrator/components/com_easyblog/includes/router.php:97 22 EBR::getMenus() JROOT/administrator/components/com_easyblog/includes/router.php:530 21 EBR::_() JROOT/administrator/components/com_easyblog/includes/post/post.php:6807 20 EasyBlogPost->getPermalink() JROOT/components/com_easyblog/themes/wireframe/helpers/featured/slider/magazine.php:26 19 include JROOT/components/com_easyblog/themes/wireframe/helpers/featured/slider/magazine.php JROOT/administrator/components/com_easyblog/includes/themes/themes.php:468 18 EasyBlogThemes->output() JROOT/administrator/components/com_easyblog/includes/themes/helpers/featured.php:124 17 EasyBlogThemesHelperFeatured->slider() JROOT/administrator/components/com_easyblog/includes/themes/themes.php:430 16 EasyBlogThemes->html() JROOT/administrator/components/com_easyblog/includes/modules/modules.php:71 15 EasyBlogModules->html() JROOT/modules/mod_easyblogshowcase/tmpl/magazine.php:39 14 require JROOT/modules/mod_easyblogshowcase/tmpl/magazine.php JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php:45 13 include JROOT/modules/mod_easyblogshowcase/mod_easyblogshowcase.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.94 ms Après la dernière requête : 388.02 ms Mémoire de requête : 0.046 MB mémoire avant requête : 9.287 MB Rangées retournées : 387
SELECT `config_key`,`config_value`
FROM r0bco13_eb_configsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_eb_configs NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 387 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.27 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 1.01 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:42 12 RADConfig->__construct() JROOT/components/com_eventbooking/helper/helper.php:847 11 EventbookingHelper::getConfig() JROOT/modules/mod_eb_events/mod_eb_events.php:30 10 include JROOT/modules/mod_eb_events/mod_eb_events.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 : 8.50 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.513 MB Rangées retournées : 1
SELECT *
FROM r0bco13_eb_themes
WHERE published = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_eb_themes NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.24 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.08 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_eventbooking/helper/helper.php:1089 12 EventbookingHelper::getDefaultTheme() JROOT/components/com_eventbooking/helper/helper.php:1223 11 EventbookingHelper::loadComponentCssForModules() JROOT/modules/mod_eb_events/mod_eb_events.php:50 10 include JROOT/modules/mod_eb_events/mod_eb_events.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.53 ms Après la dernière requête : 9.04 ms Mémoire de requête : 0.043 MB mémoire avant requête : 9.522 MB Rangées retournées : 162
SHOW FULL COLUMNS
FROM `r0bco13_eb_events`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `r0bco13_eb_events`Status Duration checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.11 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.73 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.11 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.09 ms Sending data 0.60 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.06 ms closing tables 0.01 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/joomla/database/driver/mysqli.php:448 16 JDatabaseDriverMysqli->getTableColumns() JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:83 15 RADModelList->__construct() JROOT/components/com_eventbooking/model/list.php:122 14 EventbookingModelList->__construct() JROOT/administrator/components/com_eventbooking/libraries/rad/model/model.php:150 13 RADModel::getInstance() JROOT/administrator/components/com_eventbooking/libraries/rad/model/model.php:165 12 RADModel::getTempInstance() JROOT/modules/mod_eb_events/helper.php:31 11 modEBEventsHelper::getData() JROOT/modules/mod_eb_events/mod_eb_events.php:64 10 include JROOT/modules/mod_eb_events/mod_eb_events.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.79 ms Après la dernière requête : 0.96 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.555 MB Rangées retournées : 1
SELECT COUNT(*)
FROM r0bco13_eb_events AS tbl
WHERE tbl.published > 0
AND tbl.hidden = 0
AND tbl.access IN (1,1,5)
AND tbl.language IN ('fr-FR','*', "")
AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2024-05-15 00:25:27')
AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2024-05-15 00:25:27')
AND (DATE(tbl.event_date) >= '2024-05-15' OR DATE(tbl.event_end_date) >= '2024-05-15')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbl NULL ALL idx_access,idx_published INDEX N'A PU ÊTRE UTILISÉ NULL NULL 9 11.11 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.10 ms end 0.01 ms query end 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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:210 13 RADModelList->getTotal() JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:175 12 RADModelList->getData() JROOT/modules/mod_eb_events/helper.php:70 11 modEBEventsHelper::getData() JROOT/modules/mod_eb_events/mod_eb_events.php:64 10 include JROOT/modules/mod_eb_events/mod_eb_events.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.72 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.040 MB mémoire avant requête : 9.560 MB Rangées retournées : 1
SELECT tbl.id,tbl.main_category_id,tbl.location_id,tbl.title,tbl.event_type,tbl.event_date,tbl.event_end_date,tbl.short_description,tbl.description,tbl.access,tbl.registration_access,tbl.individual_price,tbl.price_text,tbl.tax_rate,tbl.event_capacity,tbl.private_booking_count,tbl.waiting_list_capacity,tbl.created_by,tbl.created_date,tbl.cut_off_date,tbl.registration_type,tbl.min_group_number,tbl.discount_type,tbl.discount,tbl.early_bird_discount_type,tbl.early_bird_discount_date,tbl.early_bird_discount_amount,tbl.enable_cancel_registration,tbl.cancel_before_date,tbl.params,tbl.published,tbl.custom_fields,tbl.discount_groups,tbl.discount_amounts,tbl.registration_start_date,tbl.registration_handle_url,tbl.event_detail_url,tbl.fixed_group_price,tbl.attachment,tbl.late_fee_type,tbl.late_fee_date,tbl.late_fee_amount,tbl.event_password,tbl.currency_code,tbl.currency_symbol,tbl.thumb,tbl.image,tbl.image_alt,tbl.language,tbl.alias,tbl.featured,tbl.has_multiple_ticket_types,tbl.activate_waiting_list,tbl.collect_member_information,tbl.prevent_duplicate_registration,DATEDIFF(tbl.early_bird_discount_date, '2024-05-15 00:25:27') AS date_diff,DATEDIFF(tbl.event_date, '2024-05-15 00:25:27') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-05-15 00:25:27') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-05-15 00:25:27') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-05-15 00:25:27') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-05-15 00:25:27') AS cut_off_minutes,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address, c.lat, c.long,cat.tax_rate AS cat_tax_rate,(IFNULL(SUM(b.number_registrants), 0) + tbl.private_booking_count) AS total_registrants
FROM r0bco13_eb_events AS tbl
LEFT JOIN r0bco13_eb_registrants AS b
ON (tbl.id = b.event_id
AND b.group_id=0
AND (b.published = 1 OR (b.published = 0
AND b.payment_method LIKE "os_offline%")))
LEFT JOIN r0bco13_eb_locations AS c
ON tbl.location_id = c.id
LEFT JOIN r0bco13_eb_categories AS cat
ON tbl.main_category_id = cat.id
WHERE tbl.published > 0
AND tbl.hidden = 0
AND tbl.access IN (1,1,5)
AND tbl.language IN ('fr-FR','*', "")
AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2024-05-15 00:25:27')
AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2024-05-15 00:25:27')
AND (DATE(tbl.event_date) >= '2024-05-15' OR DATE(tbl.event_end_date) >= '2024-05-15')
GROUP BY tbl.id
ORDER BY tbl.event_date
LIMIT 6id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tbl NULL index PRIMARY,idx_category_id,idx_location_id,idx_parent_id,idx_access,idx_published,idx_event_date,idx_event_end_date,idx_alias PRIMARY 4 NULL 9 11.11 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE b NULL ref idx_event_id,idx_published,idx_payment_method idx_event_id 5 badmintotebcp13.tbl.id 23 100.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.tbl.location_id 1 100.00 NULL 1 SIMPLE cat NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.tbl.main_category_id 1 100.00 NULL Status Duration starting 0.26 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.57 ms init 0.17 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.12 ms preparing 0.04 ms Creating tmp table 0.07 ms Sorting for group 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.56 ms Creating sort index 0.11 ms end 0.01 ms query end 0.01 ms removing tmp table 0.06 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:186 12 RADModelList->getData() JROOT/modules/mod_eb_events/helper.php:70 11 modEBEventsHelper::getData() JROOT/modules/mod_eb_events/mod_eb_events.php:64 10 include JROOT/modules/mod_eb_events/mod_eb_events.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 : 14.82 ms Mémoire de requête : 0.024 MB mémoire avant requête : 9.643 MB Rangées retournées : 0
SELECT *
FROM r0bco13_eb_taxes
WHERE published = 1
LIMIT 2id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_eb_taxes NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.08 ms freeing items 0.07 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/components/com_eventbooking/helper/registration.php:5762 16 EventbookingHelperRegistration::getUniqueTaxRate() JROOT/components/com_eventbooking/helper/registration.php:5824 15 EventbookingHelperRegistration::calculateEventTaxRate() JROOT/components/com_eventbooking/model/list.php:205 14 EventbookingModelList->beforeReturnData() JROOT/components/com_eventbooking/model/upcomingevents.php:21 13 EventbookingModelUpcomingevents->beforeReturnData() JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:188 12 RADModelList->getData() JROOT/modules/mod_eb_events/helper.php:70 11 modEBEventsHelper::getData() JROOT/modules/mod_eb_events/mod_eb_events.php:64 10 include JROOT/modules/mod_eb_events/mod_eb_events.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.95 ms Après la dernière requête : 4.92 ms Mémoire de requête : 0.024 MB mémoire avant requête : 9.653 MB Rangées retournées : 2
SELECT *
FROM r0bco13_eb_locationsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_eb_locations NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 100.00 NULL Status Duration starting 0.05 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.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_eventbooking/helper/data.php:588 16 EventbookingHelperData::preProcessEventData() JROOT/components/com_eventbooking/helper/helper.php:827 15 EventbookingHelper::callOverridableHelperMethod() JROOT/components/com_eventbooking/model/list.php:208 14 EventbookingModelList->beforeReturnData() JROOT/components/com_eventbooking/model/upcomingevents.php:21 13 EventbookingModelUpcomingevents->beforeReturnData() JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:188 12 RADModelList->getData() JROOT/modules/mod_eb_events/helper.php:70 11 modEBEventsHelper::getData() JROOT/modules/mod_eb_events/mod_eb_events.php:64 10 include JROOT/modules/mod_eb_events/mod_eb_events.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.60 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.026 MB mémoire avant requête : 9.667 MB Rangées retournées : 1
SELECT a.*, b.event_id
FROM r0bco13_eb_categories AS a
INNER JOIN r0bco13_eb_event_categories AS b
ON a.id = b.category_id
WHERE b.event_id IN (9)
ORDER BY b.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b NULL ref idx_event_id,idx_category_id idx_event_id 5 const 1 100.00 Using index condition; Using where 1 SIMPLE a NULL eq_ref PRIMARY PRIMARY 4 badmintotebcp13.b.category_id 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.43 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.08 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/components/com_eventbooking/helper/data.php:615 16 EventbookingHelperData::preProcessEventData() JROOT/components/com_eventbooking/helper/helper.php:827 15 EventbookingHelper::callOverridableHelperMethod() JROOT/components/com_eventbooking/model/list.php:208 14 EventbookingModelList->beforeReturnData() JROOT/components/com_eventbooking/model/upcomingevents.php:21 13 EventbookingModelUpcomingevents->beforeReturnData() JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:188 12 RADModelList->getData() JROOT/modules/mod_eb_events/helper.php:70 11 modEBEventsHelper::getData() JROOT/modules/mod_eb_events/mod_eb_events.php:64 10 include JROOT/modules/mod_eb_events/mod_eb_events.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 : 3.28 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.674 MB Rangées retournées : 2
SELECT id, parent, alias,`alias_en`
FROM r0bco13_eb_categoriesid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r0bco13_eb_categories NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_eventbooking/helper/route.php:636 14 EventbookingHelperRoute::buildCategories() JROOT/components/com_eventbooking/helper/route.php:591 13 EventbookingHelperRoute::getCategoryIdsTree() JROOT/components/com_eventbooking/helper/route.php:187 12 EventbookingHelperRoute::getCategoryRoute() JROOT/modules/mod_eb_events/helper.php:81 11 modEBEventsHelper::getData() JROOT/modules/mod_eb_events/mod_eb_events.php:64 10 include JROOT/modules/mod_eb_events/mod_eb_events.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
44 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
5 × SELECT a.`id`, a.`title`, a.`alias`
FROM `r0bco13_easyblog_tag` AS a
LEFT JOIN `r0bco13_easyblog_post_tag` AS b
ON a.`id`= b.`tag_id`2 × SELECT custom_data
FROM r0bco13_extensions2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `r0bco13_assets`1 × SELECT id, rules
FROM `r0bco13_viewlevels1 × SELECT b.id
FROM r0bco13_usergroups AS a
LEFT JOIN r0bco13_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT config_value
FROM r0bco13_hikashop_config1 × SELECT *
FROM r0bco13_hikashop_confi1 × SELECT *
FROM r0bco13_rsform_confi1 × 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 r0bco13_content AS a
INNER JOIN r0bco13_categories AS c
on c.id = a.catid
LEFT JOIN r0bco13_users AS u
on u.id = a.created_by
LEFT JOIN r0bco13_categories as parent
ON parent.id = c.parent_id
LEFT JOIN r0bco13_content_rating AS v
ON a.id = v.content_id1 × 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 `r0bco13_categories` AS `s`
INNER JOIN `r0bco13_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('fr-FR','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)1 × SELECT `m`.`tag_id`,`t`.*
FROM `r0bco13_contentitem_tag_map` AS m
INNER JOIN `r0bco13_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM r0bco13_fields AS a
LEFT JOIN `r0bco13_languages` AS l
ON l.lang_code = a.language
LEFT JOIN r0bco13_users AS uc
ON uc.id=a.checked_out
LEFT JOIN r0bco13_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN r0bco13_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN r0bco13_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `r0bco13_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM r0bco13_modules AS m
LEFT JOIN r0bco13_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN r0bco13_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT language,id
FROM `r0bco13_menu`1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `r0bco13_content` AS `c`
INNER JOIN `r0bco13_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `r0bco13_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `r0bco13_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `r0bco13_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT `id`
FROM `r0bco13_rstbox`1 × SELECT *
FROM r0bco13_easyblog_configs1 × SELECT a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured`
FROM `r0bco13_easyblog_post` AS a
INNER JOIN `r0bco13_users` AS uu
ON a.`created_by` = uu.`id`
and uu.`block` = 0
LEFT JOIN `r0bco13_easyblog_featured` AS f
ON a.`id` = f.`content_id`
AND f.`type` = 'post'1 × SELECT COUNT(1) as `voted`, `uid`
FROM `r0bco13_easyblog_ratings`1 × SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid`
FROM `r0bco13_easyblog_ratings` AS a1 × SELECT a.*
FROM `r0bco13_easyblog_comment` AS a
LEFT JOIN `r0bco13_users` AS uu
ON a.`created_by` = uu.`id`1 × SELECT a.`post_id`, COUNT(1) AS `count`
FROM `r0bco13_easyblog_comment` AS a
LEFT JOIN `r0bco13_users` AS uu
ON a.`created_by` = uu.`id`1 × select a.*, b.`post_id`, b.`primary`
from `r0bco13_easyblog_category` as a
inner join `r0bco13_easyblog_post_category` as b
on a.`id` = b.`category_id`1 × select a.*, b.`post_id`
from `r0bco13_easyblog_tag` as a
inner join `r0bco13_easyblog_post_tag` as b
on a.`id` = b.`tag_id`1 × select a.*
from `r0bco13_easyblog_revisions` as a1 × select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering`
from `r0bco13_users` as u
left join `r0bco13_easyblog_users` as e
ON u.`id` = e.`id`1 × SELECT *
FROM `r0bco13_users`1 × SELECT `g`.`id`,`g`.`title`
FROM `r0bco13_usergroups` AS g
INNER JOIN `r0bco13_user_usergroup_map` AS m
ON m.group_id = g.id1 × select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value`
from `r0bco13_easyblog_category_fields_groups` as a
inner join `r0bco13_easyblog_post_category` as p
on `a`.`category_id` = `p`.`category_id`
inner join `r0bco13_easyblog_fields_groups` as fg
on `a`.`group_id` = `fg`.`id`
inner join `r0bco13_easyblog_fields` as f
on `fg`.`id` = `f`.`group_id`
left join `r0bco13_easyblog_fields_values` as fv
on `fv`.`field_id` = `f`.`id`
and `fv`.`post_id` = `p`.`post_id`
LEFT JOIN `r0bco13_easyblog_fields_groups_acl` AS acl
ON fg.`id` = acl.`group_id`1 × select *
from `r0bco13_easyblog_meta`1 × SELECT *
FROM `r0bco13_easyblog_acl`1 × SELECT *
FROM `r0bco13_easyblog_acl_group`1 × SELECT *
FROM `r0bco13_menu`1 × SELECT `config_key`,`config_value`
FROM r0bco13_eb_config1 × SELECT *
FROM r0bco13_eb_themes1 × SELECT COUNT(*)
FROM r0bco13_eb_events AS tbl1 × SELECT tbl.id,tbl.main_category_id,tbl.location_id,tbl.title,tbl.event_type,tbl.event_date,tbl.event_end_date,tbl.short_description,tbl.description,tbl.access,tbl.registration_access,tbl.individual_price,tbl.price_text,tbl.tax_rate,tbl.event_capacity,tbl.private_booking_count,tbl.waiting_list_capacity,tbl.created_by,tbl.created_date,tbl.cut_off_date,tbl.registration_type,tbl.min_group_number,tbl.discount_type,tbl.discount,tbl.early_bird_discount_type,tbl.early_bird_discount_date,tbl.early_bird_discount_amount,tbl.enable_cancel_registration,tbl.cancel_before_date,tbl.params,tbl.published,tbl.custom_fields,tbl.discount_groups,tbl.discount_amounts,tbl.registration_start_date,tbl.registration_handle_url,tbl.event_detail_url,tbl.fixed_group_price,tbl.attachment,tbl.late_fee_type,tbl.late_fee_date,tbl.late_fee_amount,tbl.event_password,tbl.currency_code,tbl.currency_symbol,tbl.thumb,tbl.image,tbl.image_alt,tbl.language,tbl.alias,tbl.featured,tbl.has_multiple_ticket_types,tbl.activate_waiting_list,tbl.collect_member_information,tbl.prevent_duplicate_registration,DATEDIFF(tbl.early_bird_discount_date, '2024-05-15 00:25:27') AS date_diff,DATEDIFF(tbl.event_date, '2024-05-15 00:25:27') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-05-15 00:25:27') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-05-15 00:25:27') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-05-15 00:25:27') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-05-15 00:25:27') AS cut_off_minutes,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address, c.lat, c.long,cat.tax_rate AS cat_tax_rate,(IFNULL(SUM(b.number_registrants), 0) + tbl.private_booking_count) AS total_registrants
FROM r0bco13_eb_events AS tbl
LEFT JOIN r0bco13_eb_registrants AS b
ON (tbl.id = b.event_id
AND b.group_id=0
AND (b.published = 1 OR (b.published = 0
AND b.payment_method LIKE "os_offline%")))
LEFT JOIN r0bco13_eb_locations AS c
ON tbl.location_id = c.id
LEFT JOIN r0bco13_eb_categories AS cat
ON tbl.main_category_id = cat.id1 × SELECT *
FROM r0bco13_eb_taxes1 × SELECT *
FROM r0bco13_eb_location1 × SELECT a.*, b.event_id
FROM r0bco13_eb_categories AS a
INNER JOIN r0bco13_eb_event_categories AS b
ON a.id = b.category_id1 × SELECT id, parent, alias,`alias_en`
FROM r0bco13_eb_categorie
Autres tables :
1 × UPDATE `r0bco13_extensions`
SET `params` = '{\"mediaversion\":\"fc106f8a7cb757572f756d5b3481af15\"}'1 × SHOW FULL COLUMNS
FROM `r0bco13_users1 × SHOW FULL COLUMNS
FROM `r0bco13_eb_events