Notre équipe

Conception et pilotage de projets Industriels et agricoles.

Suivi de travaux

Christophe LOGEAT

Dirigeant Fondateur Agriplan France

Équipements, systèmes de traite et transformation, structures et chantiers :

Manuel DAVID-MELEUX

Ingénieur des Travaux Agricoles (productions animales)
ENITA (Ecole Nationale des Ingénieurs en Travaux Agricoles) - Bordeaux.

Jean-Luc TANGUY

Ingénieur Développement agricole et agro-alimentaire
UPJV- Amiens

Environnement, gestion des espaces, Etudes d’Impacts :

Mickaël PAPIN

Ingénieur en agriculture
Diplômée ESITPA - Rouen

Bureau d’étude dessin

Philippe BONHOMME

BTS conception de produits industriels
AFPI Auxerre

Kévin Pinault

Techniciens du bâtiment, Dessinateurs DAO

Contact & Infos

AGRIPLAN France

6 allée du Blosne
ZA La Hallerais
35770 Vern Sur Seiche
Tél. +33 223-302-121
Fax. +33 223-302-120
contact2018@agriplan-france.com

Acces Partenaires

Sitemap

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1657028812,
                "last": 1657028812,
                "now": 1657028812
            },
            "client": {
                "forwarded": "3.236.221.156"
            },
            "token": "J723LB3TXjy5w6tEV7HFqmOSlKVqqCbb"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "gantry-current-template": "rt_clarion",
        "clarion-52012bdbda0cb5050172c5205a79f630-name": null,
        "clarion-52012bdbda0cb5050172c5205a79f630-main-body": null,
        "clarion-52012bdbda0cb5050172c5205a79f630-main-accent": null,
        "clarion-52012bdbda0cb5050172c5205a79f630-bgstyle": null,
        "clarion-52012bdbda0cb5050172c5205a79f630-font-family": null,
        "clarion-52012bdbda0cb5050172c5205a79f630-font-size-is": null,
        "clarion-52012bdbda0cb5050172c5205a79f630-menu-type": null,
        "clarion-52012bdbda0cb5050172c5205a79f630-typography-style": null,
        "wb_sh404sef_404_redirect_message": null
    }
}

Profil d'information

Temps

Mémoire

Temps: 47.58 ms / 47.58 ms Mémoire: 0.486 MB / 0.62 MB Application: afterLoad

Temps: 353.43 ms / 401.01 ms Mémoire: 2.435 MB / 3.05 MB Application: afterInitialise

Temps: 46.99 ms / 448.00 ms Mémoire: 0.406 MB / 3.46 MB Application: afterRoute

Temps: 7.38 ms / 455.38 ms Mémoire: 0.113 MB / 3.57 MB Application: beforeRenderComponent com_content

Temps: 6.07 ms / 461.44 ms Mémoire: 0.080 MB / 3.65 MB Application: Before Access::preloadComponents (all components)

Temps: 3.55 ms / 464.99 ms Mémoire: 0.056 MB / 3.71 MB Application: After Access::preloadComponents (all components)

Temps: 0.04 ms / 465.03 ms Mémoire: 0.000 MB / 3.71 MB Application: Before Access::preloadPermissions (com_content)

Temps: 2.08 ms / 467.11 ms Mémoire: 0.067 MB / 3.77 MB Application: After Access::preloadPermissions (com_content)

Temps: 0.05 ms / 467.15 ms Mémoire: 0.000 MB / 3.77 MB Application: Before Access::getAssetRules (id:101 name:com_content.article.33)

Temps: 1.14 ms / 468.29 ms Mémoire: 0.011 MB / 3.78 MB Application: After Access::getAssetRules (id:101 name:com_content.article.33)

Temps: 126.46 ms / 594.75 ms Mémoire: 1.527 MB / 5.31 MB Application: afterRenderComponent com_content

Temps: 100.96 ms / 695.71 ms Mémoire: 0.287 MB / 5.60 MB Application: afterDispatch

Temps: 39.84 ms / 735.55 ms Mémoire: 0.104 MB / 5.70 MB Application: beforeRenderModule mod_roknavmenu ()

Temps: 24.56 ms / 760.10 ms Mémoire: 0.246 MB / 5.95 MB Application: afterRenderModule mod_roknavmenu ()

Temps: 9.63 ms / 769.74 ms Mémoire: 0.004 MB / 5.95 MB Application: beforeRenderModule mod_menu (Bottom Menu)

