Guide examen au cas par cas

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1696030847,
                "last": 1696030847,
                "now": 1696030847
            },
            "token": "CsFpvg6Yu989uTlsVZicp7TSlrZ0fAqN"
        },
        "registry": {
            "com_installer": {
                "message": "",
                "extension_message": ""
            }
        },
        "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
        }
    }
}

Profil d'information

Temps

Mémoire

**Temps**: 52.27 ms / 52.27 ms **Mémoire**: 2.579 MB / 2.95 MB Application: afterLoad

**Temps**: 103.83 ms / 156.10 ms **Mémoire**: 4.183 MB / 7.14 MB Application: afterInitialise

**Temps**: 219.28 ms / 375.38 ms **Mémoire**: 6.762 MB / 13.90 MB Application: afterRoute

**Temps**: 0.48 ms / 375.86 ms **Mémoire**: 0.001 MB / 13.90 MB Application: beforeRenderComponent com_content

**Temps**: 11.02 ms / 386.88 ms **Mémoire**: 0.370 MB / 14.27 MB Application: Before Access::preloadComponents (all components)

**Temps**: 2.48 ms / 389.36 ms **Mémoire**: 0.057 MB / 14.33 MB Application: After Access::preloadComponents (all components)

**Temps**: 0.07 ms / 389.43 ms **Mémoire**: -0.003 MB / 14.32 MB Application: Before Access::preloadPermissions (com_content)

**Temps**: 0.50 ms / 389.92 ms **Mémoire**: 0.017 MB / 14.34 MB Application: After Access::preloadPermissions (com_content)

**Temps**: 0.03 ms / 389.96 ms **Mémoire**: 0.001 MB / 14.34 MB Application: Before Access::getAssetRules (id:71 name:com_content.article.4)

**Temps**: 1.40 ms / 391.35 ms **Mémoire**: 0.010 MB / 14.35 MB Application: After Access::getAssetRules (id:71 name:com_content.article.4)

**Temps**: 102.38 ms / 493.73 ms **Mémoire**: 3.037 MB / 17.39 MB Application: afterRenderComponent com_content

**Temps**: 9.37 ms / 503.10 ms **Mémoire**: 0.335 MB / 17.72 MB Application: afterDispatch

**Temps**: 16.41 ms / 519.51 ms **Mémoire**: 0.413 MB / 18.14 MB Application: beforeRenderModule mod_menu ()

**Temps**: 5.15 ms / 524.67 ms **Mémoire**: 0.052 MB / 18.19 MB Application: afterRenderModule mod_menu ()

**Temps**: 0.04 ms / 524.70 ms **Mémoire**: -0.019 MB / 18.17 MB Application: beforeRenderModule mod_custom ()

**Temps**: 2.27 ms / 526.98 ms **Mémoire**: 0.011 MB / 18.18 MB Application: afterRenderModule mod_custom ()

**Temps**: 0.44 ms / 527.42 ms **Mémoire**: 0.317 MB / 18.50 MB Application: beforeRenderModule mod_menu ()

**Temps**: 1.00 ms / 528.42 ms **Mémoire**: 0.022 MB / 18.52 MB Application: afterRenderModule mod_menu ()

**Temps**: 451.29 ms / 979.71 ms **Mémoire**: 0.974 MB / 19.49 MB Application: Before Access::getAssetRules (id:1 name:root.1)

**Temps**: 0.05 ms / 979.76 ms **Mémoire**: 0.007 MB / 19.50 MB Application: After Access::getAssetRules (id:1 name:root.1)

**Temps**: 240.56 ms / 1220.32 ms **Mémoire**: 1.085 MB / 20.58 MB Application: afterRender

**Total de requêtes base de données : 51.97 ms**

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

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

#	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

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

#	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

