Accueil

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701898638,
                "last": 1701898638,
                "now": 1701898638
            },
            "token": "0GNqsKWQMhkZ3dmi0JZ3i6MtmV0uXpSh"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "ce2884f4104f41cac95c5be77ec22b37f3965f10": {
                    "link": "http://www.echiquiergouesnousien.fr/index.php/les-competitions/1046-trois-gouesnousiens-au-france",
                    "expiry": 1701898638
                },
                "2d12d121bda71e2680f1928090cb179b3dd48b2b": {
                    "link": "http://www.echiquiergouesnousien.fr/index.php/79-club/1045-deux-champions-au-club",
                    "expiry": 1701898638
                },
                "41060743e57ec1c194309319c29c74ef4d7b34f7": {
                    "link": "http://www.echiquiergouesnousien.fr/index.php/les-competitions/les-championnats-individuels/1044-saison-2022-2023-bretagne-jeunes",
                    "expiry": 1701898638
                },
                "d90c130a23b748c5e03f97d5d51a24626fbddd5e": {
                    "link": "http://www.echiquiergouesnousien.fr/index.php/79-club/1043-rentree-2022-2023",
                    "expiry": 1701898638
                },
                "cd159c04727730ff9c503a7fbea408e30c225896": {
                    "link": "http://www.echiquiergouesnousien.fr/index.php/les-competitions/les-equipes-adultes/1042-gouesnou-vainqueur-de-la-coupe-2000",
                    "expiry": 1701898638
                },
                "b77e6a59ff43fd71973545d63b7f01bc4289bb3f": {
                    "link": "http://www.echiquiergouesnousien.fr/index.php/79-club/1041-tournoi-rapide-de-fouesnant",
                    "expiry": 1701898638
                },
                "0aef759eb3c1bf01d400c28c65094a3028c2d94c": {
                    "link": "http://www.echiquiergouesnousien.fr/index.php/79-club/1040-france-jeunes-2022",
                    "expiry": 1701898638
                },
                "9b6fd9972ab2d0abd20fa2d9e626882f1c3e7f1d": {
                    "link": "http://www.echiquiergouesnousien.fr/index.php/79-club/1039-bretagne-jeunes-2022",
                    "expiry": 1701898638
                },
                "6d658e5041288281d9dba4198e4389c41a8184c4": {
                    "link": "http://www.echiquiergouesnousien.fr/index.php/79-club/1038-open-de-guingamp-2022",
                    "expiry": 1701898638
                }
            }
        }
    }
}

Temps

Mémoire

43 requêtes exécutées 27.69 ms

1. Temps de requête : 0.43 ms

   SELECT `data`
   
     FROM `rbywh_session`
   
     WHERE `session_id` = X'6d73713137663671736c6c6b6a376a6a733972386e7662646e33'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	rbywh_session	const	PRIMARY	PRIMARY	194	const	1

   Profil

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.06 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

2. Temps de requête : 0.23 ms Après la dernière requête : 1.68 ms

   SELECT `session_id`
   
     FROM `rbywh_session`
   
     WHERE `session_id` = X'6d73713137663671736c6c6b6a376a6a733972386e7662646e33' 
     LIMIT 1

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	rbywh_session	const	PRIMARY	PRIMARY	194	const	1	Using index

   Profil

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

3. Temps de requête : 0.31 ms Après la dernière requête : 0.17 ms

   INSERT INTO `rbywh_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6d73713137663671736c6c6b6a376a6a733972386e7662646e33', 1, 1701898638, 0, '', 0)

   Explication

   EXPLAIN impossible sur la requête : INSERT INTO `rbywh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6d73713137663671736c6c6b6a376a6a733972386e7662646e33', 1, 1701898638, 0, '', 0)

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.02 ms
   Update	0.09 ms
   Waiting for query cache lock	0.01 ms
   Update	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.02 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   8	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

4. Temps de requête : 0.35 ms Après la dernière requête : 6.78 ms

   SELECT id, rules
   
     FROM `rbywh_viewlevels`

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	rbywh_viewlevels	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	4

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.05 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

5. Temps de requête : 0.37 ms Après la dernière requête : 0.19 ms

   SELECT b.id
   
     FROM rbywh_usergroups AS a
   
     LEFT JOIN rbywh_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

