{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1540158327,
                "last": 1540158327,
                "now": 1540158327
            },
            "client": {
                "forwarded": "54.198.55.167"
            },
            "token": "cdF7w9VFYCvs1D4zZubhEfZES0w4lOKS"
        },
        "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
        },
        "gantry-current-template": "rt_sirocco",
        "sirocco-0ce53aa2a53f4872359418b862c822b1-name": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-logo-type": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-logo-custom-image": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-accent-color1": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-accent-color2": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-top-textcolor": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-top-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-header-textcolor": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-header-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-header-type": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-showcase-textcolor": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-showcase-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-utility-textcolor": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-utility-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-expandedtop-textcolor": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-expandedtop-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-expandedbottom-textcolor": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-expandedbottom-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-mainbottom-textcolor": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-mainbottom-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-mainbody-overlay": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-extension-textcolor": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-extension-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-bottom-textcolor": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-bottom-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-footer-textcolor": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-footer-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-copyright-background": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-font-family": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-font-size-is": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-menu-type": null,
        "sirocco-0ce53aa2a53f4872359418b862c822b1-layout-mode": null
    }
}

Temps

Mémoire

47 requêtes exécutées 109.83 ms

1. Temps de requête : 0.58 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.339 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `v4_session`
   
     WHERE `session_id` = '2c1afb477fead371cde95ecec2752f90' 
     LIMIT 1

   Explication

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

   Profil

   Status	Duration
   starting	0.04 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.05 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.04 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.05 ms
   logging slow query	0.01 ms
   cleaning up	0.00 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]

   ---

2. Temps de requête : 3.39 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.006 MB mémoire avant requête : 3.349 MB

   INSERT INTO `v4_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('2c1afb477fead371cde95ecec2752f90', 1, '1540158327', 0, '', 0)

   Explication

   EXPLAIN impossible sur la requête : INSERT INTO `v4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('2c1afb477fead371cde95ecec2752f90', 1, '1540158327', 0, '', 0)

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.01 ms
   update	0.07 ms
   Waiting for query cache lock	0.01 ms
   update	0.01 ms
   end	0.00 ms
   query end	3.06 ms
   closing tables	0.03 ms
   freeing items	0.04 ms
   logging slow query	0.00 ms
   cleaning up	0.00 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]

   ---

