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

Temps

Mémoire

9 requêtes exécutées 20.27 ms

1. Temps de requête : 0.82 ms Mémoire de requête : 0.007 MB mémoire avant requête : 0.949 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `jxnyp_session`
   
     WHERE `session_id` = 'cece8e3f8ff87f25da1c62f4f1c5f525'

   Explication

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

   Profil

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.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.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.30 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:755
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Temps de requête : 0.50 ms Après la dernière requête : 0.56 ms Mémoire de requête : 0.004 MB mémoire avant requête : 0.963 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `jxnyp_session`
   
     WHERE `session_id` = 'cece8e3f8ff87f25da1c62f4f1c5f525' 
     LIMIT 1

   Explication

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

   Profil

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

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Temps de requête : 2.85 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.004 MB mémoire avant requête : 0.968 MB

   INSERT INTO `jxnyp_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('cece8e3f8ff87f25da1c62f4f1c5f525', 1, '1550309904', 0, '', 0)

   Explication

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

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.01 ms
   update	0.06 ms
   Waiting for query cache lock	0.01 ms
   update	0.02 ms
   end	0.00 ms
   query end	2.33 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   logging slow query	0.01 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Temps de requête : 0.59 ms Après la dernière requête : 1.90 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.031 MB Rangées retournées : 6

   SELECT id, rules
   
     FROM `jxnyp_viewlevels`

   Explication

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

   Profil

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

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Temps de requête : 0.33 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.042 MB Rangées retournées : 2

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

   Explication

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

   Profil

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

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Temps de requête : 3.09 ms Après la dernière requête : 16.65 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.943 MB

   UPDATE `jxnyp_extensions`
   
     SET `params` = '{\"mediaversion\":\"41e3f7102b9a294436318faca865d118\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explication

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

   Profil

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

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Temps de requête : 2.57 ms Après la dernière requête : 30.21 ms Mémoire de requête : 0.010 MB mémoire avant requête : 2.128 MB Rangées retournées : 33

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

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jxnyp_assets	range	idx_asset_name	idx_asset_name	152	NULL	34	Using where

   Profil

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

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
   15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
   14	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
   13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:423
   12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:54
   11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
   10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Temps de requête : 8.49 ms Après la dernière requête : 2.05 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.199 MB Rangées retournées : 0

   SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN c.published = 2 
     AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
     CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
   							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
   
     FROM jxnyp_content AS a
   
     INNER JOIN jxnyp_content_frontpage AS fp 
     ON fp.content_id = a.id
   
     LEFT JOIN jxnyp_categories AS c 
     ON c.id = a.catid
   
     LEFT JOIN jxnyp_users AS ua 
     ON ua.id = a.created_by
   
     LEFT JOIN jxnyp_users AS uam 
     ON uam.id = a.modified_by
   
     LEFT JOIN jxnyp_categories as parent 
     ON parent.id = c.parent_id
   
     LEFT JOIN jxnyp_content_rating AS v 
     ON a.id = v.content_id
   
     WHERE a.access IN (1,1,5) 
     AND c.access IN (1,1,5) 
     AND c.published = 1 
     AND a.state = 1 
     AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-16 09:38:24') 
     AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-16 09:38:24')
   
     ORDER BY c.lft, a.featured DESC, fp.ordering,  
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
     LIMIT 6, 6

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	fp	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	47	Using temporary; Utilisation du tri complet de type filesort
   1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	tremblaycnsite.fp.content_id	1	Using where
   1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	tremblaycnsite.a.catid	1	Using where
   1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	tremblaycnsite.a.created_by	1
   1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	tremblaycnsite.a.modified_by	1
   1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	tremblaycnsite.c.parent_id	1
   1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	tremblaycnsite.a.id	1

   Profil

   Status	Duration
   starting	0.01 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
   Opening tables	0.04 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.05 ms
   init	0.13 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.03 ms
   Creating tmp table	6.28 ms
   executing	0.01 ms
   Copying to tmp table	0.66 ms
   Sorting result	0.04 ms
   Sending data	0.05 ms
   end	0.00 ms
   removing tmp table	0.14 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
   16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
   15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
   14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
   13	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
   12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
   11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
   10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Temps de requête : 1.05 ms Après la dernière requête : 1.10 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.213 MB Rangées retournées : 1

   SELECT COUNT(*)
   
     FROM jxnyp_content AS a
   
     INNER JOIN jxnyp_content_frontpage AS fp 
     ON fp.content_id = a.id
   
     LEFT JOIN jxnyp_categories AS c 
     ON c.id = a.catid
   
     LEFT JOIN jxnyp_users AS ua 
     ON ua.id = a.created_by
   
     LEFT JOIN jxnyp_users AS uam 
     ON uam.id = a.modified_by
   
     LEFT JOIN jxnyp_categories as parent 
     ON parent.id = c.parent_id
   
     LEFT JOIN jxnyp_content_rating AS v 
     ON a.id = v.content_id
   
     WHERE a.access IN (1,1,5) 
     AND c.access IN (1,1,5) 
     AND c.published = 1 
     AND a.state = 1 
     AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-16 09:38:24') 
     AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-16 09:38:24')

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	fp	index	PRIMARY	PRIMARY	4	NULL	47	Using index
   1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	tremblaycnsite.fp.content_id	1	Using where
   1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	tremblaycnsite.a.catid	1	Using where
   1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	tremblaycnsite.a.created_by	1	Using index
   1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	tremblaycnsite.a.modified_by	1	Using index
   1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	tremblaycnsite.c.parent_id	1	Using index
   1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	tremblaycnsite.a.id	1	Using index

   Profil

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.11 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.03 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.03 ms
   executing	0.01 ms
   Sending data	0.17 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.25 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
   15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
   14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
   13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:423
   12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
   11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
   10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

1. 1 × SELECT `data` 
     FROM `jxnyp_session`

2. 1 × SELECT `session_id` 
     FROM `jxnyp_session`

3. 1 × SELECT id, rules 
     FROM `jxnyp_viewlevels

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

5. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `jxnyp_assets`

6. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN c.published = 2 
     AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
     CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
     FROM jxnyp_content AS a 
     INNER JOIN jxnyp_content_frontpage AS fp 
     ON fp.content_id = a.id 
     LEFT JOIN jxnyp_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN jxnyp_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN jxnyp_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN jxnyp_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN jxnyp_content_rating AS v 
     ON a.id = v.content_id

7. 1 × SELECT COUNT(*) 
     FROM jxnyp_content AS a 
     INNER JOIN jxnyp_content_frontpage AS fp 
     ON fp.content_id = a.id 
     LEFT JOIN jxnyp_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN jxnyp_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN jxnyp_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN jxnyp_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN jxnyp_content_rating AS v 
     ON a.id = v.content_id

Autres tables :

1. 1 × INSERT INTO `jxnyp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('cece8e3f8ff87f25da1c62f4f1c5f525', 1, '1550309904', 0, '', 0

2. 1 × UPDATE `jxnyp_extensions` 
     SET `params` = '{\"mediaversion\":\"41e3f7102b9a294436318faca865d118\"}'