6. Temps de requête : 1.00 ms Après la dernière requête : 64.31 ms

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `rbywh_assets`
   
     WHERE `name` IN ('root.1','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_autotweet','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailjet','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_sendinblue','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	rbywh_assets	range	idx_asset_name	idx_asset_name	402	NULL	45	Using index condition

   Profil

   Status	Duration
   Starting	0.12 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.09 ms
   Optimizing	0.02 ms
   Statistics	0.14 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.29 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.03 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   12	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
   11	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:78
   10	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:95
   9	RegularLabs\Library\Plugin->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

7. Temps de requête : 0.42 ms Après la dernière requête : 3.72 ms

   UPDATE `rbywh_extensions`
   
     SET `params` = '{\"mediaversion\":\"b87f3faf3be0fded2848feaa75fe71be\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explication

   EXPLAIN impossible sur la requête : UPDATE `rbywh_extensions` SET `params` = '{\"mediaversion\":\"b87f3faf3be0fded2848feaa75fe71be\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.08 ms
   Updating	0.09 ms
   End of update loop	0.01 ms
   Waiting for query cache lock	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.02 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   15	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
   9	plgSystemJComments->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

8. Temps de requête : 3.04 ms Après la dernière requête : 33.43 ms

   SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN c.published = 2 
     AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
     CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
   							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
   
     FROM rbywh_content AS a
   
     INNER JOIN rbywh_content_frontpage AS fp 
     ON fp.content_id = a.id
   
     LEFT JOIN rbywh_categories AS c 
     ON c.id = a.catid
   
     LEFT JOIN rbywh_users AS ua 
     ON ua.id = a.created_by
   
     LEFT JOIN rbywh_users AS uam 
     ON uam.id = a.modified_by
   
     LEFT JOIN rbywh_categories as parent 
     ON parent.id = c.parent_id
   
     LEFT JOIN rbywh_content_rating AS v 
     ON a.id = v.content_id
   
     WHERE c.published = 1 
     AND a.state = 1 
     AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-06 21:37:18') 
     AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-06 21:37:18')
   
     ORDER BY a.featured DESC, fp.ordering,  
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
     LIMIT 9

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	fp	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	58	Using temporary; Utilisation du tri complet de type filesort
   1	SIMPLE	a	eq_ref	PRIMARY,idx_state,idx_catid	PRIMARY	4	gouesnou_joom976.fp.content_id	1	Using where
   1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.a.catid	1	Using where
   1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.a.created_by	1	Using where
   1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.a.modified_by	1	Using where
   1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.c.parent_id	1	Using where
   1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.a.id	1	Using where

   Profil

   Status	Duration
   Starting	0.22 ms
   checking permissions	0.01 ms
   Opening tables	0.08 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.10 ms
   Optimizing	0.04 ms
   Statistics	0.10 ms
   Preparing	0.03 ms
   Creating tmp table	0.12 ms
   Sorting result	0.02 ms
   Executing	0.01 ms
   Sending data	1.57 ms
   Creating sort index	0.29 ms
   Removing tmp table	0.20 ms
   Creating sort index	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
   16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
   15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
   14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
   13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
   12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
   11	ContentViewFeatured->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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

9. Temps de requête : 0.45 ms Après la dernière requête : 2.42 ms

   SELECT `m`.`tag_id`,`t`.*
   
     FROM `rbywh_contentitem_tag_map` AS m 
   
     INNER JOIN `rbywh_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`
   
     WHERE `m`.`type_alias` = 'com_content.article' 
     AND `m`.`content_item_id` = 1046 
     AND `t`.`published` = 1 
     AND t.access IN (1,1,5)

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
   1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	gouesnou_joom976.m.tag_id	1	Using where

   Profil

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
   16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
   15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
   14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
   13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
   12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
   11	ContentViewFeatured->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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

10. Temps de requête : 0.41 ms Après la dernière requête : 0.43 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `rbywh_contentitem_tag_map` AS m 
    
      INNER JOIN `rbywh_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1045 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	gouesnou_joom976.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
    12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

11. Temps de requête : 0.39 ms Après la dernière requête : 0.41 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `rbywh_contentitem_tag_map` AS m 
    
      INNER JOIN `rbywh_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1044 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	gouesnou_joom976.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
    12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

12. Temps de requête : 0.42 ms Après la dernière requête : 0.41 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `rbywh_contentitem_tag_map` AS m 
    
      INNER JOIN `rbywh_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1043 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	gouesnou_joom976.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
    12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

13. Temps de requête : 0.38 ms Après la dernière requête : 0.44 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `rbywh_contentitem_tag_map` AS m 
    
      INNER JOIN `rbywh_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1042 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	gouesnou_joom976.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
    12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

14. Temps de requête : 0.38 ms Après la dernière requête : 0.44 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `rbywh_contentitem_tag_map` AS m 
    
      INNER JOIN `rbywh_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1041 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	gouesnou_joom976.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
    12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

15. Temps de requête : 0.40 ms Après la dernière requête : 0.44 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `rbywh_contentitem_tag_map` AS m 
    
      INNER JOIN `rbywh_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1040 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	gouesnou_joom976.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
    12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

16. Temps de requête : 0.41 ms Après la dernière requête : 0.43 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `rbywh_contentitem_tag_map` AS m 
    
      INNER JOIN `rbywh_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1039 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	gouesnou_joom976.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
    12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

17. Temps de requête : 0.41 ms Après la dernière requête : 0.43 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `rbywh_contentitem_tag_map` AS m 
    
      INNER JOIN `rbywh_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1038 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	gouesnou_joom976.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
    12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

18. Temps de requête : 0.91 ms Après la dernière requête : 1.91 ms

    SELECT COUNT(*)
    
      FROM rbywh_content AS a
    
      INNER JOIN rbywh_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN rbywh_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN rbywh_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN rbywh_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN rbywh_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN rbywh_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-06 21:37:18') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-06 21:37:18')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fp	index	PRIMARY	PRIMARY	4	NULL	58	Using index
    1	SIMPLE	a	eq_ref	PRIMARY,idx_state,idx_catid	PRIMARY	4	gouesnou_joom976.fp.content_id	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.a.catid	1	Using where

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.34 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
    14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
    13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
    12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

