{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1529894168,
                "last": 1529894168,
                "now": 1529894168
            },
            "token": "BHzY03HNoMOf93fmdMstXEUUIAUMFHEf"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cDovL2FsbGlhbmNlbXVzaWNhbGUuZnIvaW5kZXgucGhwPw%3D%3D"
            },
            "jevents": {
                "moduleid103": {
                    "shownEventIds": [],
                    "page": 0,
                    "firstEventDate": false
                }
            },
            "published_fv_ses": "0",
            "justmine_fv_ses": "0"
        },
        "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

72 requêtes exécutées 53.25 ms

1. Temps de requête : 0.41 ms Mémoire de requête : 0.027 MB mémoire avant requête : 3.294 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `jnew_session`
   
     WHERE `session_id` = '937919f06ca95e08e418224c3d4c8132'

   Explication

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

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.00 ms
   After opening tables	0.01 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
   updating status	0.02 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   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.62 ms Après la dernière requête : 4.86 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.399 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `jnew_session`
   
     WHERE `session_id` = '937919f06ca95e08e418224c3d4c8132' 
     LIMIT 1

   Explication

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

   Profil

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After opening tables	0.01 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.04 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   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 : 0.72 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.005 MB mémoire avant requête : 3.406 MB

   INSERT INTO `jnew_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('937919f06ca95e08e418224c3d4c8132', 1, '1529894168', 0, '', 0)

   Explication

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

   Profil

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After opening tables	0.01 ms
   init	0.02 ms
   update	0.14 ms
   end	0.01 ms
   query end	0.05 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.04 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 : 1.14 ms Après la dernière requête : 14.40 ms Mémoire de requête : 0.046 MB mémoire avant requête : 3.613 MB Rangées retournées : 45

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

   Explication

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

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   After opening tables	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.32 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:431
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
   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.47 ms Après la dernière requête : 14.20 ms Mémoire de requête : 0.024 MB mémoire avant requête : 3.832 MB Rangées retournées : 3

   SELECT id, rules
   
     FROM `jnew_viewlevels`

   Explication

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

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.00 ms
   After opening tables	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.04 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.00 ms
   updating status	0.02 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
   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:310
   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 : 0.45 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.024 MB mémoire avant requête : 3.846 MB Rangées retournées : 1

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

   Explication

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

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.00 ms
   After opening tables	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.02 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
   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:310
   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]

   ---

7. Temps de requête : 1.36 ms Après la dernière requête : 2.32 ms Mémoire de requête : 0.040 MB mémoire avant requête : 3.973 MB Rangées retournées : 124

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

   Explication

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

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   After opening tables	0.00 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.03 ms
   executing	0.00 ms
   Sorting result	0.51 ms
   Sending data	0.27 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.02 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
   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]

   ---

8. Temps de requête : 0.48 ms Après la dernière requête : 98.07 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.886 MB Rangées retournées : 1

   SELECT count(*)
   
     FROM `jnew_cwgears_schedule`

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Select tables optimized away

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   After opening tables	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.02 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:96
   8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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]

   ---

9. Temps de requête : 0.43 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.024 MB mémoire avant requête : 5.894 MB Rangées retournées : 1

   SELECT count(*)
   
     FROM `jnew_cwgears_schedule`
   
     WHERE time + '3600'<'1529894168'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   After opening tables	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.02 ms
   cleaning up	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:139
   8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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]

   ---

10. Temps de requête : 1.92 ms Après la dernière requête : 8.65 ms Mémoire de requête : 0.082 MB mémoire avant requête : 6.080 MB Rangées retournées : 47

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM jnew_menu AS m
    
      LEFT JOIN jnew_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	78	Using index condition; Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	alliance3.m.component_id	1	Using where

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.30 ms
    Sending data	0.35 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:488
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1070
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

11. Temps de requête : 0.60 ms Après la dernière requête : 60.05 ms Mémoire de requête : 0.030 MB mémoire avant requête : 6.948 MB Rangées retournées : 1

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

    Explication

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

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 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
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
    8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

12. Temps de requête : 0.63 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.009 MB mémoire avant requête : 6.944 MB

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

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.00 ms
    init	0.07 ms
    updating	0.07 ms
    end	0.01 ms
    query end	0.05 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
    8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

13. Temps de requête : 0.98 ms Après la dernière requête : 17.83 ms Mémoire de requête : 0.041 MB mémoire avant requête : 7.197 MB Rangées retournées : 92

    SELECT *
    
      FROM `jnew_jcomments_settings`
    
      WHERE `lang` = '' 
      AND `component` = ''

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_jcomments_settings	ref	PRIMARY	PRIMARY	214	const,const	96	Using index condition

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.39 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
    14	JCommentsCfg::_load()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_jcomments/classes/config.php:159
    11	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
    10	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
    9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
    8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

14. Temps de requête : 0.81 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.026 MB mémoire avant requête : 7.206 MB Rangées retournées : 6

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	13	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	alliance3.s.template,const	1	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_jcomments/helpers/system.php:46
    9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
    8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

15. Temps de requête : 0.42 ms Après la dernière requête : 1.79 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.217 MB Rangées retournées : 1

    SELECT count(*)
    
      FROM `jnew_extensions`
    
      WHERE `element` = 'cwgears' 
      AND `extension_id` = ''

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 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
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:1003
    9	plgSystemCwgears->updateDownloadKeySub()	JROOT/plugins/system/cwgears/cwgears.php:202
    8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

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

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

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sorting result	0.04 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

17. Temps de requête : 2.03 ms Après la dernière requête : 32.86 ms Mémoire de requête : 0.037 MB mémoire avant requête : 7.909 MB Rangées retournées : 41

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

    Explication

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

    Profil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After opening tables	0.01 ms
    init	0.08 ms
    optimizing	0.02 ms
    statistics	0.21 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	1.00 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.04 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:113
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
    13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:54
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

18. Temps de requête : 2.24 ms Après la dernière requête : 5.61 ms Mémoire de requête : 0.043 MB mémoire avant requête : 8.052 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 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 jnew_content AS a
    
      INNER JOIN jnew_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN jnew_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jnew_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jnew_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jnew_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jnew_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-25 02:36:08') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-25 02:36:08')
    
      ORDER BY 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 9

    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	32	Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	alliance3.fp.content_id	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	alliance3.a.catid	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	alliance3.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	alliance3.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	alliance3.c.parent_id	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	alliance3.a.id	1	Using where

    Profil

    Status	Duration
    starting	0.24 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After opening tables	0.01 ms
    init	0.12 ms
    optimizing	0.05 ms
    statistics	0.15 ms
    preparing	0.10 ms
    executing	0.02 ms
    Copying to tmp table	0.21 ms
    Copying to tmp table	0.47 ms
    Sorting result	0.05 ms
    Sending data	0.09 ms
    end	0.01 ms
    removing tmp table	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.04 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

19. Temps de requête : 0.73 ms Après la dernière requête : 5.70 ms Mémoire de requête : 0.038 MB mémoire avant requête : 8.357 MB Rangées retournées : 0

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

    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	alliance3.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After opening tables	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.04 ms
    executing	0.01 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
    updating status	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

20. Temps de requête : 0.77 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.038 MB mémoire avant requête : 8.381 MB Rangées retournées : 0

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

    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	alliance3.m.tag_id	1	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After opening tables	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.04 ms
    executing	0.01 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
    updating status	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

21. Temps de requête : 0.96 ms Après la dernière requête : 2.87 ms Mémoire de requête : 0.028 MB mémoire avant requête : 8.457 MB Rangées retournées : 1

    SELECT COUNT(*)
    
      FROM jnew_content AS a
    
      INNER JOIN jnew_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN jnew_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jnew_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jnew_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jnew_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jnew_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-25 02:36:08') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-25 02:36:08')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fp	index	PRIMARY	PRIMARY	4	NULL	32	Using index
    1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	alliance3.fp.content_id	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	alliance3.a.catid	1	Using where

    Profil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After opening tables	0.01 ms
    init	0.04 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sending data	0.19 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

22. Temps de requête : 1.07 ms Après la dernière requête : 65.23 ms Mémoire de requête : 0.043 MB mémoire avant requête : 9.516 MB Rangées retournées : 4

    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 `jnew_categories` AS `s`
    
      INNER JOIN `jnew_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id = 60
    
      ORDER BY c.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	9	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After opening tables	0.01 ms
    init	0.06 ms
    optimizing	0.04 ms
    statistics	0.15 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sorting result	0.01 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

