700 recettes de gâteaux , pains et viennoiseries, toutes mises au point et expliquées

gâteaux pour Pâques

Tarte à l'orange

27-02-2015 Hits:6542 Gâteaux pour Pâques Administrator

Recette de la tarte à l’orange pour Pâques Auteur Martine Acknin Pour 6 personnes Pour la pâte à tarte: 140g de beurre mou 50g de sucre en poudre 1 c.à.c de vanille liquide 1 petit oeuf 200g...

Nids de Pâques

22-03-2013 Hits:8772 Gâteaux pour Pâques Administrator

Recette de nids en meringue Par gateaupassion.com Pour 40 nids: Pour les meringues: 75g de blancs d'œufs 120g de sucre 12 gouttes colorant rouge 4 gouttes colorant bleu poche à douille douille cannelée+douille lisse Pour le décor: 40g de chocolat noir Difficulté:...

Ile flottante au chocolat

12-03-2013 Hits:8996 Gâteaux pour Pâques Administrator

Recette de l'île flottante au chocolat Par gateaupassion.com Pour 6 personnes 4 blancs d'œufs(120g) 50g de sucre en poudre 25cl lait entier 25cl d'eau gousse de vanille Pour la crème: 230g jus d'orange pressée 115g d'eau 115g confiture d'oranges 230g chocolat de...

Gâteau de Pâques alsacien

25-03-2012 Hits:10547 Gâteaux pour Pâques Administrator

Recette du gâteau de Pâques alsacien Par gateaupassion.com Pour 4 agneaux de 11X9cm : 3 œufs moyens (165g) 100g sucre semoule 100g farine tamisée 1 citron râpé 1 c.à.s d'eau beurre pour le moule sucre glace pour décor 4 moules...

Gâteau de Pâques grec

24-03-2012 Hits:12159 Gâteaux pour Pâques Administrator

Un dessert typiquement ottoman: C'est un gâteau à la semoule arrosé de sirop au jus d'orange. Très moelleux, très parfumé, tout en étant très facile à réaliser. Pour 8 à 10...

Simnel cake

22-03-2010 Hits:17009 Gâteaux pour Pâques Administrator

C'est un gâteau riche en raisins secs, et les épices lui donnent un arôme unique. Le gâteau de Simnel est connu depuis le Moyen-Age en Angleterre. A l'origine, c’était une...

Mes Oeufs de Pâques

16-03-2008 Hits:13624 Gâteaux pour Pâques Administrator

Ce sont ici de vrais œufs qui serviront à décorer votre dessert de Pâques! Pour 4 oeufs et 4 mini verrines: 4 oeufs vides Bavarois: 3 jaunes d'oeufs 250g de lait entier 60g...

Nid de Pâques

12-03-2008 Hits:13930 Gâteaux pour Pâques Administrator

Sur la base du baba, Un adorable nid décoré de vrais œufs! Pour 8 personnes: Un savarin: 250g de farine 2 pincées de sel 10g de levure de boulanger 2 càs d'eau 3 oeufs 10g...

Pain de Pâques

29-03-2007 Hits:12409 Gâteaux pour Pâques Administrator

Voici un magnifique nid pour décorer votre table le jour de Pâques! Et en plus il se mange, car c'est du vrai pain aux céréales! Honnêtement, çà change des oeufs...

Pêches rôties à la verveine

Recette des pêches rôties à la verveine.
Par gateaupassion.com
	Pour 4 personnes 4 pêches blanches non abîmées 50cl d'eau 12 feuilles de verveine fraîche 250g de sucre 1 casserole Ø16cm 25g de beurre 50g miel de romarin ou de lavande 4à8 feuilles de verveine fraîche pour le décor