**EXPLAIN impossible sur la requête : INSERT INTO `cascas_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3839303865663533646633326432663666353039393931336334353236656166', 1, 1696030847, 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**]

**Temps de requête : 1.18 ms** **Après la dernière requête : 6.90 ms** **Mémoire de requête : 0.024 MB mémoire avant requête : 5.083 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**]

**Temps de requête : 1.42 ms** **Après la dernière requête : 5.07 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 5.428 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**]

**Temps de requête : 0.94 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.440 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**]

**Temps de requête : 0.88 ms** **Après la dernière requête : 1.62 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**]

**Temps de requête : 1.45 ms** **Après la dernière requête : 34.55 ms** **Mémoire de requête : 0.005 MB mémoire avant requête : 6.802 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**]

**Temps de requête : 0.15 ms** **Après la dernière requête : 0.07 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 6.810 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**]

**Temps de requête : 1.79 ms** **Après la dernière requête : 10.13 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 7.167 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**]

**Temps de requête : 1.63 ms** **Après la dernière requête : 23.27 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 7.912 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**]

**Temps de requête : 0.33 ms** **Après la dernière requête : 78.00 ms** **Mémoire de requête : 0.028 MB mémoire avant requête : 10.208 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**]

**Temps de requête : 0.27 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.204 MB**

UPDATE `cascas_extensions`

  SET `params` = '{\"mediaversion\":\"78068e529cd2f2f13cddf70d15445972\"}'

  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**]

**Temps de requête : 1.46 ms** **Après la dernière requête : 4.61 ms** **Mémoire de requête : 0.028 MB mémoire avant requête : 10.571 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**]

**Temps de requête : 2.18 ms** **Après la dernière requête : 113.82 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 14.273 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**]

**Temps de requête : 0.33 ms** **Après la dernière requête : 0.30 ms** **Mémoire de requête : 0.025 MB mémoire avant requête : 14.324 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**]

**Temps de requête : 2.22 ms** **Après la dernière requête : 3.99 ms** **Mémoire de requête : 0.032 MB mémoire avant requête : 14.357 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**]

**Temps de requête : 0.49 ms** **Après la dernière requête : 8.73 ms** **Mémoire de requête : 0.005 MB mémoire avant requête : 14.726 MB**

UPDATE cascas_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '4'

**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**]

**Temps de requête : 4.52 ms** **Après la dernière requête : 3.49 ms** **Mémoire de requête : 0.078 MB mémoire avant requête : 14.759 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 = 4 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-29 23:40:47') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-29 23:40:47') 
  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**]

**Temps de requête : 2.58 ms** **Après la dernière requête : 5.64 ms** **Mémoire de requête : 0.022 MB mémoire avant requête : 15.179 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` = 4 
  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**]

**Temps de requête : 0.85 ms** **Après la dernière requête : 56.67 ms** **Mémoire de requête : 0.026 MB mémoire avant requête : 17.003 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**]

**Temps de requête : 3.60 ms** **Après la dernière requête : 1.65 ms** **Mémoire de requête : 0.025 MB mémoire avant requête : 17.024 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**]

**Temps de requête : 2.53 ms** **Après la dernière requête : 25.83 ms** **Mémoire de requête : 0.034 MB mémoire avant requête : 18.135 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-29 23:40:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-29 23:40:47') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 1110 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**]

**Temps de requête : 0.93 ms** **Après la dernière requête : 12.89 ms** **Mémoire de requête : 0.026 MB mémoire avant requête : 18.188 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**]

**Temps de requête : 1.43 ms** **Après la dernière requête : 9.64 ms** **Mémoire de requête : 0.020 MB mémoire avant requête : 18.574 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**]

**Temps de requête : 0.18 ms** **Après la dernière requête : 2.37 ms** **Mémoire de requête : 0.004 MB mémoire avant requête : 18.608 MB**

LOCK TABLES `cascas_extensions` WRITE

**Explication**

**EXPLAIN impossible sur la requête : LOCK TABLES `cascas_extensions` WRITE**

**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/mysqli.php:551
8	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:78
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.43 ms** **Après la dernière requête : 0.03 ms** **Mémoire de requête : 0.004 MB mémoire avant requête : 18.612 MB**

UPDATE `cascas_extensions`

  SET `params` = '{\"lastrun\":1696030847}'

  WHERE `type` = 'plugin' 
  AND `folder` = 'system' 
  AND `element` = 'updatenotification'

**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	element_clientid	402	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
8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:89
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.15 ms** **Après la dernière requête : 5.19 ms** **Mémoire de requête : 0.004 MB mémoire avant requête : 18.942 MB**

UNLOCK TABLES

**Explication**

**EXPLAIN impossible sur la requête : UNLOCK TABLES**

**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/mysqli.php:926
8	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:103
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 4.09 ms** **Après la dernière requête : 4.05 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 18.954 MB** **Rangées retournées : 1**

SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query

  FROM `cascas_update_sites` AS `a`

  INNER JOIN cascas_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

  WHERE a.enabled = 1 
  AND b.extension_id IN (700)

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	10	10.00	Using where; Using temporary
1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	8	lescorde_caspcas.a.update_site_id,const	1	100.00	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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Updater/Updater.php:248
9	Joomla\CMS\Updater\Updater->getUpdateSites()	JROOT/libraries/src/Updater/Updater.php:127
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 4.44 ms** **Après la dernière requête : 0.11 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 18.961 MB** **Rangées retournées : 5**