23. Temps de requête : 1.02 ms Après la dernière requête : 1.57 ms Mémoire de requête : 0.040 MB mémoire avant requête : 9.574 MB Rangées retournées : 0

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

    Explication

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

    Profil

    Status	Duration
    starting	0.12 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
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After opening tables	0.01 ms
    init	0.06 ms
    optimizing	0.04 ms
    statistics	0.11 ms
    preparing	0.07 ms
    executing	0.01 ms
    Sorting result	0.04 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
    updating status	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

24. Temps de requête : 0.50 ms Après la dernière requête : 22.74 ms Mémoire de requête : 0.030 MB mémoire avant requête : 10.056 MB Rangées retournées : 0

    SELECT `name`, `value`
    
      FROM `jnew_jsn_imageshow_config`
    
      WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_jsn_imageshow_config	range	name	name	767	NULL	3	Using where

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 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:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81
    16	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
    15	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
    14	include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/plugins/content/imageshow/imageshow.php:28
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

25. Temps de requête : 0.79 ms Après la dernière requête : 14.02 ms Mémoire de requête : 0.033 MB mémoire avant requête : 10.377 MB Rangées retournées : 1
    Requêtes dupliquées: #50

    SELECT *
    
      FROM jnew_extensions
    
      WHERE element='com_imageshow' 
      AND type='component'

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
    14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

