Votre projet d'aménagement est soumis à examen au cas par cas ?

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

**Temps**

**Mémoire**

**26 requêtes exécutées** 19.47 ms

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

   SELECT `data`
   
     FROM `cascas_session`
   
     WHERE `session_id` = X'3464303839666461343739343962323932333861383838376634333135366165'

   **Explication**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cascas_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   **Profil**

   Error
   The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

   **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.17 ms** **Après la dernière requête : 0.64 ms** **Mémoire de requête : 0.020 MB mémoire avant requête : 4.725 MB** **Rangées retournées : 0**

   SELECT `session_id`
   
     FROM `cascas_session`
   
     WHERE `session_id` = X'3464303839666461343739343962323932333861383838376634333135366165' 
     LIMIT 1

   **Explication**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cascas_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   **Profil**

   **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

   **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.25 ms** **Après la dernière requête : 0.08 ms** **Mémoire de requête : 0.004 MB mémoire avant requête : 4.730 MB**

   INSERT INTO `cascas_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3464303839666461343739343962323932333861383838376634333135366165', 1, 1696032210, 0, '', 0)

   **Explication**

   **EXPLAIN impossible sur la requête : INSERT INTO `cascas_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3464303839666461343739343962323932333861383838376634333135366165', 1, 1696032210, 0, '', 0)**

   **Profil**

   **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

   **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.66 ms** **Après la dernière requête : 1.04 ms** **Mémoire de requête : 0.024 MB mémoire avant requête : 5.082 MB** **Rangées retournées : 35**

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

   **Explication**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cascas_extensions	NULL	ref	extension	extension	82	const	38	1.00	Using where

   **Profil**

   **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

   **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.45 ms** **Après la dernière requête : 1.11 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 5.427 MB** **Rangées retournées : 5**

   SELECT id, rules
   
     FROM `cascas_viewlevels`

   **Explication**

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

   **Profil**

   **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

   **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.51 ms** **Après la dernière requête : 0.07 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 5.439 MB** **Rangées retournées : 2**

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

   **Explication**

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

   **Profil**

   **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

   **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 : 0.88 ms** **Après la dernière requête : 0.26 ms** **Mémoire de requête : 0.030 MB mémoire avant requête : 5.462 MB** **Rangées retournées : 87**

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM cascas_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cascas_extensions	NULL	ref	extension	extension	82	const	147	0.60	Using index condition; Using where; **Utilisation du tri complet de type filesort**

   **Profil**

   **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

   **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 : 2.32 ms** **Après la dernière requête : 10.72 ms** **Mémoire de requête : 0.005 MB mémoire avant requête : 6.801 MB**

   DELETE 
   
     FROM `cascas_jhackguard_logs`
   
     WHERE `time` < DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)

   **Explication**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	DELETE	cascas_jhackguard_logs	NULL	ALL	NULL	**INDEX N'A PU ÊTRE UTILISÉ**	NULL	NULL	0	100.00	Using where

   **Profil**

   **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

   **Pile d'appels**

   #	**Appel**	**Fichier et numéro de ligne**
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
   9	JDatabase->query()	JROOT/plugins/system/jhackguard/jhackguard.php:145
   8	PlgSystemJhackguard->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**]

   ---

9. **Temps de requête : 0.26 ms** **Après la dernière requête : 0.08 ms** **Mémoire de requête : 0.005 MB mémoire avant requête : 6.807 MB**

   DELETE 
   
     FROM `cascas_jhackguard_ip_filters`
   
     WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) 
     AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)

   **Explication**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	DELETE	cascas_jhackguard_ip_filters	NULL	ALL	NULL	**INDEX N'A PU ÊTRE UTILISÉ**	NULL	NULL	0	100.00	Using where

   **Profil**

   **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

   **Pile d'appels**

   #	**Appel**	**Fichier et numéro de ligne**
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
   9	JDatabase->query()	JROOT/plugins/system/jhackguard/jhackguard.php:156
   8	PlgSystemJhackguard->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**]

   ---

10. **Temps de requête : 0.15 ms** **Après la dernière requête : 0.05 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 6.815 MB** **Rangées retournées : 0**

    SELECT `state`,`rule_type`
    
      FROM `cascas_jhackguard_ip_filters`
    
      WHERE `ip` = '18.232.179.37' 
      AND `state` = 1
    
      ORDER BY ordering ASC

    **Explication**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	**INDEX N'A PU ÊTRE UTILISÉ**	NULL	NULL	NULL	NULL	no matching row in const table

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/plugins/system/jhackguard/jhackguard.php:358
    9	PlgSystemJhackguard->ip_is()	JROOT/plugins/system/jhackguard/jhackguard.php:174
    8	PlgSystemJhackguard->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 : 0.84 ms** **Après la dernière requête : 1.71 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 7.171 MB** **Rangées retournées : 8**

    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 cascas_menu AS m
    
      LEFT JOIN cascas_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	**INDEX N'A PU ÊTRE UTILISÉ**	NULL	NULL	35	2.86	Using where; **Utilisation du tri complet de type filesort**
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	lescorde_caspcas.m.component_id	1	100.00	Using where

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	**Même appel que celui de la ligne ci-dessous.**
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
    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**]

    ---