Difficulté: Facile Préparation: 20 minutes Cuisson: 20 minutes Repos: 120 minutes
Recette très facile. Etonnez vos invités par cette association subtile d'arômes. On peut le déguster frais avec une boule de glace à la vanille.
Suivant le nombre de pêches, il faut choisir la dimension de la casserole de sorte que les pêches rentrent tout juste au fond. Rincer les pêches à l'eau claire, sans les peler. Dans la casserole, verser les 50cl d'eau, amener à ébullition , éteindre le feu et faire infuser les feuilles de verveine pour 5 minutes à couvert. Ôter les feuilles, et ajouter le sucre, puis faire bouillir ce sirop 5 minutes. Ajouter les pêches, et les pocher 12 minutes à feu doux en les retournant délicatement plusieurs fois, pour qu'elles soient bien imprégnées du sirop. Laisser refroidir dans le sirop, au réfrigérateur. Il faut penser à les poser avec le côté tige en haut. Lorsque les pêches seront refroidies, vous les pèlerez facilement, sans les abimer. Réserver au réfrigérateur, en pensant à les mettre dans le bon sens. Filmer au fil alimentaire pour conserver l'arôme. Au moment de servir: Disposer les pêches égouttées sur les assiettes à dessert, ou même dans des coupes. Faire fondre 25g de beurre et 50g de miel dans une petite casserole, cuire une à deux minutes, napper les pêches, et décorer d'une feuille de verveine fraîche. Penser à donner à chaque convive une fourchette et un couteau, pour éviter que la pêche roule dans l'assiette. Bon appétit !
Les étapes (1) et (2) peuvent être faites la veille. Voir la recette des Pêches rôties au romarin, une délicieuse recette de Catou.

Foolow gateaupassion.com

Liens gourmands

recettes faciles.blogspot.com
cfaitmaison.com
ptitchef.com
750g.com
Recettes
Photos de dressage (visionsgourmandes.com)

Liens utiles

Choix de la langue

Console de débogage Joomla!

Session

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

Profil d'information

Temps

Mémoire

Temps: 18.86 ms / 18.86 ms Mémoire: 2.023 MB / 2.39 MB Application: afterLoad

Temps: 123.14 ms / 142.01 ms Mémoire: 4.503 MB / 6.89 MB Application: afterInitialise

Temps: 11.68 ms / 153.69 ms Mémoire: 0.807 MB / 7.70 MB Application: afterRoute

Temps: 8.68 ms / 162.37 ms Mémoire: 0.284 MB / 7.99 MB Application: beforeRenderComponent com_content

Temps: 5.98 ms / 168.35 ms Mémoire: 0.393 MB / 8.38 MB Application: Before Access::preloadComponents (all components)

Temps: 2.85 ms / 171.20 ms Mémoire: 0.058 MB / 8.44 MB Application: After Access::preloadComponents (all components)

Temps: 0.04 ms / 171.24 ms Mémoire: -0.005 MB / 8.43 MB Application: Before Access::preloadPermissions (com_content)

Temps: 12.28 ms / 183.52 ms Mémoire: 0.727 MB / 9.16 MB Application: After Access::preloadPermissions (com_content)

Temps: 0.07 ms / 183.59 ms Mémoire: -0.034 MB / 9.12 MB Application: Before Access::getAssetRules (id:507 name:com_content.article.473)

Temps: 0.57 ms / 184.16 ms Mémoire: 0.090 MB / 9.21 MB Application: After Access::getAssetRules (id:507 name:com_content.article.473)

Temps: 45.24 ms / 229.40 ms Mémoire: 2.330 MB / 11.54 MB Application: afterRenderComponent com_content

Temps: 0.37 ms / 229.78 ms Mémoire: 0.005 MB / 11.55 MB Application: afterDispatch

Temps: 6.85 ms / 236.63 ms Mémoire: 0.356 MB / 11.91 MB Application: beforeRenderModule mod_news_pro_gk5 (gâteaux pour Pâques)

Temps: 18.64 ms / 255.26 ms Mémoire: 0.733 MB / 12.64 MB Application: afterRenderModule mod_news_pro_gk5 (gâteaux pour Pâques)

Temps: 0.14 ms / 255.41 ms Mémoire: -0.190 MB / 12.45 MB Application: beforeRenderModule mod_custom (Follow)

Temps: 2.96 ms / 258.37 ms Mémoire: 0.023 MB / 12.47 MB Application: afterRenderModule mod_custom (Follow)

Temps: 0.11 ms / 258.48 ms Mémoire: -0.000 MB / 12.47 MB Application: beforeRenderModule mod_custom (Liens gourmands)

Temps: 0.43 ms / 258.91 ms Mémoire: 0.004 MB / 12.48 MB Application: afterRenderModule mod_custom (Liens gourmands)

