{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1745638798,
                "last": 1745638798,
                "now": 1745638798
            },
            "token": "Jc6X21Wpi3LyYcf4rX8PPlWT1EExmltd"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "fr-FR"
        }
    }
}

Temps

Mémoire

64 requêtes exécutées 52.03 ms

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

   SELECT `data`
   
     FROM `pudcl_session`
   
     WHERE `session_id` = X'6563366663633164343364656539643431353063633966353830376666303837'

   Explication

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

   Profil

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.09 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   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.01 ms
   Updating status	0.04 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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.35 ms Après la dernière requête : 1.42 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.282 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `pudcl_session`
   
     WHERE `session_id` = X'6563366663633164343364656539643431353063633966353830376666303837' 
     LIMIT 1

   Explication

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

   Profil

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   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.01 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   Pile d'appels

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

   INSERT INTO `pudcl_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6563366663633164343364656539643431353063633966353830376666303837', 1, 1745638798, 0, '', 0)

   Explication

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

   Profil

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.01 ms
   Update	0.09 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.14 ms
   Writing to binlog	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.01 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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Temps de requête : 0.91 ms Après la dernière requête : 2.81 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.476 MB Rangées retournées : 45

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

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.07 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.35 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.01 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:225
   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.44 ms Après la dernière requête : 3.50 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.733 MB Rangées retournées : 5

   SELECT id, rules
   
     FROM `pudcl_viewlevels`

   Explication

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

   Profil

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.07 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.05 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   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.01 ms
   Updating status	0.04 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   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:225
   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.55 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.745 MB Rangées retournées : 2

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

   Explication

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

   Profil

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.11 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   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.01 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:318
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Temps de requête : 1.36 ms Après la dernière requête : 0.81 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.814 MB Rangées retournées : 105

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

   Explication

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

   Profil

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.05 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.81 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.01 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:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   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:356
   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:225
   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.58 ms Après la dernière requête : 1.22 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.933 MB Rangées retournées : 2

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

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	pudcl_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.04 ms
   checking permissions	0.01 ms
   Opening tables	0.09 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	0.07 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.01 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
   4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
   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:225
   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.60 ms Après la dernière requête : 9.55 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.772 MB Rangées retournées : 4

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `pudcl_extensions`
   
     WHERE `type` = 'language' 
     AND `state` = 0 
     AND `enabled` = 1

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	pudcl_extensions	ref	extension	extension	82	const	4	Using index condition; Using where

   Profil

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.06 ms
   Preparing	0.05 ms
   Executing	0.01 ms
   Sending data	0.09 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.01 ms
   Updating status	0.05 ms
   Reset for next command	0.03 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/libraries/src/Language/LanguageHelper.php:209
   8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   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:225
   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.51 ms Après la dernière requête : 4.53 ms Mémoire de requête : 0.021 MB mémoire avant requête : 6.425 MB Rangées retournées : 1

    SELECT template
    
      FROM pudcl_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	pudcl_template_styles	ALL	idx_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	4	Using where

    Profil

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    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.01 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: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:668
    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:225
    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.21 ms Après la dernière requête : 1.79 ms Mémoire de requête : 0.050 MB mémoire avant requête : 6.733 MB Rangées retournées : 20

    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 pudcl_menu AS m
    
      LEFT JOIN pudcl_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	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	20	Using index condition; Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.m.component_id	1	Using where

    Profil

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.52 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.03 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
    8	PlgSystemLanguageFilter->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:668
    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:225
    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.15 ms Après la dernière requête : 6.25 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.818 MB Rangées retournées : 3

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

    Profil

    Status	Duration
    Starting	0.14 ms
    checking permissions	0.02 ms
    Opening tables	0.15 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.20 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.03 ms
    Creating sort index	0.14 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.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: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:438
    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:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Temps de requête : 0.45 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.979 MB Rangées retournées : 1

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

    Explication

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

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    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.01 ms
    Updating status	0.04 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/jcomments/jcomments.php:111
    8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    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:225
    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.51 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.006 MB mémoire avant requête : 7.971 MB

    UPDATE `pudcl_extensions`
    
      SET `params` = '{\"mediaversion\":\"79a9695138850ce0dc5b4b5c2f4fcde6\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.06 ms
    Updating	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.13 ms
    Writing to binlog	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.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
    8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    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:225
    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.94 ms Après la dernière requête : 1.75 ms Mémoire de requête : 0.033 MB mémoire avant requête : 8.266 MB Rangées retournées : 88

    SELECT *
    
      FROM `pudcl_jcomments_settings`
    
      WHERE `lang` = 'fr-FR' 
      AND `component` = ''

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.39 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.10 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.10 ms
    End of update loop	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.04 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/components/com_jcomments/classes/config.php:140
    17	JCommentsCfg::_load()	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/components/com_jcomments/classes/config.php:159
    14	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
    13	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/classes/factory.php:188
    12	JCommentsFactory::getConfig()	JROOT/components/com_jcomments/classes/multilingual.php:45
    11	JCommentsMultilingual::isEnabled()	JROOT/components/com_jcomments/classes/config.php:41
    10	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
    9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
    8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    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:225
    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.57 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.021 MB mémoire avant requête : 8.272 MB Rangées retournées : 2

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

    Explication

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

    Profil

    Status	Duration
    Starting	0.05 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.03 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.10 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.01 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:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_jcomments/helpers/system.php:46
    9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
    8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    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:225
    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 : 0.80 ms Après la dernière requête : 3.95 ms Mémoire de requête : 0.029 MB mémoire avant requête : 8.991 MB Rangées retournées : 43

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `pudcl_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_bagallery','com_banners','com_cache','com_categories','com_checkin','com_cincopa','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_igallery','com_installer','com_jcomments','com_jinc','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_myportfolio','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sitemapgenerator','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	pudcl_assets	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	167	Using where

    Profil

    Status	Duration
    Starting	0.07 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.05 ms
    Optimizing	0.02 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.20 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.01 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/libraries/src/Access/Access.php:429
    18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 0.58 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.034 MB mémoire avant requête : 9.045 MB Rangées retournées : 83

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

    Profil

    Status	Duration
    Starting	0.05 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.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.15 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.01 ms
    Updating status	0.05 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/libraries/src/Access/Access.php:359
    18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 1.23 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.025 MB mémoire avant requête : 9.164 MB Rangées retournées : 3

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

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	PRIMARY	c	ALL	cat_idx,idx_left_right,idx_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	22	Using where; Utilisation du tri complet de type filesort
    2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	crvf_fredericburdetcom.c.id	3	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.10 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
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.05 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.10 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    Executing	0.01 ms
    Sending data	0.08 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.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
    13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.61 ms Après la dernière requête : 1.06 ms Mémoire de requête : 0.048 MB mémoire avant requête : 9.370 MB Rangées retournées : 8

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM pudcl_content AS a
    
      LEFT JOIN pudcl_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN pudcl_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN pudcl_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN pudcl_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN pudcl_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 22 OR a.catid IN (
    SELECT sub.id
    
      FROM pudcl_categories as sub
    
      INNER JOIN pudcl_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt
    
      WHERE this.id = 22)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-26 03:39:58') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-26 03:39:58') 
      AND a.language IN ('fr-FR','*')
    
      ORDER BY  c.lft,  a.ordering,  a.created   
      LIMIT 19

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	range	PRIMARY,idx_access	idx_access	4	NULL	22	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
    1	PRIMARY	a	ref|filter	idx_access,idx_state,idx_catid,idx_language	idx_catid|idx_language	4|28	crvf_fredericburdetcom.c.id	3 (59%)	Using index condition; Using where; Using rowid filter
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.a.created_by	1	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.a.modified_by	1	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.c.parent_id	1	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.a.id	1	Using where
    2	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	1	Using where; Using index

    Profil

    Status	Duration
    Starting	0.20 ms
    checking permissions	0.01 ms
    Opening tables	0.23 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.11 ms
    Optimizing	0.06 ms
    Statistics	0.14 ms
    Preparing	0.07 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.04 ms
    Creating tmp table	0.08 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.17 ms
    Executing	0.01 ms
    Sending data	0.79 ms
    Creating sort index	0.09 ms
    Removing tmp table	0.13 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.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.01 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/MVC/Model/BaseDatabaseModel.php:322
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.02 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.024 MB mémoire avant requête : 9.584 MB Rangées retournées : 1

    SELECT COUNT(*)
    
      FROM pudcl_content AS a
    
      LEFT JOIN pudcl_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN pudcl_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN pudcl_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN pudcl_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN pudcl_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 22 OR a.catid IN (
    SELECT sub.id
    
      FROM pudcl_categories as sub
    
      INNER JOIN pudcl_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt
    
      WHERE this.id = 22)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-26 03:39:58') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-26 03:39:58') 
      AND a.language IN ('fr-FR','*')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	ALL	idx_access,idx_state,idx_catid,idx_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	73	Using where
    1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	crvf_fredericburdetcom.a.catid	1	Using where
    2	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	1	Using where; Using index

    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.06 ms
    Optimizing	0.06 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Executing	0.01 ms
    Sending data	0.12 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    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.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.01 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:1740
    17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
    15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
    14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 0.62 ms Après la dernière requête : 0.92 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.716 MB Rangées retournées : 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `pudcl_contentitem_tag_map` AS m 
    
      INNER JOIN `pudcl_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 22 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explication

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

    Profil

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 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.01 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:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.38 ms Après la dernière requête : 6.71 ms Mémoire de requête : 0.025 MB mémoire avant requête : 10.925 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 pudcl_fields AS a
    
      LEFT JOIN `pudcl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN pudcl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN pudcl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN pudcl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN pudcl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `pudcl_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 (22,0,20)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      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	crvf_fredericburdetcom.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.a.id	1	Using where; Using index; Distinct

    Profil

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.17 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.13 ms
    Preparing	0.05 ms
    Creating tmp table	0.06 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.33 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.10 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.01 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.04 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/MVC/Model/BaseDatabaseModel.php:322
    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:194
    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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.06 ms Après la dernière requête : 7.51 ms Mémoire de requête : 0.025 MB mémoire avant requête : 12.257 MB Rangées retournées : 1

    SELECT c.*,u.name AS displayname, u.username
    
      FROM pudcl_igallery AS c
    
      LEFT JOIN `pudcl_users` AS u 
      ON c.user = u.id
    
      WHERE c.id = 8 
      AND c.published = 1 
      AND c.moderate = 1 
      AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-04-26 03:39:58') 
      AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-26 03:39:58')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,published,publish_up,publish_down,moderate	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.44 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.04 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    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.01 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/components/com_igallery/models/category.php:45
    18	igalleryModelcategory->getCategory()	JROOT/components/com_igallery/views/category/view.html.php:48
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 1.11 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.075 MB mémoire avant requête : 12.265 MB Rangées retournées : 1

    SELECT * 
      FROM pudcl_igallery_profiles 
      WHERE published = 1 
      AND id = 2

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.40 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.15 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.10 ms
    End of update loop	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.01 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:1662
    19	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/models/category.php:59
    18	igalleryModelcategory->getProfile()	JROOT/components/com_igallery/views/category/view.html.php:56
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Temps de requête : 0.88 ms Après la dernière requête : 4.72 ms Mémoire de requête : 0.031 MB mémoire avant requête : 12.423 MB Rangées retournées : 21

    SHOW FULL COLUMNS 
      FROM `pudcl_igallery`

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.23 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    checking permissions	0.11 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.09 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.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    24	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    23	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_igallery/tables/igallery.php:10
    22	Tableigallery->Tableigallery()	JROOT/libraries/src/Table/Table.php:328
    21	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_igallery/models/category.php:553
    20	igalleryModelcategory->getTable()	JROOT/components/com_igallery/models/category.php:324
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Temps de requête : 0.37 ms Après la dernière requête : 0.36 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.477 MB Rangées retournées : 1

    SELECT *
    
      FROM pudcl_igallery
    
      WHERE `id` = '8'

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	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.01 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:1465
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    20	Joomla\CMS\Table\Table->load()	JROOT/components/com_igallery/models/category.php:325
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Temps de requête : 0.41 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.010 MB mémoire avant requête : 12.486 MB

    UPDATE pudcl_igallery
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '8'

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.03 ms
    Updating	0.09 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Writing to binlog	0.02 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    20	Joomla\CMS\Table\Table->hit()	JROOT/components/com_igallery/models/category.php:326
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.71 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.504 MB Rangées retournées : 1

    SELECT COUNT(*)
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 8 
      AND i.gallery_id = 8 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	i	ALL	gallery_id,access,published,publish_up,publish_down,moderate	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	649	Using where

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.34 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.04 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.42 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.43 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.01 ms
    Updating status	0.04 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:1740
    21	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:402
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 2.11 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.139 MB mémoire avant requête : 12.509 MB Rangées retournées : 212

    SELECT i.*,c.name,p.thumb_pagination_amount, p.thumb_pagination,u.name AS displayname, u.username
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 8 
      AND i.gallery_id = 8 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)
    
      ORDER BY i.ordering 
      LIMIT 1000

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	i	ALL	gallery_id,access,published,publish_up,publish_down,moderate	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	649	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.i.user	1

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.14 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	1.46 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.01 ms
    Updating status	0.02 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:412
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.52 ms Après la dernière requête : 160.83 ms Mémoire de requête : 0.025 MB mémoire avant requête : 13.919 MB Rangées retournées : 1

    SELECT c.*,u.name AS displayname, u.username
    
      FROM pudcl_igallery AS c
    
      LEFT JOIN `pudcl_users` AS u 
      ON c.user = u.id
    
      WHERE c.id = 9 
      AND c.published = 1 
      AND c.moderate = 1 
      AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-04-26 03:39:58') 
      AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-26 03:39:58')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,published,publish_up,publish_down,moderate	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 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.01 ms
    Updating status	0.03 ms
    Reset for next command	0.03 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/components/com_igallery/models/category.php:45
    18	igalleryModelcategory->getCategory()	JROOT/components/com_igallery/views/category/view.html.php:48
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Temps de requête : 0.43 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.074 MB mémoire avant requête : 13.927 MB Rangées retournées : 1

    SELECT * 
      FROM pudcl_igallery_profiles 
      WHERE published = 1 
      AND id = 1

    Explication

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

    Profil

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.03 ms
    Sending data	0.07 ms
    End of update loop	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.04 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 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/components/com_igallery/models/category.php:59
    18	igalleryModelcategory->getProfile()	JROOT/components/com_igallery/views/category/view.html.php:56
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.30 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.027 MB mémoire avant requête : 13.963 MB Rangées retournées : 1

    SELECT *
    
      FROM pudcl_igallery
    
      WHERE `id` = '9'

    Explication

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

    Profil

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	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.01 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:1465
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    20	Joomla\CMS\Table\Table->load()	JROOT/components/com_igallery/models/category.php:325
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Temps de requête : 0.41 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.010 MB mémoire avant requête : 13.973 MB

    UPDATE pudcl_igallery
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '9'

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.03 ms
    table lock	0.01 ms
    init for update	0.04 ms
    Updating	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Writing to binlog	0.02 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    20	Joomla\CMS\Table\Table->hit()	JROOT/components/com_igallery/models/category.php:326
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 1.36 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.992 MB Rangées retournées : 1

    SELECT COUNT(*)
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 9 
      AND i.gallery_id = 9 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	const	69	Using where

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.30 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.61 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.03 ms
    Updating status	0.03 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:1740
    21	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:402
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 1.94 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.078 MB mémoire avant requête : 13.996 MB Rangées retournées : 86

    SELECT i.*,c.name,p.thumb_pagination_amount, p.thumb_pagination,u.name AS displayname, u.username
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 9 
      AND i.gallery_id = 9 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)
    
      ORDER BY i.ordering 
      LIMIT 1000

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	const	69	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.i.user	1

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.16 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	1.28 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.01 ms
    Updating status	0.04 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:412
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Temps de requête : 0.59 ms Après la dernière requête : 66.35 ms Mémoire de requête : 0.025 MB mémoire avant requête : 13.548 MB Rangées retournées : 1

    SELECT c.*,u.name AS displayname, u.username
    
      FROM pudcl_igallery AS c
    
      LEFT JOIN `pudcl_users` AS u 
      ON c.user = u.id
    
      WHERE c.id = 10 
      AND c.published = 1 
      AND c.moderate = 1 
      AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-04-26 03:39:58') 
      AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-26 03:39:58')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,published,publish_up,publish_down,moderate	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    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.01 ms
    Updating status	0.04 ms
    Reset for next command	0.03 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/components/com_igallery/models/category.php:45
    18	igalleryModelcategory->getCategory()	JROOT/components/com_igallery/views/category/view.html.php:48
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Temps de requête : 0.33 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.562 MB Rangées retournées : 1

    SELECT *
    
      FROM pudcl_igallery
    
      WHERE `id` = '10'

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	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.01 ms
    Updating status	0.03 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:1465
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    20	Joomla\CMS\Table\Table->load()	JROOT/components/com_igallery/models/category.php:325
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Temps de requête : 0.38 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.010 MB mémoire avant requête : 13.572 MB

    UPDATE pudcl_igallery
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '10'

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.03 ms
    Updating	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Writing to binlog	0.03 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    20	Joomla\CMS\Table\Table->hit()	JROOT/components/com_igallery/models/category.php:326
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Temps de requête : 0.82 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.591 MB Rangées retournées : 1

    SELECT COUNT(*)
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 10 
      AND i.gallery_id = 10 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	const	22	Using where

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.15 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.24 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.01 ms
    Updating status	0.03 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:1740
    21	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:402
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Temps de requête : 1.13 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.038 MB mémoire avant requête : 13.595 MB Rangées retournées : 28

    SELECT i.*,c.name,p.thumb_pagination_amount, p.thumb_pagination,u.name AS displayname, u.username
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 10 
      AND i.gallery_id = 10 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)
    
      ORDER BY i.ordering 
      LIMIT 1000

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	const	22	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.i.user	1

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.18 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.46 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.01 ms
    Updating status	0.04 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:412
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.56 ms Après la dernière requête : 25.79 ms Mémoire de requête : 0.025 MB mémoire avant requête : 13.353 MB Rangées retournées : 1

    SELECT c.*,u.name AS displayname, u.username
    
      FROM pudcl_igallery AS c
    
      LEFT JOIN `pudcl_users` AS u 
      ON c.user = u.id
    
      WHERE c.id = 11 
      AND c.published = 1 
      AND c.moderate = 1 
      AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-04-26 03:39:58') 
      AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-26 03:39:58')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,published,publish_up,publish_down,moderate	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    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.01 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:1662
    19	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/models/category.php:45
    18	igalleryModelcategory->getCategory()	JROOT/components/com_igallery/views/category/view.html.php:48
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.37 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.368 MB Rangées retournées : 1

    SELECT *
    
      FROM pudcl_igallery
    
      WHERE `id` = '11'

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	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.01 ms
    Updating status	0.03 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:1465
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    20	Joomla\CMS\Table\Table->load()	JROOT/components/com_igallery/models/category.php:325
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.38 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.010 MB mémoire avant requête : 13.377 MB

    UPDATE pudcl_igallery
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '11'

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.03 ms
    Updating	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Writing to binlog	0.02 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    20	Joomla\CMS\Table\Table->hit()	JROOT/components/com_igallery/models/category.php:326
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Temps de requête : 0.90 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.396 MB Rangées retournées : 1

    SELECT COUNT(*)
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 11 
      AND i.gallery_id = 11 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	const	39	Using where

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.34 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.01 ms
    Updating status	0.04 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:1740
    21	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:402
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Temps de requête : 1.40 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.046 MB mémoire avant requête : 13.400 MB Rangées retournées : 48

    SELECT i.*,c.name,p.thumb_pagination_amount, p.thumb_pagination,u.name AS displayname, u.username
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 11 
      AND i.gallery_id = 11 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)
    
      ORDER BY i.ordering 
      LIMIT 1000

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	const	39	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.i.user	1

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.14 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.74 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.01 ms
    Updating status	0.04 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:412
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Temps de requête : 0.58 ms Après la dernière requête : 34.94 ms Mémoire de requête : 0.025 MB mémoire avant requête : 13.570 MB Rangées retournées : 1

    SELECT c.*,u.name AS displayname, u.username
    
      FROM pudcl_igallery AS c
    
      LEFT JOIN `pudcl_users` AS u 
      ON c.user = u.id
    
      WHERE c.id = 12 
      AND c.published = 1 
      AND c.moderate = 1 
      AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-04-26 03:39:58') 
      AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-26 03:39:58')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,published,publish_up,publish_down,moderate	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 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.01 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/components/com_igallery/models/category.php:45
    18	igalleryModelcategory->getCategory()	JROOT/components/com_igallery/views/category/view.html.php:48
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Temps de requête : 0.33 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.584 MB Rangées retournées : 1

    SELECT *
    
      FROM pudcl_igallery
    
      WHERE `id` = '12'

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	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.01 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:1465
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    20	Joomla\CMS\Table\Table->load()	JROOT/components/com_igallery/models/category.php:325
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Temps de requête : 0.35 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.010 MB mémoire avant requête : 13.594 MB

    UPDATE pudcl_igallery
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '12'

    Explication

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

    Profil

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.03 ms
    Updating	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Writing to binlog	0.02 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    20	Joomla\CMS\Table\Table->hit()	JROOT/components/com_igallery/models/category.php:326
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 0.88 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.613 MB Rangées retournées : 1

    SELECT COUNT(*)
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 12 
      AND i.gallery_id = 12 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	const	40	Using where

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.35 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.01 ms
    Updating status	0.04 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:1740
    21	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:402
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 1.34 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.046 MB mémoire avant requête : 13.617 MB Rangées retournées : 50

    SELECT i.*,c.name,p.thumb_pagination_amount, p.thumb_pagination,u.name AS displayname, u.username
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 12 
      AND i.gallery_id = 12 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)
    
      ORDER BY i.ordering 
      LIMIT 1000

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	const	40	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.i.user	1

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.74 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.01 ms
    Updating status	0.04 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:412
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 0.66 ms Après la dernière requête : 38.15 ms Mémoire de requête : 0.025 MB mémoire avant requête : 13.741 MB Rangées retournées : 1

    SELECT c.*,u.name AS displayname, u.username
    
      FROM pudcl_igallery AS c
    
      LEFT JOIN `pudcl_users` AS u 
      ON c.user = u.id
    
      WHERE c.id = 3 
      AND c.published = 1 
      AND c.moderate = 1 
      AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-04-26 03:39:58') 
      AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-26 03:39:58')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,published,publish_up,publish_down,moderate	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    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.01 ms
    Updating status	0.03 ms
    Reset for next command	0.03 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/components/com_igallery/models/category.php:45
    18	igalleryModelcategory->getCategory()	JROOT/components/com_igallery/views/category/view.html.php:48
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.37 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.756 MB Rangées retournées : 1

    SELECT *
    
      FROM pudcl_igallery
    
      WHERE `id` = '3'

    Explication

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

    Profil

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	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.01 ms
    Updating status	0.03 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:1465
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    20	Joomla\CMS\Table\Table->load()	JROOT/components/com_igallery/models/category.php:325
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 0.37 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.010 MB mémoire avant requête : 13.765 MB

    UPDATE pudcl_igallery
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '3'

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.03 ms
    Updating	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Writing to binlog	0.02 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    20	Joomla\CMS\Table\Table->hit()	JROOT/components/com_igallery/models/category.php:326
    19	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:425
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 1.00 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.784 MB Rangées retournées : 1

    SELECT COUNT(*)
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 3 
      AND i.gallery_id = 3 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	i	ALL	gallery_id,access,published,publish_up,publish_down,moderate	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	649	Using where

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.05 ms
    Statistics	0.15 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.39 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.01 ms
    Updating status	0.03 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:1740
    21	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:402
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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 : 2.32 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.090 MB mémoire avant requête : 13.788 MB Rangées retournées : 124

    SELECT i.*,c.name,p.thumb_pagination_amount, p.thumb_pagination,u.name AS displayname, u.username
    
      FROM pudcl_igallery_img AS i
    
      INNER JOIN `pudcl_igallery` AS c 
      ON c.id = i.gallery_id
    
      INNER JOIN `pudcl_igallery_profiles` AS p 
      ON p.id = c.profile
    
      LEFT JOIN `pudcl_users` AS u 
      ON i.user = u.id
    
      WHERE i.gallery_id = 3 
      AND i.gallery_id = 3 
      AND i.published = 1 
      AND i.moderate = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-26 03:39:58') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-26 03:39:58') 
      AND i.access IN (1,1,5)
    
      ORDER BY i.ordering 
      LIMIT 1000

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,profile	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	i	ALL	gallery_id,access,published,publish_up,publish_down,moderate	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	649	Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	crvf_fredericburdetcom.i.user	1

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.14 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	1.67 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.02 ms
    Updating status	0.03 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:412
    19	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:446
    18	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:123
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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]

    ---

57. Temps de requête : 0.57 ms Après la dernière requête : 86.12 ms Mémoire de requête : 0.030 MB mémoire avant requête : 14.085 MB Rangées retournées : 11

    SELECT * 
      FROM pudcl_igallery 
      ORDER BY parent, ordering

    Explication

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

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.13 ms
    End of update loop	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.01 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_igallery/helpers/static.php:15
    21	igStaticHelper::getCategories()	JROOT/components/com_igallery/helpers/utility.php:334
    20	igUtilityHelper::getItemid()	JROOT/components/com_igallery/helpers/utility.php:420
    19	igUtilityHelper::makeHeadJs()	JROOT/components/com_igallery/views/category/view.html.php:233
    18	igalleryViewcategory->setMetaData()	JROOT/components/com_igallery/views/category/view.html.php:204
    17	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    16	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
    15	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    14	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/plugins/content/igallery/igallery.php:136
    13	plgContentIgallery->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/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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]

    ---

58. Temps de requête : 1.13 ms Après la dernière requête : 5.80 ms Mémoire de requête : 0.024 MB mémoire avant requête : 14.542 MB Rangées retournées : 1

    SELECT count(*)
    
      FROM pudcl_jcomments AS c
    
      WHERE c.object_id = 61 
      AND c.object_group = 'com_content' 
      AND c.published = 1 
      AND c.lang = 'fr-FR'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range|filter	idx_lang,idx_object	idx_lang|idx_object	767|772	NULL	1 (25%)	Using index condition; Using where; Using rowid filter

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.48 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.05 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	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.01 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
    15	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:187
    14	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:309
    13	plgContentJComments->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/category/view.html.php:121
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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]

    ---

59. Temps de requête : 0.46 ms Après la dernière requête : 3.01 ms Mémoire de requête : 0.021 MB mémoire avant requête : 15.406 MB Rangées retournées : 3

    SELECT language,id
    
      FROM `pudcl_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.08 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.01 ms
    Updating status	0.03 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/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    7	PlgSystemLanguageFilter->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:225
    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]

    ---