12. **Temps de requête : 0.63 ms** **Après la dernière requête : 3.66 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 7.915 MB** **Rangées retournées : 4**

    SELECT id, home, template, s.params
    
      FROM cascas_template_styles as s
    
      LEFT JOIN cascas_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_template,idx_client_id,idx_client_id_home	**INDEX N'A PU ÊTRE UTILISÉ**	NULL	NULL	5	80.00	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	lescorde_caspcas.s.template,const	1	4.25	Using index condition; Using where

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **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/plugins/system/yootheme/yootheme.php:136
    9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:38
    8	plgSystemYOOtheme->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**]

    ---

13. **Temps de requête : 0.38 ms** **Après la dernière requête : 11.78 ms** **Mémoire de requête : 0.028 MB mémoire avant requête : 10.210 MB** **Rangées retournées : 1**

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

    **Explication**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cascas_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    29	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    28	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	**Même appel que celui de la ligne ci-dessous.**
    27	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    26	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    25	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    24	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    23	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    22	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    21	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    20	Joomla\CMS\Factory::getDocument()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeListener.php:90
    19	YOOtheme\Theme\Joomla\ThemeListener->onInitLate()	**Même appel que celui de la ligne ci-dessous.**
    18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeListener.php:74
    15	YOOtheme\Theme\Joomla\ThemeListener->onStart()	**Même appel que celui de la ligne ci-dessous.**
    14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
    11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:185
    10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:138
    9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:38
    8	plgSystemYOOtheme->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.29 ms** **Après la dernière requête : 0.15 ms** **Mémoire de requête : 0.011 MB mémoire avant requête : 10.207 MB**

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

    **Explication**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	cascas_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    24	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    23	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    22	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    21	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    20	Joomla\CMS\Factory::getDocument()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeListener.php:90
    19	YOOtheme\Theme\Joomla\ThemeListener->onInitLate()	**Même appel que celui de la ligne ci-dessous.**
    18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeListener.php:74
    15	YOOtheme\Theme\Joomla\ThemeListener->onStart()	**Même appel que celui de la ligne ci-dessous.**
    14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
    11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:185
    10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:138
    9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:38
    8	plgSystemYOOtheme->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.63 ms** **Après la dernière requête : 1.25 ms** **Mémoire de requête : 0.028 MB mémoire avant requête : 10.574 MB** **Rangées retournées : 1**

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

    **Explication**

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

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **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/src/Language/LanguageHelper.php:150
    25	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    24	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeListener.php:127
    23	YOOtheme\Theme\Joomla\ThemeListener->onSite()	**Même appel que celui de la ligne ci-dessous.**
    22	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    21	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    20	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeListener.php:115
    19	YOOtheme\Theme\Joomla\ThemeListener->onInitLate()	**Même appel que celui de la ligne ci-dessous.**
    18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeListener.php:74
    15	YOOtheme\Theme\Joomla\ThemeListener->onStart()	**Même appel que celui de la ligne ci-dessous.**
    14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
    11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:185
    10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:138
    9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:38
    8	plgSystemYOOtheme->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 : 1.06 ms** **Après la dernière requête : 21.07 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 14.276 MB** **Rangées retournées : 35**

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

    **Explication**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cascas_assets	NULL	ALL	idx_asset_name	**INDEX N'A PU ÊTRE UTILISÉ**	NULL	NULL	73	49.32	Using where

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

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

    ---