Temps: 3.87 ms / 773.61 ms Mémoire: 0.018 MB / 5.97 MB Application: afterRenderModule mod_menu (Bottom Menu)

Temps: 0.09 ms / 773.69 ms Mémoire: 0.000 MB / 5.97 MB Application: beforeRenderModule mod_login (Acces Partenaires)

Temps: 6.65 ms / 780.34 ms Mémoire: 0.049 MB / 6.01 MB Application: afterRenderModule mod_login (Acces Partenaires)

Temps: 0.10 ms / 780.44 ms Mémoire: 0.000 MB / 6.00 MB Application: beforeRenderModule mod_custom (Contact & Infos)

Temps: 5.49 ms / 785.93 ms Mémoire: 0.024 MB / 6.02 MB Application: afterRenderModule mod_custom (Contact & Infos)

Temps: 0.08 ms / 786.02 ms Mémoire: 0.000 MB / 6.02 MB Application: beforeRenderModule mod_custom (Besoin d'informations ?)

Temps: 0.45 ms / 786.46 ms Mémoire: 0.004 MB / 6.02 MB Application: afterRenderModule mod_custom (Besoin d'informations ?)

Temps: 0.08 ms / 786.54 ms Mémoire: 0.000 MB / 6.02 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 5.33 ms / 791.88 ms Mémoire: 0.013 MB / 6.03 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 0.09 ms / 791.96 ms Mémoire: 0.000 MB / 6.03 MB Application: beforeRenderModule mod_menu (Top Menu)

Temps: 2.94 ms / 794.90 ms Mémoire: 0.033 MB / 6.06 MB Application: afterRenderModule mod_menu (Top Menu)

Temps: 0.08 ms / 794.99 ms Mémoire: 0.000 MB / 6.06 MB Application: beforeRenderModule mod_custom (ACCUEIL - TopText)

Temps: 0.44 ms / 795.43 ms Mémoire: 0.004 MB / 6.06 MB Application: afterRenderModule mod_custom (ACCUEIL - TopText)

Temps: 25.51 ms / 820.94 ms Mémoire: 0.160 MB / 6.22 MB Application: afterRender

Total de requêtes base de données : 86.48 ms

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

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_session	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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
update	0.23 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	2.02 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Temps de requête : 2.20 ms Après la dernière requête : 3.40 ms Mémoire de requête : 0.026 MB mémoire avant requête : 1.039 MB Rangées retournées : 42

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `agrpl_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_extensions	ref	extension	extension	82	const	52	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.38 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.09 ms
executing	0.01 ms
Sending data	0.60 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.46 ms Après la dernière requête : 2.83 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.115 MB Rangées retournées : 5

SELECT id, rules

  FROM `agrpl_viewlevels`

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.56 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.13 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.23 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.129 MB Rangées retournées : 1

SELECT b.id

  FROM agrpl_usergroups AS a

  LEFT JOIN agrpl_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.36 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

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

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

Temps de requête : 2.40 ms Après la dernière requête : 0.79 ms Mémoire de requête : 0.011 MB mémoire avant requête : 1.157 MB Rangées retournées : 103

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM agrpl_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_extensions	ref	extension	extension	82	const	143	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.34 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.43 ms Après la dernière requête : 24.54 ms Mémoire de requête : 0.011 MB mémoire avant requête : 1.616 MB Rangées retournées : 1

Requêtes dupliquées: #9

SELECT template

  FROM agrpl_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	12	75.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.49 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.11 ms
cleaning up	0.02 ms

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/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.72 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.012 MB mémoire avant requête : 1.626 MB Rangées retournées : 1

Requêtes dupliquées: #8

SELECT template

  FROM agrpl_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	12	75.00	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.22 ms Après la dernière requête : 6.28 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.743 MB Rangées retournées : 4

SELECT extension, file, type

  FROM agrpl_rokcommon_configs

  ORDER BY priority

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.32 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.20 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.59 ms Après la dernière requête : 32.75 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.024 MB Rangées retournées : 37

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 agrpl_menu AS m

  LEFT JOIN agrpl_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	123	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	agriplanprod.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.21 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.52 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	1.81 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/shlib/shlib_runtime.php:70
9	plgSystemShlib->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.00 ms Après la dernière requête : 12.46 ms Mémoire de requête : 0.011 MB mémoire avant requête : 2.381 MB Rangées retournées : 22

SELECT *

  FROM agrpl_rsform_config

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.26 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
12	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
11	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
10	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
9	plgSystemRsformdeletesubmissions->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.74 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.008 MB mémoire avant requête : 2.394 MB

UPDATE agrpl_rsform_config

  SET `SettingValue`='1657028813'

  WHERE `SettingName`='deleteafter.last_run'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_rsform_config	range	PRIMARY	PRIMARY	194	const	1	100.00	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.05 ms
updating	0.11 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_rsform/helpers/config.php:88
10	RSFormProConfig->set()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:37
9	plgSystemRsformdeletesubmissions->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.88 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.403 MB Rangées retournées : 0

SELECT `FormId`,`DeleteSubmissionsAfter`

  FROM `agrpl_rsform_forms`

  WHERE `DeleteSubmissionsAfter` > '0'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:47
9	plgSystemRsformdeletesubmissions->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.93 ms Après la dernière requête : 5.52 ms Mémoire de requête : 0.014 MB mémoire avant requête : 2.460 MB Rangées retournées : 18

SHOW FULL COLUMNS 
  FROM `agrpl_extensions`

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.34 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.03 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.12 ms
closing tables	0.02 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
9	plgSystemRokSprocket->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.10 ms Après la dernière requête : 1.66 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.501 MB Rangées retournées : 1

SELECT `extension_id`

  FROM `agrpl_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.24 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.11 ms
cleaning up	0.03 ms

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/plugins/system/roksprocket/roksprocket.php:49
9	plgSystemRokSprocket->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.80 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.012 MB mémoire avant requête : 2.511 MB Rangées retournées : 1

Requêtes dupliquées: #19

SELECT *

  FROM agrpl_extensions

  WHERE `extension_id` = '10069'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_extensions	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
9	plgSystemRokSprocket->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.91 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.520 MB Rangées retournées : 1

SELECT `extension_id`

  FROM `agrpl_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.07 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.03 ms

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/plugins/system/roksprocket/roksprocket.php:72
9	plgSystemRokSprocket->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.00 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.012 MB mémoire avant requête : 2.529 MB Rangées retournées : 1

Requêtes dupliquées: #17

SELECT *

  FROM agrpl_extensions

  WHERE `extension_id` = '10069'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_extensions	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.13 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
9	plgSystemRokSprocket->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.43 ms Après la dernière requête : 174.30 ms Mémoire de requête : 0.014 MB mémoire avant requête : 2.723 MB Rangées retournées : 2

SELECT *

  FROM agrpl_languages

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.40 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.09 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:215
13	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:167
12	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84
11	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100
10	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:63
9	plgSystemSh404sef->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.40 ms Après la dernière requête : 6.26 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.880 MB Rangées retournées : 1

SELECT `params` 
  FROM agrpl_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
15	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
14	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
13	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:160
12	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:659
11	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121
10	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:86
9	plgSystemSh404sef->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.61 ms Après la dernière requête : 50.76 ms Mémoire de requête : 0.015 MB mémoire avant requête : 3.210 MB Rangées retournées : 0

SELECT * 
  FROM `agrpl_sh404sef_aliases` 
  WHERE `state` = 1 
  and (`alias` = 'Menu-TOP/agriplan-equipe.html') 
  order by `ordering` asc

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_sh404sef_aliases	ref	state,alias	state	1	const	1	100.00	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.47 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.19 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
16	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/models/redirector.php:221
15	Sh404sefModelRedirector->findHardcodedMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:115
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:86
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:206
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:664
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:263
10	Sh404sefClassRouterInternal->preprocessParseRule()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.86 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.016 MB mémoire avant requête : 3.223 MB Rangées retournées : 0

SELECT * 
  FROM agrpl_sh404sef_aliases 
  WHERE state = 1 
  and (type = 1 or type = 2);

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_sh404sef_aliases	ref	type,state	state	1	const	1	100.00	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/redirector.php:287
15	Sh404sefModelRedirector->findWildcardMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:116
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:86
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:206
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:664
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:263
10	Sh404sefClassRouterInternal->preprocessParseRule()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.01 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.013 MB mémoire avant requête : 3.237 MB Rangées retournées : 0

SELECT * 
  FROM agrpl_sh404sef_pageids 
  WHERE `pageid`='Menu-TOP/agriplan-equipe.html';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_sh404sef_pageids	ref	alias	alias	572	const	1	100.00	Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.31 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:2023
11	Sh404sefClassRouterInternal->_checkShurls()	JROOT/administrator/components/com_sh404sef/classes/router.php:264
10	Sh404sefClassRouterInternal->preprocessParseRule()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.84 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.016 MB mémoire avant requête : 3.254 MB Rangées retournées : 1

SELECT *

  FROM agrpl_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
17	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_sh404sef/classes/router.php:1728
16	Sh404sefClassRouterInternal->_getSimpleSefLanguageSefCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:1697
15	Sh404sefClassRouterInternal->_isSimpleEncodingSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1643
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1317
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2301
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:418
11	Sh404sefClassRouterInternal->parseRule()	Même appel que celui de la ligne ci-dessous.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.47 ms Après la dernière requête : 3.41 ms Mémoire de requête : 0.016 MB mémoire avant requête : 3.309 MB Rangées retournées : 2

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM agrpl_sh404sef_urls 
  WHERE `oldurl`='Menu-TOP/agriplan-equipe.html' 
  ORDER BY `rank`;

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_sh404sef_urls	ref	oldurl	oldurl	573	const	2	100.00	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.42 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.22 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
15	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1657
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1317
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2301
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:418
11	Sh404sefClassRouterInternal->parseRule()	Même appel que celui de la ligne ci-dessous.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.58 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.013 MB mémoire avant requête : 3.324 MB

UPDATE `agrpl_sh404sef_urls` 
  SET `cpt`=4903, `last_hit`='2022-07-05 13:46:53' 
  WHERE `id`='6431' 
  AND `rank`=0;

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_sh404sef_urls	range	PRIMARY,rank	PRIMARY	4	const	1	100.00	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.10 ms
updating	0.13 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	1.75 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	Même appel que celui de la ligne ci-dessous.
19	call_user_func_array()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
18	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:478
17	ShlDbClass->execute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:478
16	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:467
15	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
14	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1337
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2301
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:418
11	Sh404sefClassRouterInternal->parseRule()	Même appel que celui de la ligne ci-dessous.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.45 ms Après la dernière requête : 4.26 ms Mémoire de requête : 0.013 MB mémoire avant requête : 3.417 MB Rangées retournées : 8

SELECT * 
  FROM agrpl_rokcandy 
  WHERE published=1

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.46 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.10 ms
end	0.06 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
14	RokCandyHelper::getUserMacros()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
10	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
9	plgSystemRokCandy->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.33 ms Après la dernière requête : 0.34 ms Mémoire de requête : 0.014 MB mémoire avant requête : 3.432 MB Rangées retournées : 9

Requêtes dupliquées: #42

SELECT id, home, template, s.params

  FROM agrpl_template_styles as s

  LEFT JOIN agrpl_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	12	75.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	agriplanprod.s.template,const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.35 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
16	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:53
15	RokCandyHelper::readIniFile()	Même appel que celui de la ligne ci-dessous.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:44
11	RokCandyHelper::getTemplateOverrides()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:18
10	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
9	plgSystemRokCandy->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.00 ms Après la dernière requête : 2.59 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.481 MB Rangées retournées : 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `agrpl_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.31 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.475 MB

UPDATE `agrpl_extensions`

  SET `params` = '{\"mediaversion\":\"09a7ca3625764e7b4699088c0f816f52\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.12 ms
updating	0.10 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	1.46 ms
closing tables	0.04 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.12 ms Après la dernière requête : 9.34 ms Mémoire de requête : 0.015 MB mémoire avant requête : 3.656 MB Rangées retournées : 42

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `agrpl_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','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_gantry','com_installer','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_rokcandy','com_rokgallery','com_roksprocket','com_rsform','com_search','com_sh404sef','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_assets	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	272	15.81	Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.40 ms
init	0.19 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.32 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	1.27 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.63 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.016 MB mémoire avant requête : 3.706 MB Rangées retournées : 64

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `agrpl_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_assets	ALL	idx_asset_name,idx_parent_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	272	100.00	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.64 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.50 ms Après la dernière requête : 3.11 ms Mémoire de requête : 0.015 MB mémoire avant requête : 3.796 MB Rangées retournées : 31

SHOW FULL COLUMNS 
  FROM `agrpl_content`

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.41 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.41 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.15 ms
end	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.56 ms Après la dernière requête : 5.93 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.872 MB

UPDATE agrpl_content

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

  WHERE `id` = '33'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.08 ms
updating	0.13 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	1.68 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.66 ms Après la dernière requête : 3.07 ms Mémoire de requête : 0.017 MB mémoire avant requête : 3.911 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 agrpl_content AS a

  INNER JOIN agrpl_categories AS c 
  on c.id = a.catid

  LEFT JOIN agrpl_users AS u 
  on u.id = a.created_by

  LEFT JOIN agrpl_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN agrpl_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 33 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-07-05 13:46:53') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-07-05 13:46:53') 
  AND (a.state = 1 OR a.state =2)

Explication

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

Profil

Status	Duration
starting	0.28 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.01 ms
init	0.15 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.22 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.20 ms
cleaning up	0.05 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.24 ms Après la dernière requête : 40.50 ms Mémoire de requête : 0.015 MB mémoire avant requête : 4.001 MB Rangées retournées : 0

SELECT `m`.`tag_id`,`t`.*

  FROM `agrpl_contentitem_tag_map` AS m 

  INNER JOIN `agrpl_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 33 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

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

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.94 ms
init	0.13 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.16 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.78 ms Après la dernière requête : 9.20 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.152 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 `agrpl_categories` AS `s`

  INNER JOIN `agrpl_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 21

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.33 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.25 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.04 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.21 ms Après la dernière requête : 0.75 ms Mémoire de requête : 0.019 MB mémoire avant requête : 4.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 agrpl_fields AS a

  LEFT JOIN `agrpl_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN agrpl_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN agrpl_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN agrpl_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN agrpl_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `agrpl_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 (21,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	agriplanprod.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	agriplanprod.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	agriplanprod.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	agriplanprod.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	agriplanprod.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	agriplanprod.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.27 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.97 ms
init	0.13 ms
System lock	0.02 ms
optimizing	0.06 ms
statistics	0.26 ms
preparing	0.08 ms
Creating tmp table	0.11 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.49 ms
Creating sort index	0.06 ms
end	0.01 ms
removing tmp table	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.07 ms
freeing items	0.13 ms
cleaning up	0.04 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.90 ms Après la dernière requête : 3.96 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.306 MB Rangées retournées : 36

SHOW FULL COLUMNS 
  FROM `agrpl_sh404sef_metas`

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.38 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.41 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
Sending data	0.24 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.13 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:127
19	Sh404sefTableMetas->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:33
17	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
16	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:448
15	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:280
14	plgSystemSh404sef->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.99 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.363 MB Rangées retournées : 0

SELECT * 
  FROM agrpl_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_content&Itemid=219&id=33&lang=fr&view=article';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_sh404sef_metas	ref	newurl	newurl	573	const	1	100.00	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
20	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
19	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
18	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:34
17	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
16	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:448
15	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:280
14	plgSystemSh404sef->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.56 ms Après la dernière requête : 25.99 ms Mémoire de requête : 0.018 MB mémoire avant requête : 5.256 MB Rangées retournées : 9

Requêtes dupliquées: #29

SELECT id, home, template, s.params

  FROM agrpl_template_styles as s

  LEFT JOIN agrpl_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	12	75.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	agriplanprod.s.template,const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.16 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.37 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
21	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
20	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_clarion/html/com_content/article/default.php:14
13	include JROOT/templates/rt_clarion/html/com_content/article/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.00 ms Après la dernière requête : 17.36 ms Mémoire de requête : 0.011 MB mémoire avant requête : 5.324 MB Rangées retournées : 1

SELECT `pageid` 
  FROM agrpl_sh404sef_pageids 
  WHERE `newurl`='index.php?option=com_content&Itemid=219&id=33&lang=fr&view=article';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_sh404sef_pageids	ref	newurl	newurl	573	const	1	100.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.13 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
12	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
11	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
10	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/shurl.php:57
9	Sh404sefHelperShurl::updateShurls()	JROOT/plugins/system/sh404sef/sh404sef.php:217
8	plgSystemSh404sef->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.00 ms Après la dernière requête : 2.21 ms Mémoire de requête : 0.013 MB mémoire avant requête : 5.346 MB Rangées retournées : 1

SELECT `params` 
  FROM agrpl_extensions 
  WHERE `type`='plugin' 
  AND `folder`='system' 
  AND `element`='sef';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
15	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
14	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
13	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:182
12	Sh404sefHelperGeneral::getExtensionParams()	JROOT/administrator/components/com_sh404sef/helpers/url.php:541
11	Sh404sefHelperUrl::canonicalRoutedToAbs()	JROOT/components/com_sh404sef/meta_ext/com_content.php:125
10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:509
9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
8	plgSystemSh404sef->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.82 ms Après la dernière requête : 2.72 ms Mémoire de requête : 0.013 MB mémoire avant requête : 5.368 MB Rangées retournées : 1

SELECT `id`, `title`, `alias`, `catid`, `language` 
  FROM agrpl_content 
  WHERE `id`=33;

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_content	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
15	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
14	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
13	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/slugs.php:55
12	Sh404sefModelSlugs->getArticle()	JROOT/components/com_sh404sef/sef_ext.php:693
11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:145
10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:509
9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
8	plgSystemSh404sef->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.15 ms Après la dernière requête : 1.19 ms Mémoire de requête : 0.017 MB mémoire avant requête : 5.382 MB Rangées retournées : 1

SELECT * 
  FROM agrpl_categories 
  WHERE parent_id > 0 
  and extension = 'com_content' 
  and path = 'uncategorised' 
  and level = 1;

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_categories	ref	cat_idx,idx_path	idx_path	402	const	7	100.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
15	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
14	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
13	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:40
12	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/components/com_sh404sef/sef_ext.php:707
11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:145
10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:509
9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
8	plgSystemSh404sef->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.44 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.018 MB mémoire avant requête : 5.402 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 `agrpl_categories` AS `s`

  INNER JOIN `agrpl_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 s.id = 21

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
15	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_sh404sef/models/slugs.php:161
14	Sh404sefModelSlugs->getCategory()	JROOT/administrator/components/com_sh404sef/models/slugs.php:199
13	Sh404sefModelSlugs->getCategoryPathArray()	JROOT/administrator/components/com_sh404sef/models/slugs.php:290
12	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:714
11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:145
10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:509
9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
8	plgSystemSh404sef->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 4.46 ms Après la dernière requête : 116.84 ms Mémoire de requête : 0.014 MB mémoire avant requête : 5.670 MB Rangées retournées : 8

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM agrpl_modules AS m

  LEFT JOIN agrpl_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN agrpl_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 <= '2022-07-05 13:46:53') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-07-05 13:46:53') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 219 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

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

Profil

Status	Duration
starting	0.22 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.74 ms
init	0.13 ms
System lock	0.02 ms
optimizing	0.08 ms
statistics	0.20 ms
preparing	0.08 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	2.29 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.13 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
8	Gantry->countModules()	JROOT/templates/rt_clarion/index.php:58
7	require JROOT/templates/rt_clarion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.98 ms Après la dernière requête : 19.77 ms Mémoire de requête : 0.014 MB mémoire avant requête : 5.858 MB Rangées retournées : 0

SELECT ts.template

  FROM agrpl_template_styles AS ts

  INNER JOIN agrpl_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 219 
  AND m.template_style_id != 0

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.10 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_clarion/features/fusionmenu.php:64
10	GantryFeatureFusionMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_clarion/index.php:88
7	require JROOT/templates/rt_clarion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.79 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.014 MB mémoire avant requête : 5.871 MB Rangées retournées : 1

SELECT template

  FROM agrpl_template_styles

  WHERE home = 1 
  AND client_id = 0

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_template_styles	ALL	idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	12	75.00	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:116
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_clarion/features/fusionmenu.php:64
10	GantryFeatureFusionMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_clarion/index.php:88
7	require JROOT/templates/rt_clarion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.44 ms Après la dernière requête : 30.18 ms Mémoire de requête : 0.022 MB mémoire avant requête : 6.023 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 agrpl_fields AS a

  LEFT JOIN `agrpl_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN agrpl_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN agrpl_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN agrpl_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN agrpl_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	agriplanprod.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	agriplanprod.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	agriplanprod.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	agriplanprod.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	agriplanprod.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.27 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.14 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.30 ms
preparing	0.09 ms
Creating tmp table	0.18 ms
Sorting result	0.03 ms
executing	0.01 ms
Sending data	0.53 ms
Creating sort index	0.06 ms
end	0.01 ms
removing tmp table	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.05 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	Même appel que celui de la ligne ci-dessous.
17	call_user_func_array()	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/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.80 ms Après la dernière requête : 13.17 ms Mémoire de requête : 0.018 MB mémoire avant requête : 6.097 MB Rangées retournées : 6

SHOW FULL COLUMNS 
  FROM `agrpl_template_styles`

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.34 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.04 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.12 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
17	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
16	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
15	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
13	plgSystemGantry->onBeforeCompileHead()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.72 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.014 MB mémoire avant requête : 6.121 MB Rangées retournées : 1

SELECT *

  FROM agrpl_template_styles

  WHERE `id` = '7'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agrpl_template_styles	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.17 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
15	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
13	plgSystemGantry->onBeforeCompileHead()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Tables sélectionnées :

2 × SELECT `params` 
  FROM agrpl_extensions

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `agrpl_assets`

2 × SELECT `extension_id` 
  FROM `agrpl_extensions`

```
2 × SELECT * 
  FROM agrpl_extensions
```
```
2 × SELECT * 
  FROM agrpl_languages
```

2 × SELECT template 
  FROM agrpl_template_styles as s

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

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

2 × SELECT id, home, template, s.params 
  FROM agrpl_template_styles as s 
  LEFT JOIN agrpl_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_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 agrpl_content AS a 
  INNER JOIN agrpl_categories AS c 
  on c.id = a.catid 
  LEFT JOIN agrpl_users AS u 
  on u.id = a.created_by 
  LEFT JOIN agrpl_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN agrpl_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `agrpl_contentitem_tag_map` AS m  
  INNER JOIN `agrpl_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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 agrpl_fields AS a 
  LEFT JOIN `agrpl_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN agrpl_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN agrpl_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN agrpl_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN agrpl_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `agrpl_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT * 
  FROM agrpl_sh404sef_metas

1 × SELECT `pageid` 
  FROM agrpl_sh404sef_pageids

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 agrpl_fields AS a 
  LEFT JOIN `agrpl_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN agrpl_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN agrpl_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN agrpl_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN agrpl_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT * 
  FROM agrpl_template_styles

1 × SELECT template 
  FROM agrpl_template_styles

1 × SELECT ts.template 
  FROM agrpl_template_styles AS ts 
  INNER JOIN agrpl_menu AS m 
  ON ts.id=m.template_style_id

```
1 × SELECT * 
  FROM agrpl_categories
```

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM agrpl_modules AS m 
  LEFT JOIN agrpl_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN agrpl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `id`, `title`, `alias`, `catid`, `language` 
  FROM agrpl_content

1 × SELECT * 
  FROM agrpl_sh404sef_pageids

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

1 × SELECT extension, file, type 
  FROM agrpl_rokcommon_configs

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

1 × SELECT id, rules 
  FROM `agrpl_viewlevels

1 × SELECT `session_id` 
  FROM `agrpl_session`

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 agrpl_menu AS m 
  LEFT JOIN agrpl_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT * 
  FROM agrpl_rsform_confi

1 × SELECT `data` 
  FROM `agrpl_session`

1 × SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM agrpl_sh404sef_urls

1 × SELECT * 
  FROM agrpl_sh404sef_aliases

1 × SELECT * 
  FROM `agrpl_sh404sef_aliases`

1 × SELECT `FormId`,`DeleteSubmissionsAfter` 
  FROM `agrpl_rsform_forms`

```
1 × SELECT * 
  FROM agrpl_rokcandy
```

Autres tables :

1 × UPDATE agrpl_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `agrpl_sh404sef_metas

1 × SHOW FULL COLUMNS 
  FROM `agrpl_template_styles

1 × SHOW FULL COLUMNS 
  FROM `agrpl_content

1 × UPDATE `agrpl_extensions` 
  SET `params` = '{\"mediaversion\":\"09a7ca3625764e7b4699088c0f816f52\"}'

1 × UPDATE agrpl_rsform_config 
  SET `SettingValue`='1657028813'

1 × SHOW FULL COLUMNS 
  FROM `agrpl_extensions

1 × UPDATE `agrpl_sh404sef_urls` 
  SET `cpt`=4903, `last_hit`='2022-07-05 13:46:53'

1 × INSERT INTO `agrpl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6439636633363837363431303839633632323262653136393032373563303939', 1, 1657028812, 0, '', 0

Notre équipe

Besoin d'informations ?

Contact & Infos

Acces Partenaires

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

53 requêtes exécutées 86.48 ms

6 doubles découverts!

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

Tables sélectionnées :

Autres tables :