Cœur d’encre de Iain Softley (avec Brendan Fraser, Paul Bettany...) 2009

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

Temps

Mémoire

56 requêtes exécutées 2491.27 ms

1. Temps de requête : 0.86 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.031 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `na9bi_session`
   
     WHERE `session_id` = X'3361653663316665383630636535383762343134373531623535663337646163'

   Explication

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

   Profil

   Status	Duration
   Starting	0.14 ms
   checking permissions	0.03 ms
   Opening tables	0.04 ms
   After opening tables	0.03 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.09 ms
   Preparing	0.02 ms
   Executing	0.03 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.04 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.04 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 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.75 ms Après la dernière requête : 0.57 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.045 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `na9bi_session`
   
     WHERE `session_id` = X'3361653663316665383630636535383762343134373531623535663337646163' 
     LIMIT 1

   Explication

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

   Profil

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.08 ms
   Preparing	0.02 ms
   Executing	0.03 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 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 : 0.90 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.050 MB

   INSERT INTO `na9bi_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3361653663316665383630636535383762343134373531623535663337646163', 1, 1777473890, 0, '', 0)

   Explication

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

   Profil

   Status	Duration
   Starting	0.10 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init for update	0.05 ms
   Update	0.21 ms
   Waiting for query cache lock	0.02 ms
   Update	0.02 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.08 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 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 : 1.54 ms Après la dernière requête : 1.16 ms Mémoire de requête : 0.040 MB mémoire avant requête : 1.081 MB Rangées retournées : 47

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `na9bi_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	na9bi_extensions	ref	extension	extension	82	const	55	Using index condition; Using where

   Profil

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.05 ms
   Optimizing	0.07 ms
   Statistics	0.10 ms
   Preparing	0.06 ms
   Executing	0.02 ms
   Sending data	0.57 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.05 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 : 0.77 ms Après la dernière requête : 1.13 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.119 MB Rangées retournées : 3

   SELECT id, rules
   
     FROM `na9bi_viewlevels`

   Explication

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

   Profil

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.03 ms
   Preparing	0.03 ms
   Executing	0.02 ms
   Sending data	0.07 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.03 ms
   Updating status	0.04 ms
   Reset for next command	0.02 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 : 0.94 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.130 MB Rangées retournées : 1

   SELECT b.id
   
     FROM na9bi_usergroups AS a
   
     LEFT JOIN na9bi_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	1	Using where; Using index

   Profil

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.05 ms
   Optimizing	0.05 ms
   Statistics	0.11 ms
   Preparing	0.02 ms
   Unlocking tables	0.02 ms
   Preparing	0.06 ms
   Executing	0.03 ms
   Sending data	0.05 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.04 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: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.80 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.035 MB mémoire avant requête : 1.152 MB Rangées retournées : 131

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM na9bi_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	na9bi_extensions	ALL	extension	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	388	Using where; Utilisation du tri complet de type filesort

   Profil

   Status	Duration
   Starting	0.11 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.07 ms
   Optimizing	0.06 ms
   Statistics	0.09 ms
   Preparing	0.05 ms
   Sorting result	0.04 ms
   Executing	0.02 ms
   Sending data	0.03 ms
   Creating sort index	1.76 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.03 ms
   Starting cleanup	0.02 ms
   Freeing items	0.03 ms
   Updating status	0.05 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 : 0.92 ms Après la dernière requête : 22.66 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.111 MB Rangées retournées : 60

   SELECT *
   
     FROM na9bi_rsform_config

   Explication

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

   Profil

   Status	Duration
   Starting	0.13 ms
   checking permissions	0.03 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.03 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.04 ms
   Preparing	0.03 ms
   Executing	0.02 ms
   Sending data	0.13 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.04 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_rsform/helpers/config.php:50
   11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
   10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
   9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26
   8	plgSystemRsformdeletesubmissions->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 : 0.94 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.125 MB Rangées retournées : 1

   SELECT template
   
     FROM na9bi_template_styles
   
     WHERE `client_id`=0 
     AND `home`=1

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	na9bi_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	1	Using where

   Profil

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.05 ms
   Optimizing	0.05 ms
   Statistics	0.10 ms
   Preparing	0.06 ms
   Executing	0.02 ms
   Sending data	0.08 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.03 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.04 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   10	JDatabaseDriver->loadResult()	JROOT/plugins/system/bagallery/bagallery.php:43
   9	plgSystemBagallery->checkOverride()	JROOT/plugins/system/bagallery/bagallery.php:26
   8	plgSystemBagallery->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]

   ---

10. Temps de requête : 0.84 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.151 MB Rangées retournées : 1

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

    Explication

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

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    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/jxtcxmenu/jxtcxmenu.php:46
    8	plgSystemjxtcxmenu->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]

    ---

11. Temps de requête : 1.55 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.006 MB mémoire avant requête : 2.144 MB

    UPDATE `na9bi_extensions`
    
      SET `params` = '{\"mediaversion\":\"93789c22039b23b5fbfad2a018e72fc5\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

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

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    checking permissions	0.02 ms
    After opening tables	0.02 ms
    init for update	0.02 ms
    init	0.03 ms
    Updating main table	0.02 ms
    init	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.02 ms
    init for update	0.08 ms
    Updating	0.12 ms
    End of update loop	0.02 ms
    Waiting for query cache lock	0.63 ms
    End of update loop	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.06 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 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/jxtcxmenu/jxtcxmenu.php:46
    8	plgSystemjxtcxmenu->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]

    ---