3. Temps de requête : 0.39 ms Après la dernière requête : 2.61 ms Mémoire de requête : 0.021 MB mémoire avant requête : 3.607 MB Rangées retournées : 43

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `v4_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	v4_extensions	ref	extension	extension	82	const	43	Using where

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.07 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:425
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:433
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:499
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
   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]

   ---

4. Temps de requête : 0.20 ms Après la dernière requête : 2.36 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.853 MB Rangées retournées : 5

   SELECT id, rules
   
     FROM `v4_viewlevels`

   Explication

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

   Profil

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 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:321
   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 : 0.18 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.867 MB Rangées retournées : 2

   SELECT b.id
   
     FROM v4_usergroups AS a
   
     LEFT JOIN v4_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	3	Using where; Using index

   Profil

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.00 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:321
   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 : 0.25 ms Après la dernière requête : 0.69 ms Mémoire de requête : 0.011 MB mémoire avant requête : 3.948 MB Rangées retournées : 96

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM v4_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	v4_extensions	ref	extension	extension	82	const	117	Using where; Utilisation du tri complet de type filesort

   Profil

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 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/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   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]

   ---

7. Temps de requête : 0.33 ms Après la dernière requête : 9.41 ms Mémoire de requête : 0.011 MB mémoire avant requête : 4.542 MB Rangées retournées : 1
   Requêtes dupliquées: #8

   SELECT template
   
     FROM v4_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	Extra
   1	SIMPLE	s	ALL	idx_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	10	Using where

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.06 ms
   logging slow query	0.01 ms
   cleaning up	0.00 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:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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.22 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.553 MB Rangées retournées : 1
   Requêtes dupliquées: #7

   SELECT template
   
     FROM v4_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	Extra
   1	SIMPLE	s	ALL	idx_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	10	Using where

   Profil

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.04 ms
   logging slow query	0.01 ms
   cleaning up	0.00 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:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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 : 0.25 ms Après la dernière requête : 2.35 ms Mémoire de requête : 0.009 MB mémoire avant requête : 4.695 MB Rangées retournées : 4

   SELECT extension, file, type
   
     FROM v4_rokcommon_configs
   
     ORDER BY priority

   Explication

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

   Profil

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.04 ms
   logging slow query	0.01 ms
   cleaning up	0.00 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:131
   8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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]

   ---

10. Temps de requête : 0.24 ms Après la dernière requête : 4.70 ms Mémoire de requête : 0.008 MB mémoire avant requête : 4.962 MB Rangées retournées : 1

    SELECT `enabled`
    
      FROM `v4_extensions`
    
      WHERE `element` = 'com_akeeba' 
      AND `type` = 'component'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.04 ms
    logging slow query	0.01 ms
    cleaning up	0.00 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/plugins/system/backuponupdate/backuponupdate.php:74
    7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
    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]

    ---

11. Temps de requête : 8.90 ms Après la dernière requête : 22.74 ms Mémoire de requête : 0.014 MB mémoire avant requête : 6.061 MB Rangées retournées : 18

    SHOW FULL COLUMNS 
      FROM `v4_extensions`

    Explication

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

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	7.79 ms
    System lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.15 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
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.28 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
    11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
    9	plgSystemRokSprocket->onAfterInitialise()	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: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 : 0.28 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.009 MB mémoire avant requête : 6.114 MB Rangées retournées : 1

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.07 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
    10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:49
    9	plgSystemRokSprocket->onAfterInitialise()	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: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.24 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.012 MB mémoire avant requête : 6.124 MB Rangées retournées : 1
    Requêtes dupliquées: #15

    SELECT *
    
      FROM v4_extensions
    
      WHERE `extension_id` = '10014'

    Explication

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

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.06 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    9	plgSystemRokSprocket->onAfterInitialise()	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: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 : 0.17 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.009 MB mémoire avant requête : 6.132 MB Rangées retournées : 1

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
    10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:72
    9	plgSystemRokSprocket->onAfterInitialise()	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: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]

    ---

15. Temps de requête : 0.22 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.012 MB mémoire avant requête : 6.141 MB Rangées retournées : 1
    Requêtes dupliquées: #13

    SELECT *
    
      FROM v4_extensions
    
      WHERE `extension_id` = '10014'

    Explication

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

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.06 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    9	plgSystemRokSprocket->onAfterInitialise()	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: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]

    ---

16. Temps de requête : 1.53 ms Après la dernière requête : 29.01 ms Mémoire de requête : 0.032 MB mémoire avant requête : 6.845 MB Rangées retournées : 198

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM v4_menu AS m
    
      LEFT JOIN v4_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	236	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.m.component_id	1

    Profil

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.98 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:488
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1070
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    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: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 : 1.01 ms Après la dernière requête : 15.77 ms Mémoire de requête : 0.015 MB mémoire avant requête : 8.037 MB Rangées retournées : 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `v4_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.42 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    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/k2/k2.php:388
    9	plgSystemK2->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:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    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: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 : 3.45 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.010 MB mémoire avant requête : 8.035 MB

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

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.08 ms
    Updating	0.14 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.79 ms
    query end	2.11 ms
    closing tables	0.02 ms
    freeing items	0.10 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->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/k2/k2.php:388
    9	plgSystemK2->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:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    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: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 : 0.28 ms Après la dernière requête : 4.29 ms Mémoire de requête : 0.013 MB mémoire avant requête : 8.334 MB Rangées retournées : 2

    SELECT *
    
      FROM v4_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.04 ms
    logging slow query	0.01 ms
    cleaning up	0.00 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/src/Language/LanguageHelper.php:150
    13	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    12	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
    11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:53
    10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
    9	plgSystemK2->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:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    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: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]

    ---

20. Temps de requête : 0.72 ms Après la dernière requête : 1.57 ms Mémoire de requête : 0.016 MB mémoire avant requête : 8.462 MB Rangées retournées : 8
    Requêtes dupliquées: #26  #27

    SELECT id, home, template, s.params
    
      FROM v4_template_styles as s
    
      LEFT JOIN v4_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using where
    1	SIMPLE	s	ref	idx_template	idx_template	202	leclubdehgv4site.e.element	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.11 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
    20	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
    19	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
    18	Joomla\CMS\HTML\HTMLHelper::script()	Même appel que celui de la ligne ci-dessous.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
    14	JHtmlJquery::framework()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:71
    10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
    9	plgSystemK2->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:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    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: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]

    ---