Temps: 0.04 ms / 258.95 ms Mémoire: 0.000 MB / 12.48 MB Application: beforeRenderModule mod_custom (Liens utiles)

Temps: 0.35 ms / 259.30 ms Mémoire: 0.003 MB / 12.48 MB Application: afterRenderModule mod_custom (Liens utiles)

Temps: 0.04 ms / 259.34 ms Mémoire: 0.002 MB / 12.48 MB Application: beforeRenderModule mod_languages (Choix de la langue)

Temps: 4.62 ms / 263.95 ms Mémoire: 0.144 MB / 12.63 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Temps: 0.08 ms / 264.03 ms Mémoire: 0.008 MB / 12.63 MB Application: After Access::getAssetRules (id:8 name:com_content)

Temps: 3.05 ms / 267.08 ms Mémoire: 0.001 MB / 12.63 MB Application: afterRenderModule mod_languages (Choix de la langue)

Temps: 0.05 ms / 267.13 ms Mémoire: -0.003 MB / 12.63 MB Application: beforeRenderModule mod_syndicate (Flux RSS)

Temps: 0.49 ms / 267.62 ms Mémoire: 0.008 MB / 12.64 MB Application: afterRenderModule mod_syndicate (Flux RSS)

Temps: 0.12 ms / 267.74 ms Mémoire: 0.002 MB / 12.64 MB Application: beforeRenderModule mod_search (Trouver une recette :)

Temps: 1.08 ms / 268.81 ms Mémoire: 0.020 MB / 12.66 MB Application: afterRenderModule mod_search (Trouver une recette :)

Temps: 0.09 ms / 268.90 ms Mémoire: -0.002 MB / 12.66 MB Application: beforeRenderModule mod_custom (Fullscreen)

Temps: 0.34 ms / 269.24 ms Mémoire: 0.003 MB / 12.66 MB Application: afterRenderModule mod_custom (Fullscreen)

Temps: 2.98 ms / 272.22 ms Mémoire: 0.154 MB / 12.82 MB Application: beforeRenderModule mod_menu (Menu Principal)

Temps: 6.67 ms / 278.89 ms Mémoire: 0.208 MB / 13.03 MB Application: afterRenderModule mod_menu (Menu Principal)

Temps: 7.34 ms / 286.23 ms Mémoire: 0.160 MB / 13.19 MB Application: beforeRenderModule mod_phocagoogleadsense (Google AdSense Top)

Temps: 0.39 ms / 286.62 ms Mémoire: 0.011 MB / 13.20 MB Application: afterRenderModule mod_phocagoogleadsense (Google AdSense Top)

Temps: 2.33 ms / 288.95 ms Mémoire: 0.000 MB / 13.20 MB Application: beforeRenderModule mod_menu (Plan du site)

Temps: 1.42 ms / 290.37 ms Mémoire: 0.022 MB / 13.22 MB Application: afterRenderModule mod_menu (Plan du site)

Temps: 1.24 ms / 291.62 ms Mémoire: 0.001 MB / 13.22 MB Application: beforeRenderModule mod_search (Recherche smartphone)

Temps: 0.60 ms / 292.22 ms Mémoire: 0.005 MB / 13.22 MB Application: afterRenderModule mod_search (Recherche smartphone)

Temps: 0.05 ms / 292.26 ms Mémoire: -0.001 MB / 13.22 MB Application: beforeRenderModule mod_menu (Menu Smartphone)

Temps: 3.68 ms / 295.94 ms Mémoire: 0.008 MB / 13.23 MB Application: afterRenderModule mod_menu (Menu Smartphone)

Temps: 4.28 ms / 300.22 ms Mémoire: 0.050 MB / 13.28 MB Application: afterRender

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

Occupation de la mémoire

Requêtes de base de données

30 requêtes exécutées 106.65 ms

Temps de requête : 0.64 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.162 MB Rangées retournées : 0

SELECT `data`

  FROM `gpv25_session`

  WHERE `session_id` = X'3432313431383334383239323635373038346634353166303038393565393434'

Explication

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

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 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:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Temps de requête : 0.61 ms Après la dernière requête : 1.40 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.257 MB Rangées retournées : 0

SELECT `session_id`

  FROM `gpv25_session`

  WHERE `session_id` = X'3432313431383334383239323635373038346634353166303038393565393434' 
  LIMIT 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Temps de requête : 51.53 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.004 MB mémoire avant requête : 4.262 MB