19. Temps de requête : 1.01 ms Après la dernière requête : 20.52 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `rbywh_categories` AS `s`
    
      INNER JOIN `rbywh_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 81
    
      ORDER BY c.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	88	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.18 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.04 ms
    Statistics	0.17 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.18 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    30	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    26	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
    25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    17	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/jcomments/jcomments.php:95
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:309
    15	plgContentJComments->onContentBeforeDisplay()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:110
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

20. Temps de requête : 0.73 ms Après la dernière requête : 2.93 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `rbywh_categories` AS `s`
    
      INNER JOIN `rbywh_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 79
    
      ORDER BY c.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range|filter	cat_idx,idx_access,idx_left_right	idx_left_right|cat_idx	4|207	NULL	11 (55%)	Using index condition; Using where; Using rowid filter

    Profil

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.16 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    30	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    26	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
    25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    17	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/jcomments/jcomments.php:95
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:309
    15	plgContentJComments->onContentBeforeDisplay()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:110
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

21. Temps de requête : 0.42 ms Après la dernière requête : 12.39 ms
    Requêtes dupliquées: #25  #29

    SELECT a.filename as filename, a.type as type, a.menulink as menulink 
      FROM rbywh_phocagallery_styles AS a 
      WHERE a.published = 1 
      ORDER BY a.type, a.ordering ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	4	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736
    16	PhocaGalleryRenderFront::renderAllCSS()	JROOT/plugins/content/phocagallery/phocagallery.php:102
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

22. Temps de requête : 0.76 ms Après la dernière requête : 12.22 ms

    SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, 
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug 
      FROM rbywh_phocagallery_categories AS cc 
      LEFT JOIN rbywh_phocagallery AS a 
      ON a.catid = cc.id 
      WHERE a.published = 1 
      AND cc.published = 1 
      AND cc.approved = 1 
      AND a.approved = 1 
      AND cc.id != 0  
      AND cc.id = 274 
      GROUP BY cc.id 
      ORDER BY cc.ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	a	ref	catid	catid	5	const,const	13	Using where

    Profil

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.12 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.04 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/phocagallery/phocagallery.php:846
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

23. Temps de requête : 0.64 ms Après la dernière requête : 0.15 ms
    Requêtes dupliquées: #27  #31

    SELECT cc.title AS text, cc.id AS value, cc.parent_id as parentid 
      FROM rbywh_phocagallery_categories AS cc 
      WHERE cc.published = 1 
      AND cc.approved = 1 
      ORDER BY cc.ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	268	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.32 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/phocagallery/phocagallery.php:849
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