12. Temps de requête : 1.94 ms Après la dernière requête : 1.38 ms Mémoire de requête : 0.162 MB mémoire avant requête : 2.253 MB Rangées retournées : 87

    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 na9bi_menu AS m
    
      LEFT JOIN na9bi_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	ALL	idx_client_id_parent_id_alias_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	209	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.m.component_id	1	Using where

    Profil

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 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.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	1.01 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 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]

    ---

13. Temps de requête : 1.10 ms Après la dernière requête : 6.01 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.715 MB Rangées retournées : 0

    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 `na9bi_categories` AS `s`
    
      INNER JOIN `na9bi_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 = 188
    
      ORDER BY c.lft

    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.19 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.10 ms
    Optimizing	0.07 ms
    Statistics	0.09 ms
    Preparing	0.02 ms
    Executing	0.05 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
    10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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]

    ---

14. Temps de requête : 0.74 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.720 MB Rangées retournées : 1

    SELECT `alias`,`catid`
    
      FROM `na9bi_content`
    
      WHERE `id` = 188

    Explication

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

    Profil

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 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:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
    10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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]

    ---

15. Temps de requête : 0.84 ms Après la dernière requête : 0.69 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.741 MB Rangées retournées : 1

    SELECT catid 
      FROM na9bi_content 
      WHERE id = 188

    Explication

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

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 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:1740
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/ampz/ampz.php:654
    9	plgSystemAmpz->continueOrNot()	JROOT/plugins/system/ampz/ampz.php:108
    8	plgSystemAmpz->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:1122
    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]

    ---

16. Temps de requête : 0.90 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.020 MB mémoire avant requête : 2.760 MB Rangées retournées : 2

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	na9bi_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.07 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.09 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 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]

    ---

17. Temps de requête : 1.03 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.019 MB mémoire avant requête : 2.775 MB Rangées retournées : 1

    SELECT id, home, template, s.params
    
      FROM na9bi_template_styles as s
    
      LEFT JOIN na9bi_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	1
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	oagr7318_nawakultbdd.s.template,const	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.05 ms
    Statistics	0.12 ms
    Preparing	0.06 ms
    Executing	0.02 ms
    Sending data	0.10 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 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]

    ---

18. Temps de requête : 1.77 ms Après la dernière requête : 3.01 ms Mémoire de requête : 0.028 MB mémoire avant requête : 2.896 MB Rangées retournées : 48

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `na9bi_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_ampz','com_associations','com_bagallery','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jce','com_jch_optimize','com_joomlaupdate','com_jvrelatives','com_jxtc','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocapdf','com_plugins','com_postinstall','com_privacy','com_pwtacl','com_redirect','com_rsform','com_rstbox','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	na9bi_assets	range	idx_asset_name	idx_asset_name	202	NULL	48	Using index condition

    Profil

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.04 ms
    Statistics	0.24 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.65 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.04 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	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: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]

    ---

19. Temps de requête : 27.31 ms Après la dernière requête : 0.27 ms Mémoire de requête : 1.513 MB mémoire avant requête : 2.953 MB Rangées retournées : 9429

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `na9bi_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	na9bi_assets	ALL	idx_asset_name,idx_parent_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	18201	Using where

    Profil

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	25.96 ms
    End of update loop	0.04 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	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: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]

    ---

20. Temps de requête : 2.43 ms Après la dernière requête : 29.01 ms Mémoire de requête : 0.031 MB mémoire avant requête : 11.093 MB Rangées retournées : 31

    SHOW FULL COLUMNS 
      FROM `na9bi_content`

    Explication

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

    Profil

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.02 ms
    closing tables	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.47 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Filling schema table	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.03 ms
    checking permissions	0.51 ms
    closing tables	0.04 ms
    checking permissions	0.03 ms
    Executing	0.02 ms
    Sending data	0.19 ms
    End of update loop	0.03 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Removing tmp table	0.14 ms
    closing tables	0.03 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.03 ms
    Freeing items	0.03 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
    9	ContentModelArticle->hit()	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: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]

    ---

21. Temps de requête : 1.12 ms Après la dernière requête : 1.56 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.143 MB Rangées retournées : 1

    SELECT *
    
      FROM na9bi_content
    
      WHERE `id` = '188'

    Explication

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

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.09 ms
    Optimizing	0.05 ms
    Statistics	0.15 ms
    Preparing	0.03 ms
    Unlocking tables	0.04 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.09 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 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:1465
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	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: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]

    ---

22. Temps de requête : 1.14 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.005 MB mémoire avant requête : 11.152 MB

    UPDATE na9bi_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '188'

    Explication

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

    Profil

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    checking permissions	0.02 ms
    After opening tables	0.02 ms
    init for update	0.03 ms
    init	0.03 ms
    Updating main table	0.03 ms
    init	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.02 ms
    init for update	0.09 ms
    Updating	0.20 ms
    End of update loop	0.03 ms
    Waiting for query cache lock	0.02 ms
    End of update loop	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.08 ms
    Query end	0.02 ms
    closing tables	0.03 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
    9	ContentModelArticle->hit()	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: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]

    ---

23. Temps de requête : 1.77 ms Après la dernière requête : 0.79 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.175 MB Rangées retournées : 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM na9bi_content AS a
    
      INNER JOIN na9bi_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN na9bi_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN na9bi_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN na9bi_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 188 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-29 14:44:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-29 14:44:50') 
      AND (a.state = 1 OR a.state =2)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	1	Unique row not found

    Profil

    Status	Duration
    Starting	0.33 ms
    checking permissions	0.03 ms
    Opening tables	0.11 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.17 ms
    Optimizing	0.12 ms
    Statistics	0.30 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.10 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php: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]

    ---

24. Temps de requête : 1.60 ms Après la dernière requête : 1.11 ms Mémoire de requête : 0.027 MB mémoire avant requête : 11.205 MB Rangées retournées : 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `na9bi_categories` AS `s`
    
      INNER JOIN `na9bi_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 = 8
    
      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	8	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.24 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.13 ms
    Optimizing	0.09 ms
    Statistics	0.24 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.09 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.20 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    20	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
    19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php: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]

    ---