SELECT DISTINCT update_site_id

  FROM cascas_updates

  WHERE `update_site_id` IN (
SELECT update_site_id

  FROM cascas_update_sites

  WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1696009247')

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cascas_update_sites	NULL	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	10	40.00	Using where; Using temporary
1	SIMPLE	cascas_updates	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	81	10.00	Using where; Using join buffer (Block Nested Loop)

**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/Updater/Updater.php:426
9	Joomla\CMS\Updater\Updater->getSitesWithUpdates()	JROOT/libraries/src/Updater/Updater.php:140
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.36 ms** **Après la dernière requête : 0.10 ms** **Mémoire de requête : 0.004 MB mémoire avant requête : 18.964 MB**

DELETE 

  FROM `cascas_updates`

  WHERE `update_site_id` = '1'

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	cascas_updates	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	81	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
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/Updater.php:165
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.21 ms** **Après la dernière requête : 4.26 ms** **Mémoire de requête : 0.022 MB mémoire avant requête : 18.981 MB** **Rangées retournées : 1**

SELECT `name`

  FROM `cascas_update_sites`

  WHERE `update_site_id` = '1'

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cascas_update_sites	NULL	const	PRIMARY	PRIMARY	4	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/src/Updater/UpdateAdapter.php:195
12	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteName()	JROOT/libraries/src/Updater/UpdateAdapter.php:222
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.21 ms** **Après la dernière requête : 0.06 ms** **Mémoire de requête : 0.007 MB mémoire avant requête : 18.995 MB**

UPDATE `cascas_update_sites`

  SET `enabled` = '0'

  WHERE `update_site_id` = '1'

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	cascas_update_sites	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
12	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:245
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.33 ms** **Après la dernière requête : 402.62 ms** **Mémoire de requête : 0.006 MB mémoire avant requête : 19.013 MB**

UPDATE `cascas_update_sites`

  SET `enabled` = '1'

  WHERE `update_site_id` = '1'

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	cascas_update_sites	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
12	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:265
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.47 ms** **Après la dernière requête : 1.03 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 19.022 MB** **Rangées retournées : 15**

SHOW FULL COLUMNS 
  FROM `cascas_updates`

**Explication**

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

**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/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Update.php:32
14	Joomla\CMS\Table\Update->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:126
12	Joomla\CMS\Updater\Adapter\CollectionAdapter->_startElement()	*Même appel que celui de la ligne ci-dessous.*
11	xml_parse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:243
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.55 ms** **Après la dernière requête : 1.78 ms** **Mémoire de requête : 0.026 MB mémoire avant requête : 19.365 MB** **Rangées retournées : 18**

SHOW FULL COLUMNS 
  FROM `cascas_extensions`

**Explication**

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

**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/Extension.php:32
11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/Updater/Updater.php:330
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.22 ms** **Après la dernière requête : 0.12 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 19.393 MB** **Rangées retournées : 0**

**Requêtes dupliquées**: #40

SELECT `update_id`

  FROM `cascas_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cascas_updates	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	81	1.23	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:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Update.php:114
10	Joomla\CMS\Table\Update->find()	JROOT/libraries/src/Updater/Updater.php:338
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.21 ms** **Après la dernière requête : 0.04 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 19.398 MB** **Rangées retournées : 1**

**Requêtes dupliquées**: #41

SELECT `extension_id`

  FROM `cascas_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

**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	887	const,const,const,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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT/libraries/src/Updater/Updater.php:348
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.21 ms** **Après la dernière requête : 0.06 ms** **Mémoire de requête : 0.022 MB mémoire avant requête : 19.405 MB** **Rangées retournées : 1**

**Requêtes dupliquées**: #42

SELECT *

  FROM cascas_extensions

  WHERE `extension_id` = '700'

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cascas_extensions	NULL	const	PRIMARY	PRIMARY	4	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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Updater/Updater.php:358
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

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

**Requêtes dupliquées**: #37

SELECT `update_id`

  FROM `cascas_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cascas_updates	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	81	1.23	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:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Update.php:114
10	Joomla\CMS\Table\Update->find()	JROOT/libraries/src/Updater/Updater.php:338
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**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 : 19.417 MB** **Rangées retournées : 1**

**Requêtes dupliquées**: #38

SELECT `extension_id`

  FROM `cascas_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

**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	887	const,const,const,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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT/libraries/src/Updater/Updater.php:348
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.13 ms** **Après la dernière requête : 0.05 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 19.423 MB** **Rangées retournées : 1**

**Requêtes dupliquées**: #39

SELECT *

  FROM cascas_extensions

  WHERE `extension_id` = '700'

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cascas_extensions	NULL	const	PRIMARY	PRIMARY	4	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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Updater/Updater.php:358
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.24 ms** **Après la dernière requête : 0.08 ms** **Mémoire de requête : 0.005 MB mémoire avant requête : 19.424 MB**

INSERT INTO `cascas_updates`
(`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) 
  VALUES 
('1','700','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','','')

**Explication**

**EXPLAIN impossible sur la requête : INSERT INTO `cascas_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) VALUES ('1','700','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','','')**

**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:1421
10	JDatabaseDriver->insertObject()	JROOT/libraries/src/Table/Table.php:821
9	Joomla\CMS\Table\Table->store()	JROOT/libraries/src/Updater/Updater.php:177
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.21 ms** **Après la dernière requête : 0.05 ms** **Mémoire de requête : 0.005 MB mémoire avant requête : 19.426 MB**

UPDATE `cascas_update_sites`

  SET `last_check_timestamp` = '1696030848'

  WHERE `update_site_id` = '1'

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	cascas_update_sites	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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/Updater.php:455
9	Joomla\CMS\Updater\Updater->updateLastCheckTimestamp()	JROOT/libraries/src/Updater/Updater.php:182
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.35 ms** **Après la dernière requête : 2.57 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 19.438 MB** **Rangées retournées : 1**

SELECT u.*,`e`.`manifest_cache`

  FROM `cascas_updates` AS `u`

  LEFT JOIN `cascas_extensions` AS `e` 
  ON `e`.`extension_id` = `u`.`extension_id`

  WHERE `u`.`extension_id` != '0' 
  AND `u`.`extension_id` = '700'

  ORDER BY `u`.`name` asc 
  LIMIT 20

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	81	9.00	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	lescorde_caspcas.u.extension_id	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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_installer/models/update.php:217
9	InstallerModelUpdate->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
8	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/plugins/system/updatenotification/updatenotification.php:136
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.53 ms** **Après la dernière requête : 3.23 ms** **Mémoire de requête : 0.024 MB mémoire avant requête : 19.472 MB** **Rangées retournées : 8**

SHOW FULL COLUMNS 
  FROM `cascas_assets`

**Explication**

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

**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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
10	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Table/Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/updatenotification/updatenotification.php:297
8	PlgSystemUpdatenotification->getSuperUsers()	JROOT/plugins/system/updatenotification/updatenotification.php:186
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.19 ms** **Après la dernière requête : 0.10 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 19.488 MB** **Rangées retournées : 1**

SELECT id

  FROM cascas_assets

  WHERE parent_id = 0

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cascas_assets	NULL	ref	idx_parent_id	idx_parent_id	4	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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Table/Nested.php:1219
9	Joomla\CMS\Table\Nested->getRootId()	JROOT/plugins/system/updatenotification/updatenotification.php:297
8	PlgSystemUpdatenotification->getSuperUsers()	JROOT/plugins/system/updatenotification/updatenotification.php:186
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 2.24 ms** **Après la dernière requête : 0.12 ms** **Mémoire de requête : 0.020 MB mémoire avant requête : 19.500 MB** **Rangées retournées : 1**

SELECT `user_id`

  FROM `cascas_user_usergroup_map`

  WHERE `group_id` IN('8')

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cascas_user_usergroup_map	NULL	index	NULL	PRIMARY	8	NULL	1	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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/updatenotification/updatenotification.php:333
8	PlgSystemUpdatenotification->getSuperUsers()	JROOT/plugins/system/updatenotification/updatenotification.php:186
7	PlgSystemUpdatenotification->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**]