24. Temps de requête : 0.58 ms Après la dernière requête : 30.81 ms

    SELECT filename, extm, exts, extw, exth, extid 
      FROM rbywh_phocagallery 
      WHERE catid=274 
      AND published = 1 
      AND approved = 1 
      ORDER BY ordering 
      LIMIT 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rbywh_phocagallery	ref	catid	catid	5	const,const	13	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.13 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.04 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/phocagallery/phocagallery.php:898
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

25. Temps de requête : 0.39 ms Après la dernière requête : 7.79 ms
    Requêtes dupliquées: #21  #29

    SELECT a.filename as filename, a.type as type, a.menulink as menulink 
      FROM rbywh_phocagallery_styles AS a 
      WHERE a.published = 1 
      ORDER BY a.type, a.ordering ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	4	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736
    16	PhocaGalleryRenderFront::renderAllCSS()	JROOT/plugins/content/phocagallery/phocagallery.php:102
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

26. Temps de requête : 0.74 ms Après la dernière requête : 0.75 ms

    SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, 
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug 
      FROM rbywh_phocagallery_categories AS cc 
      LEFT JOIN rbywh_phocagallery AS a 
      ON a.catid = cc.id 
      WHERE a.published = 1 
      AND cc.published = 1 
      AND cc.approved = 1 
      AND a.approved = 1 
      AND cc.id != 0  
      AND cc.id = 272 
      GROUP BY cc.id 
      ORDER BY cc.ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	a	ref	catid	catid	5	const,const	33	Using where

    Profil

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.17 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/phocagallery/phocagallery.php:846
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

27. Temps de requête : 0.61 ms Après la dernière requête : 0.14 ms
    Requêtes dupliquées: #23  #31

    SELECT cc.title AS text, cc.id AS value, cc.parent_id as parentid 
      FROM rbywh_phocagallery_categories AS cc 
      WHERE cc.published = 1 
      AND cc.approved = 1 
      ORDER BY cc.ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	268	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.32 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/phocagallery/phocagallery.php:849
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

28. Temps de requête : 0.70 ms Après la dernière requête : 31.16 ms

    SELECT filename, extm, exts, extw, exth, extid 
      FROM rbywh_phocagallery 
      WHERE catid=272 
      AND published = 1 
      AND approved = 1 
      ORDER BY ordering 
      LIMIT 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rbywh_phocagallery	ref	catid	catid	5	const,const	33	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.19 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/phocagallery/phocagallery.php:898
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

29. Temps de requête : 0.37 ms Après la dernière requête : 2.99 ms
    Requêtes dupliquées: #21  #25

    SELECT a.filename as filename, a.type as type, a.menulink as menulink 
      FROM rbywh_phocagallery_styles AS a 
      WHERE a.published = 1 
      ORDER BY a.type, a.ordering ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	4	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736
    16	PhocaGalleryRenderFront::renderAllCSS()	JROOT/plugins/content/phocagallery/phocagallery.php:102
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

30. Temps de requête : 0.69 ms Après la dernière requête : 0.80 ms

    SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, 
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug 
      FROM rbywh_phocagallery_categories AS cc 
      LEFT JOIN rbywh_phocagallery AS a 
      ON a.catid = cc.id 
      WHERE a.published = 1 
      AND cc.published = 1 
      AND cc.approved = 1 
      AND a.approved = 1 
      AND cc.id != 0  
      AND cc.id = 271 
      GROUP BY cc.id 
      ORDER BY cc.ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	a	ref	catid	catid	5	const,const	25	Using where

    Profil

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.18 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/phocagallery/phocagallery.php:846
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

31. Temps de requête : 0.61 ms Après la dernière requête : 0.13 ms
    Requêtes dupliquées: #23  #27

    SELECT cc.title AS text, cc.id AS value, cc.parent_id as parentid 
      FROM rbywh_phocagallery_categories AS cc 
      WHERE cc.published = 1 
      AND cc.approved = 1 
      ORDER BY cc.ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	268	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.30 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/phocagallery/phocagallery.php:849
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