25. Temps de requête : 39.53 ms Après la dernière requête : 0.83 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.295 MB Rangées retournées : 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `na9bi_contentitem_tag_map` AS m 
    
      INNER JOIN `na9bi_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 188 
      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	t	ALL	PRIMARY,tag_idx,idx_access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2637	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	oagr7318_nawakultbdd.t.id	12	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.03 ms
    table lock	0.02 ms
    init	0.10 ms
    Optimizing	0.07 ms
    Statistics	0.20 ms
    Preparing	0.10 ms
    Executing	0.02 ms
    Sending data	38.28 ms
    End of update loop	0.08 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.04 ms
    Updating status	0.05 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/libraries/src/Helper/TagsHelper.php:454
    11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php: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]

    ---

26. Temps de requête : 2.91 ms Après la dernière requête : 4.09 ms Mémoire de requête : 0.025 MB mémoire avant requête : 11.386 MB Rangées retournées : 0

    SELECT DISTINCT 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, g.note as group_note
    
      FROM na9bi_fields AS a
    
      LEFT JOIN `na9bi_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN na9bi_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN na9bi_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN na9bi_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN na9bi_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `na9bi_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 (8,0)) 
      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; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	oagr7318_nawakultbdd.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.checked_out	1
    1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.id	1	Using where; Distinct

    Profil

    Status	Duration
    Starting	0.36 ms
    checking permissions	0.03 ms
    Opening tables	0.14 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.14 ms
    Optimizing	0.12 ms
    Statistics	0.38 ms
    Preparing	0.14 ms
    Creating tmp table	0.18 ms
    Sorting result	0.06 ms
    Executing	0.02 ms
    Sending data	0.56 ms
    Creating sort index	0.08 ms
    Removing tmp table	0.12 ms
    Creating sort index	0.03 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 ms
    Reset for next command	0.03 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/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    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:495
    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/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php: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]

    ---

27. Temps de requête : 25.03 ms Après la dernière requête : 15.98 ms Mémoire de requête : 0.480 MB mémoire avant requête : 11.506 MB Rangées retournées : 1319

    SELECT a.id, a.title, a.catid, a.language, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
    
      FROM na9bi_content AS a
    
      LEFT JOIN na9bi_categories AS cc 
      ON cc.id = a.catid
    
      WHERE a.catid = 8 
      AND a.state = 1 
      AND a.access IN (1,1)  
      AND (a.state = 1 OR a.state = -1) 
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-04-29 14:44:50') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-04-29 14:44:50')
    
      ORDER BY  a.created  DESC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1349	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.33 ms
    checking permissions	0.03 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.13 ms
    Optimizing	0.11 ms
    Statistics	0.25 ms
    Preparing	0.10 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	23.37 ms
    End of update loop	0.09 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.04 ms
    Updating status	0.03 ms
    Reset for next command	0.02 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/plugins/content/pagenavigation/pagenavigation.php:161
    13	PlgContentPagenavigation->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/article/view.html.php:199
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php: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]

    ---

28. Temps de requête : 1.01 ms Après la dernière requête : 10.14 ms Mémoire de requête : 0.021 MB mémoire avant requête : 11.554 MB Rangées retournées : 2

    select b.* 
      from na9bi_rstbox b 
      where b.published = 1  
      AND b.testmode=0

    Explication

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

    Profil

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.05 ms
    Preparing	0.06 ms
    Executing	0.02 ms
    Sending data	0.11 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/helper.php:242
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    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]

    ---

29. Temps de requête : 1.10 ms Après la dernière requête : 22.80 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.652 MB Rangées retournées : 1

    SELECT *
    
      FROM na9bi_modules
    
      WHERE id='250'

    Explication

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

    Profil

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.04 ms
    table lock	0.03 ms
    init	0.08 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:415
    15	NRFramework\Functions::loadModule()	JROOT/plugins/engagebox/module/layout/module.php:18
    14	include JROOT/plugins/engagebox/module/layout/module.php	JROOT/libraries/src/Layout/FileLayout.php:125
    13	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_rstbox/helpers/type.php:70
    12	EngageBoxType->onEngageBoxTypeRender()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_rstbox/helpers/helper.php:261
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    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]

    ---

30. Temps de requête : 1.04 ms Après la dernière requête : 7.41 ms Mémoire de requête : 0.037 MB mémoire avant requête : 12.002 MB Rangées retournées : 170

    SELECT * 
      FROM na9bi_acymailing_config

    Explication

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

    Profil

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.26 ms
    End of update loop	0.04 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:33
    20	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:879
    19	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1815
    18	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:23
    17	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:421
    15	NRFramework\Functions::loadModule()	JROOT/plugins/engagebox/module/layout/module.php:18
    14	include JROOT/plugins/engagebox/module/layout/module.php	JROOT/libraries/src/Layout/FileLayout.php:125
    13	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_rstbox/helpers/type.php:70
    12	EngageBoxType->onEngageBoxTypeRender()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_rstbox/helpers/helper.php:261
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    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]

    ---

31. Temps de requête : 0.87 ms Après la dernière requête : 1.61 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.116 MB Rangées retournées : 1

    SELECT * 
      FROM na9bi_acymailing_list 
      WHERE type = 'list'  
      ORDER BY ordering ASC

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	na9bi_acymailing_list	system	typeorderingindex,typeuseridindex	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1

    Profil

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.06 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:57
    18	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:241
    17	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:421
    15	NRFramework\Functions::loadModule()	JROOT/plugins/engagebox/module/layout/module.php:18
    14	include JROOT/plugins/engagebox/module/layout/module.php	JROOT/libraries/src/Layout/FileLayout.php:125
    13	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_rstbox/helpers/type.php:70
    12	EngageBoxType->onEngageBoxTypeRender()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_rstbox/helpers/helper.php:261
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    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]

    ---

32. Temps de requête : 1.09 ms Après la dernière requête : 2.94 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.351 MB Rangées retournées : 3

    SELECT * 
      FROM `na9bi_acymailing_fields` as a 
      WHERE a.`published` = 1 
      AND (a.access = 'all' OR a.access LIKE ('%,1,%')) 
      ORDER BY a.`ordering` ASC

    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	3	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.09 ms
    Optimizing	0.06 ms
    Statistics	0.05 ms
    Preparing	0.06 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	0.14 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.04 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:181
    18	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:413
    17	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:421
    15	NRFramework\Functions::loadModule()	JROOT/plugins/engagebox/module/layout/module.php:18
    14	include JROOT/plugins/engagebox/module/layout/module.php	JROOT/libraries/src/Layout/FileLayout.php:125
    13	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_rstbox/helpers/type.php:70
    12	EngageBoxType->onEngageBoxTypeRender()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_rstbox/helpers/helper.php:261
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    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]

    ---

33. Temps de requête : 0.72 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.028 MB mémoire avant requête : 12.374 MB Rangées retournées : 3

    SELECT * 
      FROM `na9bi_acymailing_fields`

    Explication

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

    Profil

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.09 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:207
    18	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:413
    17	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:421
    15	NRFramework\Functions::loadModule()	JROOT/plugins/engagebox/module/layout/module.php:18
    14	include JROOT/plugins/engagebox/module/layout/module.php	JROOT/libraries/src/Layout/FileLayout.php:125
    13	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_rstbox/helpers/type.php:70
    12	EngageBoxType->onEngageBoxTypeRender()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_rstbox/helpers/helper.php:261
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    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]

    ---

34. Temps de requête : 4.24 ms Après la dernière requête : 19.43 ms Mémoire de requête : 0.072 MB mémoire avant requête : 12.653 MB Rangées retournées : 99

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM na9bi_modules AS m
    
      LEFT JOIN na9bi_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN na9bi_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 <= '2026-04-29 14:44:50') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-29 14:44:50') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 106 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	ALL	PRIMARY,published,newsfeeds	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	oagr7318_nawakultbdd.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.m.id	5	Using where

    Profil

    Status	Duration
    Starting	0.28 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.12 ms
    Optimizing	0.13 ms
    Statistics	0.21 ms
    Preparing	0.14 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	2.66 ms
    End of update loop	0.04 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/nawakulture/layouts/default/layout.php:205
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

35. Temps de requête : 2.25 ms Après la dernière requête : 3.91 ms Mémoire de requête : 0.029 MB mémoire avant requête : 12.703 MB Rangées retournées : 0

    SELECT DISTINCT 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, g.note as group_note
    
      FROM na9bi_fields AS a
    
      LEFT JOIN `na9bi_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN na9bi_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN na9bi_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN na9bi_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN na9bi_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_custom.content' 
      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; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	oagr7318_nawakultbdd.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.checked_out	1
    1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.group_id	1	Using where

    Profil

    Status	Duration
    Starting	0.20 ms
    checking permissions	0.02 ms
    Opening tables	0.11 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.11 ms
    Optimizing	0.08 ms
    Statistics	0.23 ms
    Preparing	0.10 ms
    Creating tmp table	0.16 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.53 ms
    Creating sort index	0.07 ms
    Removing tmp table	0.09 ms
    Creating sort index	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    26	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    25	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    24	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    23	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    20	JHtmlContent::prepare()	Même appel que celui de la ligne ci-dessous.
    19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    16	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region2.php:32
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region2.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