INSERT INTO `gpv25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3432313431383334383239323635373038346634353166303038393565393434', 1, 1685457951, 0, '', 0)

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.18 ms
end	0.01 ms
query end	50.95 ms
closing tables	0.05 ms
freeing items	0.05 ms
cleaning up	0.05 ms

Pile d'appels

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

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

Temps de requête : 1.27 ms Après la dernière requête : 2.52 ms Mémoire de requête : 0.024 MB mémoire avant requête : 4.451 MB Rangées retournées : 40

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

  FROM `gpv25_extensions`

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

Explication

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

Profil

Status	Duration
starting	0.11 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.11 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.40 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.66 ms Après la dernière requête : 2.69 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.704 MB Rangées retournées : 4

SELECT id, rules

  FROM `gpv25_viewlevels`

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.02 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.09 ms
end	0.01 ms
query end	0.02 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT b.id

  FROM gpv25_usergroups AS a

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

  WHERE a.id = 1

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 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.11 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.02 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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.01 ms Après la dernière requête : 0.87 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.784 MB Rangées retournées : 92

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

  FROM gpv25_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gpv25_extensions	NULL	ref	extension	extension	82	const	190	0.40	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.13 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
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.79 ms
end	0.02 ms
query end	0.02 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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.07 ms Après la dernière requête : 1.29 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.898 MB Rangées retournées : 2

SELECT *

  FROM gpv25_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gpv25_languages	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2	50.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.02 ms
init	0.04 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.03 ms
Creating sort index	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.64 ms Après la dernière requête : 7.58 ms Mémoire de requête : 0.021 MB mémoire avant requête : 5.503 MB Rangées retournées : 4

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `gpv25_extensions`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gpv25_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.88 ms Après la dernière requête : 14.70 ms Mémoire de requête : 0.085 MB mémoire avant requête : 6.614 MB Rangées retournées : 40

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

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

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

  ORDER BY m.lft

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	63	10.00	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 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.07 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 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/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `gpv25_extensions`

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

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.02 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
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:1137
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.58 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.005 MB mémoire avant requête : 7.788 MB

UPDATE `gpv25_extensions`

  SET `params` = '{\"mediaversion\":\"65cff109dd335bdf2121fc254bdd797c\"}'

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	gpv25_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,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.13 ms
updating	0.14 ms
end	0.02 ms
query end	2.88 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.03 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:1137
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.10 ms Après la dernière requête : 2.24 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.980 MB Rangées retournées : 11

SELECT id, home, template, s.params

  FROM gpv25_template_styles as s

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

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	15	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	db462563782.e.element	1	78.57	Using index condition; Using where

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 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.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.55 ms Après la dernière requête : 6.46 ms Mémoire de requête : 0.027 MB mémoire avant requête : 8.382 MB Rangées retournées : 40

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

  FROM `gpv25_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_easytagcloud','com_fields','com_finder','com_installer','com_joomlaupdate','com_josetta','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gpv25_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	41	100.00	Using index condition

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.30 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.39 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	1.08 ms
end	0.01 ms
query end	0.02 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/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 10.45 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.161 MB mémoire avant requête : 8.433 MB Rangées retournées : 941

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

  FROM `gpv25_assets`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gpv25_assets	NULL	ALL	idx_asset_name,idx_parent_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1138	20.84	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.02 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	9.78 ms
end	0.03 ms
query end	0.02 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.26 ms Après la dernière requête : 3.18 ms Mémoire de requête : 0.031 MB mémoire avant requête : 9.254 MB Rangées retournées : 31

SHOW FULL COLUMNS 
  FROM `gpv25_content`

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.47 ms
init	0.03 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.18 ms
checking permissions	0.09 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.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
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.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.20 ms
closing tables	0.01 ms
freeing items	0.06 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:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.59 ms Après la dernière requête : 3.54 ms Mémoire de requête : 0.006 MB mémoire avant requête : 9.489 MB

