Rosa damascena Mill.
Maroc

DES ESSENCES PURES

Trouvez des ingrédients uniques pour sublimer vos créations!

« Matière première : première parce qu’elle est au commencement d'un cycle, mais première surtout parce qu’elle est essentielle, primordiale. De même lorsque nous parlons des Peuples Premiers, nous savons qu'ils sont notre origine mais aussi notre horizon, porteurs d'un savoir encore peu accessible pour nous qu'ils appellent leurs petits frères… ».

Découvrez tous nos produits

À propos de nous...

Albert Vieille a sélectionné pour l’In-cosmetics Europe de Hamburg en 2014, une gamme de produits aromatiques reconnus pour leurs activités en cosmétique.

Albert Vieille a lancé au World Perfumery Congress de Deauville en 2014, une absolue de café sublimée extraite à partir de l’espèce la plus noble du café « Coffea arabica L. ». Elle offre une odeur enveloppante et puissante caractéristique des grains de café torréfiés. Sa forte solubilité dans l’alcool, facilite son incorporation en formules.

Albert Vieille aura le plaisir de vous accueillir à l’In-cosmetics Asia à Bangkok du 4 au 6 Novembre 2014. Nous exposerons sur le pavillon français d’Ubifrance. Nous vous présenterons une large gamme de matières premières aromatiques 100% pures et naturelles destinées aux marchés de la cosmétique et de la parfumerie. Venez découvrir nos nouveautés…

La société Albert Vieille est heureuse de vous présenter son nouveau site internet.

Au cœur de la matière première aromatique naturelle, Albert Vieille s’engage avec la charte « 100% pur et naturel » à garantir la qualité et la traçabilité de tous ses produits.

Focus produits

Le mot de Georges

« Matière première : première parce qu'elle est au commencement d'un cycle, mais première surtout parce qu'elle est essentielle, primordiale. »

Informations

Société

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Temps: 0.0 ms / 0.0 ms Mémoire: 0.608 MB / 0.61 MB Application: afterLoad

Temps: 66.2 ms / 66.2 ms Mémoire: 4.051 MB / 4.66 MB Application: afterInitialise

Temps: 25.9 ms / 92.2 ms Mémoire: 1.600 MB / 6.26 MB Application: afterRoute

Temps: 56.9 ms / 149.0 ms Mémoire: 2.595 MB / 8.85 MB Application: afterDispatch

Temps: 21.8 ms / 170.9 ms Mémoire: 0.415 MB / 9.27 MB Application: beforeRenderModule mod_custom (Suivez nous)

Temps: 2.3 ms / 173.2 ms Mémoire: 0.028 MB / 9.30 MB Application: afterRenderModule mod_custom (Suivez nous)

Temps: 0.1 ms / 173.3 ms Mémoire: 0.000 MB / 9.30 MB Application: beforeRenderModule mod_menu (Société)

Temps: 5.8 ms / 179.1 ms Mémoire: 0.096 MB / 9.39 MB Application: afterRenderModule mod_menu (Société)

Temps: 0.1 ms / 179.2 ms Mémoire: 0.000 MB / 9.39 MB Application: beforeRenderModule mod_menu (Informations)

Temps: 3.9 ms / 183.1 ms Mémoire: 0.055 MB / 9.44 MB Application: afterRenderModule mod_menu (Informations)

Temps: 0.1 ms / 183.3 ms Mémoire: 0.000 MB / 9.44 MB Application: beforeRenderModule mod_custom (Le mot de Georges)

Temps: 0.5 ms / 183.8 ms Mémoire: 0.007 MB / 9.44 MB Application: afterRenderModule mod_custom (Le mot de Georges)

Temps: 0.2 ms / 183.9 ms Mémoire: 0.005 MB / 9.45 MB Application: beforeRenderModule mod_articles_category (Focus produits)

Temps: 8.0 ms / 191.9 ms Mémoire: 0.385 MB / 9.83 MB Application: afterRenderModule mod_articles_category (Focus produits)

Temps: 0.2 ms / 192.1 ms Mémoire: 0.000 MB / 9.82 MB Application: beforeRenderModule mod_articles_category (À propos de nous...)

