{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1534844804,
                "last": 1534844804,
                "now": 1534844804
            },
            "token": "Etn4caPL9W5WyZZbyKaMBziTDz8XdJhH"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "fr-FR"
        }
    }
}

Temps

Mémoire

20 requêtes exécutées 23.19 ms

1. Temps de requête : 0.89 ms Mémoire de requête : 0.027 MB mémoire avant requête : 1.179 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `r3w62_session`
   
     WHERE `session_id` = 'b6763cea01e28ac39b713dac53b4cb67'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	r3w62_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.03 ms
   executing	0.00 ms
   end	0.00 ms
   query end	0.00 ms
   ha_commit_one_phase(-1)	0.01 ms
   innobase_commit_low():trx_comm	0.00 ms
   ha_commit_one_phase(-1)	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.03 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   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:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:755
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   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.94 ms Après la dernière requête : 2.55 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.197 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `r3w62_session`
   
     WHERE `session_id` = 'b6763cea01e28ac39b713dac53b4cb67' 
     LIMIT 1

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	r3w62_session	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.05 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.02 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   ha_commit_one_phase(-1)	0.01 ms
   innobase_commit_low():trx_comm	0.00 ms
   ha_commit_one_phase(-1)	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   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 : 1.21 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.204 MB

   INSERT INTO `r3w62_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('b6763cea01e28ac39b713dac53b4cb67', 1, '1534844804', 0, '', 0)

   Explication

   EXPLAIN impossible sur la requête : INSERT INTO `r3w62_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('b6763cea01e28ac39b713dac53b4cb67', 1, '1534844804', 0, '', 0)

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.13 ms
   end	0.00 ms
   query end	0.00 ms
   wsrep in pre-commit stage	0.10 ms
   ha_commit_one_phase(1707753377	0.00 ms
   innobase_commit_low():trx_comm	0.01 ms
   ha_commit_one_phase(1707753377	0.00 ms
   wsrep in pre-commit stage	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   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.92 ms Après la dernière requête : 10.30 ms Mémoire de requête : 0.024 MB mémoire avant requête : 1.356 MB Rangées retournées : 4

   SELECT id, rules
   
     FROM `r3w62_viewlevels`

   Explication

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

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.00 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   ha_commit_one_phase(-1)	0.01 ms
   innobase_commit_low():trx_comm	0.00 ms
   ha_commit_one_phase(-1)	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
   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:310
   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:606
   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:195
   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 : 1.30 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.024 MB mémoire avant requête : 1.370 MB Rangées retournées : 1

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

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	20.00	Using where; Using index

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   ha_commit_one_phase(-1)	0.01 ms
   innobase_commit_low():trx_comm	0.00 ms
   ha_commit_one_phase(-1)	0.00 ms
   query end	0.00 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   cleaning up	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
   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:310
   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:606
   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:195
   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.25 ms Après la dernière requête : 40.12 ms Mémoire de requête : 0.026 MB mémoire avant requête : 1.836 MB Rangées retournées : 1
   Requêtes dupliquées: #7

   SELECT template
   
     FROM r3w62_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	ALL	idx_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	11	100.00	Using where

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   ha_commit_one_phase(-1)	0.01 ms
   innobase_commit_low():trx_comm	0.00 ms
   ha_commit_one_phase(-1)	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.06 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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 : 1.36 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.027 MB mémoire avant requête : 1.846 MB Rangées retournées : 1
   Requêtes dupliquées: #6

   SELECT template
   
     FROM r3w62_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	ALL	idx_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	11	100.00	Using where

   Profil

   Status	Duration
   starting	0.06 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   ha_commit_one_phase(-1)	0.01 ms
   innobase_commit_low():trx_comm	0.00 ms
   ha_commit_one_phase(-1)	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.03 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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 : 0.97 ms Après la dernière requête : 12.28 ms Mémoire de requête : 0.025 MB mémoire avant requête : 1.990 MB Rangées retournées : 2

   SELECT extension, file, type
   
     FROM r3w62_rokcommon_configs
   
     ORDER BY priority

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	r3w62_rokcommon_configs	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2	100.00	Utilisation du tri complet de type filesort

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.00 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.00 ms
   Creating sort index	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   ha_commit_one_phase(-1)	0.01 ms
   innobase_commit_low():trx_comm	0.00 ms
   ha_commit_one_phase(-1)	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
   8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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 : 1.58 ms Après la dernière requête : 37.71 ms Mémoire de requête : 0.033 MB mémoire avant requête : 2.187 MB Rangées retournées : 18

   SHOW FULL COLUMNS 
     FROM `r3w62_extensions`

   Explication

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

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.29 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.00 ms
   executing	0.01 ms
   Opening tables	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   removing tmp table	0.07 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.04 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
   13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
   10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
   9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
   8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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.86 ms Après la dernière requête : 2.47 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.233 MB Rangées retournées : 1

    SELECT `extension_id`
    
      FROM `r3w62_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	r3w62_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.02 ms
    query end	0.00 ms
    ha_commit_one_phase(-1)	0.01 ms
    innobase_commit_low():trx_comm	0.02 ms
    ha_commit_one_phase(-1)	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    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:195
    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 : 1.14 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.030 MB mémoire avant requête : 2.242 MB Rangées retournées : 1
    Requêtes dupliquées: #13

    SELECT *
    
      FROM r3w62_extensions
    
      WHERE `extension_id` = '10063'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	r3w62_extensions	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    innobase_commit_low():trx_comm	0.00 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    ha_commit_one_phase(-1)	0.01 ms
    innobase_commit_low():trx_comm	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    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:195
    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 : 1.09 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.249 MB Rangées retournées : 1

    SELECT `extension_id`
    
      FROM `r3w62_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	r3w62_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    ha_commit_one_phase(-1)	0.01 ms
    innobase_commit_low():trx_comm	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    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:195
    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.81 ms Après la dernière requête : 0.34 ms Mémoire de requête : 0.030 MB mémoire avant requête : 2.256 MB Rangées retournées : 1
    Requêtes dupliquées: #11

    SELECT *
    
      FROM r3w62_extensions
    
      WHERE `extension_id` = '10063'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	r3w62_extensions	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    innobase_commit_low():trx_comm	0.00 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    ha_commit_one_phase(-1)	0.01 ms
    innobase_commit_low():trx_comm	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    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:195
    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 : 1.13 ms Après la dernière requête : 150.25 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.067 MB

    UPDATE `r3w62_extensions`
    
      SET `params` = '{\"mediaversion\":\"1dc25f28972d371bde0705f7c468c9de\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	r3w62_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.05 ms
    updating	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    wsrep in pre-commit stage	0.14 ms
    ha_commit_one_phase(1707753434	0.00 ms
    innobase_commit_low():trx_comm	0.01 ms
    ha_commit_one_phase(1707753434	0.00 ms
    wsrep in pre-commit stage	0.02 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    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 : 1.40 ms Après la dernière requête : 30.57 ms Mémoire de requête : 0.041 MB mémoire avant requête : 3.290 MB Rangées retournées : 3

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

    Explication

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

    Profil

    Status	Duration
    starting	0.15 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.12 ms
    preparing	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.12 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.06 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    ha_commit_one_phase(-1)	0.01 ms
    innobase_commit_low():trx_comm	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
    15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/categories.php:115
    13	ContentModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoriesView.php:56
    11	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.86 ms Après la dernière requête : 37.44 ms Mémoire de requête : 0.024 MB mémoire avant requête : 3.390 MB Rangées retournées : 1

    SELECT language,id
    
      FROM `r3w62_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	r3w62_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	78	100.00	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.14 ms
    end	0.00 ms
    query end	0.00 ms
    ha_commit_one_phase(-1)	0.01 ms
    innobase_commit_low():trx_comm	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.08 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:718
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    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.97 ms Après la dernière requête : 8.08 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.410 MB Rangées retournées : 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `r3w62_menu` AS `c`
    
      INNER JOIN `r3w62_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `r3w62_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `r3w62_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 182

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    ha_commit_one_phase(-1)	0.01 ms
    innobase_commit_low():trx_comm	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:735
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    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 : 1.07 ms Après la dernière requête : 9.86 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.423 MB Rangées retournées : 1

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
    
      FROM `r3w62_categories` AS `c`
    
      INNER JOIN `r3w62_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_categories.item'
    
      INNER JOIN `r3w62_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `r3w62_categories` AS `c2` 
      ON a2.id = c2.`id` 
      AND c2.extension = 'com_content'
    
      WHERE c.id = 108 
      AND c.extension = 'com_content'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
    1	SIMPLE	a2	ref	idx_key	idx_key	765	const	2	100.00	Using where
    1	SIMPLE	c2	eq_ref	PRIMARY,cat_idx	PRIMARY	4	lfh_js.a2.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    ha_commit_one_phase(-1)	0.01 ms
    innobase_commit_low():trx_comm	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    11	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:113
    10	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
    9	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
    8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:750
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    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 : 2.44 ms Après la dernière requête : 14.40 ms Mémoire de requête : 0.046 MB mémoire avant requête : 3.522 MB Rangées retournées : 42

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM r3w62_modules AS m
    
      LEFT JOIN r3w62_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN r3w62_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-08-21 09:46:44') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-08-21 09:46:44') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 182 OR mm.menuid <= 0) 
      AND m.language IN ('fr-FR','*')
    
      ORDER BY m.position, m.ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	53	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	lfh_js.m.module,const	1	100.00	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	lfh_js.m.id	3	100.00	Using where; Using index

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.97 ms
    end	0.00 ms
    query end	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    innobase_commit_low():trx_comm	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
    16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
    15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
    14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:633
    12	T3Template->countModules()	JROOT/templates/ja_university_t3/tpls/blocks/header.php:22
    11	include JROOT/templates/ja_university_t3/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:195
    10	T3Template->loadBlock()	JROOT/templates/ja_university_t3/tpls/no-sidebar.php:36
    9	include JROOT/templates/ja_university_t3/tpls/no-sidebar.php	JROOT/plugins/system/t3/includes/core/template.php:221
    8	T3Template->loadLayout()	JROOT/templates/ja_university_t3/index.php:34
    7	require JROOT/templates/ja_university_t3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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 : 1.00 ms Après la dernière requête : 550.40 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.029 MB Rangées retournées : 1

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM r3w62_modules AS m
    
      WHERE m.id = 110 
      AND m.published = 1 
      AND m.access IN (1,1)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    innobase_commit_low():trx_comm	0.00 ms
    statistics	0.00 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    innobase_commit_low():trx_comm	0.00 ms
    ha_commit_one_phase(-1)	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.04 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:332
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:304
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:259
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:234
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:187
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:86
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

1. 2 × SELECT `extension_id` 
     FROM `r3w62_extensions`

2. 2 × SELECT template 
     FROM r3w62_template_styles as s

3. 2 × SELECT * 
     FROM r3w62_extensions

4. 1 × SELECT `data` 
     FROM `r3w62_session`

5. 1 × SELECT `session_id` 
     FROM `r3w62_session`

6. 1 × SELECT id, rules 
     FROM `r3w62_viewlevels

7. 1 × SELECT b.id 
     FROM r3w62_usergroups AS a 
     LEFT JOIN r3w62_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

8. 1 × SELECT extension, file, type 
     FROM r3w62_rokcommon_configs

9. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`) 
     FROM `r3w62_content` AS `i`

10. 1 × SELECT language,id 
      FROM `r3w62_menu`

11. 1 × SELECT `c2`.`language`,`c2`.`id` 
      FROM `r3w62_menu` AS `c` 
      INNER JOIN `r3w62_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item' 
      INNER JOIN `r3w62_associations` AS `a2` 
      ON a.key = a2.key 
      INNER JOIN `r3w62_menu` AS `c2` 
      ON a2.id = c2.`id`

12. 1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` 
      FROM `r3w62_categories` AS `c` 
      INNER JOIN `r3w62_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_categories.item' 
      INNER JOIN `r3w62_associations` AS `a2` 
      ON a.key = a2.key 
      INNER JOIN `r3w62_categories` AS `c2` 
      ON a2.id = c2.`id` 
      AND c2.extension = 'com_content'

13. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM r3w62_modules AS m 
      LEFT JOIN r3w62_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN r3w62_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

14. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params 
      FROM r3w62_modules AS m

Autres tables :

1. 1 × INSERT INTO `r3w62_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('b6763cea01e28ac39b713dac53b4cb67', 1, '1534844804', 0, '', 0

2. 1 × SHOW FULL COLUMNS 
     FROM `r3w62_extensions

3. 1 × UPDATE `r3w62_extensions` 
     SET `params` = '{\"mediaversion\":\"1dc25f28972d371bde0705f7c468c9de\"}'