Console de débogage Joomla!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1524726737,
                "last": 1524726737,
                "now": 1524726737
            },
            "token": "IFPPnMIVYS6hddb8Sq3QrwJaZSSVzPJR"
        },
        "registry": {
            "users": {
                "login": {
                    "form": {
                        "data": {
                            "return": "index.php?option=com_users&view=profile"
                        }
                    }
                }
            },
            "com_attachments": {
                "current_url": "&return=aHR0cDovL2xhai5mci9pbmRleC5waHAvY29ubmV4aW9uPw%3D%3D"
            }
        },
        "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

23 requêtes exécutées 2883.22 ms

1. Temps de requête : 44.31 ms Mémoire de requête : 0.026 MB mémoire avant requête : 2.312 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `lajfr1_session`
   
     WHERE `session_id` = 'f87c499c78d62b1a681f1b9400d1a74a'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	lajfr1_session	const	PRIMARY	PRIMARY	575	const	1

   Profil

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

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   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:748
   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:404
   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 : 742.73 ms Après la dernière requête : 2.34 ms Mémoire de requête : 0.004 MB mémoire avant requête : 2.447 MB

   DELETE 
   
     FROM `lajfr1_session`
   
     WHERE `time` < '1524725837'

   Explication

   EXPLAIN impossible sur la requête : DELETE FROM `lajfr1_session` WHERE `time` < '1524725837'

   Profil

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.08 ms
   updating	0.06 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:765
   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:404
   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 : 42.22 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.454 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `lajfr1_session`
   
     WHERE `session_id` = 'f87c499c78d62b1a681f1b9400d1a74a' 
     LIMIT 1

   Explication

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

   Profil

   Status	Duration
   starting	0.03 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.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.01 ms
   executing	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.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   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:774
   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:404
   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 : 41.70 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.005 MB mémoire avant requête : 2.459 MB

   INSERT INTO `lajfr1_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('f87c499c78d62b1a681f1b9400d1a74a', 0, '1524726738')

   Explication

   EXPLAIN impossible sur la requête : INSERT INTO `lajfr1_session` (`session_id`, `client_id`, `time`) VALUES ('f87c499c78d62b1a681f1b9400d1a74a', 0, '1524726738')

   Profil

   Status	Duration
   starting	0.05 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.01 ms
   update	0.11 ms
   Waiting for query cache lock	0.01 ms
   update	0.11 ms
   end	0.00 ms
   query end	0.92 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:208
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
   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:404
   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 : 164.63 ms Après la dernière requête : 4.11 ms Mémoire de requête : 0.061 MB mémoire avant requête : 2.704 MB Rangées retournées : 46

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

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	lajfr1_extensions	ref	extension	extension	62	const	46	Using where

   Profil

   Status	Duration
   starting	0.05 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.19 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.05 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.24 ms
   Waiting for query cache lock	0.01 ms
   Sending data	82.64 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.11 ms
   Waiting for query cache lock	0.16 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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   8	JDatabaseDriver->loadObjectList()	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:584
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   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 : 42.02 ms Après la dernière requête : 2.45 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.873 MB Rangées retournées : 2

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

   Explication

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

   Profil

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:852
   9	JAccess::getGroupsByUser()	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:594
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   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 : 41.47 ms Après la dernière requête : 0.93 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.921 MB Rangées retournées : 4

   SELECT id, rules
   
     FROM `lajfr1_viewlevels`

   Explication

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

   Profil

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:938
   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:594
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   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 : 43.83 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.031 MB mémoire avant requête : 2.933 MB Rangées retournées : 67

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

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	lajfr1_extensions	ref	extension	extension	62	const	160	Using where; Utilisation du tri complet de type filesort

   Profil

   Status	Duration
   starting	0.04 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.13 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.04 ms
   optimizing	0.02 ms
   statistics	0.08 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sorting result	0.59 ms
   Sending data	0.25 ms
   end	0.02 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.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.05 ms
   logging slow query	0.00 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   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:594
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   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 : 586.03 ms Après la dernière requête : 39.22 ms Mémoire de requête : 0.082 MB mémoire avant requête : 4.608 MB Rangées retournées : 56

   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 lajfr1_menu AS m
   
     LEFT JOIN lajfr1_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	84	Using where; Utilisation du tri complet de type filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db484986895.m.component_id	1

   Profil

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

   Call Stack

   #	Caller	File and line number
   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:133
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
   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:196
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1091
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   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 : 45.03 ms Après la dernière requête : 4.84 ms Mémoire de requête : 0.029 MB mémoire avant requête : 5.194 MB Rangées retournées : 1

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

    Explication

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

    Profil

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    14	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:52
    8	plgSystemK2->onAfterRoute()	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:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    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 : 39.76 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.009 MB mémoire avant requête : 5.190 MB

    UPDATE `lajfr1_extensions`
    
      SET `params` = '{\"mediaversion\":\"1924b014a5151c791ec56de84e24d48f\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

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

    Profil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    System lock	0.01 ms
    init	0.15 ms
    Updating	0.16 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.32 ms
    query end	1.08 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:52
    8	plgSystemK2->onAfterRoute()	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:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    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 : 40.76 ms Après la dernière requête : 3.31 ms Mémoire de requête : 0.030 MB mémoire avant requête : 5.493 MB Rangées retournées : 1

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

    Explication

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

    Profil

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    12	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    11	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:315
    10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
    9	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
    8	plgSystemK2->onAfterRoute()	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:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    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 : 579.62 ms Après la dernière requête : 3.62 ms Mémoire de requête : 0.055 MB mémoire avant requête : 5.699 MB Rangées retournées : 12

    SELECT id, home, template, s.params
    
      FROM lajfr1_template_styles as s
    
      LEFT JOIN lajfr1_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	18	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	db484986895.s.template,const	1	Using where

    Profil

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    17	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:335
    16	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:680
    15	JHtml::script()	JROOT/libraries/cms/html/html.php:237
    14	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    13	JHtml::_()	JROOT/libraries/cms/html/behavior.php:61
    12	JHtmlBehavior::framework()	JROOT/libraries/cms/html/html.php:237
    11	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    10	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:76
    9	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
    8	plgSystemK2->onAfterRoute()	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:1101
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:776
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    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 : 43.37 ms Après la dernière requête : 104.12 ms Mémoire de requête : 0.029 MB mémoire avant requête : 7.724 MB Rangées retournées : 7

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM lajfr1_modules AS m
    
      LEFT JOIN lajfr1_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN lajfr1_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-04-26 07:12:20') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-26 07:12:20') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 220 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	14	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db484986895.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	db484986895.m.module,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.09 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.12 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.10 ms
    Sending data	0.13 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.04 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.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
    11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
    10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    8	JDocumentHtml->countModules()	JROOT/templates/laj_01/index.php:60
    7	require JROOT/templates/laj_01/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1048
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    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 : 40.22 ms Après la dernière requête : 10.10 ms Mémoire de requête : 0.038 MB mémoire avant requête : 8.313 MB Rangées retournées : 8

    SHOW FULL COLUMNS 
      FROM `lajfr1_assets`

    Explication

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

    Profil

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

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    24	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    23	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    22	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:304
    21	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:714
    20	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
    19	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:533
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1062
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    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 : 42.89 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.034 MB mémoire avant requête : 8.364 MB Rangées retournées : 1

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

    Explication

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

    Profil

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    22	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
    21	JTable->load()	JROOT/libraries/joomla/access/access.php:715
    20	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
    19	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:533
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1062
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    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 : 42.06 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.032 MB mémoire avant requête : 8.379 MB Rangées retournées : 1

    SELECT a.rules
    
      FROM lajfr1_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,152	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

    Profil

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    20	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:670
    19	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:533
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1062
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    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 : 43.40 ms Après la dernière requête : 0.99 ms Mémoire de requête : 0.035 MB mémoire avant requête : 8.412 MB Rangées retournées : 46

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lajfr1_extensions	ref	extension	extension	62	const	46	Using where

    Profil

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:412
    21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:533
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1062
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    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 : 44.38 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.036 MB mémoire avant requête : 8.433 MB Rangées retournées : 45

    SELECT a.name, a.rules
    
      FROM lajfr1_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_attachments','com_banners','com_booking','com_breezingforms','com_cache','com_categories','com_checkin','com_cobalt','com_config','com_contact','com_content','com_contentbuilder','com_contenthistory','com_cpanel','com_fabrik','com_finder','com_gantry','com_gantry','com_icagenda','com_installer','com_jce','com_jevents','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mtimporter','com_mtree','com_newsfeeds','com_plugins','com_postinstall','com_proforms','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') 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	206	Using where

    Profil

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    22	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:439
    21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:533
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1062
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    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 : 45.49 ms Après la dernière requête : 2.23 ms Mémoire de requête : 0.043 MB mémoire avant requête : 8.800 MB Rangées retournées : 2

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM lajfr1_content AS a
    
      LEFT JOIN lajfr1_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN lajfr1_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN lajfr1_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN lajfr1_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN lajfr1_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM lajfr1_categories AS cat JOIN lajfr1_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
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid IN (29) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-26 07:12:20') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-26 07:12:20')
    
      ORDER BY a.title ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
    1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	2	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	db484986895.a.created_by	1
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	db484986895.a.modified_by	1
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	db484986895.a.id	1
    1	PRIMARY	<derived2>	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	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	37	Using where; Using index; Using join buffer

    Profil

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.32 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.67 ms
    System lock	0.06 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    Creating tmp table	0.01 ms
    executing	0.00 ms
    Copying to tmp table	0.11 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    removing tmp table	0.01 ms
    Sending data	0.01 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.04 ms
    init	0.09 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.05 ms
    Creating tmp table	0.41 ms
    executing	0.01 ms
    Copying to tmp table	0.17 ms
    Sorting result	0.04 ms
    Sending data	0.06 ms
    end	0.00 ms
    removing tmp table	0.08 ms
    end	0.01 ms
    query end	0.01 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.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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:533
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1062
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    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 : 44.31 ms Après la dernière requête : 1.95 ms Mémoire de requête : 0.041 MB mémoire avant requête : 8.924 MB Rangées retournées : 2

    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 lajfr1_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM lajfr1_categories AS cat JOIN lajfr1_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 lajfr1_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,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=29
    
      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	37	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	153	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	37	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.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    15	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    14	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_articles_category/helper.php:243
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:533
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1062
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    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 : 41.71 ms Après la dernière requête : 4.13 ms Mémoire de requête : 0.040 MB mémoire avant requête : 8.996 MB Rangées retournées : 1

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
    
      FROM lajfr1_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM lajfr1_categories AS cat JOIN lajfr1_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 lajfr1_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      LEFT JOIN `lajfr1_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=31
    
      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	37	Using where
    1	PRIMARY	<derived2>	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where; Not exists
    1	PRIMARY	i	ref	idx_state,idx_catid	idx_catid	4	db484986895.c.id	2
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	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	37	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.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    15	JCategories->get()	JROOT/components/com_content/models/categories.php:115
    14	ContentModelCategories->getItems()	JROOT/modules/mod_articles_category/helper.php:143
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:533
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1062
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    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 : 41.29 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.041 MB mémoire avant requête : 9.014 MB Rangées retournées : 0

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM lajfr1_content AS a
    
      LEFT JOIN lajfr1_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN lajfr1_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN lajfr1_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN lajfr1_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN lajfr1_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM lajfr1_categories AS cat JOIN lajfr1_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
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid IN (31) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-26 07:12:20') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-26 07:12:20')
    
      ORDER BY a.title ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	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	37	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.18 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.04 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.01 ms
    executing	0.00 ms
    Copying to tmp table	0.08 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.05 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.03 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.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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:533
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1062
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:758
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    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 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