Temps: 11.1 ms / 203.2 ms Mémoire: 0.395 MB / 10.22 MB Application: afterRenderModule mod_articles_category (À propos de nous...)

Temps: 0.3 ms / 203.5 ms Mémoire: 0.000 MB / 10.06 MB Application: beforeRenderModule mod_custom (Découvrez tous nos produits)

Temps: 0.4 ms / 203.9 ms Mémoire: 0.007 MB / 10.06 MB Application: afterRenderModule mod_custom (Découvrez tous nos produits)

Temps: 0.1 ms / 204.1 ms Mémoire: 0.000 MB / 10.06 MB Application: beforeRenderModule mod_custom (Gamme alimentaire)

Temps: 0.4 ms / 204.4 ms Mémoire: 0.006 MB / 10.07 MB Application: afterRenderModule mod_custom (Gamme alimentaire)

Temps: 0.1 ms / 204.6 ms Mémoire: 0.000 MB / 10.07 MB Application: beforeRenderModule mod_custom (Gamme cosmétique)

Temps: 0.4 ms / 204.9 ms Mémoire: 0.006 MB / 10.07 MB Application: afterRenderModule mod_custom (Gamme cosmétique)

Temps: 0.1 ms / 205.0 ms Mémoire: 0.000 MB / 10.07 MB Application: beforeRenderModule mod_custom (Gamme parfumerie)

Temps: 0.4 ms / 205.4 ms Mémoire: 0.006 MB / 10.08 MB Application: afterRenderModule mod_custom (Gamme parfumerie)

Temps: 0.1 ms / 205.5 ms Mémoire: 0.000 MB / 10.08 MB Application: beforeRenderModule mod_custom (Gamme aromathérapie)

Temps: 0.4 ms / 205.9 ms Mémoire: 0.006 MB / 10.08 MB Application: afterRenderModule mod_custom (Gamme aromathérapie)

Temps: 0.2 ms / 206.2 ms Mémoire: 0.000 MB / 10.08 MB Application: beforeRenderModule mod_cotation (Module de recherche)

Temps: 2.9 ms / 209.1 ms Mémoire: 0.018 MB / 10.10 MB Application: afterRenderModule mod_cotation (Module de recherche)

Temps: 0.2 ms / 209.3 ms Mémoire: 0.009 MB / 10.11 MB Application: beforeRenderModule mod_simple_responsive_slideshow (Slide accueil)

Temps: 1.9 ms / 211.2 ms Mémoire: 0.053 MB / 10.16 MB Application: afterRenderModule mod_simple_responsive_slideshow (Slide accueil)

Temps: 0.2 ms / 211.4 ms Mémoire: 0.000 MB / 10.13 MB Application: beforeRenderModule mod_sr_menu (Phone Menu FR)

Temps: 12.2 ms / 223.6 ms Mémoire: 0.114 MB / 10.24 MB Application: afterRenderModule mod_sr_menu (Phone Menu FR)

Temps: 0.2 ms / 223.8 ms Mémoire: 0.000 MB / 10.24 MB Application: beforeRenderModule mod_languages (Changement de langue)

Temps: 9.7 ms / 233.5 ms Mémoire: 0.299 MB / 10.53 MB Application: afterRenderModule mod_languages (Changement de langue)

Temps: 0.2 ms / 233.7 ms Mémoire: 0.000 MB / 10.53 MB Application: beforeRenderModule mod_custom (Téléphone)

Temps: 0.4 ms / 234.1 ms Mémoire: 0.006 MB / 10.54 MB Application: afterRenderModule mod_custom (Téléphone)

Temps: 0.1 ms / 234.2 ms Mémoire: 0.000 MB / 10.53 MB Application: beforeRenderModule mod_custom (Outils)

Temps: 0.4 ms / 234.5 ms Mémoire: 0.006 MB / 10.54 MB Application: afterRenderModule mod_custom (Outils)

Temps: 0.2 ms / 234.7 ms Mémoire: 0.000 MB / 10.54 MB Application: beforeRenderModule mod_search (Recherche site FR)

