This is the slogan for my company

Le panier est vide

Le Beaujolais nouveau en trois mots : région, tradition et primeur

La fin des vendanges annonce assez vite l'arrivée prochaine du Beaujolais nouveau. Vous êtes nombreux à fêter cette tradition et nombreux également à vouloir en savoir davantage sur le Beaujolais.

Nous allons vous en dire en plus en trois mots !

Le Beaujolais une région viticole

Le Beaujolais est une région géographique et viticole située dans les départements du Rhône (69) et de la Saône et Loire (71). Elle s'étend plus précisément sur 17.000 hectares au nord de Lyon, jusqu'à la bordure de la région voisine, la Bourgogne.

Le Beaujolais tiendrait son nom de sa capitale historique Beaujeu. Il le tiendrait également de Beaujou (de la forme dialectale jou « mont, colline »), ce qui n'est pas étonnant à la vue de cette région vallonnée composés de nombreuses collines et coteaux.

L'étendue de cette région viticole permet une richesse de terroirs composé de dix crus aux saveurs et arômes divers. Ces dix crus sont : Brouilly, Côte de Brouilly, Régnié, Fleurie, Morgon, Chiroubles, Chénas, Juliénas, Moulin à Vent, Saint Amour.
Vous l'aurez compris, dans le Beaujolais on ne fait pas que du Beaujolais nouveau ! !

Le Beaujolais nouveau, une tradition

Tous les ans le Beaujolais nouveau s'invite autant chez les cavistes, au comptoir d'un bistrot que chez vous à l'occasion d'un apéro entre amis. Mais pas n'importe quel apéro ! Il s'agit bien là d'une tradition !

Fêté dans le monde entier, il se fête le 3ème jeudi du mois de novembre. Pour la petite histoire, en 1951, un décret empêche la commercialisation des vins n'ayant pas assez macérés. En effet suite aux vendanges cela reportait leur vente au 15 décembre de la même année. Face à la révolte des syndicats viticoles, une appellation "Beaujolais nouveau " est créée. Elle permet alors sous cette condition de vendre ce vin primeur dès le mois de novembre. Alors pourquoi un jeudi, et le troisième du mois... Tout simplement par simplicité de calendrier !

Le Beaujolais nouveau, un vin primeur

Le Beaujolais nouveau est un vin primeur qui est produit dans l'année de sa récolte et se boit généralement assez rapidement. Il ne s'agit pas d'un vin de garde, contrairement à d'autres vins de Beaujolais. On l'appelle aussi vin de fête, léger et aromatisé. Il convient très bien pour un apéro sur le pouce.

Cette année le Beaujolais nouveau du domaine Guillot Gonin sera authentique, traditionnel (de source sûre des vignerons qui le produisent) et édulcoré tels ces petits bonbons acidulé dont nous tairons le nom !

Le mieux étant encore de le déguster pour vous en faire votre idée.
Alors pour ce 3ème jeudi du mois de novembre, nous vous donnons rendez- vous à la Cave de Morgon à Clichy.

Catégories

Trouver un article

Derniers Articles

Du Producteur au Consommateur

Domaine et Cave à Morgon

Du mardi au samedi :

10h-13h / 14h30-18h30

12 Boulevard du Parc,
69910 Villié-Morgon

TEL : 06.07.69.21.26 / 04.74.07.04.73

@ nous contacter

Cave et Boutique à Clichy

Du jeudi au samedi de :

10h00 - 13h00 16h00 - 19h30

Dimanches & jours fériés :

10h30 - 13h00

8, Allée Gambetta
92110 Clichy

TEL : 06.86.43.28.01 / 01.47.39.42.14

@ nous contacter

Antenne Bretonne

Benoit vous livre dans toute la Bretagne

TEL : 06.62.45.37.18

@ nous contacter

Infos Pratiques

Conditions de livraison

Nous contacter

Nous trouver

Nos actualités

Nous suivre sur :

Retrouvez nos caves

Domaine et Cave

12 Boulevard du Parc, 69910 Villié-Morgon

Cave et Boutique

8, Allée Gambetta, 92110 Clichy

Nos actualités

Du Producteur au Consommateur

Infos Pratiques

Conditions de livraison

Nous contacter

Nous trouver

CGV

Politiques de confidentialité

Mentions Légales