36. Temps de requête : 0.97 ms Après la dernière requête : 2.08 ms Mémoire de requête : 0.027 MB mémoire avant requête : 12.749 MB Rangées retournées : 1

    select * 
      from `na9bi_jvrelatives`

    Explication

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

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jvrelatives/common/class.init.php:49
    18	JvrelInit::getCfg()	JROOT/administrator/components/com_jvrelatives/common/class.init.php:289
    17	require_once JROOT/administrator/components/com_jvrelatives/common/class.init.php	JROOT/modules/mod_jvrelatives_content/mod_jvrelatives_content.php:25
    16	include JROOT/modules/mod_jvrelatives_content/mod_jvrelatives_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region5.php:30
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region5.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

37. Temps de requête : 1.02 ms Après la dernière requête : 1.14 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.773 MB Rangées retournées : 1

    SELECT `id` as id, `title` as title, concat(`introtext`, `fulltext`) as text, `catid` as catid, `metakey` as metakey
    
      FROM na9bi_content
    
      WHERE id = 188

    Explication

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

    Profil

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.03 ms
    Opening tables	0.09 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jvrelatives/extensions/com_content.php:39
    18	JvrelativesCom_content->loadArticleInfo()	JROOT/administrator/components/com_jvrelatives/common/class.plugin.php:84
    17	JvrelativesProcessor->action()	JROOT/modules/mod_jvrelatives_content/mod_jvrelatives_content.php:76
    16	include JROOT/modules/mod_jvrelatives_content/mod_jvrelatives_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region5.php:30
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region5.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

