{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679949672,
                "last": 1679949672,
                "now": 1679949672
            }
        },
        "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": [
                "9"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Temps

Mémoire

21 requêtes exécutées 79.94 ms

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

   SELECT `data`
   
     FROM `josa_session`
   
     WHERE `session_id` = '1l7r0e5c7pec09dghtpvpu7i34'

   Explication

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

   Profil

   Status	Duration
   Starting	0.12 ms
   Waiting for query cache lock	0.05 ms
   Init	0.03 ms
   Checking query cache for query	0.13 ms
   Checking permissions	0.07 ms
   Opening tables	0.18 ms
   After opening tables	0.06 ms
   System lock	0.07 ms
   Table lock	0.08 ms
   Waiting for query cache lock	0.10 ms
   Init	0.12 ms
   Optimizing	0.08 ms
   Statistics	0.31 ms
   Preparing	0.05 ms
   Executing	0.10 ms
   End of update loop	0.05 ms
   Query end	0.03 ms
   Commit	0.06 ms
   Closing tables	0.06 ms
   Unlocking tables	0.06 ms
   Closing tables	0.05 ms
   Starting cleanup	0.05 ms
   Freeing items	0.05 ms
   Updating status	0.03 ms
   Waiting for query cache lock	0.03 ms
   Updating status	0.06 ms
   Waiting for query cache lock	0.03 ms
   Updating status	0.04 ms
   Storing result in query cache	0.05 ms
   Reset for next command	0.05 ms

   Pile d'appels

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
   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:258
   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:47

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

   ---

2. Temps de requête : 2.49 ms Après la dernière requête : 12.14 ms Mémoire de requête : 0.012 MB mémoire avant requête : 2.911 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `josa_session`
   
     WHERE `session_id` = '1l7r0e5c7pec09dghtpvpu7i34' 
     LIMIT 0, 1

   Explication

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

   Profil

   Status	Duration
   Starting	0.07 ms
   Waiting for query cache lock	0.03 ms
   Init	0.03 ms
   Checking query cache for query	0.19 ms
   Checking permissions	0.05 ms
   Opening tables	0.06 ms
   After opening tables	0.06 ms
   System lock	0.05 ms
   Table lock	0.04 ms
   Waiting for query cache lock	0.05 ms
   Init	0.15 ms
   Optimizing	0.10 ms
   Statistics	0.15 ms
   Preparing	0.06 ms
   Executing	0.09 ms
   End of update loop	0.12 ms
   Query end	0.09 ms
   Commit	0.07 ms
   Closing tables	0.07 ms
   Unlocking tables	0.04 ms
   Closing tables	0.06 ms
   Starting cleanup	0.08 ms
   Freeing items	0.10 ms
   Updating status	0.06 ms
   Waiting for query cache lock	0.09 ms
   Updating status	0.09 ms
   Waiting for query cache lock	0.05 ms
   Updating status	0.03 ms
   Storing result in query cache	0.05 ms
   Reset for next command	0.08 ms

   Pile d'appels

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
   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:47

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

   ---

3. Temps de requête : 5.78 ms Après la dernière requête : 0.55 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.924 MB

   INSERT INTO `josa_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('1l7r0e5c7pec09dghtpvpu7i34', 0, '1679949672')

   Explication

   EXPLAIN impossible sur la requête : INSERT INTO `josa_session` (`session_id`, `client_id`, `time`) VALUES ('1l7r0e5c7pec09dghtpvpu7i34', 0, '1679949672')

   Profil

   Status	Duration
   Starting	0.22 ms
   Checking permissions	0.05 ms
   Opening tables	0.06 ms
   After opening tables	0.03 ms
   System lock	0.05 ms
   Table lock	0.04 ms
   Init for update	0.05 ms
   Update	0.45 ms
   Waiting for query cache lock	0.05 ms
   Update	0.04 ms
   End of update loop	0.05 ms
   Query end	0.08 ms
   Commit	4.02 ms
   Closing tables	0.05 ms
   Unlocking tables	0.08 ms
   Closing tables	0.05 ms
   Starting cleanup	0.05 ms
   Freeing items	0.04 ms
   Updating status	0.08 ms
   Reset for next command	0.04 ms

   Pile d'appels

   #	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:47

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

   ---

4. Temps de requête : 5.40 ms Après la dernière requête : 29.41 ms Mémoire de requête : 0.017 MB mémoire avant requête : 3.295 MB Rangées retournées : 31

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

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	josa_extensions	ref	extension	extension	82	const	31	Using index condition

   Profil

   Status	Duration
   Starting	0.12 ms
   Waiting for query cache lock	0.11 ms
   Init	0.06 ms
   Checking query cache for query	0.24 ms
   Checking permissions	0.09 ms
   Opening tables	0.25 ms
   After opening tables	0.09 ms
   System lock	0.10 ms
   Table lock	0.08 ms
   Waiting for query cache lock	0.23 ms
   Init	0.13 ms
   Optimizing	0.09 ms
   Statistics	0.50 ms
   Preparing	0.13 ms
   Executing	0.13 ms
   Sending data	1.51 ms
   End of update loop	0.11 ms
   Query end	0.13 ms
   Commit	0.07 ms
   Closing tables	0.05 ms
   Unlocking tables	0.13 ms
   Closing tables	0.09 ms
   Starting cleanup	0.06 ms
   Freeing items	0.06 ms
   Updating status	0.05 ms
   Waiting for query cache lock	0.05 ms
   Updating status	0.12 ms
   Waiting for query cache lock	0.09 ms
   Updating status	0.09 ms
   Storing result in query cache	0.06 ms
   Reset for next command	0.06 ms

   Pile d'appels

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
   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:50

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

   ---

5. Temps de requête : 0.92 ms Après la dernière requête : 6.61 ms Mémoire de requête : 0.014 MB mémoire avant requête : 3.442 MB Rangées retournées : 2

   SELECT b.id
   
     FROM josa_usergroups AS a
   
     LEFT JOIN josa_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

   Profil

   Status	Duration
   Starting	0.08 ms
   Waiting for query cache lock	0.08 ms
   Init	0.05 ms
   Checking query cache for query	0.09 ms
   Checking privileges on cached	0.15 ms
   Checking permissions	0.08 ms
   Sending cached result to clien	0.12 ms
   Updating status	0.07 ms
   Reset for next command	0.05 ms

   Pile d'appels

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
   9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
   8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:423
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	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:257
   1	JApplicationCms->execute()	JROOT/index.php:50

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

   ---

6. Temps de requête : 0.87 ms Après la dernière requête : 2.02 ms Mémoire de requête : 0.013 MB mémoire avant requête : 3.498 MB Rangées retournées : 5

   SELECT id, rules
   
     FROM `josa_viewlevels`

   Explication

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

   Profil

   Status	Duration
   Starting	0.07 ms
   Waiting for query cache lock	0.07 ms
   Init	0.05 ms
   Checking query cache for query	0.07 ms
   Checking privileges on cached	0.05 ms
   Checking permissions	0.17 ms
   Sending cached result to clien	0.12 ms
   Updating status	0.08 ms
   Reset for next command	0.05 ms

   Pile d'appels

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
   8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:440
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	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:257
   1	JApplicationCms->execute()	JROOT/index.php:50

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

   ---

7. Temps de requête : 9.94 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.517 MB Rangées retournées : 47

   SELECT folder AS type, element AS name, params
   
     FROM josa_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	josa_extensions	ref	extension	extension	82	const	64	Using index condition; Using where; Utilisation du tri complet de type filesort

   Profil

   Status	Duration
   Starting	0.18 ms
   Waiting for query cache lock	0.10 ms
   Init	0.07 ms
   Checking query cache for query	0.31 ms
   Checking permissions	0.09 ms
   Opening tables	0.14 ms
   After opening tables	0.09 ms
   System lock	0.07 ms
   Table lock	0.12 ms
   Waiting for query cache lock	0.14 ms
   Init	0.17 ms
   Optimizing	0.14 ms
   Statistics	0.31 ms
   Preparing	0.99 ms
   Sorting result	0.12 ms
   Executing	0.13 ms
   Sending data	0.09 ms
   Creating sort index	4.28 ms
   End of update loop	0.11 ms
   Query end	0.07 ms
   Commit	0.14 ms
   Closing tables	0.11 ms
   Unlocking tables	0.06 ms
   Closing tables	0.12 ms
   Starting cleanup	0.08 ms
   Freeing items	0.09 ms
   Updating status	0.06 ms
   Waiting for query cache lock	0.06 ms
   Updating status	0.15 ms
   Waiting for query cache lock	0.09 ms
   Updating status	0.09 ms
   Storing result in query cache	0.09 ms
   Reset for next command	0.06 ms

   Pile d'appels

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	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:257
   1	JApplicationCms->execute()	JROOT/index.php:50

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

   ---

8. Temps de requête : 5.99 ms Après la dernière requête : 78.74 ms Mémoire de requête : 0.027 MB mémoire avant requête : 5.264 MB Rangées retournées : 15

   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 josa_menu AS m
   
     LEFT JOIN josa_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	16	Using index condition; Using where; Utilisation du tri complet de type filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	naiscywr_joomla.m.component_id	1	Using where

   Profil

   Status	Duration
   Starting	0.15 ms
   Waiting for query cache lock	0.12 ms
   Init	0.09 ms
   Checking query cache for query	0.30 ms
   Checking permissions	0.09 ms
   Opening tables	0.47 ms
   After opening tables	0.05 ms
   System lock	0.03 ms
   Table lock	0.03 ms
   Waiting for query cache lock	0.10 ms
   Init	0.10 ms
   Optimizing	0.08 ms
   Statistics	0.33 ms
   Preparing	0.17 ms
   Sorting result	0.20 ms
   Executing	0.08 ms
   Sending data	0.10 ms
   Creating sort index	1.72 ms
   End of update loop	0.06 ms
   Query end	0.08 ms
   Commit	0.06 ms
   Closing tables	0.03 ms
   Unlocking tables	0.04 ms
   Closing tables	0.12 ms
   Starting cleanup	0.16 ms
   Freeing items	0.09 ms
   Updating status	0.07 ms
   Waiting for query cache lock	0.05 ms
   Updating status	0.16 ms
   Waiting for query cache lock	0.12 ms
   Updating status	0.04 ms
   Storing result in query cache	0.03 ms
   Reset for next command	0.06 ms

   Pile d'appels

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   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:1097
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
   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:50

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

   ---

9. Temps de requête : 3.29 ms Après la dernière requête : 11.85 ms Mémoire de requête : 0.018 MB mémoire avant requête : 5.588 MB Rangées retournées : 4

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

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
   1	SIMPLE	s	ALL	idx_template	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	6	Using where; Using join buffer (flat, BNL join)

   Profil

   Status	Duration
   Starting	0.07 ms
   Waiting for query cache lock	0.03 ms
   Init	0.03 ms
   Checking query cache for query	0.13 ms
   Checking permissions	0.04 ms
   Opening tables	0.22 ms
   After opening tables	0.06 ms
   System lock	0.04 ms
   Table lock	0.03 ms
   Waiting for query cache lock	0.06 ms
   Init	0.08 ms
   Optimizing	0.10 ms
   Statistics	0.22 ms
   Preparing	0.18 ms
   Executing	0.04 ms
   Sending data	0.38 ms
   End of update loop	0.05 ms
   Query end	0.05 ms
   Commit	0.04 ms
   Closing tables	0.03 ms
   Unlocking tables	0.03 ms
   Closing tables	0.09 ms
   Starting cleanup	0.04 ms
   Freeing items	0.06 ms
   Updating status	0.04 ms
   Waiting for query cache lock	0.03 ms
   Updating status	0.06 ms
   Waiting for query cache lock	0.03 ms
   Updating status	0.03 ms
   Storing result in query cache	0.03 ms
   Reset for next command	0.06 ms

   Pile d'appels

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
   11	JApplicationSite->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:310
   10	T3::detect()	JROOT/plugins/system/t3/t3.php:81
   9	plgSystemT3->onAfterRoute()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
   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:50

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

   ---

10. Temps de requête : 2.13 ms Après la dernière requête : 46.35 ms Mémoire de requête : 0.019 MB mémoire avant requête : 6.539 MB Rangées retournées : 1

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	josa_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

    Profil

    Status	Duration
    Starting	0.08 ms
    Waiting for query cache lock	0.03 ms
    Init	0.03 ms
    Checking query cache for query	0.13 ms
    Checking permissions	0.07 ms
    Opening tables	0.07 ms
    After opening tables	0.06 ms
    System lock	0.04 ms
    Table lock	0.03 ms
    Waiting for query cache lock	0.06 ms
    Init	0.09 ms
    Optimizing	0.07 ms
    Statistics	0.30 ms
    Preparing	0.10 ms
    Executing	0.06 ms
    Sending data	0.21 ms
    End of update loop	0.05 ms
    Query end	0.03 ms
    Commit	0.03 ms
    Closing tables	0.03 ms
    Unlocking tables	0.03 ms
    Closing tables	0.05 ms
    Starting cleanup	0.03 ms
    Freeing items	0.07 ms
    Updating status	0.07 ms
    Waiting for query cache lock	0.03 ms
    Updating status	0.07 ms
    Waiting for query cache lock	0.03 ms
    Updating status	0.03 ms
    Storing result in query cache	0.03 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    13	JDatabaseDriver->loadObject()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
    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:737
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
    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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

11. Temps de requête : 6.07 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.012 MB mémoire avant requête : 6.542 MB

    UPDATE `josa_extensions`
    
      SET `params` = '{\"mediaversion\":\"01aa1717c80624927a6ae23bc3c44985\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

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

    Profil

    Status	Duration
    Starting	0.13 ms
    Checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.06 ms
    System lock	0.03 ms
    Table lock	0.03 ms
    Init for update	0.21 ms
    Updating	0.48 ms
    End of update loop	0.05 ms
    Waiting for query cache lock	0.03 ms
    End of update loop	0.22 ms
    Query end	0.04 ms
    Commit	4.25 ms
    Closing tables	0.05 ms
    Unlocking tables	0.03 ms
    Closing tables	0.04 ms
    Starting cleanup	0.06 ms
    Freeing items	0.03 ms
    Updating status	0.07 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Caller	File and line number
    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:737
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
    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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

12. Temps de requête : 0.63 ms Après la dernière requête : 7.27 ms Mémoire de requête : 0.013 MB mémoire avant requête : 6.823 MB Rangées retournées : 1

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	josa_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.05 ms
    Waiting for query cache lock	0.03 ms
    Init	0.03 ms
    Checking query cache for query	0.03 ms
    Checking privileges on cached	0.03 ms
    Checking permissions	0.06 ms
    Sending cached result to clien	0.09 ms
    Updating status	0.06 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

13. Temps de requête : 0.60 ms Après la dernière requête : 29.27 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.511 MB Rangées retournées : 1

    SELECT a.rules
    
      FROM josa_assets AS a
    
      WHERE (a.id = 1)
    
      GROUP BY a.id, a.rules, a.lft

    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.09 ms
    Waiting for query cache lock	0.03 ms
    Init	0.03 ms
    Checking query cache for query	0.03 ms
    Checking privileges on cached	0.03 ms
    Checking permissions	0.06 ms
    Sending cached result to clien	0.08 ms
    Updating status	0.03 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

14. Temps de requête : 0.50 ms Après la dernière requête : 2.48 ms Mémoire de requête : 0.021 MB mémoire avant requête : 7.564 MB Rangées retournées : 2

    SELECT b.rules
    
      FROM josa_assets AS a
    
      LEFT JOIN josa_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE (a.name = 'com_content')
    
      GROUP BY b.id, b.rules, b.lft
    
      ORDER BY b.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	idx_asset_name	idx_asset_name	202	const	1	Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	10	Using where

    Profil

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.03 ms
    Init	0.03 ms
    Checking query cache for query	0.03 ms
    Checking privileges on cached	0.03 ms
    Checking permissions	0.05 ms
    Sending cached result to clien	0.07 ms
    Updating status	0.03 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
    14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

15. Temps de requête : 4.35 ms Après la dernière requête : 4.10 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.669 MB Rangées retournées : 30

    SHOW FULL COLUMNS 
      FROM `josa_content`

    Explication

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

    Profil

    Status	Duration
    Starting	0.12 ms
    Checking permissions	0.04 ms
    Closing tables	0.03 ms
    Opening tables	1.32 ms
    After opening tables	0.05 ms
    System lock	0.03 ms
    Table lock	0.04 ms
    Init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.05 ms
    Preparing	0.07 ms
    Executing	0.06 ms
    Filling schema table	0.05 ms
    Opening tables	0.34 ms
    After opening tables	0.05 ms
    Checking permissions	0.51 ms
    Closing tables	0.16 ms
    Executing	0.04 ms
    Sending data	0.26 ms
    End of update loop	0.05 ms
    Query end	0.03 ms
    Commit	0.05 ms
    Closing tables	0.03 ms
    Removing tmp table	0.47 ms
    Closing tables	0.04 ms
    Unlocking tables	0.03 ms
    Closing tables	0.03 ms
    Starting cleanup	0.03 ms
    Freeing items	0.03 ms
    Updating status	0.08 ms
    Reset for next command	0.04 ms

    Pile d'appels

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
    11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:305
    10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

16. Temps de requête : 2.51 ms Après la dernière requête : 13.30 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.042 MB Rangées retournées : 1

    SELECT *
    
      FROM josa_content
    
      WHERE `id` = '17'

    Explication

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

    Profil

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.03 ms
    Init	0.03 ms
    Checking query cache for query	0.14 ms
    Checking permissions	0.04 ms
    Opening tables	0.07 ms
    After opening tables	0.04 ms
    System lock	0.06 ms
    Table lock	0.04 ms
    Waiting for query cache lock	0.10 ms
    Init	0.19 ms
    Optimizing	0.07 ms
    Statistics	0.40 ms
    Preparing	0.05 ms
    Unlocking tables	0.06 ms
    Preparing	0.06 ms
    Executing	0.03 ms
    Sending data	0.16 ms
    End of update loop	0.04 ms
    Query end	0.07 ms
    Commit	0.04 ms
    Closing tables	0.03 ms
    Unlocking tables	0.03 ms
    Closing tables	0.07 ms
    Starting cleanup	0.06 ms
    Freeing items	0.06 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.03 ms
    Updating status	0.11 ms
    Waiting for query cache lock	0.05 ms
    Updating status	0.05 ms
    Storing result in query cache	0.05 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:728
    10	JTable->load()	JROOT/components/com_content/models/article.php:265
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

17. Temps de requête : 6.36 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.014 MB mémoire avant requête : 8.057 MB

    UPDATE josa_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '17'

    Explication

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

    Profil

    Status	Duration
    Starting	0.15 ms
    Checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.05 ms
    Table lock	0.03 ms
    Init for update	0.18 ms
    Updating	0.53 ms
    End of update loop	0.05 ms
    Waiting for query cache lock	0.03 ms
    End of update loop	0.10 ms
    Query end	0.07 ms
    Commit	4.33 ms
    Closing tables	0.07 ms
    Unlocking tables	0.06 ms
    Closing tables	0.12 ms
    Starting cleanup	0.05 ms
    Freeing items	0.04 ms
    Updating status	0.08 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1249
    10	JTable->hit()	JROOT/components/com_content/models/article.php:266
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

18. Temps de requête : 7.62 ms Après la dernière requête : 7.18 ms Mémoire de requête : 0.028 MB mémoire avant requête : 8.252 MB Rangées retournées : 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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
    
      FROM josa_content AS a
    
      LEFT JOIN josa_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN josa_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN josa_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN josa_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM josa_categories AS cat JOIN josa_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 17 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 20:41:12') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 20:41:12') 
      AND (a.state = 1 OR a.state =2)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	Using index condition; Using temporary; Utilisation du tri complet de type filesort
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	6	Using where; Using index; Using join buffer (flat, BNL join)

    Profil

    Status	Duration
    Starting	0.06 ms
    Waiting for query cache lock	0.03 ms
    Init	0.03 ms
    Checking query cache for query	0.58 ms
    Checking permissions	0.05 ms
    Opening tables	1.05 ms
    After opening tables	0.12 ms
    System lock	0.07 ms
    Table lock	0.04 ms
    Waiting for query cache lock	0.14 ms
    Init	0.49 ms
    Optimizing	0.25 ms
    Optimizing	0.11 ms
    Statistics	0.48 ms
    Statistics	1.21 ms
    Preparing	0.20 ms
    Creating tmp table	0.14 ms
    Sorting result	0.13 ms
    Preparing	0.07 ms
    Unlocking tables	0.05 ms
    Preparing	0.19 ms
    Executing	0.07 ms
    Sending data	0.15 ms
    Executing	0.05 ms
    Sending data	0.21 ms
    Creating sort index	0.10 ms
    Removing tmp table	0.06 ms
    Creating sort index	0.17 ms
    End of update loop	0.14 ms
    Query end	0.12 ms
    Commit	0.05 ms
    Closing tables	0.05 ms
    Removing tmp table	0.05 ms
    Closing tables	0.04 ms
    Unlocking tables	0.04 ms
    Closing tables	0.13 ms
    Starting cleanup	0.06 ms
    Freeing items	0.07 ms
    Updating status	0.06 ms
    Waiting for query cache lock	0.04 ms
    Updating status	0.13 ms
    Waiting for query cache lock	0.06 ms
    Updating status	0.09 ms
    Storing result in query cache	0.06 ms
    Reset for next command	0.07 ms

    Pile d'appels

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    12	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

19. Temps de requête : 0.85 ms Après la dernière requête : 9.48 ms Mémoire de requête : 0.026 MB mémoire avant requête : 8.512 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 josa_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM josa_categories AS cat JOIN josa_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 josa_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=2
    
      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	6	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	naiscywr_joomla.c.id	2	Using where
    2	DERIVED	parent	ALL	cat_idx,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	6	Using where; Using temporary; Utilisation du tri complet de type filesort
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	6	Using where; Using index; Using join buffer (flat, BNL join)

    Profil

    Status	Duration
    Starting	0.09 ms
    Waiting for query cache lock	0.06 ms
    Init	0.05 ms
    Checking query cache for query	0.15 ms
    Checking privileges on cached	0.07 ms
    Checking permissions	0.07 ms
    Sending cached result to clien	0.10 ms
    Updating status	0.11 ms
    Reset for next command	0.06 ms

    Pile d'appels

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

20. Temps de requête : 3.47 ms Après la dernière requête : 24.12 ms Mémoire de requête : 0.024 MB mémoire avant requête : 8.630 MB Rangées retournées : 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `josa_contentitem_tag_map` AS m 
    
      INNER JOIN `josa_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 17 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	naiscywr_joomla.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.10 ms
    Waiting for query cache lock	0.04 ms
    Init	0.04 ms
    Checking query cache for query	0.27 ms
    Checking permissions	0.05 ms
    Opening tables	0.40 ms
    After opening tables	0.09 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    Waiting for query cache lock	0.10 ms
    Init	0.22 ms
    Optimizing	0.10 ms
    Statistics	0.40 ms
    Preparing	0.12 ms
    Executing	0.04 ms
    Sending data	0.20 ms
    End of update loop	0.04 ms
    Query end	0.06 ms
    Commit	0.03 ms
    Closing tables	0.15 ms
    Unlocking tables	0.09 ms
    Closing tables	0.09 ms
    Starting cleanup	0.06 ms
    Freeing items	0.11 ms
    Updating status	0.07 ms
    Waiting for query cache lock	0.06 ms
    Updating status	0.15 ms
    Waiting for query cache lock	0.06 ms
    Updating status	0.06 ms
    Storing result in query cache	4.33 ms
    Reset for next command	0.09 ms

    Pile d'appels

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
    11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

21. Temps de requête : 7.19 ms Après la dernière requête : 67.34 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.841 MB Rangées retournées : 4

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM josa_modules AS m
    
      LEFT JOIN josa_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN josa_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 <= '2023-03-27 20:41:12') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-27 20:41:12') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 118 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explication

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

    Profil

    Status	Duration
    Starting	0.13 ms
    Waiting for query cache lock	0.06 ms
    Init	0.05 ms
    Checking query cache for query	0.45 ms
    Checking permissions	0.08 ms
    Opening tables	0.38 ms
    After opening tables	0.11 ms
    System lock	0.10 ms
    Table lock	0.12 ms
    Waiting for query cache lock	0.21 ms
    Init	0.21 ms
    Optimizing	0.27 ms
    Statistics	0.51 ms
    Preparing	0.25 ms
    Sorting result	0.13 ms
    Executing	0.06 ms
    Sending data	0.08 ms
    Creating sort index	2.69 ms
    End of update loop	0.20 ms
    Query end	0.07 ms
    Commit	0.06 ms
    Closing tables	0.06 ms
    Unlocking tables	0.05 ms
    Closing tables	0.09 ms
    Starting cleanup	0.11 ms
    Freeing items	0.08 ms
    Updating status	0.07 ms
    Waiting for query cache lock	0.05 ms
    Updating status	0.12 ms
    Waiting for query cache lock	0.06 ms
    Updating status	0.09 ms
    Storing result in query cache	0.07 ms
    Reset for next command	0.06 ms

    Pile d'appels

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:430
    17	JModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:373
    16	JModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:89
    15	JModuleHelper::getModules()	JROOT/templates/purity_iii/helper.php:75
    14	JATemplateHelper::loadModules()	JROOT/templates/purity_iii/html/com_content/article/default.php:161
    13	include JROOT/templates/purity_iii/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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:257
    1	JApplicationCms->execute()	JROOT/index.php:50

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

    ---