L'ABUS D'ALCOOL EST DANGEREUX POUR LA SANTÉ , À CONSOMMER AVEC MODÉRATION.

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701380850,
                "last": 1701380850,
                "now": 1701380850
            },
            "token": "pRt3WLQ5d6RdcirwIOq8L6UzqIhkkbhP"
        },
        "registry": {
            "com_hikashop": {
                "user_id": 0
            }
        },
        "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
        },
        "fabrik": {
            "js": {
                "scripts": null,
                "cacheids": null,
                "head": {
                    "scripts": null,
                    "cache": {
                        "877bf374385c6500f406b75fb0c23f7b": "{\"\\\/media\\\/jui\\\/js\\\/jquery.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/jui\\\/js\\\/jquery-noconflict.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/com_hikashop\\\/js\\\/hikashop.js?v=403\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/jui\\\/js\\\/jquery-migrate.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/components\\\/com_pagebuilderck\\\/assets\\\/jquery-uick.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_pagebuilderck\\\/assets\\\/pagebuilderck.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_pagebuilderck\\\/assets\\\/parallaxbackground.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/system\\\/js\\\/html5fallback-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"conditional\":\"lt IE 9\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/mootools-core-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/system\\\/js\\\/core-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/punycode-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/validate-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/caption-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/modals\\\/js\\\/jquery.touchSwipe.min.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"framework\":false,\"relative\":true,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/modals\\\/js\\\/jquery.modals.js?v=11.5.5\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/modals\\\/js\\\/script.js?v=11.5.5\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/jui\\\/js\\\/bootstrap.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/com_slideshowck\\\/assets\\\/jquery.easing.1.3.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/com_slideshowck\\\/assets\\\/camera.min.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/media\\\/com_hikashop\\\/js\\\/vex.min.js?v=403\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/plugins\\\/hikashop\\\/cartnotify\\\/media\\\/notify-vex.js\":{\"type\":\"text\\\/javascript\",\"options\":[]}}"
                    }
                },
                "config": null,
                "shim": null,
                "jlayouts": null
            }
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 5.82 ms / 5.82 ms Mémoire: 0.583 MB / 0.92 MB Application: afterLoad

Temps: 86.93 ms / 92.76 ms Mémoire: 2.879 MB / 3.79 MB Application: afterInitialise

Temps: 9.72 ms / 102.47 ms Mémoire: 0.726 MB / 4.52 MB Application: afterRoute

Temps: 1.36 ms / 103.84 ms Mémoire: 0.039 MB / 4.56 MB Application: beforeRenderComponent com_content

Temps: 1.25 ms / 105.08 ms Mémoire: 0.041 MB / 4.60 MB Application: Before Access::preloadComponents (all components)

Temps: 1.30 ms / 106.38 ms Mémoire: 0.085 MB / 4.69 MB Application: After Access::preloadComponents (all components)

Temps: 0.04 ms / 106.42 ms Mémoire: 0.060 MB / 4.75 MB Application: Before Access::preloadPermissions (com_content)

Temps: 0.80 ms / 107.22 ms Mémoire: 0.036 MB / 4.78 MB Application: After Access::preloadPermissions (com_content)

Temps: 0.03 ms / 107.25 ms Mémoire: 0.000 MB / 4.78 MB Application: Before Access::getAssetRules (id:201 name:com_content.article.24)

Temps: 0.24 ms / 107.49 ms Mémoire: 0.010 MB / 4.79 MB Application: After Access::getAssetRules (id:201 name:com_content.article.24)

Temps: 22.83 ms / 130.32 ms Mémoire: 0.736 MB / 5.53 MB Application: beforeRenderModule mod_articles_categories (Liste des catégories d'article)

Temps: 5.62 ms / 135.94 ms Mémoire: 0.157 MB / 5.68 MB Application: afterRenderModule mod_articles_categories (Liste des catégories d'article)

Temps: 2.04 ms / 137.97 ms Mémoire: 0.094 MB / 5.78 MB Application: beforeRenderModule mod_articles_category (Derniers Articles)

Temps: 3.68 ms / 141.65 ms Mémoire: 0.197 MB / 5.98 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Temps: 0.03 ms / 141.68 ms Mémoire: 0.002 MB / 5.98 MB Application: After Access::getAssetRules (id:8 name:com_content)

Temps: 3.67 ms / 145.35 ms Mémoire: 0.191 MB / 6.17 MB Application: afterRenderModule mod_articles_category (Derniers Articles)

Temps: 15.25 ms / 160.61 ms Mémoire: 0.000 MB / 6.06 MB Application: afterRenderComponent com_content

Temps: 4.90 ms / 165.51 ms Mémoire: 0.035 MB / 6.09 MB Application: afterDispatch

Temps: 1.43 ms / 166.94 ms Mémoire: 0.274 MB / 6.37 MB Application: beforeRenderModule mod_pagebuilderck (Bannière Alcool)

Temps: 1.96 ms / 168.90 ms Mémoire: 0.018 MB / 6.39 MB Application: afterRenderModule mod_pagebuilderck (Bannière Alcool)

Temps: 0.44 ms / 169.34 ms Mémoire: 0.037 MB / 6.42 MB Application: beforeRenderModule mod_pagebuilderck (Footer - Infos new)

Temps: 11.12 ms / 180.46 ms Mémoire: 0.107 MB / 6.53 MB Application: afterRenderModule mod_pagebuilderck (Footer - Infos new)

Temps: 0.07 ms / 180.53 ms Mémoire: 0.000 MB / 6.40 MB Application: beforeRenderModule mod_breadcrumbs (Fil de navigation)

Temps: 1.33 ms / 181.86 ms Mémoire: 0.013 MB / 6.41 MB Application: afterRenderModule mod_breadcrumbs (Fil de navigation)

Temps: 1.39 ms / 183.25 ms Mémoire: 0.014 MB / 6.43 MB Application: beforeRenderModule mod_hikashop_cart (Hikashop_cart - Panier)

Temps: 12.27 ms / 195.51 ms Mémoire: 0.403 MB / 6.83 MB Application: afterRenderModule mod_hikashop_cart (Hikashop_cart - Panier)

Temps: 0.55 ms / 196.06 ms Mémoire: 0.000 MB / 6.81 MB Application: beforeRenderModule mod_pagebuilderck (Menu Haut de Page)

Temps: 0.39 ms / 196.45 ms Mémoire: 0.004 MB / 6.82 MB Application: afterRenderModule mod_pagebuilderck (Menu Haut de Page)

Temps: 309.53 ms / 505.98 ms Mémoire: 1.060 MB / 7.88 MB Application: afterRender

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

Occupation de la mémoire

Requêtes de base de données

33 requêtes exécutées 62.66 ms

Temps de requête : 0.93 ms Mémoire de requête : 0.027 MB mémoire avant requête : 1.185 MB Rangées retournées : 0

SELECT `data`

  FROM `tcp_session`

  WHERE `session_id` = 'vivnfi4v9dp6b4kgj7dhm2cvu6'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tcp_session	const	PRIMARY	PRIMARY	194	const	1

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.03 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.07 ms
freeing items	0.03 ms
updating status	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:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

SELECT `session_id`

  FROM `tcp_session`

  WHERE `session_id` = 'vivnfi4v9dp6b4kgj7dhm2cvu6' 
  LIMIT 1

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.03 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.02 ms

Pile d'appels

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

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

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

INSERT INTO `tcp_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('vivnfi4v9dp6b4kgj7dhm2cvu6', 1, 1701380850, 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `tcp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('vivnfi4v9dp6b4kgj7dhm2cvu6', 1, 1701380850, 0, '', 0)

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.03 ms
update	0.12 ms
Waiting for query cache lock	0.03 ms
update	0.03 ms
end	0.02 ms
query end	27.56 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.02 ms

Pile d'appels

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

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

Temps de requête : 0.93 ms Après la dernière requête : 3.56 ms Mémoire de requête : 0.025 MB mémoire avant requête : 1.372 MB Rangées retournées : 7

SELECT id, rules

  FROM `tcp_viewlevels`

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.04 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.03 ms

Pile d'appels

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

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

Temps de requête : 1.10 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.025 MB mémoire avant requête : 1.387 MB Rangées retournées : 2

SELECT b.id

  FROM tcp_usergroups AS a

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

  WHERE a.id = 9

Explication

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

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.05 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.03 ms
Unlocking tables	0.05 ms
executing	0.02 ms
Sending data	0.06 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.05 ms
freeing items	0.03 ms
updating status	0.09 ms
cleaning up	0.02 ms

Pile d'appels

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

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

Temps de requête : 2.88 ms Après la dernière requête : 33.05 ms Mémoire de requête : 0.010 MB mémoire avant requête : 2.886 MB

UPDATE `tcp_extensions`

  SET `params` = '{\"mediaversion\":\"61654b24ec8f62780e0cbb363d612f40\"}'

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

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.09 ms
updating	0.07 ms
end	0.02 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	2.34 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2755
10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168
9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57
8	plgSystemHikashopgeolocation->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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.01 ms Après la dernière requête : 4.89 ms Mémoire de requête : 0.100 MB mémoire avant requête : 3.539 MB Rangées retournées : 333

SELECT * 
  FROM tcp_hikashop_config

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.26 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 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:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
12	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1071
11	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2774
10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168
9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57
8	plgSystemHikashopgeolocation->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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.07 ms Après la dernière requête : 13.11 ms Mémoire de requête : 0.037 MB mémoire avant requête : 4.608 MB Rangées retournées : 49

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

  FROM `tcp_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_acymailing','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_cookiesck','com_cpanel','com_fabrik','com_ffexplorer','com_fields','com_finder','com_hikashop','com_imageeffectck','com_installer','com_jce','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_pagebuilderck','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_systempay','com_tags','com_templateck','com_templates','com_users','com_wrapper')

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.08 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.37 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.64 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.034 MB mémoire avant requête : 4.747 MB Rangées retournées : 32

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

  FROM `tcp_assets`

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

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

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

Temps de requête : 1.67 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.039 MB mémoire avant requête : 4.795 MB Rangées retournées : 31

SHOW FULL COLUMNS 
  FROM `tcp_content`

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.47 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
checking permissions	0.05 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.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
closing tables	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
removing tmp table	0.11 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.59 ms Après la dernière requête : 1.01 ms Mémoire de requête : 0.103 MB mémoire avant requête : 4.881 MB Rangées retournées : 1

SELECT *

  FROM tcp_content

  WHERE `id` = '24'

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
Unlocking tables	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
Unlocking tables	0.03 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Pile d'appels

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

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

Temps de requête : 2.94 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.007 MB mémoire avant requête : 4.956 MB

UPDATE tcp_content

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

  WHERE `id` = '24'

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
updating	0.07 ms
end	0.02 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	2.47 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.04 ms
updating status	0.03 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:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.91 ms Après la dernière requête : 0.88 ms Mémoire de requête : 0.074 MB mémoire avant requête : 5.003 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 tcp_content AS a

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

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

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

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

  WHERE a.id = 24 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-11-30 21:47:30') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-11-30 21:47:30') 
  AND (a.state = 1 OR a.state =2)

Explication

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

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.02 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
freeing items	0.02 ms
updating status	0.02 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:1656
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.77 ms Après la dernière requête : 1.04 ms Mémoire de requête : 0.045 MB mémoire avant requête : 5.086 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 `tcp_categories` AS `s`

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

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

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.02 ms
Unlocking tables	0.04 ms
executing	0.02 ms
Sorting result	0.05 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.79 ms Après la dernière requête : 0.51 ms Mémoire de requête : 0.045 MB mémoire avant requête : 5.122 MB Rangées retournées : 9

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

  FROM `tcp_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.23 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.03 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:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM tcp_modules AS m

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

  LEFT JOIN tcp_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-11-30 21:47:30') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-11-30 21:47:30') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND m.id = 172

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published,newsfeeds	PRIMARY	4	const	1
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	const,const	1	Using index condition; Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
20	JDatabaseDriver->loadObject()	JROOT/components/com_pagebuilderck/models/page.php:501
19	PagebuilderckModelPage->getModule()	JROOT/components/com_pagebuilderck/models/page.php:440
18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.75 ms Après la dernière requête : 1.39 ms Mémoire de requête : 0.050 MB mémoire avant requête : 5.580 MB Rangées retournées : 6

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 `tcp_categories` AS `s`

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

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

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sorting result	0.05 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
26	Joomla\CMS\Categories\Categories->get()	JROOT/modules/mod_articles_categories/helper.php:34
25	ModArticlesCategoriesHelper::getList()	Même appel que celui de la ligne ci-dessous.
24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
22	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_categories/mod_articles_categories.php:28
21	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.72 ms Après la dernière requête : 0.58 ms Mémoire de requête : 0.054 MB mémoire avant requête : 5.611 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 `tcp_categories` AS `s`

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

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

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sorting result	0.04 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
36	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
35	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
34	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
33	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
32	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
31	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
30	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
29	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
28	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
24	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
23	require JROOT/modules/mod_articles_categories/tmpl/default_items.php	JROOT/modules/mod_articles_categories/tmpl/default.php:13
22	require JROOT/modules/mod_articles_categories/tmpl/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
21	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.75 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.054 MB mémoire avant requête : 5.642 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 `tcp_categories` AS `s`

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

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

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sorting result	0.04 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
36	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
35	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
34	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
33	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
32	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
31	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
30	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
29	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
28	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
24	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
23	require JROOT/modules/mod_articles_categories/tmpl/default_items.php	JROOT/modules/mod_articles_categories/tmpl/default.php:13
22	require JROOT/modules/mod_articles_categories/tmpl/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
21	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.71 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.054 MB mémoire avant requête : 5.672 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 `tcp_categories` AS `s`

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

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

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sorting result	0.04 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
36	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
35	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
34	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
33	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
32	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
31	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
30	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
29	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
28	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
24	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
23	require JROOT/modules/mod_articles_categories/tmpl/default_items.php	JROOT/modules/mod_articles_categories/tmpl/default.php:13
22	require JROOT/modules/mod_articles_categories/tmpl/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
21	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM tcp_modules AS m

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

  LEFT JOIN tcp_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-11-30 21:47:30') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-11-30 21:47:30') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND m.id = 161

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published,newsfeeds	PRIMARY	4	const	1
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	const,const	1	Using index condition; Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
20	JDatabaseDriver->loadObject()	JROOT/components/com_pagebuilderck/models/page.php:501
19	PagebuilderckModelPage->getModule()	JROOT/components/com_pagebuilderck/models/page.php:440
18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.64 ms Après la dernière requête : 0.57 ms Mémoire de requête : 0.033 MB mémoire avant requête : 5.741 MB Rangées retournées : 1

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

  FROM tcp_modules AS m

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

  LEFT JOIN tcp_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-11-30 21:47:30') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-11-30 21:47:30') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND m.id = 160

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published,newsfeeds	PRIMARY	4	const	1
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	const,const	1	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
20	JDatabaseDriver->loadObject()	JROOT/components/com_pagebuilderck/models/page.php:501
19	PagebuilderckModelPage->getModule()	JROOT/components/com_pagebuilderck/models/page.php:440
18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.36 ms Après la dernière requête : 1.97 ms Mémoire de requête : 0.050 MB mémoire avant requête : 5.928 MB Rangées retournées : 6

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

  FROM `tcp_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `tcp_categories` AS `s`

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

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

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.25 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.05 ms
Sending data	0.07 ms
executing	0.02 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/categories.php:115
26	ContentModelCategories->getItems()	JROOT/modules/mod_articles_category/helper.php:142
25	ModArticlesCategoryHelper::getList()	Même appel que celui de la ligne ci-dessous.
24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
22	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
21	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.29 ms Après la dernière requête : 0.56 ms Mémoire de requête : 0.156 MB mémoire avant requête : 5.976 MB Rangées retournées : 4

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM tcp_content AS a

  LEFT JOIN tcp_categories AS c 
  ON c.id = a.catid

  LEFT JOIN tcp_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN tcp_users AS uam 
  ON uam.id = a.modified_by

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (8,9,10,11,12) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-11-30 21:47:30') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-11-30 21:47:30')

  ORDER BY a.title ASC 
  LIMIT 4

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY,idx_access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	11	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	cmp0912db.c.id	1	Using index condition; Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	cmp0912db.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	cmp0912db.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	cmp0912db.c.parent_id	1	Using where

Profil

Status	Duration
starting	0.13 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.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.06 ms
executing	0.01 ms
Creating tmp table	0.63 ms
Copying to tmp table	0.37 ms
Sorting result	0.10 ms
Sending data	0.20 ms
end	0.02 ms
removing tmp table	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
27	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
26	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:224
25	ModArticlesCategoryHelper::getList()	Même appel que celui de la ligne ci-dessous.
24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
22	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
21	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_pagebuilderck/models/page.php:454
18	PagebuilderckModelPage->renderModule()	JROOT/components/com_pagebuilderck/models/page.php:308
17	PagebuilderckModelPage->replaceModule()	Même appel que celui de la ligne ci-dessous.
16	preg_replace_callback()	JROOT/components/com_pagebuilderck/models/page.php:133
15	PagebuilderckModelPage->parseHtml()	JROOT/plugins/system/pagebuilderck/pagebuilderck.php:213
14	plgSystemPagebuilderck->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT 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 tcp_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Explication

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

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.03 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.06 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.02 ms

Pile d'appels

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

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

Temps de requête : 0.48 ms Après la dernière requête : 6.33 ms Mémoire de requête : 0.025 MB mémoire avant requête : 6.091 MB Rangées retournées : 1

SELECT params,layoutcss,state 
  from tcp_cookiesck_styles 
  WHERE id = 1

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	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:1656
9	JDatabaseDriver->loadObject()	JROOT/plugins/system/cookiesck/cookiesck.php:410
8	plgSystemCookiesck->getStylesCss()	JROOT/plugins/system/cookiesck/cookiesck.php:192
7	plgSystemCookiesck->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.20 ms Après la dernière requête : 22.08 ms Mémoire de requête : 0.027 MB mémoire avant requête : 6.517 MB Rangées retournées : 0

SELECT cart.cart_id 
  FROM tcp_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = 'vivnfi4v9dp6b4kgj7dhm2cvu6')  
  ORDER BY cart.cart_current DESC, cart.cart_modified DESC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cart	ref	session_id	session_id	767	const	1	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.12 ms
preparing	0.07 ms
executing	0.03 ms
Sorting result	0.07 ms
Sending data	0.04 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.05 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:1734
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
14	hikashopCartClass->getCurrentCartId()	JROOT/components/com_hikashop/views/product/view.html.php:2260
13	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
11	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
10	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.48 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.029 MB mémoire avant requête : 6.562 MB Rangées retournées : 0

SELECT a.id 
  FROM tcp_menu AS a 
  INNER JOIN `tcp_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' 
  AND a.language IN ('*', '', 'fr-FR')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	idx_menutype	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	Using where