21. Temps de requête : 0.27 ms Après la dernière requête : 1.84 ms Mémoire de requête : 0.016 MB mémoire avant requête : 8.508 MB Rangées retournées : 82

    SELECT * 
      FROM v4_rokcandy 
      WHERE published=1

    Explication

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

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
    14	RokCandyHelper::getUserMacros()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
    10	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
    9	plgSystemRokCandy->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:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    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: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]

    ---

22. Temps de requête : 0.31 ms Après la dernière requête : 8.55 ms Mémoire de requête : 0.017 MB mémoire avant requête : 9.086 MB Rangées retournées : 43

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `v4_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_fsf','com_fsj_main','com_fsj_transman','com_gantry','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_rokcandy','com_rokgallery','com_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.05 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:113
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
    13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:54
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    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]

    ---

23. Temps de requête : 9.65 ms Après la dernière requête : 2.75 ms Mémoire de requête : 0.020 MB mémoire avant requête : 9.240 MB Rangées retournées : 0

    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 v4_content AS a
    
      INNER JOIN v4_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN v4_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN v4_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN v4_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN v4_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN v4_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-21 21:45:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-21 21:45:27') 
      AND a.catid IN (16)
    
      ORDER BY c.lft, 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 3

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.21 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.10 ms
    init	0.10 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.13 ms
    Creating tmp table	7.59 ms
    executing	0.01 ms
    Copying to tmp table	0.55 ms
    Sorting result	0.09 ms
    Sending data	0.04 ms
    end	0.01 ms
    removing tmp table	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.01 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/MVC/Model/BaseDatabaseModel.php:308
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    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]

    ---

24. Temps de requête : 1.24 ms Après la dernière requête : 1.34 ms Mémoire de requête : 0.013 MB mémoire avant requête : 9.353 MB Rangées retournées : 1

    SELECT COUNT(*)
    
      FROM v4_content AS a
    
      INNER JOIN v4_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN v4_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN v4_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN v4_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN v4_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN v4_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-21 21:45:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-21 21:45:27') 
      AND a.catid IN (16)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	a	index_merge	PRIMARY,idx_access,idx_state,idx_catid	idx_state,idx_catid	1,4	NULL	1	Using intersect(idx_state,idx_catid); Using where
    1	SIMPLE	fp	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.a.id	1	Using where; Using index
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.a.created_by	1	Using index
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.a.modified_by	1	Using index
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.a.id	1	Using index

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.19 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sending data	0.12 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.30 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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/src/MVC/Model/BaseDatabaseModel.php:335
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    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]

    ---

25. Temps de requête : 0.39 ms Après la dernière requête : 5.53 ms Mémoire de requête : 0.015 MB mémoire avant requête : 9.790 MB Rangées retournées : 8

    SELECT id, home, template, params
    
      FROM v4_template_styles
    
      WHERE client_id = 0

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.08 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/gantry.php:148
    18	gantry_getAllTemplates()	JROOT/libraries/gantry/gantry.php:125
    17	gantry_getTemplateById()	JROOT/libraries/gantry/gantry.php:206
    16	gantry_getTemplateParams()	JROOT/libraries/gantry/gantry.php:264
    15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_sirocco/html/com_content/featured/default.php:14
    13	include JROOT/templates/rt_sirocco/html/com_content/featured/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/featured/view.html.php:160
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    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]

    ---

26. Temps de requête : 0.37 ms Après la dernière requête : 9.00 ms Mémoire de requête : 0.017 MB mémoire avant requête : 10.764 MB Rangées retournées : 8
    Requêtes dupliquées: #20  #27

    SELECT id, home, template, s.params
    
      FROM v4_template_styles as s
    
      LEFT JOIN v4_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using where
    1	SIMPLE	s	ref	idx_template	idx_template	202	leclubdehgv4site.e.element	1	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.10 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
    20	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:65
    19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
    18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
    17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
    16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
    15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_sirocco/html/com_content/featured/default.php:14
    13	include JROOT/templates/rt_sirocco/html/com_content/featured/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/featured/view.html.php:160
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    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]

    ---

27. Temps de requête : 0.26 ms Après la dernière requête : 0.93 ms Mémoire de requête : 0.018 MB mémoire avant requête : 10.783 MB Rangées retournées : 8
    Requêtes dupliquées: #20  #26

    SELECT id, home, template, s.params
    
      FROM v4_template_styles as s
    
      LEFT JOIN v4_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using where
    1	SIMPLE	s	ref	idx_template	idx_template	202	leclubdehgv4site.e.element	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
    21	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
    20	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
    19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
    18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
    17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
    16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
    15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_sirocco/html/com_content/featured/default.php:14
    13	include JROOT/templates/rt_sirocco/html/com_content/featured/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/featured/view.html.php:160
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    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]

    ---

28. Temps de requête : 3.08 ms Après la dernière requête : 37.09 ms Mémoire de requête : 0.018 MB mémoire avant requête : 11.893 MB Rangées retournées : 111

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM v4_modules AS m
    
      LEFT JOIN v4_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN v4_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-10-21 21:45:27') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-10-21 21:45:27') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.55 ms
    Sending data	0.21 ms
    Waiting for query cache lock	0.03 ms
    Sending data	0.22 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.04 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.03 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.04 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.03 ms
    Waiting for query cache lock	0.01 ms
    Sending data	1.09 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.03 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
    15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
    13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
    12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
    9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
    8	Gantry->countModules()	JROOT/templates/rt_sirocco/index.php:58
    7	require JROOT/templates/rt_sirocco/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]

    ---

29. Temps de requête : 0.36 ms Après la dernière requête : 6.70 ms Mémoire de requête : 0.014 MB mémoire avant requête : 12.116 MB Rangées retournées : 1

    SELECT ts.template
    
      FROM v4_template_styles AS ts
    
      INNER JOIN v4_menu AS m 
      ON ts.id=m.template_style_id
    
      WHERE m.id = 101 
      AND m.template_style_id != 0

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.05 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_sirocco/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/rt_sirocco/index.php:84
    7	require JROOT/templates/rt_sirocco/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]

    ---

30. Temps de requête : 2.80 ms Après la dernière requête : 27.75 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.611 MB Rangées retournées : 111

    SELECT id, title, module, position, content, showtitle, params, mm.menuid
    
      FROM v4_modules AS m
    
      LEFT JOIN v4_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      WHERE m.published = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-10-21 21:45:27') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-10-21 21:45:27') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY position, ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published	published	1	const	106	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	leclubdehgv4site.m.id	3	Using where; Using index

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sorting result	0.64 ms
    Sending data	0.12 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.19 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.05 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.03 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.05 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.03 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.88 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:171
    20	RokNavMenu::loadModules()	JROOT/templates/rt_sirocco/html/mod_roknavmenu/themes/gantry-dropdown/layout.php:262
    19	GantryDropdownLayout->getModule()	JROOT/templates/rt_sirocco/html/mod_roknavmenu/themes/gantry-dropdown/layout.php:129
    18	GantryDropdownLayout->renderItem()	JROOT/templates/rt_sirocco/html/mod_roknavmenu/themes/gantry-dropdown/layout.php:366
    17	GantryDropdownLayout->renderMenu()	JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenuDefaultRenderer.php:97
    16	RokMenuDefaultRenderer->renderMenu()	JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenu.php:93
    15	RokMenu->renderMenu()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:59
    14	RokNavMenu->render()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:23
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_sirocco/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/rt_sirocco/index.php:84
    7	require JROOT/templates/rt_sirocco/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]

    ---

31. Temps de requête : 11.70 ms Après la dernière requête : 17.09 ms Mémoire de requête : 0.013 MB mémoire avant requête : 12.768 MB Rangées retournées : 5

    SELECT c.*, i.catid, i.title, i.alias, category.alias AS catalias, category.name AS categoryname
                
      FROM v4_k2_comments AS c
                
      LEFT JOIN v4_k2_items AS i 
      ON i.id = c.itemID
                
      LEFT JOIN v4_k2_categories AS category 
      ON category.id = i.catid
                
      WHERE i.published = 1
                    
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-10-21 21:45:27')
                    
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-10-21 21:45:27')
                    
      AND i.trash = 0
                    
      AND i.access IN(1,5)
                    
      AND category.published = 1
                    
      AND category.trash = 0
                    
      AND category.access IN(1,5)
                    
      AND c.published = 1 
      GROUP BY i.id 
      ORDER BY c.commentDate DESC 
      LIMIT 0, 5

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ALL	itemID,published,latestComments,countComments	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	228	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	i	eq_ref	PRIMARY,item,catid	PRIMARY	4	leclubdehgv4site.c.itemID	1	Using where
    1	SIMPLE	category	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	leclubdehgv4site.i.catid	1	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.05 ms
    Creating tmp table	7.41 ms
    executing	0.01 ms
    Copying to tmp table	2.97 ms
    Sorting result	0.18 ms
    Sending data	0.06 ms
    end	0.01 ms
    removing tmp table	0.18 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.04 ms
    logging slow query	0.00 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/modules/mod_k2_comments/helper.php:92
    11	modK2CommentsHelper::getLatestComments()	JROOT/modules/mod_k2_comments/mod_k2_comments.php:49
    10	include JROOT/modules/mod_k2_comments/mod_k2_comments.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

32. Temps de requête : 0.84 ms Après la dernière requête : 31.98 ms Mémoire de requête : 0.017 MB mémoire avant requête : 13.271 MB Rangées retournées : 8

    SELECT id
                            
      FROM v4_k2_categories
                            
      WHERE parent IN (3)
                            
      AND id NOT IN (3) 
                                    
      AND published=1
                                    
      AND trash=0 
      AND access IN(1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_k2_categories	ref	PRIMARY,category,parent,published,access,trash	parent	5	const	11	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.47 ms
    checking query cache for query	0.03 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    22	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:563
    21	K2ModelItemlist->getCategoryTree()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/K2/Filter.php:153
    20	RokSprocket_Provider_K2_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

33. Temps de requête : 0.33 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.017 MB mémoire avant requête : 13.289 MB Rangées retournées : 0

    SELECT id
                            
      FROM v4_k2_categories
                            
      WHERE parent IN (13,14,15,16,26,29,32,34)
                            
      AND id NOT IN (13,14,15,16,26,29,32,34) 
                                    
      AND published=1
                                    
      AND trash=0 
      AND access IN(1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_k2_categories	range	PRIMARY,category,parent,published,access,trash	parent	5	NULL	8	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    22	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:563
    21	K2ModelItemlist->getCategoryTree()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/K2/Filter.php:153
    20	RokSprocket_Provider_K2_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

34. Temps de requête : 0.21 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.017 MB mémoire avant requête : 13.306 MB Rangées retournées : 0

    SELECT id
                            
      FROM v4_k2_categories
                            
      WHERE parent IN (28)
                            
      AND id NOT IN (28) 
                                    
      AND published=1
                                    
      AND trash=0 
      AND access IN(1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_k2_categories	ref	PRIMARY,category,parent,published,access,trash	parent	5	const	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    22	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:563
    21	K2ModelItemlist->getCategoryTree()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/K2/Filter.php:153
    20	RokSprocket_Provider_K2_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

35. Temps de requête : 0.24 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.017 MB mémoire avant requête : 13.323 MB Rangées retournées : 0

    SELECT id
                            
      FROM v4_k2_categories
                            
      WHERE parent IN (4)
                            
      AND id NOT IN (4) 
                                    
      AND published=1
                                    
      AND trash=0 
      AND access IN(1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_k2_categories	ref	PRIMARY,category,parent,published,access,trash	parent	5	const	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    22	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:563
    21	K2ModelItemlist->getCategoryTree()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/K2/Filter.php:153
    20	RokSprocket_Provider_K2_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

36. Temps de requête : 0.19 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.017 MB mémoire avant requête : 13.340 MB Rangées retournées : 0

    SELECT id
                            
      FROM v4_k2_categories
                            
      WHERE parent IN (6)
                            
      AND id NOT IN (6) 
                                    
      AND published=1
                                    
      AND trash=0 
      AND access IN(1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_k2_categories	ref	PRIMARY,category,parent,published,access,trash	parent	5	const	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    22	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:563
    21	K2ModelItemlist->getCategoryTree()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/K2/Filter.php:153
    20	RokSprocket_Provider_K2_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

37. Temps de requête : 0.26 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.017 MB mémoire avant requête : 13.357 MB Rangées retournées : 0

    SELECT id
                            
      FROM v4_k2_categories
                            
      WHERE parent IN (17)
                            
      AND id NOT IN (17) 
                                    
      AND published=1
                                    
      AND trash=0 
      AND access IN(1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_k2_categories	ref	PRIMARY,category,parent,published,access,trash	parent	5	const	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    22	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:563
    21	K2ModelItemlist->getCategoryTree()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/K2/Filter.php:153
    20	RokSprocket_Provider_K2_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

38. Temps de requête : 0.27 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.017 MB mémoire avant requête : 13.373 MB Rangées retournées : 0

    SELECT id
                            
      FROM v4_k2_categories
                            
      WHERE parent IN (31)
                            
      AND id NOT IN (31) 
                                    
      AND published=1
                                    
      AND trash=0 
      AND access IN(1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_k2_categories	ref	PRIMARY,category,parent,published,access,trash	parent	5	const	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    22	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:563
    21	K2ModelItemlist->getCategoryTree()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/K2/Filter.php:153
    20	RokSprocket_Provider_K2_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

39. Temps de requête : 44.32 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.096 MB mémoire avant requête : 13.394 MB Rangées retournées : 175

    SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.published, a.access, a.created, a.modified, a.extra_fields, a.extra_fields_search, a.created_by, a.created_by_alias, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.ordering, a.language, a.metakey, a.metadesc, a.metadata,c.name AS category_title, c.image AS category_image, c.alias as category_alias,CONCAT_WS(",", f.id) AS field_ids, CONCAT_WS(",", f.name) AS field_names,CONCAT_WS(",", t.id) AS tag_ids, CONCAT_WS(",", t.name) AS tag_names,COUNT(co.id) AS comment_count,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
    
      FROM v4_k2_items as a
    
      LEFT JOIN v4_k2_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN v4_k2_extra_fields_groups AS fg 
      ON fg.id = c.extraFieldsGroup
    
      LEFT JOIN v4_k2_extra_fields AS f 
      ON f.
      group = fg.id
    
      LEFT JOIN v4_k2_tags_xref AS tx 
      ON tx.itemID = a.id
    
      LEFT JOIN v4_k2_tags AS t 
      ON t.id = tx.tagID
    
      LEFT JOIN v4_k2_comments AS co 
      ON co.itemID = a.id
    
      LEFT JOIN v4_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN v4_users AS um 
      ON um.id = a.modified_by
    
      LEFT JOIN v4_k2_rating AS v 
      ON a.id = v.itemID
    
      LEFT JOIN v4_viewlevels AS vl 
      ON a.access = vl.id
    
      LEFT JOIN v4_languages AS l 
      ON a.language = l.lang_code
    
      WHERE ((a.access IN(1,1,5) 
      AND a.trash = 0 
      AND a.published = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-21 21:45:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-21 21:45:27')) 
      AND a.id IN (14)) OR ((a.access IN(1,1,5) 
      AND a.trash = 0 
      AND a.published = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-21 21:45:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-21 21:45:27')) 
      AND (a.catid IN (3,13,14,15,16,26,29,32,34) OR a.catid IN (28) OR a.catid IN (4) OR a.catid IN (6) OR a.catid IN (17) OR a.catid IN (31)))
    
      GROUP BY a.id
    
      ORDER BY a.created DESC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	PRIMARY,item,catid	item	10	NULL	931	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.a.catid	1
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.c.extraFieldsGroup	1	Using index
    1	SIMPLE	f	ref	group	group	4	leclubdehgv4site.fg.id	1
    1	SIMPLE	tx	ref	itemID	itemID	4	leclubdehgv4site.a.id	1
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.tx.tagID	1
    1	SIMPLE	co	ref	itemID,countComments	itemID	4	leclubdehgv4site.a.id	1	Using index
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.a.created_by	1
    1	SIMPLE	um	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.a.modified_by	1
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.a.id	1
    1	SIMPLE	vl	eq_ref	PRIMARY	PRIMARY	4	leclubdehgv4site.a.access	1
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	func	1

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.17 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.06 ms
    init	0.19 ms
    optimizing	0.10 ms
    statistics	0.14 ms
    preparing	0.05 ms
    Creating tmp table	6.31 ms
    executing	0.01 ms
    Copying to tmp table	23.21 ms
    Sorting result	0.68 ms
    Sending data	0.17 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.18 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.28 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.08 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.24 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.07 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.28 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.22 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.13 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.40 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.12 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.45 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.07 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.30 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.11 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.15 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.01 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.11 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.06 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.11 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.04 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.09 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.08 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.09 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.07 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.19 ms
    Waiting for query cache lock	0.01 ms
    Sending data	8.28 ms
    end	0.01 ms
    removing tmp table	0.33 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

40. Temps de requête : 0.66 ms Après la dernière requête : 176.09 ms Mémoire de requête : 0.020 MB mémoire avant requête : 15.784 MB Rangées retournées : 70

    SELECT id, name,  parent  
      FROM v4_k2_categories 
      WHERE published=1  
      AND trash=0 
      AND access IN(1,1,5) 
      ORDER BY parent

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v4_k2_categories	ref	category,published,access,trash	category	2	const	71	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    starting	0.19 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.09 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1077
    23	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:314
    22	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:41
    21	K2HelperRoute::getItemRoute()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/K2.php:169
    20	RokSprocket_Provider_K2->convertRawToItem()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:83
    19	RokSprocket_Provider_AbstarctJoomlaBasedProvider->convertRawToItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:63
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

41. Temps de requête : 0.92 ms Après la dernière requête : 212.15 ms Mémoire de requête : 0.018 MB mémoire avant requête : 16.255 MB Rangées retournées : 123

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM v4_roksprocket_items as i
    
      WHERE i.module_id = '327' 
      AND i.provider = 'k2'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	123	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.16 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
    19	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

42. Temps de requête : 0.37 ms Après la dernière requête : 132.53 ms Mémoire de requête : 0.017 MB mémoire avant requête : 13.969 MB Rangées retournées : 1

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM v4_roksprocket_items as i
    
      WHERE i.module_id = '302' 
      AND i.provider = 'simple'
    
      ORDER BY i.
      order

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module_order	137	const	1	Using where

    Profil

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.07 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:37
    20	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    19	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    18	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

43. Temps de requête : 0.24 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.017 MB mémoire avant requête : 13.990 MB Rangées retournées : 1

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM v4_roksprocket_items as i
    
      WHERE i.module_id = '302' 
      AND i.provider = 'simple'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	1	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.05 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:59
    21	RokSprocket_Provider_Simple_Storage_Joomla->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:40
    20	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    19	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    18	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

44. Temps de requête : 0.57 ms Après la dernière requête : 8.60 ms Mémoire de requête : 0.017 MB mémoire avant requête : 14.021 MB Rangées retournées : 9

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM v4_roksprocket_items as i
    
      WHERE i.module_id = '301' 
      AND i.provider = 'simple'
    
      ORDER BY i.
      order

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module_order	137	const	9	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.07 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:37
    20	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    19	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    18	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

45. Temps de requête : 0.30 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.018 MB mémoire avant requête : 14.064 MB Rangées retournées : 9

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM v4_roksprocket_items as i
    
      WHERE i.module_id = '301' 
      AND i.provider = 'simple'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	9	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.05 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:59
    21	RokSprocket_Provider_Simple_Storage_Joomla->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:40
    20	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    19	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    18	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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: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]

    ---

46. Temps de requête : 6.63 ms Après la dernière requête : 15.44 ms Mémoire de requête : 0.018 MB mémoire avant requête : 14.139 MB Rangées retournées : 6

    SHOW FULL COLUMNS 
      FROM `v4_template_styles`

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	5.88 ms
    System lock	0.02 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.12 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.10 ms
    closing tables	0.00 ms
    freeing items	0.06 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    17	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
    16	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
    15	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
    14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    13	plgSystemGantry->onBeforeCompileHead()	Même appel que celui de la ligne ci-dessous.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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]

    ---

47. Temps de requête : 0.27 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.014 MB mémoire avant requête : 14.164 MB Rangées retournées : 1

    SELECT *
    
      FROM v4_template_styles
    
      WHERE `id` = '27'

    Explication

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

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    15	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
    14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    13	plgSystemGantry->onBeforeCompileHead()	Même appel que celui de la ligne ci-dessous.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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]

    ---