Console de débogage Joomla!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1606743865,
                "last": 1606743865,
                "now": 1606743865
            }
        },
        "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

71 requêtes exécutées 113.14 ms

1. Temps de requête : 0.62 ms Mémoire de requête : 0.018 MB mémoire avant requête : 2.978 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `jevnew_session`
   
     WHERE `session_id` = 'f0c138f927827ebfce4570ecca902e1c'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jevnew_session	const	PRIMARY	PRIMARY	766	const	1

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.18 ms
   checking query cache for query	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.10 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 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.02 ms
   logging slow query	0.00 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:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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 : 1.20 ms Après la dernière requête : 2.64 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.184 MB

   DELETE 
   
     FROM `jevnew_session`
   
     WHERE `time` < '1606742965'

   Explication

   EXPLAIN impossible sur la requête : DELETE FROM `jevnew_session` WHERE `time` < '1606742965'

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.03 ms
   updating	0.25 ms
   end	0.00 ms
   Waiting for query cache lock	0.00 ms
   end	0.01 ms
   query end	0.62 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
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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.58 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.196 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `jevnew_session`
   
     WHERE `session_id` = 'f0c138f927827ebfce4570ecca902e1c' 
     LIMIT 1

   Explication

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

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.02 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.00 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.01 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/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Temps de requête : 0.74 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.211 MB

   INSERT INTO `jevnew_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('f0c138f927827ebfce4570ecca902e1c', 0, 1, '1606743865', 0, '')

   Explication

   EXPLAIN impossible sur la requête : INSERT INTO `jevnew_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('f0c138f927827ebfce4570ecca902e1c', 0, 1, '1606743865', 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.03 ms
   Waiting for query cache lock	0.00 ms
   update	0.01 ms
   end	0.00 ms
   query end	0.48 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/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

5. Temps de requête : 0.62 ms Après la dernière requête : 2.68 ms Mémoire de requête : 0.017 MB mémoire avant requête : 3.466 MB Rangées retournées : 39

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jevnew_extensions`
   
     WHERE `type` = 'component'

   Explication

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

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.06 ms
   System lock	0.01 ms
   Waiting for query cache 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.13 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.02 ms
   freeing items	0.00 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.00 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.45 ms Après la dernière requête : 2.05 ms Mémoire de requête : 0.015 MB mémoire avant requête : 3.671 MB Rangées retournées : 1

   SELECT b.id
   
     FROM jevnew_usergroups AS a
   
     LEFT JOIN jevnew_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.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.10 ms
   System lock	0.01 ms
   Waiting for query cache 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.02 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.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:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.45 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.014 MB mémoire avant requête : 3.747 MB Rangées retournées : 3

   SELECT id, rules
   
     FROM `jevnew_viewlevels`

   Explication

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

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.06 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.03 ms
   init	0.01 ms
   optimizing	0.00 ms
   statistics	0.00 ms
   preparing	0.00 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.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.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:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.79 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.014 MB mémoire avant requête : 3.765 MB Rangées retournées : 52

   SELECT folder AS type, element AS name, params
   
     FROM jevnew_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	jevnew_extensions	ref	extension	extension	82	const	76	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.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.02 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sorting result	0.18 ms
   Sending data	0.11 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.00 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/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Temps de requête : 1.38 ms Après la dernière requête : 28.38 ms Mémoire de requête : 0.028 MB mémoire avant requête : 5.613 MB Rangées retournées : 23

   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 jevnew_menu AS m
   
     LEFT JOIN jevnew_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	79	Using where; Utilisation du tri complet de type filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db673244344.m.component_id	1

   Profil

   Status	Duration
   starting	0.03 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.05 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.11 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sorting result	0.18 ms
   Sending data	0.11 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.31 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.02 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.01 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:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.66 ms Après la dernière requête : 8.14 ms Mémoire de requête : 0.018 MB mémoire avant requête : 6.307 MB Rangées retournées : 9

    SELECT id, home, template, s.params
    
      FROM jevnew_template_styles as s
    
      LEFT JOIN jevnew_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	15	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db673244344.s.template,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.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.03 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.02 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    12	JApplicationSite->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
    11	jsn_template_framework_class_loader()	Même appel que celui de la ligne ci-dessous.
    10	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:162
    9	PlgSystemJSNTPLFramework->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Temps de requête : 1.28 ms Après la dernière requête : 1.78 ms Mémoire de requête : 0.019 MB mémoire avant requête : 6.390 MB Rangées retournées : 1

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.04 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.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.08 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 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:1650
    13	JDatabaseDriver->loadObject()	Même appel que celui de la ligne ci-dessous.
    12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 2.28 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.012 MB mémoire avant requête : 6.392 MB

    UPDATE `jevnew_extensions`
    
      SET `params` = '{\"mediaversion\":\"2eb1aafc1e75f2635e815ad28fc03e51\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.04 ms
    Updating	0.04 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.08 ms
    query end	1.26 ms
    closing tables	0.01 ms
    freeing items	0.05 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/cms/library/helper.php:119
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.67 ms Après la dernière requête : 2.72 ms Mémoire de requête : 0.014 MB mémoire avant requête : 6.639 MB Rangées retournées : 2

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_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.01 ms
    checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.15 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.06 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.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.04 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:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.91 ms Après la dernière requête : 28.85 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.458 MB Rangées retournées : 1

    SELECT a.*
    
      FROM jevnew_xmap_sitemap AS a
    
      WHERE a.id = 1 
      AND a.state = 1 
      AND a.access IN (1,1)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	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.03 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.05 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.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.07 ms
    logging slow query	0.00 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:1650
    13	JDatabaseDriver->loadObject()	JROOT/components/com_xmap/models/sitemap.php:109
    12	XmapModelSitemap->getItem()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:46
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.90 ms Après la dernière requête : 0.36 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.491 MB Rangées retournées : 11

    SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
    
      FROM jevnew_menu AS n
    
      INNER JOIN  jevnew_menu AS p 
      ON p.lft = 0
    
      WHERE n.lft > p.lft 
      AND n.lft < p.rgt 
      AND n.menutype = 'menu_lateral' 
      AND n.published = 1 
      AND n.access IN (1,1)
    
      ORDER BY n.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n	ref	idx_menutype,idx_left_right	idx_menutype	98	const	48	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	p	ref	idx_left_right	idx_left_right	4	const	1	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.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.13 ms
    Sending data	0.08 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 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.03 ms
    logging slow query	0.00 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:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_xmap/helpers/xmap.php:61
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Temps de requête : 0.59 ms Après la dernière requête : 0.49 ms Mémoire de requête : 0.026 MB mémoire avant requête : 7.577 MB Rangées retournées : 2

    SELECT *
    
      FROM jevnew_extensions AS n
    
      WHERE n.folder = 'xmap' 
      AND n.enabled = 1

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.04 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.19 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.00 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:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_xmap/helpers/xmap.php:131
    15	XmapHelper::getExtensions()	JROOT/components/com_xmap/helpers/xmap.php:154
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.14 ms Après la dernière requête : 3.28 ms Mémoire de requête : 0.029 MB mémoire avant requête : 7.839 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=60

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.01 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.00 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Temps de requête : 1.01 ms Après la dernière requête : 0.54 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.883 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=104

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.40 ms
    preparing	0.05 ms
    executing	0.02 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 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.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.07 ms
    logging slow query	0.02 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.66 ms Après la dernière requête : 0.48 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.921 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=142

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 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.01 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.69 ms Après la dernière requête : 0.50 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.959 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=112

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	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.03 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.79 ms Après la dernière requête : 0.45 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.997 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=105

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.00 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.00 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.46 ms Après la dernière requête : 0.45 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.034 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=106

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.05 ms
    init	0.08 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.02 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.06 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    logging slow query	0.04 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.16 ms Après la dernière requête : 0.49 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.072 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=107

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.14 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.02 ms
    Sending data	0.01 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.06 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.15 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.112 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=108

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 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.00 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.88 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.149 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=158

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 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.00 ms
    closing tables	0.01 ms
    freeing items	0.00 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.00 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.01 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.187 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=150

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 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.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.04 ms Après la dernière requête : 0.46 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.225 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=109

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.00 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.00 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 1.58 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.241 MB Rangées retournées : 4

    SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
    
      FROM jevnew_menu AS n
    
      INNER JOIN  jevnew_menu AS p 
      ON p.lft = 0
    
      WHERE n.lft > p.lft 
      AND n.lft < p.rgt 
      AND n.menutype = 'menu_superieur' 
      AND n.published = 1 
      AND n.access IN (1,1)
    
      ORDER BY n.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n	ref	idx_menutype,idx_left_right	idx_menutype	98	const	21	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	p	ref	idx_left_right	idx_left_right	4	const	1	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.06 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.11 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 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.00 ms
    logging slow query	0.00 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:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_xmap/helpers/xmap.php:61
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.70 ms Après la dernière requête : 0.53 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.292 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=170

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	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.05 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.00 ms
    storing result in query cache	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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.83 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.330 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=113

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.06 ms
    checking query cache for query	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.00 ms
    storing result in query cache	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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 1.51 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.365 MB Rangées retournées : 2

    SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
    
      FROM jevnew_menu AS n
    
      INNER JOIN  jevnew_menu AS p 
      ON p.lft = 0
    
      WHERE n.lft > p.lft 
      AND n.lft < p.rgt 
      AND n.menutype = 'pied_de_page' 
      AND n.published = 1 
      AND n.access IN (1,1)
    
      ORDER BY n.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n	ref	idx_menutype,idx_left_right	idx_menutype	98	const	4	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	p	ref	idx_left_right	idx_left_right	4	const	1	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.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.06 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 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.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.05 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:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_xmap/helpers/xmap.php:61
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.77 ms Après la dernière requête : 0.55 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.412 MB Rangées retournées : 1

    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `jevnew_content`
    
      WHERE `id`=81

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 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.04 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:82
    15	xmap_com_content::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:159
    14	XmapHelper::prepareMenuItem()	JROOT/components/com_xmap/helpers/xmap.php:94
    13	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
    12	XmapModelSitemap->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_xmap/views/html/view.html.php:47
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Temps de requête : 1.64 ms Après la dernière requête : 2.98 ms Mémoire de requête : 0.029 MB mémoire avant requête : 8.725 MB Rangées retournées : 8

    SHOW FULL COLUMNS 
      FROM `jevnew_assets`

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.23 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.10 ms
    checking permissions	0.04 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
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.07 ms
    closing tables	0.00 ms
    freeing items	0.02 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:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    16	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    15	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    14	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    13	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    12	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    11	JUser->authorise()	JROOT/components/com_xmap/views/html/view.html.php:50
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 1.25 ms Après la dernière requête : 0.93 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.795 MB Rangées retournées : 1

    SELECT *
    
      FROM jevnew_assets
    
      WHERE `id` = '1'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_assets	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	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.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:1453
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    14	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    13	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    12	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    11	JUser->authorise()	JROOT/components/com_xmap/views/html/view.html.php:50
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Temps de requête : 1.55 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.812 MB Rangées retournées : 1

    SELECT a.rules
    
      FROM jevnew_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache 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.07 ms
    end	0.01 ms
    query end	0.01 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.02 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    12	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    11	JUser->authorise()	JROOT/components/com_xmap/views/html/view.html.php:50
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 1.93 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.866 MB Rangées retournées : 39

    SELECT element
    
      FROM jevnew_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache 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.10 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 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.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:1538
    15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    14	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    13	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    12	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    11	JUser->authorise()	JROOT/components/com_xmap/views/html/view.html.php:50
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 2.51 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.894 MB Rangées retournées : 37

    SELECT a.name, a.rules
    
      FROM jevnew_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_avreloaded','com_banners','com_cache','com_categories','com_checkin','com_chronoforms','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativeimageslider','com_djimageslider','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap') OR a.name = 'root.1')

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.52 ms
    end	0.01 ms
    query end	0.01 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.00 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:1494
    15	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    14	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    13	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    12	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    11	JUser->authorise()	JROOT/components/com_xmap/views/html/view.html.php:50
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 1.60 ms Après la dernière requête : 6.92 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.460 MB Rangées retournées : 1

    SELECT * 
      FROM jevnew_modules 
      WHERE module='mod_menu' 
      AND params LIKE '%"menutype":"menu_lateral"%' 
      AND access IN (1,1) 
      AND published=1 
      AND client_id=0 
      LIMIT 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_modules	ref	published,newsfeeds	newsfeeds	204	const,const	7	Using where

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.06 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.17 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.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    18	JDatabaseDriver->loadObject()	JROOT/components/com_xmap/displayer.php:115
    17	XmapDisplayer->getMenuTitle()	JROOT/components/com_xmap/displayer.php:84
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 1.64 ms Après la dernière requête : 0.78 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.504 MB Rangées retournées : 1

    SELECT `introtext`,`fulltext`,`alias`,`catid`
    
      FROM `jevnew_content`
    
      WHERE `id`=60

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.04 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 ms
    Waiting for query cache lock	0.02 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.00 ms
    logging slow query	0.00 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:1650
    20	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:252
    19	xmap_com_content::getTree()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/components/com_xmap/displayer.php:202
    17	XmapDisplayer->printMenuTree()	JROOT/components/com_xmap/displayer.php:87
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 3.81 ms Après la dernière requête : 1.11 ms Mémoire de requête : 0.037 MB mémoire avant requête : 9.654 MB Rangées retournées : 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM jevnew_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jevnew_categories AS cat JOIN jevnew_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN jevnew_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=36
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	40	Using where
    1	PRIMARY	<derived2>	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	Using where; Using temporary; Utilisation du tri complet de type filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	40	Using where; Using index; Using join buffer

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.03 ms
    checking query cache for query	0.18 ms
    checking permissions	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.29 ms
    System lock	0.06 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    executing	0.00 ms
    Copying to tmp table	0.09 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    removing tmp table	0.01 ms
    Sending data	0.00 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.04 ms
    init	0.09 ms
    optimizing	0.02 ms
    statistics	0.21 ms
    preparing	0.08 ms
    Creating tmp table	0.59 ms
    executing	0.00 ms
    Copying to tmp table	0.20 ms
    Sorting result	0.02 ms
    Sending data	0.09 ms
    end	0.01 ms
    removing tmp table	0.27 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.07 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.01 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.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    21	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    20	ContentHelperRoute::getArticleRoute()	JROOT/plugins/xmap/com_content/com_content.php:255
    19	xmap_com_content::getTree()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/components/com_xmap/displayer.php:202
    17	XmapDisplayer->printMenuTree()	JROOT/components/com_xmap/displayer.php:87
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 1.38 ms Après la dernière requête : 0.97 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.696 MB Rangées retournées : 1

    SELECT `introtext`,`fulltext`,`alias`,`catid`
    
      FROM `jevnew_content`
    
      WHERE `id`=104

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache 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.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.01 ms
    logging slow query	0.00 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:1650
    20	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:252
    19	xmap_com_content::getTree()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/components/com_xmap/displayer.php:202
    17	XmapDisplayer->printMenuTree()	JROOT/components/com_xmap/displayer.php:87
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 1.91 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.037 MB mémoire avant requête : 9.734 MB Rangées retournées : 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM jevnew_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jevnew_categories AS cat JOIN jevnew_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN jevnew_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=55
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	40	Using where
    1	PRIMARY	<derived2>	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	Using where; Using temporary; Utilisation du tri complet de type filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	40	Using where; Using index; Using join buffer

    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.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    executing	0.00 ms
    Copying to tmp table	0.06 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    removing tmp table	0.01 ms
    Sending data	0.00 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.03 ms
    init	0.06 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.03 ms
    Creating tmp table	0.26 ms
    executing	0.00 ms
    Copying to tmp table	0.12 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	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.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    21	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    20	ContentHelperRoute::getArticleRoute()	JROOT/plugins/xmap/com_content/com_content.php:255
    19	xmap_com_content::getTree()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/components/com_xmap/displayer.php:202
    17	XmapDisplayer->printMenuTree()	JROOT/components/com_xmap/displayer.php:87
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.93 ms Après la dernière requête : 0.87 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.761 MB Rangées retournées : 1

    SELECT `introtext`,`fulltext`,`alias`,`catid`
    
      FROM `jevnew_content`
    
      WHERE `id`=142

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache 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.01 ms
    end	0.01 ms
    query end	0.01 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.02 ms
    logging slow query	0.00 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:1650
    20	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:252
    19	xmap_com_content::getTree()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/components/com_xmap/displayer.php:202
    17	XmapDisplayer->printMenuTree()	JROOT/components/com_xmap/displayer.php:87
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 2.06 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.037 MB mémoire avant requête : 9.799 MB Rangées retournées : 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM jevnew_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jevnew_categories AS cat JOIN jevnew_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN jevnew_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=53
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	40	Using where
    1	PRIMARY	<derived2>	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	Using where; Using temporary; Utilisation du tri complet de type filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	40	Using where; Using index; Using join buffer

    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.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    executing	0.00 ms
    Copying to tmp table	0.06 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    removing tmp table	0.01 ms
    Sending data	0.00 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.03 ms
    init	0.06 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.23 ms
    executing	0.00 ms
    Copying to tmp table	0.17 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	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.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    21	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    20	ContentHelperRoute::getArticleRoute()	JROOT/plugins/xmap/com_content/com_content.php:255
    19	xmap_com_content::getTree()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/components/com_xmap/displayer.php:202
    17	XmapDisplayer->printMenuTree()	JROOT/components/com_xmap/displayer.php:87
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.45 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.826 MB Rangées retournées : 1

    SELECT `introtext`,`fulltext`,`alias`,`catid`
    
      FROM `jevnew_content`
    
      WHERE `id`=112

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 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:1650
    20	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:252
    19	xmap_com_content::getTree()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/components/com_xmap/displayer.php:202
    17	XmapDisplayer->printMenuTree()	JROOT/components/com_xmap/displayer.php:87
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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 : 2.54 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.037 MB mémoire avant requête : 9.866 MB Rangées retournées : 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM jevnew_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jevnew_categories AS cat JOIN jevnew_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN jevnew_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=48
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	40	Using where
    1	PRIMARY	<derived2>	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	Using where; Using temporary; Utilisation du tri complet de type filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	40	Using where; Using index; Using join buffer

    Profil

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.27 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.07 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    executing	0.00 ms
    Copying to tmp table	0.11 ms
    Sorting result	0.03 ms
    Sending data	0.02 ms
    removing tmp table	0.01 ms
    Sending data	0.01 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.03 ms
    init	0.11 ms
    optimizing	0.04 ms
    statistics	0.14 ms
    preparing	0.03 ms
    Creating tmp table	0.49 ms
    executing	0.01 ms
    Copying to tmp table	0.24 ms
    Sorting result	0.03 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.10 ms
    end	0.02 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.07 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.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:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    21	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    20	ContentHelperRoute::getArticleRoute()	JROOT/plugins/xmap/com_content/com_content.php:255
    19	xmap_com_content::getTree()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/components/com_xmap/displayer.php:202
    17	XmapDisplayer->printMenuTree()	JROOT/components/com_xmap/displayer.php:87
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->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.62 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.891 MB Rangées retournées : 1

    SELECT `introtext`,`fulltext`,`alias`,`catid`
    
      FROM `jevnew_content`
    
      WHERE `id`=105

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jevnew_content	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 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.01 ms
    logging slow query	0.00 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:1650
    20	JDatabaseDriver->loadObject()	JROOT/plugins/xmap/com_content/com_content.php:252
    19	xmap_com_content::getTree()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/components/com_xmap/displayer.php:202
    17	XmapDisplayer->printMenuTree()	JROOT/components/com_xmap/displayer.php:87
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

48. Temps de requête : 1.27 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.037 MB mémoire avant requête : 9.929 MB Rangées retournées : 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM jevnew_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jevnew_categories AS cat JOIN jevnew_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN jevnew_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=54
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	40	Using where
    1	PRIMARY	<derived2>	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	Using where; Using temporary; Utilisation du tri complet de type filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	40	Using where; Using index; Using join buffer

    Profil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    executing	0.00 ms
    Copying to tmp table	0.06 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    removing tmp table	0.00 ms
    Sending data	0.00 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.03 ms
    init	0.06 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.03 ms
    Creating tmp table	0.25 ms
    executing	0.01 ms
    Copying to tmp table	0.12 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 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.04 ms
    logging slow query	0.01 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:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    21	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    20	ContentHelperRoute::getArticleRoute()	JROOT/plugins/xmap/com_content/com_content.php:255
    19	xmap_com_content::getTree()	Même appel que celui de la ligne ci-dessous.
    18	call_user_func_array()	JROOT/components/com_xmap/displayer.php:202
    17	XmapDisplayer->printMenuTree()	JROOT/components/com_xmap/displayer.php:87
    16	XmapDisplayer->printSitemap()	JROOT/components/com_xmap/views/html/tmpl/default_items.php:17
    15	include JROOT/components/com_xmap/views/html/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/components/com_xmap/views/html/tmpl/default.php:96
    13	include JROOT/components/com_xmap/views/html/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_xmap/views/html/view.html.php:103
    10	XmapViewHtml->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_xmap/controller.php:57
    8	XmapController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_xmap/xmap.php:24
    6	require_once JROOT/components/com_xmap/xmap.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

49. Temps de requête : 0.58 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.961 MB Rangées retournées : 1