1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	cmp0912db.b.menutype	6	Using where

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.06 ms
optimizing	0.06 ms
statistics	0.16 ms
preparing	0.07 ms
executing	0.03 ms
Sending data	0.38 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.05 ms
freeing items	0.03 ms
updating status	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:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:206
15	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
14	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:2344
13	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
11	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
10	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.45 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.030 MB mémoire avant requête : 6.575 MB Rangées retournées : 13

SELECT a.id 
  FROM tcp_menu AS a 
  INNER JOIN `tcp_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link LIKE 'index.php?option=com_hikashop&view=%' 
  AND a.language IN ('*', '', 'fr-FR')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	idx_menutype	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	Using where
1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	cmp0912db.b.menutype	6	Using where

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.13 ms
preparing	0.06 ms
executing	0.03 ms
Sending data	0.33 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.06 ms
freeing items	0.03 ms
updating status	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:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:211
15	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
14	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:2344
13	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:756
11	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
10	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.71 ms Après la dernière requête : 6.25 ms Mémoire de requête : 0.056 MB mémoire avant requête : 6.842 MB Rangées retournées : 266

SELECT * 
  FROM tcp_acym_configuration

Explication

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.23 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	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:1695
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:31
17	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/configuration.php:15
16	AcyMailing\Classes\ConfigurationClass->load()	JROOT/administrator/components/com_acym/helpers/global/global.php:35
15	acym_config()	JROOT/administrator/components/com_acym/libraries/object.php:14
14	AcyMailing\Libraries\acymObject->__construct()	JROOT/administrator/components/com_acym/classes/form.php:42
13	AcyMailing\Classes\FormClass->__construct()	JROOT/plugins/system/acymtriggers/acymtriggers.php:111
12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.45 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.031 MB mémoire avant requête : 7.004 MB Rangées retournées : 0

SELECT * 
  FROM tcp_acym_form 
  WHERE active = 1 
  AND type != 'shortcode'

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:31
14	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/form.php:112
13	AcyMailing\Classes\FormClass->getAllFormsToDisplay()	JROOT/plugins/system/acymtriggers/acymtriggers.php:112
12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.76 ms Après la dernière requête : 1.69 ms Mémoire de requête : 0.031 MB mémoire avant requête : 7.126 MB Rangées retournées : 49

SELECT name, element AS `option`

  FROM tcp_extensions

  WHERE type = 'component' 
  AND enabled = 1

  ORDER BY name ASC

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.23 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 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:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_menus/models/menutypes.php:90
12	MenusModelMenutypes->getTypeOptions()	JROOT/plugins/system/betterpreview/src/Component/Link.php:35
11	RegularLabs\Plugin\System\BetterPreview\Component\Link->__construct()	JROOT/plugins/system/betterpreview/src/Component.php:29
10	RegularLabs\Plugin\System\BetterPreview\Component::getClass()	JROOT/plugins/system/betterpreview/betterpreview.php:190
9	PlgSystemBetterPreview->getClass()	JROOT/plugins/system/betterpreview/betterpreview.php:164
8	PlgSystemBetterPreview->handleOnAfterRender()	JROOT/libraries/regularlabs/src/Plugin.php:193
7	RegularLabs\Library\Plugin->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM tcp_extensions

  WHERE element = 'jch_optimize' 
  AND type = 'plugin' 
  AND folder = 'system'

Explication

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

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.16 ms
preparing	0.07 ms
executing	0.03 ms
Sending data	0.10 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	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:1656
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/jch_optimize/platform/plugin.php:82
16	JchOptimize\Platform\Plugin::loadjch()	JROOT/plugins/system/jch_optimize/platform/plugin.php:55
15	JchOptimize\Platform\Plugin::getPlugin()	JROOT/plugins/system/jch_optimize/platform/plugin.php:99
14	JchOptimize\Platform\Plugin::getPluginParams()	JROOT/plugins/system/jch_optimize/platform/cache.php:139
13	JchOptimize\Platform\Cache::getLifetime()	JROOT/plugins/system/jch_optimize/platform/cache.php:121
12	JchOptimize\Platform\Cache::getCacheObject()	JROOT/plugins/system/jch_optimize/platform/cache.php:45
11	JchOptimize\Platform\Cache::getCache()	JROOT/plugins/system/jch_optimize/jchoptimize/parser.php:101
10	JchOptimize\Core\Parser->__construct()	JROOT/plugins/system/jch_optimize/jchoptimize/optimize.php:56
9	JchOptimize\Core\Optimize->process()	JROOT/plugins/system/jch_optimize/jchoptimize/optimize.php:116
8	JchOptimize\Core\Optimize::optimize()	JROOT/plugins/system/jch_optimize/jch_optimize.php:125
7	plgSystemJCH_Optimize->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Tables sélectionnées :

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

3 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM tcp_modules AS m 
  LEFT JOIN tcp_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN tcp_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

2 × SELECT a.id 
  FROM tcp_menu AS a 
  INNER JOIN `tcp_menu_types` as b 
  on a.menutype = b.menutype

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM tcp_content AS a 
  LEFT JOIN tcp_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN tcp_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN tcp_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN tcp_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT name, element AS `option` 
  FROM tcp_extensions

```
1 × SELECT * 
  FROM tcp_acym_form