32. Temps de requête : 0.74 ms Après la dernière requête : 31.05 ms

    SELECT filename, extm, exts, extw, exth, extid 
      FROM rbywh_phocagallery 
      WHERE catid=271 
      AND published = 1 
      AND approved = 1 
      ORDER BY ordering 
      LIMIT 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rbywh_phocagallery	ref	catid	catid	5	const,const	25	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 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.01 ms
    Creating sort index	0.20 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/phocagallery/phocagallery.php:898
    15	plgContentPhocaGallery->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    11	ContentViewFeatured->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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

33. Temps de requête : 1.02 ms Après la dernière requête : 119.11 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
    
      FROM rbywh_modules AS m
    
      LEFT JOIN rbywh_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      LEFT JOIN rbywh_advancedmodules as am 
      ON am.moduleid = m.id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0
    
      ORDER BY m.position, m.ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	range	published,newsfeeds	published	5	NULL	15	Using index condition; Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.m.id	1	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	gouesnou_joom976.m.module,const	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.30 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:413
    20	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:127
    19	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:366
    15	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:87
    14	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:641
    12	T3Template->countModules()	JROOT/templates/t3_blank/tpls/blocks/header.php:37
    11	include JROOT/templates/t3_blank/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:200
    10	T3Template->loadBlock()	JROOT/templates/t3_blank/tpls/default.php:29
    9	include JROOT/templates/t3_blank/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:226
    8	T3Template->loadLayout()	JROOT/templates/t3_blank/index.php:34
    7	require JROOT/templates/t3_blank/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