Temps: 3.4 ms / 238.1 ms Mémoire: 0.037 MB / 10.58 MB Application: afterRenderModule mod_search (Recherche site FR)

Temps: 0.2 ms / 238.3 ms Mémoire: 0.000 MB / 10.57 MB Application: beforeRenderModule mod_cinch_menu (Menu FR)

Temps: 5.9 ms / 244.2 ms Mémoire: 0.055 MB / 10.63 MB Application: afterRenderModule mod_cinch_menu (Menu FR)

Temps: 37.3 ms / 281.5 ms Mémoire: 0.198 MB / 10.82 MB Application: afterRender

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

Occupation de la mémoire

Requêtes de base de données

39 requêtes exécutées 34.1 ms

Temps de requête : 0.38 ms Mémoire de requête : 0.016 MB mémoire avant requête : 2.294 MB Rangées retournées : 1
```
SELECT `data`

  FROM `jz6u8_session`

  WHERE `session_id` = 'bo8b859bprkqd6t47ouqak18t4'
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_session const PRIMARY PRIMARY 602 const 1
Profil
Error
MySql have_profiling = off
Call Stack
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:658
JROOT/libraries/joomla/session/session.php:596
JROOT/libraries/cms/application/cms.php:728
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:388
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.32 ms Après la dernière requête : 3.30 ms Mémoire de requête : 0.008 MB mémoire avant requête : 2.402 MB
```
DELETE 

  FROM `jz6u8_session`

  WHERE `time` < '1412302199'
```
Explication
EXPLAIN impossible sur la requête : DELETE FROM `jz6u8_session` WHERE `time` < '1412302199'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/cms/application/cms.php:745
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:388
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.24 ms Après la dernière requête : 8.20 ms Mémoire de requête : 0.014 MB mémoire avant requête : 2.763 MB Rangées retournées : 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM jz6u8_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_users'
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:563
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[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 : 1.34 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.820 MB Rangées retournées : 50
```
SELECT folder AS type, element AS name, params

  FROM jz6u8_extensions

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

  ORDER BY ordering
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_extensions ref extension extension 62 const 66 Using where; Utilisation du tri complet de type filesort
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:568
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.20 ms Après la dernière requête : 4.63 ms Mémoire de requête : 0.017 MB mémoire avant requête : 3.211 MB Rangées retournées : 2
```
SELECT *

  FROM jz6u8_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_languages ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 Using where; Utilisation du tri complet de type filesort
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/language/helper.php:166
JROOT/plugins/system/languagefilter/languagefilter.php:67
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:568
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.16 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.018 MB mémoire avant requête : 3.247 MB Rangées retournées : 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM jz6u8_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/languagefilter/languagefilter.php:69
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:568
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.31 ms Après la dernière requête : 0.56 ms Mémoire de requête : 0.013 MB mémoire avant requête : 3.277 MB Rangées retournées : 1
```
SELECT COUNT(*)

  FROM `jz6u8_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 72 Using where
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32
JROOT/plugins/system/languagefilter/languagefilter.php:71
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:568
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jz6u8_session	const	PRIMARY	PRIMARY	602	const	1

Error
MySql have_profiling = off

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jz6u8_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jz6u8_extensions	ref	extension	extension	62	const	66	Using where; Utilisation du tri complet de type filesort

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jz6u8_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jz6u8_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	72	Using where

Temps de requête : 1.43 ms Après la dernière requête : 25.37 ms Mémoire de requête : 0.039 MB mémoire avant requête : 4.723 MB Rangées retournées : 80

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jz6u8_menu AS m

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

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

  ORDER BY m.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	72	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	albertvieille.m.component_id	1

Profil

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

Call Stack

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:413

JROOT/libraries/cms/application/site.php:272

JROOT/libraries/cms/router/site.php:218

JROOT/libraries/cms/router/router.php:408

JROOT/libraries/cms/router/router.php:192

JROOT/libraries/cms/router/site.php:90

JROOT/libraries/cms/application/cms.php:1078

JROOT/libraries/cms/application/site.php:742

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Temps de requête : 0.26 ms Après la dernière requête : 6.92 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.604 MB Rangées retournées : 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM jz6u8_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_content'
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/components/com_content/router.php:289
JROOT/libraries/cms/router/site.php:369
JROOT/libraries/cms/router/router.php:408
JROOT/libraries/cms/router/router.php:192
JROOT/libraries/cms/router/site.php:90
JROOT/libraries/cms/application/cms.php:1078
JROOT/libraries/cms/application/site.php:742
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.22 ms Après la dernière requête : 1.07 ms Mémoire de requête : 0.025 MB mémoire avant requête : 5.661 MB Rangées retournées : 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM jz6u8_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/jqueryeasy/jqueryeasy.php:55
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1087
JROOT/libraries/cms/application/site.php:742
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 4.24 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.018 MB mémoire avant requête : 5.669 MB
```
UPDATE `jz6u8_extensions`

  SET `params` = '{\"mediaversion\":\"d11cad2e49765761b5aca49ad44c6cc5\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explication