```

1 × SELECT * 
  FROM tcp_acym_configuratio

1 × SELECT cart.cart_id 
  FROM tcp_hikashop_cart AS cart

1 × SELECT params,layoutcss,state 
  from tcp_cookiesck_styles

1 × SELECT 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 tcp_fields AS a 
  LEFT JOIN `tcp_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN tcp_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN tcp_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN tcp_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN tcp_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `tcp_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT `data` 
  FROM `tcp_session`

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

1 × SELECT `session_id` 
  FROM `tcp_session`

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

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

```
1 × SELECT * 
  FROM tcp_content
```

1 × SELECT * 
  FROM tcp_hikashop_confi

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

1 × SELECT id, rules 
  FROM `tcp_viewlevels

1 × SELECT folder AS type, element AS name, params, extension_id 
  FROM tcp_extensions

Autres tables :

1 × INSERT INTO `tcp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('vivnfi4v9dp6b4kgj7dhm2cvu6', 1, 1701380850, 0, '', 0

1 × UPDATE `tcp_extensions` 
  SET `params` = '{\"mediaversion\":\"61654b24ec8f62780e0cbb363d612f40\"}'

1 × SHOW FULL COLUMNS 
  FROM `tcp_content

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

Le Beaujolais nouveau en trois mots : région, tradition et primeur

Le Beaujolais une région viticole

Le Beaujolais nouveau, une tradition

Le Beaujolais nouveau, un vin primeur

Vodka

Événement

Domaine Guillot Gonin

Beaujolais

Derniers Articles

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

33 requêtes exécutées 62.66 ms

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

Tables sélectionnées :

Autres tables :