17. **Temps de requête : 0.32 ms** **Après la dernière requête : 0.21 ms** **Mémoire de requête : 0.026 MB mémoire avant requête : 14.328 MB** **Rangées retournées : 10**

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

    **Explication**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cascas_assets	NULL	ALL	idx_asset_name,idx_parent_id	**INDEX N'A PU ÊTRE UTILISÉ**	NULL	NULL	73	28.00	Using where

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.94 ms** **Après la dernière requête : 1.13 ms** **Mémoire de requête : 0.032 MB mémoire avant requête : 14.360 MB** **Rangées retournées : 31**

    SHOW FULL COLUMNS 
      FROM `cascas_content`

    **Explication**

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

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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 : 0.38 ms** **Après la dernière requête : 2.34 ms** **Mémoire de requête : 0.005 MB mémoire avant requête : 14.729 MB**

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

    **Explication**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	cascas_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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 : 1.61 ms** **Après la dernière requête : 1.14 ms** **Mémoire de requête : 0.063 MB mémoire avant requête : 14.762 MB** **Rangées retournées : 1**

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

    **Explication**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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 : 0.93 ms** **Après la dernière requête : 1.33 ms** **Mémoire de requête : 0.022 MB mémoire avant requête : 15.161 MB** **Rangées retournées : 0**

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

    **Explication**

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

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.66 ms** **Après la dernière requête : 18.78 ms** **Mémoire de requête : 0.026 MB mémoire avant requête : 16.669 MB** **Rangées retournées : 2**

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

    **Explication**

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

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	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/article/view.html.php:193
    10	ContentViewArticle->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.64 ms** **Après la dernière requête : 0.30 ms** **Mémoire de requête : 0.025 MB mémoire avant requête : 17.006 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 cascas_fields AS a
    
      LEFT JOIN `cascas_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN cascas_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN cascas_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN cascas_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN cascas_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `cascas_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 (2,0)) 
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; **Utilisation du tri complet de type filesort**
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	lescorde_caspcas.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	lescorde_caspcas.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	lescorde_caspcas.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	lescorde_caspcas.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	lescorde_caspcas.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	lescorde_caspcas.a.id	1	100.00	Using where; Using index; Distinct

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **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/article/view.html.php:193
    10	ContentViewArticle->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.05 ms** **Après la dernière requête : 5.97 ms** **Mémoire de requête : 0.034 MB mémoire avant requête : 17.785 MB** **Rangées retournées : 3**

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM cascas_modules AS m
    
      LEFT JOIN cascas_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN cascas_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 <= '2023-09-30 00:03:30') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-30 00:03:30') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    **Explication**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	**INDEX N'A PU ÊTRE UTILISÉ**	NULL	NULL	23	4.35	Using where; **Utilisation du tri complet de type filesort**
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	lescorde_caspcas.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	lescorde_caspcas.m.id	1	40.00	Using where; Using index

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    38	JDatabaseDriver->loadObjectList()	**Même appel que celui de la ligne ci-dessous.**
    37	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    36	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    35	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    34	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    33	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    32	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/index.php:14
    31	YOOtheme\Module->{closure}()	**Même appel que celui de la ligne ci-dessous.**
    30	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:74
    29	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/header-mobile.php:55
    28	require JROOT/templates/yootheme/templates/header-mobile.php	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:252
    27	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50
    26	YOOtheme\Module->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    25	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:143
    24	YOOtheme\Theme->replace()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    23	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:32
    22	YOOtheme\Theme\Joomla\UrlListener->__invoke()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    21	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217
    20	YOOtheme\View->render()	JROOT/templates/yootheme/templates/header.php:86
    19	require JROOT/templates/yootheme/templates/header.php	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:252
    18	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50
    17	YOOtheme\Module->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    16	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:143
    15	YOOtheme\Theme->replace()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:32
    13	YOOtheme\Theme\Joomla\UrlListener->__invoke()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217
    11	YOOtheme\View->render()	**Même appel que celui de la ligne ci-dessous.**
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:132
    7	require JROOT/templates/yootheme/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**]

    ---

25. **Temps de requête : 0.73 ms** **Après la dernière requête : 6.16 ms** **Mémoire de requête : 0.026 MB mémoire avant requête : 18.147 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 cascas_fields AS a
    
      LEFT JOIN `cascas_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN cascas_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN cascas_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN cascas_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN cascas_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_custom.content' 
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; **Utilisation du tri complet de type filesort**
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	lescorde_caspcas.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	lescorde_caspcas.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	lescorde_caspcas.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	lescorde_caspcas.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	lescorde_caspcas.a.group_id	1	100.00	Using where

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **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/MVC/Model/BaseDatabaseModel.php:322
    21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	**Même appel que celui de la ligne ci-dessous.**
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.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/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:27
    7	YOOtheme\Theme\Joomla\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**]

    ---

26. **Temps de requête : 0.31 ms** **Après la dernière requête : 3.23 ms** **Mémoire de requête : 0.020 MB mémoire avant requête : 18.213 MB** **Rangées retournées : 0**

    SELECT `name`,`regex`,`replacement`
    
      FROM `cascas_jhackguard_output_filters`
    
      WHERE `state` = 1
    
      ORDER BY ordering ASC

    **Explication**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	**INDEX N'A PU ÊTRE UTILISÉ**	NULL	NULL	NULL	NULL	no matching row in const table

    **Profil**

    **No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**

    **Pile d'appels**

    #	**Appel**	**Fichier et numéro de ligne**
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jhackguard/jhackguard.php:91
    7	PlgSystemJhackguard->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**]

    ---

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

**Tables sélectionnées :**

1. **2 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `cascas_assets`**

2. **2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `cascas_extensions`**

3. **1 × SELECT `data` 
     FROM `cascas_session`**

4. **1 × 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 cascas_fields AS a 
     LEFT JOIN `cascas_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN cascas_users AS uc 
     ON uc.id=a.checked_out 
     LEFT JOIN cascas_viewlevels AS ag 
     ON ag.id = a.access 
     LEFT JOIN cascas_users AS ua 
     ON ua.id = a.created_user_id 
     LEFT JOIN cascas_fields_groups AS g 
     ON g.id = a.group_id**