1. 2 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM lajfr1_extensions

2. 2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
     CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
     CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
     CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
     FROM lajfr1_content AS a 
     LEFT JOIN lajfr1_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN lajfr1_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN lajfr1_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN lajfr1_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN lajfr1_content_rating AS v 
     ON a.id = v.content_id 
     LEFT 
     OUTER JOIN (SELECT cat.id as id 
     FROM lajfr1_categories AS cat JOIN lajfr1_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

3. 1 × SELECT `data` 
     FROM `lajfr1_session`

4. 1 × SELECT * 
     FROM lajfr1_assets

5. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM lajfr1_categories as c 
     LEFT JOIN  (SELECT cat.id as id 
     FROM lajfr1_categories AS cat JOIN lajfr1_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

6. 1 × SELECT a.name, a.rules 
     FROM lajfr1_assets AS a

7. 1 × SELECT element 
     FROM lajfr1_extensions

8. 1 × SELECT a.rules 
     FROM lajfr1_assets AS a

9. 1 × SELECT id, home, template, s.params 
     FROM lajfr1_template_styles as s 
     LEFT JOIN lajfr1_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id

10. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM lajfr1_modules AS m 
      LEFT JOIN lajfr1_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN lajfr1_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

11. 1 × SELECT `session_id` 
      FROM `lajfr1_session`

12. 1 × SELECT * 
      FROM lajfr1_languages

13. 1 × 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 lajfr1_menu AS m 
      LEFT JOIN lajfr1_extensions AS e 
      ON m.component_id = e.extension_id

14. 1 × SELECT folder AS type, element AS name, params 
      FROM lajfr1_extensions

15. 1 × SELECT id, rules 
      FROM `lajfr1_viewlevels

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

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

Autres tables :

1. 1 × DELETE  
     FROM `lajfr1_session`

2. 1 × INSERT INTO `lajfr1_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('f87c499c78d62b1a681f1b9400d1a74a', 0, '1524726738'

3. 1 × UPDATE `lajfr1_extensions` 
     SET `params` = '{\"mediaversion\":\"1924b014a5151c791ec56de84e24d48f\"}'

4. 1 × SHOW FULL COLUMNS 
     FROM `lajfr1_assets