EXPLAIN impossible sur la requête : UPDATE `jz6u8_extensions` SET `params` = '{\"mediaversion\":\"d11cad2e49765761b5aca49ad44c6cc5\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/jqueryeasy/jqueryeasy.php:55
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1087
JROOT/libraries/cms/application/site.php:742
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jz6u8_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jz6u8_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

Temps de requête : 0.42 ms Après la dernière requête : 11.01 ms Mémoire de requête : 0.010 MB mémoire avant requête : 6.285 MB Rangées retournées : 4

SELECT id, home, template, s.params

  FROM jz6u8_template_styles as s

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

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	albertvieille.s.template,const	1	Using where

Profil

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

Call Stack

JROOT/libraries/cms/application/site.php:479

JROOT/libraries/cms/application/site.php:165

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

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

SELECT b.rules

  FROM jz6u8_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	12	Using where

Profil

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

Call Stack

JROOT/libraries/joomla/access/access.php:248

JROOT/libraries/joomla/access/access.php:109

JROOT/libraries/joomla/user/user.php:373

JROOT/components/com_content/models/article.php:55

JROOT/libraries/legacy/model/legacy.php:415

JROOT/components/com_content/models/article.php:75

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/article/view.html.php:44

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Temps de requête : 0.36 ms Après la dernière requête : 1.66 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.175 MB Rangées retournées : 2
```
SELECT b.id

  FROM jz6u8_usergroups AS a

  LEFT JOIN jz6u8_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 range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/access/access.php:334
JROOT/libraries/joomla/access/access.php:113
JROOT/libraries/joomla/user/user.php:373
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:415
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_content/views/article/view.html.php:44
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

Temps de requête : 0.95 ms Après la dernière requête : 1.06 ms Mémoire de requête : 0.029 MB mémoire avant requête : 7.217 MB Rangées retournées : 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS 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 jz6u8_content AS a

  LEFT JOIN jz6u8_categories AS c 
  on c.id = a.catid

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jz6u8_categories AS cat JOIN jz6u8_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.language in ('fr-FR','*') 
  AND a.id = 2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-03 05:09:59') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-03 05:09:59') 
  AND (a.state = 1 OR a.state =2)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	0	const row not found
1	PRIMARY	a	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	Using where; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	66	Using where; Using index; Using join buffer

Profil

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

Call Stack

JROOT/components/com_content/models/article.php:158

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/article/view.html.php:44

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Temps de requête : 0.98 ms Après la dernière requête : 4.37 ms Mémoire de requête : 0.028 MB mémoire avant requête : 7.429 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 jz6u8_categories as c

  LEFT JOIN jz6u8_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM jz6u8_categories AS cat JOIN jz6u8_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

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

  GROUP BY 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

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	0	const row not found
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	66	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	11	Using where; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	66	Using where; Using index; Using join buffer

Profil

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

Call Stack

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:41

JROOT/components/com_content/views/article/view.html.php:72

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Temps de requête : 0.30 ms Après la dernière requête : 4.73 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.649 MB Rangées retournées : 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM jz6u8_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_tags'
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/helper/tags.php:392
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jz6u8_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

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

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

  FROM `jz6u8_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 2 
  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	m	ALL	idx_tag_type,idx_tag	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	albertvieille.m.tag_id	1	Using where

