Tous les évènements

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1614827885,
                "last": 1614827885,
                "now": 1614827885
            },
            "client": {
                "forwarded": "3.239.33.139"
            },
            "token": "drJPldkd9ELzBPAiqLFNeK8zQFN3m9BL"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cDovL3ZpbGxlLWZpZ3VpZy5pbmZvL2luZGV4LnBocC9zZXJ2aWNlcy1pbmZyYXN0cnVjdHVyZXMvbWFpc29uLWRlLWxhLWN1bHR1cmUvY2FsZW5kcmllci1kLWFjdGl2aXRlcz8%3D"
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "vvisit_counter": {
            "lastlog": 1614828600
        }
    }
}

Temps

Mémoire

17 requêtes exécutées 71.74 ms

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

   SELECT `data`
   
     FROM `dvrex_session`
   
     WHERE `session_id` = X'3131653732333535393933373064313233653435363033343236323932663633'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	dvrex_session	const	PRIMARY	PRIMARY	194	const	1

   Profil

   Status	Duration
   Starting	0.11 ms
   Checking permissions	0.01 ms
   Opening tables	1.59 ms
   After opening tables	0.04 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.05 ms
   Updating status	0.05 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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.52 ms Après la dernière requête : 0.70 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.225 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `dvrex_session`
   
     WHERE `session_id` = X'3131653732333535393933373064313233653435363033343236323932663633' 
     LIMIT 1

   Explication

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

   Profil

   Status	Duration
   Starting	0.09 ms
   Checking permissions	0.03 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.02 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.03 ms
   Freeing items	0.05 ms
   Updating status	0.05 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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 : 1.77 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.231 MB

   INSERT INTO `dvrex_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3131653732333535393933373064313233653435363033343236323932663633', 1, 1614827885, 0, '', 0)

   Explication

   EXPLAIN impossible sur la requête : INSERT INTO `dvrex_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3131653732333535393933373064313233653435363033343236323932663633', 1, 1614827885, 0, '', 0)

   Profil

   Status	Duration
   Starting	0.08 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
   Init for update	0.02 ms
   Update	0.93 ms
   Waiting for query cache lock	0.04 ms
   Update	0.03 ms
   End of update loop	0.01 ms
   Query end	0.02 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.02 ms
   Waiting for query cache lock	0.01 ms
   Unlocking tables	0.27 ms
   Closing tables	0.03 ms
   Starting cleanup	0.02 ms
   Freeing items	0.07 ms
   Updating status	0.05 ms
   Reset for next command	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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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 : 3.13 ms Après la dernière requête : 0.95 ms Mémoire de requête : 0.006 MB mémoire avant requête : 1.266 MB Rangées retournées : 34

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `dvrex_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	dvrex_extensions	ref	extension	extension	62	const	41	Using index condition; Using where

   Profil

   Status	Duration
   Starting	0.21 ms
   Checking permissions	0.02 ms
   Opening tables	1.17 ms
   After opening tables	0.03 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   Init	0.06 ms
   Optimizing	0.03 ms
   Statistics	0.10 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.98 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.13 ms
   Closing tables	0.02 ms
   Starting cleanup	0.03 ms
   Freeing items	0.07 ms
   Updating status	0.56 ms
   Reset for next command	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   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:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   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:594
   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:196
   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 : 1.80 ms Après la dernière requête : 2.27 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.369 MB Rangées retournées : 4

   SELECT id, rules
   
     FROM `dvrex_viewlevels`

   Explication

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

   Profil

   Status	Duration
   Starting	0.08 ms
   Checking permissions	0.01 ms
   Opening tables	1.33 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.05 ms
   Updating status	0.05 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   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:196
   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 : 1.23 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.380 MB Rangées retournées : 1

   SELECT b.id
   
     FROM dvrex_usergroups AS a
   
     LEFT JOIN dvrex_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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where

   Profil

   Status	Duration
   Starting	0.07 ms
   Checking permissions	0.01 ms
   Opening tables	0.70 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.04 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.05 ms
   Updating status	0.05 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Temps de requête : 2.83 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.403 MB Rangées retournées : 66

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM dvrex_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	dvrex_extensions	ref	extension	extension	62	const	131	Using index condition; Using where; Utilisation du tri complet de type filesort

   Profil

   Status	Duration
   Starting	0.28 ms
   Checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   Init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.14 ms
   Preparing	0.03 ms
   Sorting result	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	1.80 ms
   End of update loop	0.03 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.11 ms
   Reset for next command	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   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:359
   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:604
   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:196
   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 : 20.86 ms Après la dernière requête : 5.17 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.736 MB

   UPDATE dvrex_vvisit_counter
   
     SET visits=visits+1
   	, guests=guests+1
   
     WHERE time=1614828600

   Explication

   EXPLAIN impossible sur la requête : UPDATE dvrex_vvisit_counter SET visits=visits+1 , guests=guests+1 WHERE time=1614828600

   Profil

   Status	Duration
   Starting	0.13 ms
   Checking permissions	0.01 ms
   Opening tables	1.43 ms
   After opening tables	0.04 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init for update	0.03 ms
   Updating	18.74 ms
   End of update loop	0.07 ms
   Waiting for query cache lock	0.01 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Waiting for query cache lock	0.01 ms
   Unlocking tables	0.02 ms
   Closing tables	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.07 ms
   Updating status	0.07 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:109
   10	plgSystemVVisit_Counter::_updateRecord()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:75
   9	plgSystemVVisit_Counter::_insertRecord()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:43
   8	plgSystemVVisit_Counter->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:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:196
   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 : 12.22 ms Après la dernière requête : 1.36 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.840 MB Rangées retournées : 71

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

   Profil

   Status	Duration
   Starting	0.23 ms
   Checking permissions	0.02 ms
   Opening tables	1.93 ms
   After opening tables	0.05 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   Init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.11 ms
   Preparing	0.04 ms
   Sorting result	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   Creating sort index	9.23 ms
   End of update loop	0.06 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.08 ms
   Updating status	0.11 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   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:375
   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:491
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   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:196
   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 : 0.98 ms Après la dernière requête : 3.59 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.291 MB Rangées retournées : 1

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

    Explication

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

    Profil

    Status	Duration
    Starting	0.19 ms
    Checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.26 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.06 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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.78 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.005 MB mémoire avant requête : 2.282 MB

    UPDATE `dvrex_extensions`
    
      SET `params` = '{\"mediaversion\":\"8f9a94e3a520a72965a762ccc8f01a49\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

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

    Profil

    Status	Duration
    Starting	0.11 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
    Init for update	0.20 ms
    Updating	0.07 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Waiting for query cache lock	0.01 ms
    Unlocking tables	0.02 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.06 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 3.44 ms Après la dernière requête : 0.60 ms Mémoire de requête : 0.003 MB mémoire avant requête : 2.331 MB Rangées retournées : 2

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	dvrex_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.09 ms
    Checking permissions	0.02 ms
    Opening tables	1.62 ms
    After opening tables	1.13 ms
    System lock	0.03 ms
    Table lock	0.02 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 ms
    Updating status	0.06 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    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:196
    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 : 2.19 ms Après la dernière requête : 0.36 ms Mémoire de requête : 0.003 MB mémoire avant requête : 2.345 MB Rangées retournées : 2

    SELECT id, home, template, s.params
    
      FROM dvrex_template_styles as s
    
      LEFT JOIN dvrex_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	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	4
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	adidjuyo_nctest.s.template,const	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	1.32 ms
    After opening tables	0.03 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.16 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.12 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.07 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    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:196
    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 : 5.57 ms Après la dernière requête : 51.68 ms Mémoire de requête : 0.008 MB mémoire avant requête : 2.559 MB Rangées retournées : 1
    Requêtes dupliquées: #16

    SELECT e.*
    
      FROM dvrex_icagenda_events AS e
    
      LEFT JOIN dvrex_icagenda_category AS c 
      ON c.id = e.catid
    
      WHERE c.state = 1 
      AND e.state = 1 
      AND e.catid IN (4) 
      AND  TRUE  
      AND e.language IN ('fr-FR','*') 
      AND e.access IN (1, 1) 
      AND e.approval <> 1
    
      GROUP BY e.id

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	SIMPLE	e	ref	idx_state,idx_approval,idx_language,idx_catid	idx_catid	4	const	1	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.20 ms
    Checking permissions	0.02 ms
    Opening tables	4.00 ms
    After opening tables	0.06 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.09 ms
    Optimizing	0.04 ms
    Statistics	0.21 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.32 ms
    End of update loop	0.03 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.09 ms
    Updating status	0.10 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:254
    15	icagendaEventsData::getAllDates()	JROOT/components/com_icagenda/models/list.php:310
    14	iCagendaModelList->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_icagenda/models/list.php:382
    11	iCagendaModelList->getItems()	JROOT/components/com_icagenda/views/list/view.html.php:64
    10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:54
    8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:139
    6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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 : 5.82 ms Après la dernière requête : 11.15 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.565 MB Rangées retournées : 1

    SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features
    
      FROM `dvrex_icagenda_events` AS e
    
      LEFT JOIN dvrex_icagenda_category AS c 
      ON c.id = e.catid
    
      LEFT JOIN (
    SELECT fx.event_id, COUNT(*) AS count
    
      FROM dvrex_icagenda_feature_xref AS fx
    
      INNER JOIN dvrex_icagenda_feature AS f 
      ON fx.feature_id=f.id 
      AND f.state=1 
      AND f.icon<>'-1'
    
      GROUP BY fx.event_id) AS feat 
      ON e.id=feat.event_id
    
      WHERE c.state = 1 
      AND  TRUE  
      AND (e.state IN (0, 1)) 
      AND e.approval <> 1 
      AND e.id IN (4)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	<derived2>	system	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	0	Const row not found
    1	PRIMARY	e	const	PRIMARY,idx_state,idx_approval,idx_catid	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY,idx_state	PRIMARY	4	const	1
    2	DERIVED	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	no matching row in const table

    Profil

    Status	Duration
    Starting	0.22 ms
    Checking permissions	0.02 ms
    Opening tables	4.46 ms
    After opening tables	0.06 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.25 ms
    Optimizing	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Removing tmp table	0.02 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.09 ms
    Updating status	0.10 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_icagenda/models/list.php:382
    11	iCagendaModelList->getItems()	JROOT/components/com_icagenda/views/list/view.html.php:64
    10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:54
    8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:139
    6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.98 ms Après la dernière requête : 13.37 ms Mémoire de requête : 0.006 MB mémoire avant requête : 2.652 MB Rangées retournées : 1
    Requêtes dupliquées: #14

    SELECT e.*
    
      FROM dvrex_icagenda_events AS e
    
      LEFT JOIN dvrex_icagenda_category AS c 
      ON c.id = e.catid
    
      WHERE c.state = 1 
      AND e.state = 1 
      AND e.catid IN (4) 
      AND  TRUE  
      AND e.language IN ('fr-FR','*') 
      AND e.access IN (1, 1) 
      AND e.approval <> 1
    
      GROUP BY e.id

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	SIMPLE	e	ref	idx_state,idx_approval,idx_language,idx_catid	idx_catid	4	const	1	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.20 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
    Init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.06 ms
    End of update loop	0.01 ms
    Query end	0.02 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.08 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:254
    11	icagendaEventsData::getAllDates()	JROOT/components/com_icagenda/views/list/view.html.php:67
    10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:54
    8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:139
    6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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 : 5.50 ms Après la dernière requête : 51.76 ms Mémoire de requête : 0.008 MB mémoire avant requête : 2.846 MB Rangées retournées : 20

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM dvrex_modules AS m
    
      LEFT JOIN dvrex_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN dvrex_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-03-04 03:18:05') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-04 03:18:05') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 584 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explication

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

    Profil

    Status	Duration
    Starting	0.22 ms
    Checking permissions	0.02 ms
    Opening tables	2.63 ms
    After opening tables	0.09 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.09 ms
    Preparing	0.06 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	1.70 ms
    End of update loop	0.04 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.11 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	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/libraries/src/Helper/ModuleHelper.php:432
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
    9	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/templates/ict_novotela/includes/var.php:43
    8	require JROOT/templates/ict_novotela/includes/var.php	JROOT/templates/ict_novotela/index.php:18
    7	require JROOT/templates/ict_novotela/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `dvrex_extensions`

2. 2 × SELECT e.* 
     FROM dvrex_icagenda_events AS e 
     LEFT JOIN dvrex_icagenda_category AS c 
     ON c.id = e.catid

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

4. 1 × SELECT `session_id` 
     FROM `dvrex_session`

5. 1 × SELECT id, rules 
     FROM `dvrex_viewlevels

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

7. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
     FROM dvrex_extensions

8. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
     FROM dvrex_menu AS m 
     LEFT JOIN dvrex_extensions AS e 
     ON m.component_id = e.extension_id

9. 1 × SELECT * 
     FROM dvrex_languages

10. 1 × SELECT id, home, template, s.params 
      FROM dvrex_template_styles as s 
      LEFT JOIN dvrex_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

11. 1 × SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features 
      FROM `dvrex_icagenda_events` AS e 
      LEFT JOIN dvrex_icagenda_category AS c 
      ON c.id = e.catid 
      LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count 
      FROM dvrex_icagenda_feature_xref AS fx 
      INNER JOIN dvrex_icagenda_feature AS f 
      ON fx.feature_id=f.id 
      AND f.state=1 
      AND f.icon<>'-1' 
      GROUP BY fx.event_id) AS feat 
      ON e.id=feat.event_id

12. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM dvrex_modules AS m 
      LEFT JOIN dvrex_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN dvrex_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

Autres tables :

1. 1 × INSERT INTO `dvrex_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'3131653732333535393933373064313233653435363033343236323932663633', 1, 1614827885, 0, '', 0

2. 1 × UPDATE dvrex_vvisit_counter 
     SET visits=visits+1  , guests=guests+1

3. 1 × UPDATE `dvrex_extensions` 
     SET `params` = '{\"mediaversion\":\"8f9a94e3a520a72965a762ccc8f01a49\"}'