60. Temps de requête : 0.55 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.021 MB mémoire avant requête : 15.530 MB Rangées retournées : 0

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
    
      FROM `pudcl_categories` AS `c`
    
      INNER JOIN `pudcl_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_categories.item'
    
      INNER JOIN `pudcl_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `pudcl_categories` AS `c2` 
      ON a2.id = c2.`id` 
      AND c2.extension = 'com_content'
    
      WHERE c.id = 22 
      AND c.extension = 'com_content'

    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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    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.01 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/libraries/src/Language/Associations.php:115
    11	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:113
    10	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
    9	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
    8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
    7	PlgSystemLanguageFilter->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:225
    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]

    ---

61. Temps de requête : 0.93 ms Après la dernière requête : 2.11 ms Mémoire de requête : 0.023 MB mémoire avant requête : 16.403 MB Rangées retournées : 4

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM pudcl_modules AS m
    
      LEFT JOIN pudcl_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN pudcl_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 <= '2025-04-26 03:39:58') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-26 03:39:58') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 148 OR mm.menuid <= 0) 
      AND m.language IN ('fr-FR','*')
    
      ORDER BY m.position, m.ordering

    Explication

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

    Profil

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.05 ms
    Statistics	0.09 ms
    Preparing	0.06 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.22 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.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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/jaxstorm-black/index.php:24
    7	require JROOT/templates/jaxstorm-black/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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:231
    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]

    ---