Profil

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

Call Stack

JROOT/libraries/cms/helper/tags.php:412

JROOT/components/com_content/views/article/view.html.php:155

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Temps de requête : 0.94 ms Après la dernière requête : 9.16 ms Mémoire de requête : 0.028 MB mémoire avant requête : 8.126 MB Rangées retournées : 30
```
SHOW FULL COLUMNS 
  FROM `jz6u8_content`
```
Explication
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `jz6u8_content`
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/libraries/legacy/table/content.php:31
JROOT/libraries/joomla/table/table.php:301
JROOT/components/com_content/models/article.php:263
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.20 ms Après la dernière requête : 2.33 ms Mémoire de requête : 0.027 MB mémoire avant requête : 8.317 MB Rangées retournées : 1
```
SELECT *

  FROM jz6u8_content

  WHERE `id` = '2'
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_content const PRIMARY PRIMARY 4 const 1
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/table/table.php:723
JROOT/components/com_content/models/article.php:264
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 1.21 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.016 MB mémoire avant requête : 8.334 MB
```
UPDATE jz6u8_content

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

  WHERE `id` = '2'
```
Explication
EXPLAIN impossible sur la requête : UPDATE jz6u8_content SET `hits` = (`hits` + 1) WHERE `id` = '2'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/table/table.php:1233
JROOT/components/com_content/models/article.php:265
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

Temps de requête : 1.23 ms Après la dernière requête : 14.79 ms Mémoire de requête : 0.021 MB mémoire avant requête : 8.996 MB Rangées retournées : 28

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

  FROM jz6u8_modules AS m

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

  LEFT JOIN jz6u8_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 <= '2014-10-03 05:09:59') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-03 05:09:59') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0) 
  AND m.language IN ('fr-FR','*')

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	31	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	albertvieille.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	albertvieille.m.module,const	1	Using where

Profil

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

Call Stack

JROOT/libraries/cms/module/helper.php:376

JROOT/libraries/cms/module/helper.php:84

JROOT/libraries/joomla/document/html/html.php:497

JROOT/templates/huile_essentielle/index.php:43

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:1034

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Temps de requête : 2.41 ms Après la dernière requête : 1.84 ms Mémoire de requête : 0.016 MB mémoire avant requête : 9.135 MB Rangées retournées : 99

SELECT DISTINCT nom_plante_fr AS value

  FROM jz6u8_cotation_produits

  WHERE state = 1

  ORDER BY nom_plante_fr

Explication

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

Profil

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

Call Stack

JROOT/modules/mod_cotation/helper.php:52

JROOT/templates/huile_essentielle/index.php:289

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:1034

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[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 : 0.48 ms Mémoire de requête : 0.017 MB mémoire avant requête : 9.148 MB Rangées retournées : 174

SELECT DISTINCT nom_produit_fr AS value

  FROM jz6u8_cotation_produits

  WHERE state = 1

  ORDER BY nom_produit_fr

Explication

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

Profil

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

Call Stack

JROOT/modules/mod_cotation/helper.php:52

JROOT/templates/huile_essentielle/index.php:290

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:1034

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Temps de requête : 2.40 ms Après la dernière requête : 0.76 ms Mémoire de requête : 0.016 MB mémoire avant requête : 9.162 MB Rangées retournées : 120

SELECT DISTINCT nom_botanique AS value

  FROM jz6u8_cotation_produits

  WHERE state = 1

  ORDER BY nom_botanique

Explication

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

Profil

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

Call Stack

JROOT/modules/mod_cotation/helper.php:52

JROOT/templates/huile_essentielle/index.php:291

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:1034

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Temps de requête : 2.26 ms Après la dernière requête : 0.49 ms Mémoire de requête : 0.016 MB mémoire avant requête : 9.191 MB Rangées retournées : 114

SELECT DISTINCT cas_tsca AS value

  FROM jz6u8_cotation_produits

  WHERE state = 1

  ORDER BY cas_tsca

Explication

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

Profil

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

Call Stack

JROOT/modules/mod_cotation/helper.php:52

JROOT/templates/huile_essentielle/index.php:292

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:1034

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Temps de requête : 0.20 ms Après la dernière requête : 21.68 ms Mémoire de requête : 0.023 MB mémoire avant requête : 9.826 MB Rangées retournées : 4
```
SELECT id, rules

  FROM `jz6u8_viewlevels`
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_viewlevels ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 4
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/access/access.php:420
JROOT/modules/mod_articles_category/helper.php:54
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/module/helper.php:488
JROOT/modules/mod_articles_category/mod_articles_category.php:61
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:1048
JROOT/libraries/cms/application/site.php:724
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

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

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 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,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM jz6u8_content AS a

  LEFT JOIN jz6u8_content_frontpage AS fp 
  ON fp.content_id = a.id

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM jz6u8_categories AS cat JOIN jz6u8_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (64) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-03 05:09:59') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-03 05:09:59') 
  AND a.language in ('fr-FR','*')

  ORDER BY publish_up DESC 
  LIMIT 0, 10

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	0	const row not found
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Utilisation du tri complet de type filesort
1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	1	Using where
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	albertvieille.a.id	1	Using index
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	albertvieille.a.created_by	1
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	albertvieille.a.modified_by	1
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	albertvieille.a.id	1
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	11	Using where; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	66	Using where; Using index; Using join buffer