26. Temps de requête : 0.53 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.034 MB mémoire avant requête : 10.394 MB Rangées retournées : 1
    Requêtes dupliquées: #32  #40

    SELECT * 
      FROM jnew_imageshow_showlist 
      WHERE  published = 1 
      AND  showlist_id = 1

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
    14	JSNISShowlist->getShowListByID()	JROOT/plugins/content/imageshow/imageshow.php:99
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

27. Temps de requête : 0.47 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.030 MB mémoire avant requête : 10.408 MB Rangées retournées : 1

    SELECT * 
      FROM jnew_imageshow_showcase 
      WHERE  published = 1 
      AND  showcase_id = 1

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcase.php:155
    14	JSNISShowcase->getShowCaseByID()	JROOT/plugins/content/imageshow/imageshow.php:107
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

28. Temps de requête : 0.75 ms Après la dernière requête : 1.76 ms Mémoire de requête : 0.029 MB mémoire avant requête : 10.457 MB Rangées retournées : 1

    SELECT * 
      FROM jnew_imageshow_theme_profile 
      WHERE showcase_id =1

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:341
    14	JSNISShowcaseTheme->getThemeProfile()	JROOT/plugins/content/imageshow/imageshow.php:119
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

29. Temps de requête : 0.65 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.033 MB mémoire avant requête : 10.468 MB Rangées retournées : 1

    SELECT *
    			   
      FROM jnew_extensions
    			   
      WHERE folder = 'jsnimageshow'
    			   
      AND element='themecarousel'

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:293
    14	JSNISShowcaseTheme->getThemeInfo()	JROOT/plugins/content/imageshow/imageshow.php:130
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

30. Temps de requête : 0.43 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.480 MB Rangées retournées : 0

    SELECT c.introtext, c.fulltext
    				   
      FROM jnew_imageshow_showlist sl
    				   
      INNER JOIN jnew_content c 
      ON sl.alter_autid = c.id
    				   
      WHERE sl.showlist_id=1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.06 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
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_show.php:85
    14	JSNISShow->getArticleAuth()	JROOT/plugins/content/imageshow/imageshow.php:149
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

31. Temps de requête : 0.76 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.035 MB mémoire avant requête : 10.491 MB Rangées retournées : 10
    Requêtes dupliquées: #39

    SELECT
    						image_id, image_title, image_alt_text,
    						image_small, image_big, image_medium,
    						image_description, image_link,
    						image_extid, album_extid, image_size, custom_data, exif_data,
    						image_size, sync, ordering				
    				   
      FROM jnew_imageshow_images
    				   
      WHERE showlist_id =1
    				   
      ORDER BY ordering ASC

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sorting result	0.06 ms
    Sending data	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:47
    14	JSNISImages->getImagesByShowlistID()	JROOT/plugins/content/imageshow/imageshow.php:151
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

32. Temps de requête : 0.46 ms Après la dernière requête : 6.79 ms Mémoire de requête : 0.038 MB mémoire avant requête : 10.596 MB Rangées retournées : 1
    Requêtes dupliquées: #26  #40

    SELECT * 
      FROM jnew_imageshow_showlist 
      WHERE  published = 1 
      AND  showlist_id = 1

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
    21	JSNISShowlist->getShowListByID()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:25
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