38. Temps de requête : 59.61 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.027 MB mémoire avant requête : 12.787 MB Rangées retournées : 0

    SELECT t.title
    
      FROM na9bi_tags as t
    
      INNER JOIN na9bi_contentitem_tag_map as m 
      on t.id = m.tag_id
    
      WHERE t.published = 1 
      AND m.type_alias = 'com_content.article' 
      AND m.content_item_id = 188
    
      ORDER BY t.title asc

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ALL	PRIMARY,tag_idx	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2637	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	oagr7318_nawakultbdd.t.id	12	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.06 ms
    Statistics	0.15 ms
    Preparing	0.07 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	58.38 ms
    End of update loop	0.12 ms
    Query end	0.03 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.05 ms
    Reset for next command	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jvrelatives/extensions/com_jvrelatives.php:143
    20	JvrelativesComponent->getExtensionTagsFromJoomla()	JROOT/administrator/components/com_jvrelatives/extensions/com_content.php:74
    19	JvrelativesCom_content->getMetaKeys()	JROOT/administrator/components/com_jvrelatives/common/class.plugin.php:204
    18	JvrelativesProcessor->coreProcessor()	JROOT/administrator/components/com_jvrelatives/common/class.plugin.php:124
    17	JvrelativesProcessor->action()	JROOT/modules/mod_jvrelatives_content/mod_jvrelatives_content.php:76
    16	include JROOT/modules/mod_jvrelatives_content/mod_jvrelatives_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region5.php:30
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region5.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

39. Temps de requête : 83.07 ms Après la dernière requête : 0.49 ms Mémoire de requête : 0.075 MB mémoire avant requête : 12.800 MB Rangées retournées : 10

    SELECT distinct a.id as item_id, a.title as item_title, concat(a.introtext, a.fulltext) as item_text, a.created as item_createdon, a.created_by as item_createdby, a.created_by_alias as item_createdbyalias, a.modified as item_modifiedon, a.hits as item_hits, a.metakey as item_keywords, c.title as item_cattitle,
      case when char_length(a.alias) then concat_ws(":", a.id, a.alias) else a.id end as item_aslug,
      case when char_length(c.alias) then concat_ws(":", c.id, c.alias) else c.id end as item_cslug
    
      FROM na9bi_content as a
    
      INNER JOIN na9bi_categories as c 
      on a.catid = c.id
    
      WHERE a.id != 188 
      AND a.state = 1 
      AND c.published = 1 
      AND (a.publish_down = '0000-00-00 00:00:00' or a.publish_down >= '2026-04-29 14:44:50') 
      AND a.access in (1,1) 
      AND (a.publish_up = '0000-00-00 00:00:00' or a.publish_up <= '2026-04-29 14:44:50') 
      AND a.catid = 8
    
      GROUP BY item_id
    
      ORDER BY RAND() 
      limit 0, 10

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	a	ref	PRIMARY,idx_access,idx_state,idx_catid	idx_catid	4	const	1349	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.33 ms
    checking permissions	0.03 ms
    Opening tables	0.09 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.11 ms
    Optimizing	0.09 ms
    Statistics	0.32 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.10 ms
    Creating tmp table	0.13 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	70.19 ms
    Creating sort index	10.36 ms
    End of update loop	0.10 ms
    Removing tmp table	0.55 ms
    End of update loop	0.04 ms
    Query end	0.03 ms
    Commit	0.03 ms
    Query end	0.02 ms
    closing tables	0.03 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.05 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jvrelatives/extensions/com_content.php:132
    19	JvrelativesCom_content->getFallbackRelatedArticles()	JROOT/administrator/components/com_jvrelatives/common/class.plugin.php:208
    18	JvrelativesProcessor->coreProcessor()	JROOT/administrator/components/com_jvrelatives/common/class.plugin.php:124
    17	JvrelativesProcessor->action()	JROOT/modules/mod_jvrelatives_content/mod_jvrelatives_content.php:76
    16	include JROOT/modules/mod_jvrelatives_content/mod_jvrelatives_content.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region5.php:30
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region5.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

40. Temps de requête : 398.48 ms Après la dernière requête : 10.54 ms Mémoire de requête : 0.080 MB mémoire avant requête : 12.907 MB Rangées retournées : 12

    SELECT a.id, a.access,a.introtext,a.fulltext, a.title,UNIX_TIMESTAMP(a.created) as created,UNIX_TIMESTAMP(a.modified) as modified, a.catid, a.created_by, a.created_by_alias, a.hits, a.alias, a.images, a.urls,
    	cc.title as cat_title, cc.params as cat_params, cc.description as cat_description, cc.alias as cat_alias,
    	u.name as author, u.username as authorid,
    	
      CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
    	
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug
    	
      FROM na9bi_content AS a 
      INNER JOIN na9bi_categories AS cc 
      ON cc.id = a.catid
    	
      LEFT JOIN na9bi_users AS u 
      ON u.id = a.created_by 
      WHERE a.state = 1 
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-29 14:44:50' )
    	
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-29 14:44:50' )
    	
      AND (cc.published = 1 OR cc.published IS NULL) 
      AND (cc.id=8 OR cc.id=10 OR cc.id=11 OR cc.id=12 OR cc.id=13 OR cc.id=14 OR cc.id=15 OR cc.id=16 OR cc.id=20 OR cc.id=22 OR cc.id=23 OR cc.id=24 OR cc.id=25 OR cc.id=26 OR cc.id=27 OR cc.id=28 OR cc.id=30 OR cc.id=31 OR cc.id=32 OR cc.id=33 OR cc.id=34 OR cc.id=35 OR cc.id=36 OR cc.id=37 OR cc.id=38 OR cc.id=39 OR cc.id=40 OR cc.id=44 OR cc.id=45 OR cc.id=47 OR cc.id=48 OR cc.id=49 OR cc.id=50 OR cc.id=51) 
      ORDER BY RAND() 
      LIMIT 0, 12

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	idx_state,idx_catid	idx_state	1	NULL	7282	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	cc	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.catid	1	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.created_by	1	Using where

    Profil

    Status	Duration
    Starting	0.51 ms
    checking permissions	0.03 ms
    Opening tables	0.10 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.15 ms
    Optimizing	0.17 ms
    Statistics	0.24 ms
    Preparing	0.19 ms
    Creating tmp table	0.14 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	359.08 ms
    Creating sort index	34.99 ms
    End of update loop	0.08 ms
    Removing tmp table	2.34 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php:224
    16	include JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php:29
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