Profil

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

Call Stack

JROOT/libraries/legacy/model/legacy.php:301

JROOT/libraries/legacy/model/list.php:171

JROOT/components/com_content/models/articles.php:537

JROOT/modules/mod_articles_category/helper.php:201

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:488

JROOT/modules/mod_articles_category/mod_articles_category.php:61

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:1048

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[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 : 1.56 ms Mémoire de requête : 0.037 MB mémoire avant requête : 9.896 MB Rangées retournées : 5

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 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,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM jz6u8_content AS a

  LEFT JOIN jz6u8_content_frontpage AS fp 
  ON fp.content_id = a.id

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM jz6u8_categories AS cat JOIN jz6u8_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (21) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-03 05:09:59') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-03 05:09:59') 
  AND a.language in ('fr-FR','*')

  ORDER BY publish_up DESC 
  LIMIT 0, 10

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	0	const row not found
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Utilisation du tri complet de type filesort
1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	5	Using where
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	albertvieille.a.id	1	Using index
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	albertvieille.a.created_by	1
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	albertvieille.a.modified_by	1
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	albertvieille.a.id	1
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	11	Using where; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	66	Using where; Using index; Using join buffer

Profil

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

Call Stack

JROOT/libraries/legacy/model/legacy.php:301

JROOT/libraries/legacy/model/list.php:171

JROOT/components/com_content/models/articles.php:537

JROOT/modules/mod_articles_category/helper.php:201

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:488

JROOT/modules/mod_articles_category/mod_articles_category.php:61

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:1048

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

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

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

  FROM `jz6u8_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 43 
  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	m	ALL	idx_tag_type,idx_tag	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	albertvieille.m.tag_id	1	Using where

Profil

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

Call Stack

JROOT/libraries/cms/helper/tags.php:412

JROOT/components/com_content/models/articles.php:663

JROOT/modules/mod_articles_category/helper.php:201

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:488

JROOT/modules/mod_articles_category/mod_articles_category.php:61

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:1048

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

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

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

  FROM `jz6u8_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 42 
  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	m	ALL	idx_tag_type,idx_tag	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	albertvieille.m.tag_id	1	Using where

Profil

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

Call Stack

JROOT/libraries/cms/helper/tags.php:412

JROOT/components/com_content/models/articles.php:663

JROOT/modules/mod_articles_category/helper.php:201

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:488

JROOT/modules/mod_articles_category/mod_articles_category.php:61

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:1048

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

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

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

  FROM `jz6u8_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 36 
  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	m	ALL	idx_tag_type,idx_tag	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	albertvieille.m.tag_id	1	Using where

Profil

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

Call Stack

JROOT/libraries/cms/helper/tags.php:412

JROOT/components/com_content/models/articles.php:663

JROOT/modules/mod_articles_category/helper.php:201

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:488

JROOT/modules/mod_articles_category/mod_articles_category.php:61

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:1048

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

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

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

  FROM `jz6u8_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 32 
  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	m	ALL	idx_tag_type,idx_tag	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	albertvieille.m.tag_id	1	Using where