33. Temps de requête : 0.84 ms Après la dernière requête : 1.49 ms Mémoire de requête : 0.042 MB mémoire avant requête : 10.630 MB Rangées retournées : 20

    SHOW FULL COLUMNS 
      FROM `jnew_imageshow_showlist`

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.15 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.04 ms
    closing tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
    26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    24	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_imageshow/tables/showlist.php:41
    23	TableShowList->__construct()	JROOT/libraries/src/Table/Table.php:312
    22	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:120
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:26
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

34. Temps de requête : 0.51 ms Après la dernière requête : 4.42 ms Mémoire de requête : 0.039 MB mémoire avant requête : 10.702 MB Rangées retournées : 1
    Requêtes dupliquées: #35

    SELECT *
    
      FROM jnew_imageshow_showlist
    
      WHERE `showlist_id` = '1'

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.00 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    22	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:123
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:26
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

35. Temps de requête : 0.57 ms Après la dernière requête : 12.39 ms Mémoire de requête : 0.040 MB mémoire avant requête : 10.951 MB Rangées retournées : 1
    Requêtes dupliquées: #34

    SELECT *
    
      FROM jnew_imageshow_showlist
    
      WHERE `showlist_id` = '1'

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    26	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    25	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_default.php:20
    24	JSNImagesSourcesDefault->__construct()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:18
    23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
    22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:26
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

36. Temps de requête : 0.51 ms Après la dernière requête : 3.00 ms Mémoire de requête : 0.018 MB mémoire avant requête : 11.027 MB

    UPDATE jnew_extensions 
      SET enabled = 1 
      WHERE element LIKE 'source%' 
      AND folder = 'jsnimageshow' 
      AND enabled = 0

    Explication

    EXPLAIN impossible sur la requête : UPDATE jnew_extensions SET enabled = 1 WHERE element LIKE 'source%' AND folder = 'jsnimageshow' AND enabled = 0

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.00 ms
    init	0.08 ms
    updating	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    29	JDatabase->query()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:67
    28	JSNISSource->_setListSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:26
    27	JSNISSource->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:33
    26	JSNISFactory::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:70
    25	JSNISFactory::getObj()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:33
    24	JSNImagesSourcesInternal->checkComponent()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:20
    23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
    22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:26
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

37. Temps de requête : 0.63 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.041 MB mémoire avant requête : 11.046 MB Rangées retournées : 1

    SELECT * 
      FROM jnew_extensions 
      WHERE element LIKE 'source%' 
      AND folder = 'jsnimageshow' 
      AND enabled = 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jnew_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	1	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    29	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:71
    28	JSNISSource->_setListSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:26
    27	JSNISSource->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:33
    26	JSNISFactory::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:70
    25	JSNISFactory::getObj()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:33
    24	JSNImagesSourcesInternal->checkComponent()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:20
    23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
    22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:26
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

38. Temps de requête : 0.52 ms Après la dernière requête : 3.68 ms Mémoire de requête : 0.034 MB mémoire avant requête : 11.169 MB Rangées retournées : 0

    SELECT album_extid
    				  
      FROM jnew_imageshow_images
    				  
      WHERE showlist_id =1
    				  
      AND sync = 1
    				  
      GROUP BY album_extid

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.00 ms
    Copying to tmp table	0.02 ms
    Copying to tmp table	0.05 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    end	0.00 ms
    removing tmp table	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:199
    24	JSNISImages->getSyncAlbumsByShowlistID()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:23
    23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
    22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:26
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

39. Temps de requête : 0.68 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.041 MB mémoire avant requête : 11.187 MB Rangées retournées : 10
    Requêtes dupliquées: #31

    SELECT
    						image_id, image_title, image_alt_text,
    						image_small, image_big, image_medium,
    						image_description, image_link,
    						image_extid, album_extid, image_size, custom_data, exif_data,
    						image_size, sync, ordering				
    				   
      FROM jnew_imageshow_images
    				   
      WHERE showlist_id =1
    				   
      ORDER BY ordering ASC

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sorting result	0.04 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:47
    25	JSNISImages->getImagesByShowlistID()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_default.php:157
    24	JSNImagesSourcesDefault->getImages2JSON()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:102
    23	JSNImagesSourcesInternal->getImages2JSON()	JROOT/administrator/components/com_imageshow/imagesources/source_folder/internal_source_folder.php:409
    22	JSNInternalSourceFolder->getImages2JSON()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:126
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:26
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

40. Temps de requête : 0.55 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.039 MB mémoire avant requête : 11.234 MB Rangées retournées : 1
    Requêtes dupliquées: #26  #32

    SELECT * 
      FROM jnew_imageshow_showlist 
      WHERE  published = 1 
      AND  showlist_id = 1

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
    22	JSNISShowlist->getShowListByID()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:129
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:26
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