20 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 josa_extensions

2. 1 × SELECT * 
     FROM josa_content

3. 1 × SELECT b.rules 
     FROM josa_assets AS a 
     LEFT JOIN josa_assets AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

4. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
     CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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 
     FROM josa_content AS a 
     LEFT JOIN josa_categories AS c 
     on c.id = a.catid 
     LEFT JOIN josa_users AS u 
     on u.id = a.created_by 
     LEFT JOIN josa_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN josa_content_rating AS v 
     ON a.id = v.content_id 
     LEFT 
     OUTER JOIN  (SELECT cat.id as id 
     FROM josa_categories AS cat JOIN josa_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

5. 1 × SELECT `m`.`tag_id`,`t`.* 
     FROM `josa_contentitem_tag_map` AS m  
     INNER JOIN `josa_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`

6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM josa_modules AS m 
     LEFT JOIN josa_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN josa_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

7. 1 × SELECT a.rules 
     FROM josa_assets AS a

8. 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 josa_categories as c 
     LEFT JOIN  (SELECT cat.id as id 
     FROM josa_categories AS cat JOIN josa_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

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

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

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

12. 1 × SELECT id, rules 
      FROM `josa_viewlevels

13. 1 × SELECT folder AS type, element AS name, params 
      FROM josa_extensions

14. 1 × SELECT `data` 
      FROM `josa_session`

15. 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 josa_menu AS m 
      LEFT JOIN josa_extensions AS e 
      ON m.component_id = e.extension_id

16. 1 × SELECT * 
      FROM josa_languages

Autres tables :

1. 1 × UPDATE josa_content 
     SET `hits` = (`hits` + 1)

2. 1 × SHOW FULL COLUMNS 
     FROM `josa_content

3. 1 × UPDATE `josa_extensions` 
     SET `params` = '{\"mediaversion\":\"01aa1717c80624927a6ae23bc3c44985\"}'

4. 1 × INSERT INTO `josa_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('1l7r0e5c7pec09dghtpvpu7i34', 0, '1679949672'