Profil

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

Call Stack

JROOT/libraries/cms/helper/tags.php:412

JROOT/components/com_content/models/articles.php:663

JROOT/modules/mod_articles_category/helper.php:201

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:488

JROOT/modules/mod_articles_category/mod_articles_category.php:61

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:1048

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

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

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

  FROM `jz6u8_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 31 
  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	m	ALL	idx_tag_type,idx_tag	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	albertvieille.m.tag_id	1	Using where

Profil

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

Call Stack

JROOT/libraries/cms/helper/tags.php:412

JROOT/components/com_content/models/articles.php:663

JROOT/modules/mod_articles_category/helper.php:201

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:488

JROOT/modules/mod_articles_category/mod_articles_category.php:61

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:1048

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Temps de requête : 0.67 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.033 MB mémoire avant requête : 10.177 MB Rangées retourné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 jz6u8_categories as c

  LEFT JOIN jz6u8_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM jz6u8_categories AS cat JOIN jz6u8_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

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

  GROUP BY 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

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	0	const row not found
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	66	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	11	Using where; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	66	Using where; Using index; Using join buffer

Profil

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

Call Stack

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:41

JROOT/modules/mod_articles_category/helper.php:235

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/module/helper.php:488

JROOT/modules/mod_articles_category/mod_articles_category.php:61

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:1048

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Temps de requête : 0.22 ms Après la dernière requête : 12.26 ms Mémoire de requête : 0.019 MB mémoire avant requête : 10.180 MB Rangées retournées : 1
```
SELECT nom_plante_fr AS nom_plante,nom_botanique,origine_fr AS origine, photo

  FROM jz6u8_cotation_produits 

  WHERE id = 143
```
Explication
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE jz6u8_cotation_produits const PRIMARY PRIMARY 4 const 1
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/modules/mod_simple_responsive_slideshow/mod_simple_responsive_slideshow.php:61
JROOT/modules/mod_simple_responsive_slideshow/mod_simple_responsive_slideshow.php:103
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:1048
JROOT/libraries/cms/application/site.php:724
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

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

SELECT m2.language, m2.id

  FROM jz6u8_menu as m

  INNER JOIN jz6u8_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item'

  INNER JOIN jz6u8_associations as a2 
  ON a.key=a2.key

  INNER JOIN jz6u8_menu as m2 
  ON a2.id=m2.id

  WHERE m.id=101

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	156	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	96	const	2	Using index
1	SIMPLE	m2	eq_ref	PRIMARY	PRIMARY	4	albertvieille.a2.id	1

Profil

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

Call Stack

JROOT/administrator/components/com_menus/helpers/menus.php:257

JROOT/modules/mod_languages/helper.php:58

JROOT/modules/mod_languages/mod_languages.php:18

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:1048

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

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

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

  FROM `jz6u8_content` AS `c`

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

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

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

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

  WHERE c.id = 2

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	156	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	96	const	1	Using index
1	SIMPLE	c2	eq_ref	PRIMARY,idx_catid	PRIMARY	4	albertvieille.a2.id	1	Using where
1	SIMPLE	ca	eq_ref	PRIMARY,cat_idx	PRIMARY	4	albertvieille.c2.catid	1	Using where

Profil

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

Call Stack

JROOT/libraries/cms/language/associations.php:83

JROOT/components/com_content/helpers/association.php:48

JROOT/modules/mod_languages/helper.php:69

JROOT/modules/mod_languages/mod_languages.php:18

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:1048

JROOT/libraries/cms/application/site.php:724

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Temps de requête : 3.42 ms Après la dernière requête : 53.03 ms Mémoire de requête : 0.003 MB mémoire avant requête : 10.812 MB
```
UPDATE `jz6u8_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1412312957;s:18:\"session.timer.last\";i:1412312961;s:17:\"session.timer.now\";i:1412312999;s:24:\"session.client.forwarded\";s:15:\"204.236.235.245\";s:22:\"session.client.browser\";s:75:\"ia_archiver (+http://www.alexa.com/site/help/webmasters; [email protected])\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
	, `time` = '1412312999'

  WHERE `session_id` = 'bo8b859bprkqd6t47ouqak18t4'
```
Explication
EXPLAIN impossible sur la requête : UPDATE `jz6u8_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1412312957;s:18:\"session.timer.last\";i:1412312961;s:17:\"session.timer.now\";i:1412312999;s:24:\"session.client.forwarded\";s:15:\"204.236.235.245\";s:22:\"session.client.browser\";s:75:\"ia_archiver (+http://www.alexa.com/site/help/webmasters; [email protected])\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1412312999' WHERE `session_id` = 'bo8b859bprkqd6t47ouqak18t4'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:85
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

Tables sélectionnées :

6 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jz6u8_contentitem_tag_map` AS m  
  INNER JOIN `jz6u8_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

5 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM jz6u8_extensions

2 × 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 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,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM jz6u8_content AS a 
  LEFT JOIN jz6u8_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN jz6u8_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jz6u8_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jz6u8_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jz6u8_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jz6u8_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM jz6u8_categories AS cat JOIN jz6u8_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM jz6u8_categories as c 
  LEFT JOIN jz6u8_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM jz6u8_categories AS cat JOIN jz6u8_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT DISTINCT nom_produit_fr AS value 
  FROM jz6u8_cotation_produits

1 × SELECT DISTINCT nom_botanique AS value 
  FROM jz6u8_cotation_produits

1 × SELECT DISTINCT nom_plante_fr AS value 
  FROM jz6u8_cotation_produits

1 × SELECT id, rules 
  FROM `jz6u8_viewlevels

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