41. Temps de requête : 0.91 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.032 MB mémoire avant requête : 13.007 MB Rangées retournées : 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `na9bi_categories` AS `s`
    
      INNER JOIN `na9bi_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 = 28
    
      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	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	55	Using where; Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    Starting	0.12 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
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.12 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.02 ms
    Creating sort index	0.11 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    30	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    29	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    28	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
    27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_jxtc_newspro/tmpl/default_parse.php:115
    18	require JROOT/modules/mod_jxtc_newspro/tmpl/default_parse.php	JROOT/modules/mod_jxtc_newspro/tmpl/default.php:111
    17	require JROOT/modules/mod_jxtc_newspro/tmpl/default.php	JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php:252
    16	include JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php:29
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

42. Temps de requête : 0.78 ms Après la dernière requête : 1.25 ms Mémoire de requête : 0.032 MB mémoire avant requête : 13.036 MB Rangées retournées : 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `na9bi_categories` AS `s`
    
      INNER JOIN `na9bi_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 = 12
    
      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	11	Using index condition; 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
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    30	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    29	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    28	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
    27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_jxtc_newspro/tmpl/default_parse.php:115
    18	require JROOT/modules/mod_jxtc_newspro/tmpl/default_parse.php	JROOT/modules/mod_jxtc_newspro/tmpl/default.php:111
    17	require JROOT/modules/mod_jxtc_newspro/tmpl/default.php	JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php:252
    16	include JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php:29
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

43. Temps de requête : 0.76 ms Après la dernière requête : 0.75 ms Mémoire de requête : 0.032 MB mémoire avant requête : 13.058 MB Rangées retournées : 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `na9bi_categories` AS `s`
    
      INNER JOIN `na9bi_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 = 15
    
      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	14	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.09 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
    init	0.05 ms
    Optimizing	0.03 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.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    30	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    29	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    28	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
    27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_jxtc_newspro/tmpl/default_parse.php:115
    18	require JROOT/modules/mod_jxtc_newspro/tmpl/default_parse.php	JROOT/modules/mod_jxtc_newspro/tmpl/default.php:111
    17	require JROOT/modules/mod_jxtc_newspro/tmpl/default.php	JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php:252
    16	include JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php:29
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

44. Temps de requête : 0.74 ms Après la dernière requête : 0.72 ms Mémoire de requête : 0.032 MB mémoire avant requête : 13.080 MB Rangées retournées : 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `na9bi_categories` AS `s`
    
      INNER JOIN `na9bi_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 = 13
    
      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	12	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 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.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    30	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    29	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    28	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
    27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_jxtc_newspro/tmpl/default_parse.php:115
    18	require JROOT/modules/mod_jxtc_newspro/tmpl/default_parse.php	JROOT/modules/mod_jxtc_newspro/tmpl/default.php:111
    17	require JROOT/modules/mod_jxtc_newspro/tmpl/default.php	JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php:252
    16	include JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php:29
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

