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

Temps

Mémoire

31 requêtes exécutées 100.32 ms

1. Temps de requête : 0.72 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.412 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `jnew_session`
   
     WHERE `session_id` = 'e3f06ac0568b9f6072b224788c592108'

   Explication

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

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.09 ms
   System lock	0.01 ms
   init	0.01 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.02 ms
   freeing items	0.02 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:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Temps de requête : 0.94 ms Après la dernière requête : 1.30 ms Mémoire de requête : 0.013 MB mémoire avant requête : 4.588 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `jnew_session`
   
     WHERE `session_id` = 'e3f06ac0568b9f6072b224788c592108' 
     LIMIT 1

   Explication

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

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 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:1734
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Temps de requête : 1.56 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.010 MB mémoire avant requête : 4.605 MB

   INSERT INTO `jnew_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('e3f06ac0568b9f6072b224788c592108', 1, 1548317759, 0, '', 0)

   Explication

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

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.01 ms
   update	0.04 ms
   Waiting for query cache lock	0.00 ms
   update	0.01 ms
   end	0.00 ms
   query end	0.65 ms
   closing tables	0.01 ms
   freeing items	0.02 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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Temps de requête : 3.63 ms Après la dernière requête : 2.67 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.940 MB Rangées retournées : 40

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jnew_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	jnew_extensions	ref	extension	extension	82	const	40	Using where

   Profil

   Status	Duration
   starting	0.16 ms
   checking permissions	0.01 ms
   Opening tables	0.15 ms
   System lock	0.01 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.83 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.25 ms
   logging slow query	0.01 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Temps de requête : 1.06 ms Après la dernière requête : 2.04 ms Mémoire de requête : 0.014 MB mémoire avant requête : 5.252 MB Rangées retournées : 3

   SELECT id, rules
   
     FROM `jnew_viewlevels`

   Explication

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

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.08 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.03 ms
   freeing items	0.02 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:1500
   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:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Temps de requête : 1.59 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.015 MB mémoire avant requête : 5.275 MB Rangées retournées : 1

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

   Explication

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

   Profil

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.14 ms
   System lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	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:1544
   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:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   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 : 2.02 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.019 MB mémoire avant requête : 5.377 MB Rangées retournées : 99

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

   Explication

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

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sorting result	0.25 ms
   Sending data	0.20 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.08 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:1695
   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:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   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 : 2.43 ms Après la dernière requête : 8.31 ms Mémoire de requête : 0.013 MB mémoire avant requête : 6.489 MB Rangées retournées : 1

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

   Explication

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

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 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:1734
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
   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:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   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 : 10.66 ms Après la dernière requête : 16.84 ms Mémoire de requête : 0.033 MB mémoire avant requête : 8.040 MB Rangées retournées : 29
   Requêtes dupliquées: #29  #30

   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 jnew_menu AS m
   
     LEFT JOIN jnew_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	ALL	idx_client_id_parent_id_alias_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	135	Using where; Utilisation du tri complet de type filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db614869858.m.component_id	1

   Profil

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.10 ms
   System lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sorting result	0.09 ms
   Sending data	4.37 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.07 ms
   logging slow query	0.00 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:1695
   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:375
   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:491
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   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 : 2.45 ms Après la dernière requête : 12.01 ms Mémoire de requête : 0.017 MB mémoire avant requête : 9.070 MB Rangées retournées : 1

    SELECT id
    
      FROM `jnew_tags`
    
      WHERE `alias` = 'capoeira'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_tags	ref	idx_alias	idx_alias	402	const	1	Using where

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 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:1734
    11	JDatabaseDriver->loadResult()	JROOT/components/com_tags/router.php:179
    10	TagsRouter->fixSegment()	JROOT/components/com_tags/router.php:147
    9	TagsRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 2.84 ms Après la dernière requête : 0.97 ms Mémoire de requête : 0.020 MB mémoire avant requête : 9.140 MB Rangées retournées : 1

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

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.09 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 4.11 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.013 MB mémoire avant requête : 9.142 MB

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

    Explication

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

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.10 ms
    Updating	0.07 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.99 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

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

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

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 5.01 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.010 MB mémoire avant requête : 9.465 MB Rangées retournées : 7

    SELECT id, home, template, s.params
    
      FROM jnew_template_styles as s
    
      LEFT JOIN jnew_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	s	ALL	idx_template	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	11	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db614869858.s.template,const	1	Using where

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 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
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 9.95 ms Après la dernière requête : 10.86 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.664 MB Rangées retournées : 16

    SELECT *
    
      FROM `jnew_content_types`

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.16 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    logging slow query	0.00 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:1500
    18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Helper/TagsHelper.php:794
    17	Joomla\CMS\Helper\TagsHelper::getTypes()	JROOT/libraries/src/Helper/TagsHelper.php:628
    16	Joomla\CMS\Helper\TagsHelper->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:149
    15	TagsModelTag->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
    12	TagsModelTag->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:93
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 7.80 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.689 MB Rangées retournées : 0

    SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
    
      FROM jnew_contentitem_tag_map AS m
    
      INNER JOIN jnew_ucm_content AS c 
      ON m.type_alias = c.core_type_alias 
      AND m.core_content_id = c.core_content_id 
      AND c.core_state IN (1) 
      AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2019-01-24 08:15:59')  
      AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2019-01-24 08:15:59')
    
      INNER JOIN jnew_content_types AS ct 
      ON ct.type_alias = m.type_alias
    
      LEFT JOIN jnew_categories AS tc 
      ON tc.id = c.core_catid
    
      LEFT JOIN jnew_users AS ua 
      ON ua.id = c.core_created_user_id
    
      WHERE m.tag_id IN (2) 
      AND (c.core_catid = 0 OR tc.published = 1) 
      AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_eventgallery.category') 
      AND c.core_access IN (0,1)
    
      GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
    
      ORDER BY MAX(`c`.`core_title`) ASC 
      LIMIT 20

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	3	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	ct	ref	idx_alias	idx_alias	402	db614869858.m.type_alias	1	Using where
    1	SIMPLE	c	ALL	PRIMARY,tag_idx,idx_access,idx_content_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where; Using join buffer
    1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	db614869858.c.core_catid	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db614869858.c.core_created_user_id	1

    Profil

    Status	Duration
    starting	0.27 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.47 ms
    System lock	0.01 ms
    init	0.20 ms
    optimizing	0.05 ms
    statistics	0.15 ms
    preparing	0.09 ms
    Creating tmp table	0.49 ms
    executing	0.03 ms
    Copying to tmp table	0.23 ms
    Sorting result	0.04 ms
    Sending data	0.06 ms
    end	0.01 ms
    removing tmp table	0.20 ms
    end	0.05 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.09 ms
    logging slow query	0.02 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:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
    12	TagsModelTag->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:93
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 7.16 ms Après la dernière requête : 3.09 ms Mémoire de requête : 0.029 MB mémoire avant requête : 11.106 MB Rangées retournées : 30

    SHOW FULL COLUMNS 
      FROM `jnew_tags`

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.27 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    Opening tables	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.11 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.00 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:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:29
    14	TagsTableTag->__construct()	JROOT/libraries/src/Table/Table.php:312
    13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_tags/models/tag.php:272
    12	TagsModelTag->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:94
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 4.94 ms Après la dernière requête : 3.04 ms Mémoire de requête : 0.027 MB mémoire avant requête : 11.296 MB Rangées retournées : 1
    Requêtes dupliquées: #20

    SELECT *
    
      FROM jnew_tags
    
      WHERE `id` = '2'

    Explication

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

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    13	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:281
    12	TagsModelTag->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:94
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 7.26 ms Après la dernière requête : 3.36 ms Mémoire de requête : 0.025 MB mémoire avant requête : 11.484 MB Rangées retournées : 0

    SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
    
      FROM jnew_contentitem_tag_map AS m
    
      INNER JOIN jnew_ucm_content AS c 
      ON m.type_alias = c.core_type_alias 
      AND m.core_content_id = c.core_content_id 
      AND c.core_state IN (1) 
      AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2019-01-24 08:15:59')  
      AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2019-01-24 08:15:59')
    
      INNER JOIN jnew_content_types AS ct 
      ON ct.type_alias = m.type_alias
    
      LEFT JOIN jnew_categories AS tc 
      ON tc.id = c.core_catid
    
      LEFT JOIN jnew_users AS ua 
      ON ua.id = c.core_created_user_id
    
      WHERE m.tag_id IN (2) 
      AND (c.core_catid = 0 OR tc.published = 1) 
      AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_eventgallery.category') 
      AND c.core_access IN (0,1)
    
      GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
    
      ORDER BY MAX(`c`.`core_title`) ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	3	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	ct	ref	idx_alias	idx_alias	402	db614869858.m.type_alias	1	Using where
    1	SIMPLE	c	ALL	PRIMARY,tag_idx,idx_access,idx_content_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where; Using join buffer
    1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	db614869858.c.core_catid	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db614869858.c.core_created_user_id	1

    Profil

    Status	Duration
    starting	0.23 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.15 ms
    optimizing	0.04 ms
    statistics	0.06 ms
    preparing	0.05 ms
    Creating tmp table	0.50 ms
    executing	0.00 ms
    Copying to tmp table	0.17 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    end	0.00 ms
    removing tmp table	0.10 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
    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:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:97
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 2.54 ms Après la dernière requête : 17.73 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.753 MB Rangées retournées : 1
    Requêtes dupliquées: #18

    SELECT *
    
      FROM jnew_tags
    
      WHERE `id` = '2'

    Explication

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

    Profil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.08 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    12	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:336
    11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:245
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.75 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.016 MB mémoire avant requête : 12.769 MB

    UPDATE jnew_tags
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '2'

    Explication

    EXPLAIN impossible sur la requête : UPDATE jnew_tags SET `hits` = (`hits` + 1) WHERE `id` = '2'

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.21 ms
    Updating	0.13 ms
    end	0.09 ms
    Waiting for query cache lock	0.01 ms
    end	0.01 ms
    query end	0.90 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
    12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_tags/models/tag.php:337
    11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:245
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.70 ms Après la dernière requête : 27.11 ms Mémoire de requête : 0.039 MB mémoire avant requête : 13.309 MB Rangées retournées : 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jnew_fields AS a
    
      LEFT JOIN `jnew_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jnew_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jnew_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jnew_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jnew_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_tag.tag' 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	db614869858.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	db614869858.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	db614869858.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db614869858.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	db614869858.a.group_id	1	Using where

    Profil

    Status	Duration
    starting	0.22 ms
    checking permissions	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.48 ms
    System lock	0.06 ms
    init	0.09 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.06 ms
    executing	0.04 ms
    Sorting result	0.07 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.04 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
    21	PlgSystemFields->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    20	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Même appel que celui de la ligne ci-dessous.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_tags/views/tag/tmpl/default.php:25
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    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_tags/views/tag/view.html.php:249
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.60 ms Après la dernière requête : 9.24 ms Mémoire de requête : 0.031 MB mémoire avant requête : 14.244 MB Rangées retournées : 40

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jnew_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_allvideoshare','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventgallery','com_fields','com_finder','com_installer','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_vertexupdate','com_weblinks','com_wrapper')

    Explication

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

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.38 ms
    end	0.01 ms
    query end	0.00 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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    16	Joomla\CMS\User\User->authorise()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:20
    15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    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_tags/views/tag/view.html.php:249
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 2.75 ms Après la dernière requête : 4.59 ms Mémoire de requête : 0.017 MB mémoire avant requête : 14.725 MB Rangées retournées : 1

    SELECT * 
      FROM jnew_template_styles 
      WHERE template = 'forte';

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_template_styles	ref	idx_template	idx_template	202	const	1	Using where

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	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:1500
    10	JDatabaseDriver->loadAssocList()	JROOT/templates/forte/vertex/parameters.php:20
    9	getTemplateName()	JROOT/templates/forte/vertex/parameters.php:169
    8	require_once JROOT/templates/forte/vertex/parameters.php	JROOT/templates/forte/index.php:21
    7	require JROOT/templates/forte/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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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 : 3.12 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.021 MB mémoire avant requête : 14.742 MB Rangées retournées : 1

    SELECT * 
      FROM jnew_menu 
      WHERE template_style_id IN (37) 
      LIMIT 1

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	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:1500
    10	JDatabaseDriver->loadAssocList()	JROOT/templates/forte/vertex/parameters.php:45
    9	getTemplateName()	JROOT/templates/forte/vertex/parameters.php:169
    8	require_once JROOT/templates/forte/vertex/parameters.php	JROOT/templates/forte/index.php:21
    7	require JROOT/templates/forte/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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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 : 1.44 ms Après la dernière requête : 5.75 ms Mémoire de requête : 0.023 MB mémoire avant requête : 15.287 MB Rangées retournées : 6

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jnew_modules AS m
    
      LEFT JOIN jnew_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jnew_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 <= '2019-01-24 08:15:59') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-01-24 08:15:59') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 0 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	27	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db614869858.m.module,const	1	Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db614869858.m.id	5	Using where; Using index

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.14 ms
    System lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.14 ms
    Sending data	0.27 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    logging slow query	0.00 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:1695
    15	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/forte/vertex/module_calcs.php:41
    8	require_once JROOT/templates/forte/vertex/module_calcs.php	JROOT/templates/forte/index.php:23
    7	require JROOT/templates/forte/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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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 : 1.40 ms Après la dernière requête : 3.96 ms Mémoire de requête : 0.017 MB mémoire avant requête : 15.169 MB Rangées retournées : 0
    Requêtes dupliquées: #28

    SELECT menutype  
      FROM  jnew_menu 
      WHERE language = 'fr-FR' 
      AND home = 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_menu	ref	idx_language	idx_language	28	const	1	Using where

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 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:1734
    11	JDatabaseDriver->loadResult()	JROOT/templates/forte/vertex/responsive/responsive_mobile_menu.php:284
    10	include JROOT/templates/forte/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/forte/vertex/responsive/responsive_mobile_sidebar.php:70
    9	require JROOT/templates/forte/vertex/responsive/responsive_mobile_sidebar.php	JROOT/templates/forte/vertex/includes/vertex_includes_top.php:4
    8	require_once JROOT/templates/forte/vertex/includes/vertex_includes_top.php	JROOT/templates/forte/index.php:124
    7	require JROOT/templates/forte/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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Temps de requête : 0.70 ms Après la dernière requête : 4.21 ms Mémoire de requête : 0.015 MB mémoire avant requête : 15.429 MB Rangées retournées : 0
    Requêtes dupliquées: #27

    SELECT menutype  
      FROM  jnew_menu 
      WHERE language = 'fr-FR' 
      AND home = 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_menu	ref	idx_language	idx_language	28	const	1	Using where

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 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:1734
    9	JDatabaseDriver->loadResult()	JROOT/templates/forte/vertex/s5flex_menu/default.php:89
    8	include JROOT/templates/forte/vertex/s5flex_menu/default.php	JROOT/templates/forte/index.php:180
    7	require JROOT/templates/forte/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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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 : 1.73 ms Après la dernière requête : 1.61 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.701 MB Rangées retournées : 29
    Requêtes dupliquées: #9  #30

    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 jnew_menu AS m
    
      LEFT JOIN jnew_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	ALL	idx_client_id_parent_id_alias_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	135	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db614869858.m.component_id	1

    Profil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sorting result	0.24 ms
    Sending data	0.28 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    16	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	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/Menu/SiteMenu.php:101
    13	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    12	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    11	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/templates/forte/vertex/s5flex_menu/helpers.php:75
    10	S5modMainMenuHelper::getList()	JROOT/templates/forte/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/forte/vertex/s5flex_menu/default.php:107
    8	include JROOT/templates/forte/vertex/s5flex_menu/default.php	JROOT/templates/forte/index.php:180
    7	require JROOT/templates/forte/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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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 : 1.10 ms Après la dernière requête : 0.53 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.895 MB Rangées retournées : 29
    Requêtes dupliquées: #9  #29

    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 jnew_menu AS m
    
      LEFT JOIN jnew_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	ALL	idx_client_id_parent_id_alias_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	135	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db614869858.m.component_id	1

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.07 ms
    Sending data	0.26 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.09 ms
    logging slow query	0.00 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:1695
    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/templates/forte/vertex/s5flex_menu/helpers.php:78
    10	S5modMainMenuHelper::getList()	JROOT/templates/forte/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/forte/vertex/s5flex_menu/default.php:107
    8	include JROOT/templates/forte/vertex/s5flex_menu/default.php	JROOT/templates/forte/index.php:180
    7	require JROOT/templates/forte/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:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Temps de requête : 0.73 ms Après la dernière requête : 6.24 ms Mémoire de requête : 0.036 MB mémoire avant requête : 15.901 MB Rangées retournées : 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jnew_fields AS a
    
      LEFT JOIN `jnew_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jnew_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jnew_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jnew_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jnew_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_custom.content' 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	db614869858.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	db614869858.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	db614869858.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db614869858.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	db614869858.a.group_id	1	Using where

    Profil

    Status	Duration
    starting	0.09 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
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
    18	PlgSystemFields->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
    17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	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:111
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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]

    ---