UPDATE gpv25_content

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

  WHERE `id` = '473'

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.03 ms
updating	0.10 ms
end	0.02 ms
query end	2.71 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.92 ms Après la dernière requête : 1.84 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.610 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 gpv25_content AS a

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

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

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

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

  WHERE a.id = 473 
  AND c.published > 0 
  AND a.language in ('fr-FR','*')

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_catid,idx_language	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 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:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.02 ms Après la dernière requête : 3.01 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.826 MB Rangées retournées : 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `gpv25_categories` AS `s`

  INNER JOIN `gpv25_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('fr-FR','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.07 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 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/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.68 ms Après la dernière requête : 1.07 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.880 MB Rangées retournées : 0

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

  FROM `gpv25_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.26 ms Après la dernière requête : 7.49 ms Mémoire de requête : 0.025 MB mémoire avant requête : 10.372 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 gpv25_fields AS a

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

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

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

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

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

  LEFT JOIN `gpv25_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 (3,0,86)) 
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	db462563782.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	db462563782.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.19 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.79 ms Après la dernière requête : 5.08 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.803 MB Rangées retournées : 2

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM gpv25_content AS a

  LEFT JOIN gpv25_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 3 
  AND a.state = 1 
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-05-30 14:45:51') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-05-30 14:45:51') 
  AND a.language in ('fr-FR','*')

  ORDER BY a.title

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_catid,idx_language	idx_catid	4	const	2	16.00	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.02 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.10 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.40 ms Après la dernière requête : 15.07 ms Mémoire de requête : 0.075 MB mémoire avant requête : 11.762 MB Rangées retournées : 17

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

  FROM gpv25_modules AS m

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

  LEFT JOIN gpv25_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-05-30 14:45:51') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-30 14:45:51') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 200 OR mm.menuid <= 0) 
  AND m.language IN ('fr-FR','*')

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	27	1.60	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	db462563782.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	db462563782.m.id	2	40.00	Using where; Using index

Profil

Status	Duration
starting	0.28 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.22 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	2.08 ms
end	0.02 ms
query end	0.05 ms
closing tables	0.04 ms
freeing items	0.05 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()	Même appel que celui de la ligne ci-dessous.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_eat/layouts/theme.config.php:26
10	include JROOT/templates/yoo_eat/layouts/theme.config.php	JROOT/templates/yoo_eat/layouts/theme.php:10
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.76 ms Après la dernière requête : 5.97 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.419 MB Rangées retournées : 9

SELECT 
					c.id AS CID
				
  FROM 
					gpv25_categories AS c
				
  LEFT JOIN 
					gpv25_content AS content 
					
  ON 
					c.id = content.catid 
						
				
  WHERE 
					1=1 
					 
  AND ( c.id = 259) 
					
  AND 
					c.extension = 'com_content' 
  AND 
					c.published = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content	NULL	ref	idx_catid	idx_catid	4	const	9	100.00	Using index

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.03 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.02 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/modules/mod_news_pro_gk5/data_sources/com_content/model.php:85
16	NSP_GK5_com_content_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:100
15	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_eat/layouts/theme.config.php:73
10	include JROOT/templates/yoo_eat/layouts/theme.config.php	JROOT/templates/yoo_eat/layouts/theme.php:10
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.03 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.431 MB Rangées retournées : 9

SELECT
			content.id AS iid				
		
  FROM 
			gpv25_content AS content
			 
			 
			
		
  WHERE 
			content.state = 1
                 
  AND content.access IN (1,1)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-05-30 16:45:51' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-05-30 16:45:51' )
			 
  AND (  content.catid = 259 ) 
			 
  AND content.language in ('fr-FR','*') 
			 
			
			
			
		
		
		
  ORDER BY 
			 content.created DESC 
		
  LIMIT
			0,36;

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	9	16.00	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.28 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 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:1506
17	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:268
16	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
15	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_eat/layouts/theme.config.php:73
10	include JROOT/templates/yoo_eat/layouts/theme.config.php	JROOT/templates/yoo_eat/layouts/theme.php:10
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.85 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.091 MB mémoire avant requête : 12.449 MB Rangées retournées : 9

SELECT
			content.id AS iid,
			content.title AS title, 
			content.introtext AS text,
			content.created AS date,  
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.images AS images,
			content.featured AS frontpage,
			content.access AS access,
			content.language AS lang,
			categories.title AS catname, 
			users.email AS author_email,
			content.created_by_alias AS author_alias,
			users.name AS author_username,
			content_rating.rating_sum AS rating_sum,
			content_rating.rating_count AS rating_count,
			
  CASE WHEN CHAR_LENGTH(content.alias) 
				THEN CONCAT_WS(":", content.id, content.alias) 
					ELSE content.id END as id, 
			
  CASE WHEN CHAR_LENGTH(categories.alias) 
				THEN CONCAT_WS(":", categories.id, categories.alias) 
					ELSE categories.id END as cid			
		
  FROM 
			gpv25_content AS content 
			
  LEFT JOIN 
				gpv25_categories AS categories 
				
  ON categories.id = content.catid 
			
  LEFT JOIN 
				gpv25_users AS users 
				
  ON users.id = content.created_by 			
			
  LEFT JOIN 
				gpv25_content_rating AS content_rating 
				
  ON content_rating.content_id = content.id
			
  LEFT JOIN 
				gpv25_content_frontpage AS content_frontpage 
				
  ON content_frontpage.content_id = content.id
		
  WHERE 
			1=1
			 
  AND ( content.id = 1932 OR  content.id = 1867 OR  content.id = 1864 OR  content.id = 577 OR  content.id = 576 OR  content.id = 445 OR  content.id = 233 OR  content.id = 232 OR  content.id = 125)
		
  ORDER BY 
			 content.created DESC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	range	PRIMARY	PRIMARY	4	NULL	9	100.00	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	categories	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.content.catid	1	100.00	Using where
1	SIMPLE	users	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.content.created_by	1	100.00	Using where
1	SIMPLE	content_rating	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.content.id	1	100.00	Using where
1	SIMPLE	content_frontpage	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.content.id	1	100.00	Using where; Using index

Profil

Status	Duration
starting	0.22 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.24 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.63 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.07 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:1506
17	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:332
16	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
15	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_eat/layouts/theme.config.php:73
10	include JROOT/templates/yoo_eat/layouts/theme.config.php	JROOT/templates/yoo_eat/layouts/theme.php:10
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.79 ms Après la dernière requête : 1.28 ms Mémoire de requête : 0.033 MB mémoire avant requête : 12.590 MB Rangées retournées : 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `gpv25_categories` AS `s`

  INNER JOIN `gpv25_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('fr-FR','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
31	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
30	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
29	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
28	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
27	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
26	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
25	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
20	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
19	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
18	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
17	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:41
16	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
15	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_eat/layouts/theme.config.php:73
10	include JROOT/templates/yoo_eat/layouts/theme.config.php	JROOT/templates/yoo_eat/layouts/theme.php:10
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.79 ms Après la dernière requête : 7.27 ms Mémoire de requête : 0.029 MB mémoire avant requête : 12.478 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 gpv25_fields AS a

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

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

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

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

  LEFT JOIN gpv25_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	db462563782.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.a.group_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Même appel que celui de la ligne ci-dessous.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
14	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_eat/layouts/theme.config.php:73
10	include JROOT/templates/yoo_eat/layouts/theme.config.php	JROOT/templates/yoo_eat/layouts/theme.php:10
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.18 ms Après la dernière requête : 3.20 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.595 MB Rangées retournées : 2

SELECT `c2`.`language`,`c2`.`id`

  FROM `gpv25_menu` AS `c`

  INNER JOIN `gpv25_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `gpv25_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `gpv25_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 200

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	NULL	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
1	SIMPLE	a2	NULL	ref	idx_key	idx_key	128	const	2	100.00	Using index
1	SIMPLE	c2	NULL	eq_ref	PRIMARY	PRIMARY	4	db462563782.a2.id	1	100.00	NULL

Profil

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.86 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.48 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.01 ms
freeing items	0.03 ms
cleaning up	0.01 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/Associations.php:115
17	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
16	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
15	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
14	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_eat/layouts/theme.config.php:73
10	include JROOT/templates/yoo_eat/layouts/theme.config.php	JROOT/templates/yoo_eat/layouts/theme.php:10
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.86 ms Après la dernière requête : 0.83 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.634 MB Rangées retournées : 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `gpv25_content` AS `c`

  INNER JOIN `gpv25_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `gpv25_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `gpv25_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `gpv25_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 473 
  AND c2.access IN (1,1) 
  AND c2.language != 'fr-FR'

Explication

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

Profil

Status	Duration
starting	0.20 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.21 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.27 ms
executing	0.02 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
17	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:76
16	ContentHelperAssociation::getAssociations()	JROOT/modules/mod_languages/helper.php:68
15	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
14	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_eat/layouts/theme.config.php:73
10	include JROOT/templates/yoo_eat/layouts/theme.config.php	JROOT/templates/yoo_eat/layouts/theme.php:10
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Tables sélectionné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 `gpv25_categories` AS `s` 
  INNER JOIN `gpv25_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('fr-FR','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

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

1 × SELECT `data` 
  FROM `gpv25_session`

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `gpv25_menu` AS `c` 
  INNER JOIN `gpv25_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `gpv25_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `gpv25_menu` AS `c2` 
  ON a2.id = c2.`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 gpv25_fields AS a 
  LEFT JOIN `gpv25_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN gpv25_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN gpv25_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN gpv25_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN gpv25_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT    content.id AS iid,    content.title AS title,     content.introtext AS text,    content.created AS date,      content.publish_up AS date_publish,    content.hits AS hits,    content.images AS images,    content.featured AS frontpage,    content.access AS access,    content.language AS lang,    categories.title AS catname,     users.email AS author_email,    content.created_by_alias AS author_alias,    users.name AS author_username,    content_rating.rating_sum AS rating_sum,    content_rating.rating_count AS rating_count,    
  CASE WHEN CHAR_LENGTH(content.alias)      THEN CONCAT_WS(":", content.id, content.alias)       ELSE content.id END as id,     
  CASE WHEN CHAR_LENGTH(categories.alias)      THEN CONCAT_WS(":", categories.id, categories.alias)       ELSE categories.id END as cid      
  FROM     gpv25_content AS content     
  LEFT JOIN      gpv25_categories AS categories      
  ON categories.id = content.catid     
  LEFT JOIN      gpv25_users AS users      
  ON users.id = content.created_by        
  LEFT JOIN      gpv25_content_rating AS content_rating      
  ON content_rating.content_id = content.id    
  LEFT JOIN      gpv25_content_frontpage AS content_frontpage      
  ON content_frontpage.content_id = content.id

1 × SELECT    content.id AS iid       
  FROM     gpv25_content AS content

1 × SELECT       c.id AS CID     
  FROM       gpv25_categories AS c     
  LEFT JOIN       gpv25_content AS content       
  ON       c.id = content.catid

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

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM gpv25_content AS a 
  LEFT JOIN gpv25_categories AS cc 
  ON cc.id = a.catid

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 gpv25_fields AS a 
  LEFT JOIN `gpv25_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN gpv25_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN gpv25_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN gpv25_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN gpv25_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `gpv25_fields_categories` AS fc 
  ON fc.field_id = a.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 gpv25_content AS a 
  INNER JOIN gpv25_categories AS c 
  on c.id = a.catid 
  LEFT JOIN gpv25_users AS u 
  on u.id = a.created_by 
  LEFT JOIN gpv25_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN gpv25_content_rating AS v 
  ON a.id = v.content_id

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

1 × SELECT `session_id` 
  FROM `gpv25_session`

1 × SELECT id, home, template, s.params 
  FROM gpv25_template_styles as s 
  LEFT JOIN gpv25_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

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

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `gpv25_extensions`

```
1 × SELECT * 
  FROM gpv25_languages
```

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

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

1 × SELECT id, rules 
  FROM `gpv25_viewlevels

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `gpv25_content` AS `c` 
  INNER JOIN `gpv25_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `gpv25_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `gpv25_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `gpv25_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

Autres tables :

1 × INSERT INTO `gpv25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3432313431383334383239323635373038346634353166303038393565393434', 1, 1685457951, 0, '', 0

1 × UPDATE `gpv25_extensions` 
  SET `params` = '{\"mediaversion\":\"65cff109dd335bdf2121fc254bdd797c\"}'

1 × SHOW FULL COLUMNS 
  FROM `gpv25_content

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

gâteaux pour Pâques

Trouver une recette :

Pêches rôties à la verveine

Recette des pêches rôties à la verveine.

Pour 4 personnes

Liens gourmands

Liens utiles

Choix de la langue

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

30 requêtes exécutées 106.65 ms

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

Tables sélectionnées :

Autres tables :