**Temps de requête : 0.20 ms** **Après la dernière requête : 0.10 ms** **Mémoire de requête : 0.021 MB mémoire avant requête : 19.506 MB** **Rangées retournées : 1**

SELECT `id`,`username`,`email`

  FROM `cascas_users`

  WHERE `id` IN('792') 
  AND `block` = 0 
  AND `sendEmail` = '1'

**Explication**

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cascas_users	NULL	const	PRIMARY,idx_block	PRIMARY	4	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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/updatenotification/updatenotification.php:373
8	PlgSystemUpdatenotification->getSuperUsers()	JROOT/plugins/system/updatenotification/updatenotification.php:186
7	PlgSystemUpdatenotification->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**]

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

Tables sélectionnées :

**2 × SELECT * 
  FROM cascas_extensions**

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

**2 × SELECT `extension_id` 
  FROM `cascas_extensions`**

**2 × SELECT `update_id` 
  FROM `cascas_updates`**

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

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

**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**

**1 × SELECT `user_id` 
  FROM `cascas_user_usergroup_map`**

**1 × SELECT id 
  FROM cascas_assets**

**1 × SELECT u.*,`e`.`manifest_cache` 
  FROM `cascas_updates` AS `u` 
  LEFT JOIN `cascas_extensions` AS `e` 
  ON `e`.`extension_id` = `u`.`extension_id`**