45. Temps de requête : 1.25 ms Après la dernière requête : 3.31 ms Mémoire de requête : 0.028 MB mémoire avant requête : 13.128 MB Rangées retournées : 0

    SELECT DISTINCT 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, g.note as group_note
    
      FROM na9bi_fields AS a
    
      LEFT JOIN `na9bi_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN na9bi_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN na9bi_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN na9bi_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN na9bi_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_content.article' 
      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; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	oagr7318_nawakultbdd.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.checked_out	1
    1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.group_id	1	Using where

    Profil

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.08 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.12 ms
    Preparing	0.05 ms
    Creating tmp table	0.09 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.23 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.05 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    19	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php:302
    16	include JROOT/modules/mod_jxtc_newspro/mod_jxtc_newspro.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php:29
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region6.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

46. Temps de requête : 503.73 ms Après la dernière requête : 3.11 ms Mémoire de requête : 0.028 MB mémoire avant requête : 13.080 MB Rangées retournées : 10
    Requêtes dupliquées: #47  #48  #49  #50

    SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
    
      FROM `na9bi_contentitem_tag_map` AS `m`
    
      INNER JOIN `na9bi_tags` AS `t` 
      ON `tag_id` = t.id
    
      INNER JOIN `na9bi_ucm_content` AS `c` 
      ON `m`.`core_content_id` = `c`.`core_content_id`
    
      WHERE `t`.`access` IN (1,1) 
      AND `t`.`published` = 1  
      AND `m`.`type_alias` = `c`.`core_type_alias` 
      AND `c`.`core_state` = 1 
      AND (`c`.`core_access` IN (1,1) OR `c`.`core_access` = 0) 
      AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2026-04-29 14:44:50') 
      AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2026-04-29 14:44:50')
    
      GROUP BY `tag_id`,`title`,`access`,`alias`
    
      ORDER BY  RAND()  
      LIMIT 10

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	PRIMARY,tag_idx,idx_access,idx_content_type	idx_access	4	NULL	7729	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_core_content_id	4	oagr7318_nawakultbdd.c.core_content_id	3	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	oagr7318_nawakultbdd.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.16 ms
    Preparing	0.07 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	501.85 ms
    Creating sort index	0.83 ms
    End of update loop	0.02 ms
    Removing tmp table	0.10 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
    20	ModTagsPopularHelper::getList()	Même appel que celui de la ligne ci-dessous.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:587
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
    16	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region9.php:30
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region9.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

47. Temps de requête : 493.90 ms Après la dernière requête : 3.15 ms Mémoire de requête : 0.028 MB mémoire avant requête : 13.106 MB Rangées retournées : 10
    Requêtes dupliquées: #46  #48  #49  #50

    SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
    
      FROM `na9bi_contentitem_tag_map` AS `m`
    
      INNER JOIN `na9bi_tags` AS `t` 
      ON `tag_id` = t.id
    
      INNER JOIN `na9bi_ucm_content` AS `c` 
      ON `m`.`core_content_id` = `c`.`core_content_id`
    
      WHERE `t`.`access` IN (1,1) 
      AND `t`.`published` = 1  
      AND `m`.`type_alias` = `c`.`core_type_alias` 
      AND `c`.`core_state` = 1 
      AND (`c`.`core_access` IN (1,1) OR `c`.`core_access` = 0) 
      AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2026-04-29 14:44:50') 
      AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2026-04-29 14:44:50')
    
      GROUP BY `tag_id`,`title`,`access`,`alias`
    
      ORDER BY  RAND()  
      LIMIT 10

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	PRIMARY,tag_idx,idx_access,idx_content_type	idx_access	4	NULL	7729	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_core_content_id	4	oagr7318_nawakultbdd.c.core_content_id	3	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	oagr7318_nawakultbdd.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.05 ms
    Statistics	0.17 ms
    Preparing	0.08 ms
    Creating tmp table	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	492.12 ms
    Creating sort index	0.69 ms
    End of update loop	0.02 ms
    Removing tmp table	0.09 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
    20	ModTagsPopularHelper::getList()	Même appel que celui de la ligne ci-dessous.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:587
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
    16	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region9.php:30
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region9.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

48. Temps de requête : 279.45 ms Après la dernière requête : 1.80 ms Mémoire de requête : 0.028 MB mémoire avant requête : 13.129 MB Rangées retournées : 10
    Requêtes dupliquées: #46  #47  #49  #50

    SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
    
      FROM `na9bi_contentitem_tag_map` AS `m`
    
      INNER JOIN `na9bi_tags` AS `t` 
      ON `tag_id` = t.id
    
      INNER JOIN `na9bi_ucm_content` AS `c` 
      ON `m`.`core_content_id` = `c`.`core_content_id`
    
      WHERE `t`.`access` IN (1,1) 
      AND `t`.`published` = 1  
      AND `m`.`type_alias` = `c`.`core_type_alias` 
      AND `c`.`core_state` = 1 
      AND (`c`.`core_access` IN (1,1) OR `c`.`core_access` = 0) 
      AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2026-04-29 14:44:50') 
      AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2026-04-29 14:44:50')
    
      GROUP BY `tag_id`,`title`,`access`,`alias`
    
      ORDER BY  RAND()  
      LIMIT 10

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	PRIMARY,tag_idx,idx_access,idx_content_type	idx_access	4	NULL	7729	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_core_content_id	4	oagr7318_nawakultbdd.c.core_content_id	3	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	oagr7318_nawakultbdd.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.10 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
    init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.14 ms
    Preparing	0.06 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	277.90 ms
    Creating sort index	0.61 ms
    End of update loop	0.01 ms
    Removing tmp table	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.05 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
    20	ModTagsPopularHelper::getList()	Même appel que celui de la ligne ci-dessous.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:587
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
    16	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region9.php:30
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region9.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

49. Temps de requête : 258.86 ms Après la dernière requête : 1.77 ms Mémoire de requête : 0.028 MB mémoire avant requête : 13.152 MB Rangées retournées : 10
    Requêtes dupliquées: #46  #47  #48  #50

    SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
    
      FROM `na9bi_contentitem_tag_map` AS `m`
    
      INNER JOIN `na9bi_tags` AS `t` 
      ON `tag_id` = t.id
    
      INNER JOIN `na9bi_ucm_content` AS `c` 
      ON `m`.`core_content_id` = `c`.`core_content_id`
    
      WHERE `t`.`access` IN (1,1) 
      AND `t`.`published` = 1  
      AND `m`.`type_alias` = `c`.`core_type_alias` 
      AND `c`.`core_state` = 1 
      AND (`c`.`core_access` IN (1,1) OR `c`.`core_access` = 0) 
      AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2026-04-29 14:44:50') 
      AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2026-04-29 14:44:50')
    
      GROUP BY `tag_id`,`title`,`access`,`alias`
    
      ORDER BY  RAND()  
      LIMIT 10

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	PRIMARY,tag_idx,idx_access,idx_content_type	idx_access	4	NULL	7729	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_core_content_id	4	oagr7318_nawakultbdd.c.core_content_id	3	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	oagr7318_nawakultbdd.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.13 ms
    Preparing	0.08 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	257.35 ms
    Creating sort index	0.62 ms
    End of update loop	0.01 ms
    Removing tmp table	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
    20	ModTagsPopularHelper::getList()	Même appel que celui de la ligne ci-dessous.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:587
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
    16	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region9.php:30
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region9.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

50. Temps de requête : 264.94 ms Après la dernière requête : 1.89 ms Mémoire de requête : 0.028 MB mémoire avant requête : 13.180 MB Rangées retournées : 10
    Requêtes dupliquées: #46  #47  #48  #49

    SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
    
      FROM `na9bi_contentitem_tag_map` AS `m`
    
      INNER JOIN `na9bi_tags` AS `t` 
      ON `tag_id` = t.id
    
      INNER JOIN `na9bi_ucm_content` AS `c` 
      ON `m`.`core_content_id` = `c`.`core_content_id`
    
      WHERE `t`.`access` IN (1,1) 
      AND `t`.`published` = 1  
      AND `m`.`type_alias` = `c`.`core_type_alias` 
      AND `c`.`core_state` = 1 
      AND (`c`.`core_access` IN (1,1) OR `c`.`core_access` = 0) 
      AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2026-04-29 14:44:50') 
      AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2026-04-29 14:44:50')
    
      GROUP BY `tag_id`,`title`,`access`,`alias`
    
      ORDER BY  RAND()  
      LIMIT 10

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	PRIMARY,tag_idx,idx_access,idx_content_type	idx_access	4	NULL	7729	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_core_content_id	4	oagr7318_nawakultbdd.c.core_content_id	3	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	oagr7318_nawakultbdd.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.10 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
    init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.14 ms
    Preparing	0.07 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	263.21 ms
    Creating sort index	0.78 ms
    End of update loop	0.02 ms
    Removing tmp table	0.10 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
    20	ModTagsPopularHelper::getList()	Même appel que celui de la ligne ci-dessous.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:587
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
    16	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/nawakulture/XTC/XTC_library.php:630
    11	_xtcJdocCount()	JROOT/templates/nawakulture/XTC/XTC_library.php:319
    10	xtcGrid()	JROOT/templates/nawakulture/layouts/default/layout_includes/region9.php:30
    9	require JROOT/templates/nawakulture/layouts/default/layout_includes/region9.php	JROOT/templates/nawakulture/layouts/default/layout.php:248
    8	require JROOT/templates/nawakulture/layouts/default/layout.php	JROOT/templates/nawakulture/index.php:30
    7	require JROOT/templates/nawakulture/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]

    ---

51. Temps de requête : 0.78 ms Après la dernière requête : 4.37 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.185 MB Rangées retournées : 0
    Requêtes dupliquées: #53  #55

    SELECT *
    
      FROM na9bi_banners
    
      WHERE '2026-04-29 14:44:50' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    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

    Profil

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.09 ms
    Optimizing	0.06 ms
    Executing	0.10 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 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_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

52. Temps de requête : 1.48 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.202 MB Rangées retournées : 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM na9bi_banners as a
    
      LEFT JOIN na9bi_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-29 14:44:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-29 14:44:50') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (52)
    
      ORDER BY a.sticky DESC, RAND()  
      LIMIT 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_state	1	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.cid	1

    Profil

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.06 ms
    Statistics	0.12 ms
    Preparing	0.07 ms
    Creating tmp table	0.08 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.32 ms
    Creating sort index	0.06 ms
    End of update loop	0.02 ms
    Removing tmp table	0.08 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

53. Temps de requête : 0.61 ms Après la dernière requête : 1.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.216 MB Rangées retournées : 0
    Requêtes dupliquées: #51  #55

    SELECT *
    
      FROM na9bi_banners
    
      WHERE '2026-04-29 14:44:50' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    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

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.04 ms
    Executing	0.05 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.03 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_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

54. Temps de requête : 1.51 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.226 MB Rangées retournées : 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM na9bi_banners as a
    
      LEFT JOIN na9bi_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-29 14:44:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-29 14:44:50') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (53)
    
      ORDER BY a.sticky DESC, RAND()  
      LIMIT 5

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_state	1	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.cid	1

    Profil

    Status	Duration
    Starting	0.20 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.09 ms
    Optimizing	0.08 ms
    Statistics	0.11 ms
    Preparing	0.06 ms
    Creating tmp table	0.07 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.29 ms
    Creating sort index	0.08 ms
    End of update loop	0.02 ms
    Removing tmp table	0.07 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

55. Temps de requête : 0.64 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.233 MB Rangées retournées : 0
    Requêtes dupliquées: #51  #53

    SELECT *
    
      FROM na9bi_banners
    
      WHERE '2026-04-29 14:44:50' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    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

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Executing	0.08 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.03 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_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---

56. Temps de requête : 1.51 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.243 MB Rangées retournées : 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM na9bi_banners as a
    
      LEFT JOIN na9bi_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-29 14:44:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-29 14:44:50') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (3)
    
      ORDER BY a.sticky DESC, RAND()  
      LIMIT 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_state	1	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	oagr7318_nawakultbdd.a.cid	1

    Profil

    Status	Duration
    Starting	0.20 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.09 ms
    Optimizing	0.09 ms
    Statistics	0.11 ms
    Preparing	0.06 ms
    Creating tmp table	0.06 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.26 ms
    Creating sort index	0.06 ms
    End of update loop	0.02 ms
    Removing tmp table	0.10 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

    ---