1 × SELECT m2.language, m2.id 
  FROM jz6u8_menu as m 
  INNER JOIN jz6u8_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item' 
  INNER JOIN jz6u8_associations as a2 
  ON a.key=a2.key 
  INNER JOIN jz6u8_menu as m2 
  ON a2.id=m2.id

1 × SELECT nom_plante_fr AS nom_plante,nom_botanique,origine_fr AS origine, photo 
  FROM jz6u8_cotation_produits

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

1 × SELECT DISTINCT cas_tsca AS value 
  FROM jz6u8_cotation_produits

1 × SELECT `data` 
  FROM `jz6u8_session`

1 × SELECT COUNT(*) 
  FROM `jz6u8_menu`

```
1 × SELECT * 
  FROM jz6u8_languages
```

1 × SELECT folder AS type, element AS name, params 
  FROM jz6u8_extensions

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

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

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS 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 jz6u8_content AS a 
  LEFT JOIN jz6u8_categories AS c 
  on c.id = a.catid 
  LEFT JOIN jz6u8_users AS u 
  on u.id = a.created_by 
  LEFT JOIN jz6u8_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jz6u8_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jz6u8_categories AS cat JOIN jz6u8_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

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

```
1 × SELECT * 
  FROM jz6u8_content
```

Autres tables :

1 × UPDATE `jz6u8_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1412312957;s:18:\"session.timer.last\";i:1412312961;s:17:\"session.timer.now\";i:1412312999;s:24:\"session.client.forwarded\";s:15:\"204.236.235.245\";s:22:\"session.client.browser\";s:75:\"ia_archiver (+http://www.alexa.com/site/help/webmasters; [email protected])\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'  , `time` = '1412312999'

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

1 × SHOW FULL COLUMNS 
  FROM `jz6u8_content

1 × UPDATE `jz6u8_extensions` 
  SET `params` = '{\"mediaversion\":\"d11cad2e49765761b5aca49ad44c6cc5\"}'

```
1 × DELETE  
  FROM `jz6u8_session`
```

DES ESSENCES PURES

Trouvez des ingrédients uniques pour sublimer vos créations!

Mot du président

À propos de nous...

Focus produits

Le mot de Georges

Informations

Société

Suivez nous

Console de débogage Joomla!

Session

__default

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

39 requêtes exécutées 34.1 ms

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

Tables sélectionnées :

Autres tables :