5. **1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM cascas_modules AS m 
     LEFT JOIN cascas_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN cascas_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id**

6. **1 × 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 cascas_fields AS a 
     LEFT JOIN `cascas_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN cascas_users AS uc 
     ON uc.id=a.checked_out 
     LEFT JOIN cascas_viewlevels AS ag 
     ON ag.id = a.access 
     LEFT JOIN cascas_users AS ua 
     ON ua.id = a.created_user_id 
     LEFT JOIN cascas_fields_groups AS g 
     ON g.id = a.group_id 
     LEFT JOIN `cascas_fields_categories` AS fc 
     ON fc.field_id = a.id**

7. **1 × 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 `cascas_categories` AS `s` 
     INNER JOIN `cascas_categories` AS `c` 
     ON (s.lft <= c.lft 
     AND c.lft < s.rgt) OR (c.lft < s.lft 
     AND s.rgt < c.rgt)**

8. **1 × SELECT `m`.`tag_id`,`t`.* 
     FROM `cascas_contentitem_tag_map` AS m  
     INNER JOIN `cascas_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`**

9. **1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
     FROM cascas_content AS a 
     INNER JOIN cascas_categories AS c 
     on c.id = a.catid 
     LEFT JOIN cascas_users AS u 
     on u.id = a.created_by 
     LEFT JOIN cascas_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN cascas_content_rating AS v 
     ON a.id = v.content_id**

10. **1 × SELECT * 
      FROM cascas_languages**

11. **1 × SELECT `session_id` 
      FROM `cascas_session`**

12. **1 × SELECT id, home, template, s.params 
      FROM cascas_template_styles as s 
      LEFT JOIN cascas_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id**

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

14. **1 × SELECT `state`,`rule_type` 
      FROM `cascas_jhackguard_ip_filters`**

15. **1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM cascas_extensions**

16. **1 × SELECT b.id 
      FROM cascas_usergroups AS a 
      LEFT JOIN cascas_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt**

17. **1 × SELECT id, rules 
      FROM `cascas_viewlevels**

18. **1 × SELECT `name`,`regex`,`replacement` 
      FROM `cascas_jhackguard_output_filters`**

**Autres tables :**

1. **1 × INSERT INTO `cascas_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'3464303839666461343739343962323932333861383838376634333135366165', 1, 1696032210, 0, '', 0**

2. **1 × DELETE  
     FROM `cascas_jhackguard_logs`**

3. **1 × DELETE  
     FROM `cascas_jhackguard_ip_filters`**

4. **1 × UPDATE `cascas_extensions` 
     SET `params` = '{\"mediaversion\":\"b6abab810687a76fa611063f0f0df8c7\"}'**

5. **1 × SHOW FULL COLUMNS 
     FROM `cascas_content**

6. **1 × UPDATE cascas_content 
     SET `hits` = (`hits` + 1)**

**Aucun**

• **Chargé** : JROOT/language/fr-FR/fr-FR.ini
• **Chargé** : JROOT/language/fr-FR/fr-FR.lib_joomla.ini
• **Chargé** : JROOT/administrator/language/fr-FR/fr-FR.plg_system_updatenotification.ini
• **Chargé** : JROOT/administrator/language/fr-FR/fr-FR.plg_system_fields.ini
• **Chargé** : JROOT/administrator/language/fr-FR/fr-FR.plg_system_actionlogs.ini
• **Chargé** : JROOT/administrator/language/fr-FR/fr-FR.plg_actionlog_joomla.ini
• **Chargé** : JROOT/administrator/language/fr-FR/fr-FR.plg_system_logrotation.ini
• **Chargé** : JROOT/administrator/language/fr-FR/fr-FR.plg_system_logout.ini
• **Chargé** : JROOT/templates/yootheme/language/fr-FR/fr-FR.tpl_yootheme.ini
• **Chargé** : JROOT/language/fr-FR/fr-FR.tpl_yootheme.ini
• **Chargé** : JROOT/language/fr-FR/fr-FR.com_content.ini
• **Chargé** : JROOT/language/fr-FR/fr-FR.mod_menu.ini
• **Chargé** : JROOT/language/fr-FR/fr-FR.mod_custom.ini
• **Chargé** : JROOT/administrator/language/fr-FR/fr-FR.plg_system_debug.ini

# JROOT/libraries/src/Language/Text.php

EXAMEN_AU_CAS_PAR_CAS="AU CAS PAR CAS"