**1 × SELECT `name` 
  FROM `cascas_update_sites`**

**1 × SELECT DISTINCT update_site_id 
  FROM cascas_updates**

**1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query 
  FROM `cascas_update_sites` AS `a` 
  INNER JOIN cascas_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id**

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

**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**

**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**

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

**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)**

**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`**

**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**

**1 × SELECT * 
  FROM cascas_languages**

**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**

**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**

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

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

**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**

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

**1 × SELECT `id`,`username`,`email` 
  FROM `cascas_users`**

Autres tables :

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

**1 × DELETE  
  FROM `cascas_jhackguard_ip_filters`**

**1 × UPDATE `cascas_extensions` 
  SET `params` = '{\"mediaversion\":\"78068e529cd2f2f13cddf70d15445972\"}'**

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

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

**1 × LOCK TABLES `cascas_extensions` WRIT**

**1 × UPDATE `cascas_extensions` 
  SET `params` = '{\"lastrun\":1696030847}'**

```
**1 × UNLOCK TABLE**
```

**1 × DELETE  
  FROM `cascas_updates`**

**1 × UPDATE `cascas_update_sites` 
  SET `enabled` = '0'**

**1 × UPDATE `cascas_update_sites` 
  SET `enabled` = '1'**

**1 × SHOW FULL COLUMNS 
  FROM `cascas_updates**

**1 × SHOW FULL COLUMNS 
  FROM `cascas_extensions**

**1 × INSERT INTO `cascas_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) 
  VALUES  ('1','700','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','',''**

**1 × UPDATE `cascas_update_sites` 
  SET `last_check_timestamp` = '1696030848'**

**1 × SHOW FULL COLUMNS 
  FROM `cascas_assets**


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

COM_INSTALLER_MSG_UPDATE_UPDATE="INSTALLER MSG UPDATE UPDATE"
COM_INSTALLER_TYPE_FILE="INSTALLER TYPE FILE"
COM_INSTALLER_TYPE_NONAPPLICABLE="INSTALLER TYPE NONAPPLICABLE"
EXAMEN_AU_CAS_PAR_CAS="AU CAS PAR CAS"

Qu'est-ce-que c'est ?

Petit glossaire

Évaluation environnementale :

Autorité Environnementale :

Qui est concerné ?

Projet photovoltaïque

Grandes constructions

Parking

Déboisement

Quelle est la procédure ?

J-2

J+0

J+?

J+35

Quand faut-il déposer la demande d'examen au cas par cas ?

Vous avez besoin d'accompagnement ?

Encore des questions ?

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

49 requêtes exécutées 51.97 ms

6 doubles découverts!

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

Tables sélectionnées :

Autres tables :

Erreurs d'analyse dans les fichiers de langue

Fichiers de langue chargés

Chaînes non traduites

Qu'est-ce-que c'est ?

Petit glossaire

Évaluation environnementale :

Autorité Environnementale :

Qui est concerné ?

Projet photovoltaïque

Grandes constructions

Parking

Déboisement

Quelle est la procédure ?

J-2

J+0

J+?

J+35

Quand faut-il déposer la demande d'examen au cas par cas ?

Vous avez besoin d'accompagnement ?

Encore des questions ?

**Console de débogage Joomla!**

**Session**

**Profil d'information**

**Temps**

**Mémoire**

**Occupation de la mémoire**

**Requêtes de base de données**

**49 requêtes exécutées** 51.97 ms

**6 doubles découverts!**

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

**Tables sélectionnées :**

**Autres tables :**

**Erreurs d'analyse dans les fichiers de langue**

**Fichiers de langue chargés**

**Chaînes non traduites**

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

49 requêtes exécutées 51.97 ms

6 doubles découverts!

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

Tables sélectionnées :

Autres tables :

Erreurs d'analyse dans les fichiers de langue

Fichiers de langue chargés

Chaînes non traduites