41. Temps de requête : 1.12 ms Après la dernière requête : 3.56 ms Mémoire de requête : 0.042 MB mémoire avant requête : 11.241 MB Rangées retournées : 27

    SHOW FULL COLUMNS 
      FROM `jnew_imageshow_theme_carousel`

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    closing tables	0.00 ms
    Opening tables	0.14 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.05 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
    26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    24	Joomla\CMS\Table\Table->__construct()	JROOT/plugins/jsnimageshow/themecarousel/tables/themecarousel.php:45
    23	TableThemeCarousel->__construct()	JROOT/libraries/src/Table/Table.php:312
    22	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/jsnimageshow/themecarousel/models/themecarousel.php:53
    21	ThemeCarousel->getTable()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:58
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

42. Temps de requête : 0.55 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.041 MB mémoire avant requête : 11.310 MB Rangées retournées : 1

    SELECT *
    
      FROM jnew_imageshow_theme_carousel
    
      WHERE `theme_id` = '1'

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    22	Joomla\CMS\Table\Table->load()	JROOT/plugins/jsnimageshow/themecarousel/models/themecarousel.php:55
    21	ThemeCarousel->getTable()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:58
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

43. Temps de requête : 1.27 ms Après la dernière requête : 20.22 ms Mémoire de requête : 0.044 MB mémoire avant requête : 11.529 MB Rangées retournées : 160

    SHOW TABLES

    Explication

    EXPLAIN impossible sur la requête : SHOW TABLES

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Filling schema table	0.01 ms
    checking permissions	0.71 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.00 ms
    freeing items	0.00 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    24	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
    23	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
    22	JSNConfigHelper::get()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:305
    21	JSNISCarouselDisplay->loadjQuery()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:63
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

44. Temps de requête : 0.40 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.033 MB mémoire avant requête : 11.566 MB Rangées retournées : 3

    SELECT name,value
    
      FROM jnew_jsn_imageshow_config
    
      WHERE 1

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
    22	JSNConfigHelper::get()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:305
    21	JSNISCarouselDisplay->loadjQuery()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:63
    20	JSNISCarouselDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themecarousel/classes/jsn_is_carouseldisplay.php:292
    19	JSNISCarouselDisplay->display()	JROOT/plugins/jsnimageshow/themecarousel/themecarousel.php:78
    18	plgJSNImageshowThemeCarousel->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/plugins/content/imageshow/imageshow.php:205
    13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

45. Temps de requête : 0.44 ms Après la dernière requête : 86.91 ms Mémoire de requête : 0.028 MB mémoire avant requête : 11.979 MB Rangées retournées : 1

    SELECT created_by, catid
    
      FROM jnew_content
    
      WHERE id = 185

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:319
    13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:106
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

46. Temps de requête : 1.15 ms Après la dernière requête : 2.16 ms Mémoire de requête : 0.065 MB mémoire avant requête : 12.005 MB Rangées retournées : 242

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jnew_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.00 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.41 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    21	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    17	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_attachments/permissions.php:125
    16	AttachmentsPermissions::userMayEditArticle()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:884
    15	AttachmentsPlugin_Com_Content->userMayAddAttachment()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862
    14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:325
    13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:106
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

47. Temps de requête : 0.67 ms Après la dernière requête : 18.05 ms Mémoire de requête : 0.036 MB mémoire avant requête : 12.372 MB Rangées retournées : 0

    SELECT a.*, u.name as creator_name
    
      FROM jnew_attachments AS a
    
      LEFT JOIN jnew_users AS u 
      ON u.id = a.created_by
    
      WHERE a.parent_id=185 
      AND a.state = 1 
      AND a.parent_type='com_content' 
      AND a.parent_entity='article' 
      AND a.access IN (1)
    
      ORDER BY filename

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	116	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	alliance3.a.created_by	1

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.00 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.12 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_attachments/models/attachments.php:436
    17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
    16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
    15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:325
    13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:106
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

48. Temps de requête : 0.86 ms Après la dernière requête : 19.40 ms Mémoire de requête : 0.043 MB mémoire avant requête : 12.505 MB Rangées retournées : 3

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Utilisation du tri complet de type filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	63	Using where

    Profil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.00 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.10 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    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]

    ---

49. Temps de requête : 0.77 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.040 MB mémoire avant requête : 12.520 MB Rangées retournées : 0

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