34. Temps de requête : 2.08 ms Après la dernière requête : 86.24 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
    SELECT COUNT(i.`id`)
    
      FROM `rbywh_content` AS `i`
    
      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems
    
      FROM `rbywh_categories` AS `s`
    
      INNER JOIN `rbywh_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 97
    
      ORDER BY c.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	88	Using where; Utilisation du tri complet de type filesort
    2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	gouesnou_joom976.c.id	5	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.17 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.14 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.17 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Executing	0.01 ms
    Sending data	0.34 ms
    Executing	0.01 ms
    Sending data	0.66 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    18	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    17	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/categories.php:115
    16	ContentModelCategories->getItems()	JROOT/modules/mod_articles_category/helper.php:142
    15	ModArticlesCategoryHelper::getList()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:571
    12	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    11	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

35. Temps de requête : 1.31 ms Après la dernière requête : 0.74 ms

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM rbywh_content AS a
    
      LEFT JOIN rbywh_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN rbywh_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN rbywh_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN rbywh_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN rbywh_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN rbywh_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE c.published = 1 
      AND a.state = 1 
      AND a.catid IN (97) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-06 21:37:18') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-06 21:37:18')
    
      ORDER BY a.publish_down ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	a	index_merge	idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	160	Using intersect(idx_catid,idx_state); Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.a.modified_by	1	Using where
    1	SIMPLE	fp	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.a.id	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	gouesnou_joom976.a.id	1	Using where

    Profil

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.56 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysql->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/libraries/src/MVC/Model/ListModel.php:194
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    16	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:224
    15	ModArticlesCategoryHelper::getList()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:571
    12	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    11	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

36. Temps de requête : 0.54 ms Après la dernière requête : 8.16 ms

    SELECT guest, client_id
    
      FROM rbywh_session
    
      WHERE client_id = 0

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rbywh_session	ref	client_id_guest	client_id_guest	2	const	185	Using index

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.11 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:45
    12	ModWhosonlineHelper::getOnlineCount()	JROOT/modules/mod_whosonline/mod_whosonline.php:19
    11	include JROOT/modules/mod_whosonline/mod_whosonline.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

37. Temps de requête : 0.98 ms Après la dernière requête : 71.30 ms

    SHOW TABLES

    Explication

    EXPLAIN impossible sur la requête : SHOW TABLES

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    checking permissions	0.50 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1550
    20	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
    19	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
    18	F0FDatabaseDriverJoomla->getTableList()	JROOT/libraries/f0f/table/table.php:2070
    17	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
    16	F0FTable->__construct()	JROOT/administrator/components/com_autotweet/tables/automator.php:33
    15	AutotweetTableAutomator->__construct()	JROOT/libraries/f0f/table/table.php:433
    14	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
    13	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
    12	F0FModel->getTable()	JROOT/administrator/components/com_autotweet/models/automators.php:91
    11	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
    10	AutotweetModelAutomators->lastRunCheck()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
    9	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
    8	PlgSystemAutotweetAutomator->onAfterRender()	Même appel que celui de la ligne ci-dessous.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

38. Temps de requête : 0.85 ms Après la dernière requête : 0.32 ms

    SHOW FULL COLUMNS 
      FROM `rbywh_autotweet_automator`

    Explication

    EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `rbywh_autotweet_automator`

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.39 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    checking permissions	0.06 ms
    closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.08 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
    18	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
    17	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
    16	F0FTable->__construct()	JROOT/administrator/components/com_autotweet/tables/automator.php:33
    15	AutotweetTableAutomator->__construct()	JROOT/libraries/f0f/table/table.php:433
    14	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
    13	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
    12	F0FModel->getTable()	JROOT/administrator/components/com_autotweet/models/automators.php:91
    11	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
    10	AutotweetModelAutomators->lastRunCheck()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
    9	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
    8	PlgSystemAutotweetAutomator->onAfterRender()	Même appel que celui de la ligne ci-dessous.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

39. Temps de requête : 0.34 ms Après la dernière requête : 1.33 ms

    SELECT rbywh_autotweet_automator.*
    
      FROM rbywh_autotweet_automator
    
      WHERE `rbywh_autotweet_automator`.`plugin` = 'automator'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rbywh_autotweet_automator	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2	Using where

    Profil

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
    13	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
    12	F0FTable->load()	JROOT/administrator/components/com_autotweet/models/automators.php:96
    11	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
    10	AutotweetModelAutomators->lastRunCheck()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
    9	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
    8	PlgSystemAutotweetAutomator->onAfterRender()	Même appel que celui de la ligne ci-dessous.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

40. Temps de requête : 0.25 ms Après la dernière requête : 0.28 ms

    SELECT rbywh_autotweet_automator.*
    
      FROM rbywh_autotweet_automator
    
      WHERE `rbywh_autotweet_automator`.`id` = '1'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rbywh_autotweet_automator	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
    14	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
    13	F0FTable->load()	JROOT/libraries/f0f/model/model.php:1154
    12	F0FModel->getItem()	JROOT/administrator/components/com_autotweet/models/automators.php:100
    11	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
    10	AutotweetModelAutomators->lastRunCheck()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
    9	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
    8	PlgSystemAutotweetAutomator->onAfterRender()	Même appel que celui de la ligne ci-dessous.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

41. Temps de requête : 0.12 ms Après la dernière requête : 0.42 ms

    
      SET sql_big_selects=1

    Explication

    EXPLAIN impossible sur la requête : SET sql_big_selects=1

    Profil

    Status	Duration
    Starting	0.02 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/database.php:33
    10	JDatabase->query()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:236
    9	PlgAutotweetBase->onContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
    8	PlgSystemAutotweetContent->onAfterRender()	Même appel que celui de la ligne ci-dessous.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

42. Temps de requête : 0.27 ms Après la dernière requête : 0.62 ms

    SELECT rbywh_autotweet_automator.*
    
      FROM rbywh_autotweet_automator
    
      WHERE `rbywh_autotweet_automator`.`plugin` = 'content'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rbywh_autotweet_automator	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2	Using where

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
    14	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
    13	F0FTable->load()	JROOT/administrator/components/com_autotweet/models/automators.php:96
    12	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
    11	AutotweetModelAutomators->lastRunCheck()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648
    10	PlgAutotweetBase->executeContentPolling()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238
    9	PlgAutotweetBase->onContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
    8	PlgSystemAutotweetContent->onAfterRender()	Même appel que celui de la ligne ci-dessous.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

43. Temps de requête : 0.24 ms Après la dernière requête : 0.27 ms

    SELECT rbywh_autotweet_automator.*
    
      FROM rbywh_autotweet_automator
    
      WHERE `rbywh_autotweet_automator`.`id` = '2'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rbywh_autotweet_automator	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
    15	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
    14	F0FTable->load()	JROOT/libraries/f0f/model/model.php:1154
    13	F0FModel->getItem()	JROOT/administrator/components/com_autotweet/models/automators.php:100
    12	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
    11	AutotweetModelAutomators->lastRunCheck()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648
    10	PlgAutotweetBase->executeContentPolling()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238
    9	PlgAutotweetBase->onContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
    8	PlgSystemAutotweetContent->onAfterRender()	Même appel que celui de la ligne ci-dessous.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---