62. Temps de requête : 0.48 ms Après la dernière requête : 2.97 ms Mémoire de requête : 0.023 MB mémoire avant requête : 16.634 MB Rangées retournées : 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `pudcl_menu` AS `c`
    
      INNER JOIN `pudcl_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `pudcl_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `pudcl_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 148

    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.05 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.03 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    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.01 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/libraries/src/Language/Associations.php:115
    13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
    11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    10	include JROOT/modules/mod_languages/mod_languages.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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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:231
    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]

    ---

63. Temps de requête : 0.38 ms Après la dernière requête : 1.57 ms Mémoire de requête : 0.023 MB mémoire avant requête : 16.827 MB Rangées retournées : 1

    SELECT id, url, title, lightboxUrl, form_id
    
      FROM pudcl_bagallery_items

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 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.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.04 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.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_bagallery/helpers/bagallery.php:159
    14	bagalleryHelper::checkImage()	JROOT/components/com_bagallery/helpers/bagallery.php:30
    13	bagalleryHelper::addStyle()	JROOT/plugins/system/bagallery/bagallery.php:71
    12	plgSystemBagallery->onBeforeCompileHead()	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/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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:231
    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]

    ---

64. Temps de requête : 0.50 ms Après la dernière requête : 4.53 ms Mémoire de requête : 0.026 MB mémoire avant requête : 19.181 MB Rangées retournées : 81

    SELECT * 
      FROM pudcl_acymailing_config

    Explication

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	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.01 ms
    Updating status	0.06 ms
    Reset for next command	0.01 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/administrator/components/com_acymailing/classes/cpanel.php:17
    10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:473
    9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1185
    8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
    7	plgSystemRegacymailing->onAfterRender()	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/CMSApplication.php:1118
    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:231
    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]

    ---