Toutes les permanences

TRIER_PAR :

Nom

44 RESULTATS

Conseil Départemental d'Accès au Droit (CDAD67)

Conseil départemental d'accès au droit

1 Quai Finkmatt
TGI de Strasbourg
67120 Molsheim
03 88 75 29 28
SITE_WEB

La permanence a lieu au rez-de-chaussée dans la salle Bureau Mission locale

Soliha Alsace

20 rue de Rosheim
67000 Strasbourg
03 90 41 40 90
contact.alsace@soliha.fr

La permanence a lieu au 2ème étage dans la salle Bureau de permanence 2 située à droite de l'escalier.

Sous Préfecture Arrondissement Molsheim

03 88 97 86 20
SITE_WEB

La permanence a lieu au 2ème étage dans la salle PIH 1 située à droite de l'escalier.

Caisse Primaire d'Assurance Maladie du Bas-Rhin

16 Rue de Lausanne
67090 Strasbourg Cedex
36 46
SITE_WEB

La permanence a lieu au 2ème étage dans la salle Bureau des permanences située à gauche de l'escalier.

Association Forestière de la Vallée de la Bruche

114 Grand Rue
67130 Schirmeck
06 07 72 71 99

La permanence a lieu

UTAMS secrétaire autonomie

16b Rue Gaston Romazzotti
Bâtiment le Veyron
67120 Molsheim
03 68 33 87 44
sandrine.gott@alsace.eu

La permanence a lieu au rez-de-chaussée dans la salle Bureau Mission locale

Chambre de Métiers d'Alsace

1 rue Gambrinus
Parc de la Brasserie
67190 Mutzig
03 88 38 44 90
fdesnauds@cm-alsace.fr
SITE_WEB

La permanence a lieu au 2ème étage dans la salle Salle de réunion située à droite de l'escalier.

SIVOM de la Vallée de la Bruche

114 Grand Rue
67130 Schirmeck
03 88 97 08 70
sivom.vallee.bruche@wanadoo.fr

La permanence a lieu au 2ème étage dans la salle Bureau SIVOM située à gauche de l'escalier.

Ecrivain public

03 68 33 89 00

La permanence a lieu au à Molsheim, à Schirmeck et à Saâles.

La Croix Bleue

Croix Bleue Alsace

06 12 60 73 79
SITE_WEB

La permanence a lieu

Inspection du travail

6 rue Gustave Adolphe Hirn
DIRECCTE ALSACE
67085 Strasbourg
03 88 75 86 86
alsace-ut67.uc3@direccte.gouv.fr
SITE_WEB

La permanence a lieu au 2e étage dans la salle Bureau de permanence 2 située à droite de l'escalier.

Alsace Habitat

SIBAR

3 rue Henri Meck
67120 Molsheim
03 88 04 68 20
SITE_WEB

La permanence a lieu au 2ème étage dans la salle Bureau Point Info Habitat située à droite de l'escalier.

Les partenaires de la Communauté de communes

Communes

Préfecture

PETR Bruche Mossig

Office de tourisme

Collectivité européenne d’Alsace

Région Grand-Est

Select'om

Proval

Scot de la bruche

ADIRA

Services public

CCI Alsace Eurométropole

Vallée de la Bruche

L'accueil est dans notre nature

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1701958569,
                "last": 1701958569,
                "now": 1701958569
            },
            "token": "ffo3GE7FVW2kqcAvr95PpbsPZOsXJjxu"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "fr-FR"
        },
        "com_zoo": {
            "zootrack": {
                "items": {
                    "current": null
                },
                "categories": {
                    "current": null
                }
            }
        }
    },
    "__joomlei": {
        "alea_session": "0,41"
    },
    "__joomlei_liste": {
        "joomlei_listefiches": [
            "215003875",
            "215003137",
            "215003449",
            "215003876",
            "215003226",
            "215003230",
            "215003014",
            "215003069",
            "215003878",
            "215004792",
            "215003231",
            "215003774"
        ],
        "joomlei_liensfiches": [
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003875_conseil-departemental-d-acces-au-droit-cdad67-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003137_soliha-alsace-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003449_sous-prefecture-arrondissement-molsheim-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003876_caisse-primaire-d-assurance-maladie-du-bas-rhin-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003226_association-forestiere-de-la-vallee-de-la-bruche-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003230_utams-secretaire-autonomie-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003014_chambre-de-metiers-d-alsace-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003069_sivom-de-la-vallee-de-la-bruche-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003878_ecrivain-public-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215004792_la-croix-bleue-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003231_inspection-du-travail-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003774_alsace-habitat-.html"
        ],
        "joomlei_nomsfiches": [
            "Conseil D\u00e9partemental d'Acc\u00e8s au Droit (CDAD67)",
            "Soliha Alsace",
            "Sous Pr\u00e9fecture Arrondissement Molsheim",
            "Caisse Primaire d'Assurance Maladie du Bas-Rhin",
            "Association Foresti\u00e8re de la Vall\u00e9e de la Bruche",
            "UTAMS secr\u00e9taire autonomie",
            "Chambre de M\u00e9tiers d'Alsace",
            "SIVOM de la Vall\u00e9e de la Bruche",
            "Ecrivain public",
            "La Croix Bleue",
            "Inspection du travail",
            "Alsace Habitat"
        ]
    }
}

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

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

EXPLAIN impossible sur la requête : INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'693937646b6e70666332646332646f347530636c656836397065', 1, 1701958569, 0, '', 0)

Profil

Status	Duration
Starting	0.03 ms
Checking permissions	0.02 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init for update	0.01 ms
Update	0.06 ms
Waiting for query cache lock	0.01 ms
Update	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.82 ms
Closing tables	0.04 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
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.37 ms Après la dernière requête : 4.52 ms Mémoire de requête : 0.031 MB mémoire avant requête : 4.003 MB Rangées retournées : 136

SELECT id, rules

  FROM `jos_viewlevels`

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	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	1	Using where; Using index

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

SELECT * 
  FROM jos_virtualdomain
				  
  WHERE `domain` = 'cc.valleedelabruche.fr'

Explication

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

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/virtualdomains/virtualdomains.php:164
9	plgSystemVirtualdomains->_getCurrentDomain()	JROOT/plugins/system/virtualdomains/virtualdomains.php:89
8	plgSystemVirtualdomains->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:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.17 ms Après la dernière requête : 10.92 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.573 MB Rangées retournées : 32

SELECT *

  FROM jos_rsform_config

Explication

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->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:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.27 ms Après la dernière requête : 19.01 ms Mémoire de requête : 0.006 MB mémoire avant requête : 11.928 MB

UPDATE `jos_extensions`

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

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

Explication

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

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init for update	0.06 ms
Updating	0.09 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.88 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:1168
8	plgSystemGdpr->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.28 ms Après la dernière requête : 6.08 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.612 MB Rangées retournées : 1

Requêtes dupliquées: #9

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
13	JoomleiModelParametress->getParametre()	JROOT/components/com_joomlei/helpers/jdncaddons.php:440
12	JDncAddons::get_urlasp()	JROOT/administrator/components/com_joomlei/defines.php:153
11	require JROOT/administrator/components/com_joomlei/defines.php	JROOT/components/com_joomlei/helpers/jdncaddons.php:5
10	include_once JROOT/components/com_joomlei/helpers/jdncaddons.php	JROOT/libraries/loader.php:260
9	JLoader::load()	Même appel que celui de la ligne ci-dessous.
8	spl_autoload_call()	JROOT/administrator/components/com_joomlei/defines.php:153
7	include JROOT/administrator/components/com_joomlei/defines.php	JROOT/components/com_joomlei/joomlei.php:15
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #8

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
9	JoomleiModelParametress->getParametre()	JROOT/components/com_joomlei/helpers/jdncaddons.php:440
8	JDncAddons::get_urlasp()	JROOT/administrator/components/com_joomlei/defines.php:153
7	include JROOT/administrator/components/com_joomlei/defines.php	JROOT/components/com_joomlei/joomlei.php:15
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=150

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:68
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=33

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:89
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=34

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:90
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=35

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:91
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=36

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:92
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=37

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:93
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=38

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:94
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=39

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:95
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=40

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:96
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=41

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:97
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=42

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:98
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=43

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:101
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM jos_joomlei_parametres as p 
  WHERE p.numero=45

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	numero_unique_params	numero_unique_params	4	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:102
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.20 ms Après la dernière requête : 0.81 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.612 MB Rangées retournées : 1

SELECT * 
  FROM jos_joomlei_champsdetri 
  WHERE id = 6

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_joomlei_champsdetri	const	PRIMARY	PRIMARY	8	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomlei/models/champsdetri.php:57
12	JoomleiModelChampsdetri->getData()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:501
11	JoomleiFrontHelper->getListe()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:151
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.16 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.619 MB Rangées retournées : 1

SELECT * 
  FROM jos_joomlei_champsdetri 
  WHERE id = 2

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_joomlei_champsdetri	const	PRIMARY	PRIMARY	8	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomlei/models/champsdetri.php:57
12	JoomleiModelChampsdetri->getData()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:545
11	JoomleiFrontHelper->getListe()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:151
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.50 ms Après la dernière requête : 0.46 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.731 MB Rangées retournées : 20

SELECT DISTINCT el.critere as crit 
  FROM jos_joomlei_groupesdonnees AS g  
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)  
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)  
  WHERE g.id=1 
  AND el.critere IS NOT NULL  UNION SELECT DISTINCT el.critere_legende as crit  
  FROM jos_joomlei_groupesdonnees AS g  
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)  
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)  
  WHERE g.id=1 
  AND el.critere IS NOT NULL

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	g	const	PRIMARY	PRIMARY	8	const	1	Using index; Using temporary
1	PRIMARY	ch	ref	PRIMARY,FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	10	Using index
1	PRIMARY	el	ref	FK_jos_joomlei_elementsdonnees_1,jos_joomlei_elementsdonnees_idx_critere	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
2	UNION	g	const	PRIMARY	PRIMARY	8	const	1	Using index; Using temporary
2	UNION	ch	ref	PRIMARY,FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	10	Using index
2	UNION	el	ref	FK_jos_joomlei_elementsdonnees_1,jos_joomlei_elementsdonnees_idx_critere	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
NULL	UNION RESULT	<union1,2>	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.03 ms
Removing tmp table	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:284
12	JoomleiModelGroupesdonneess->getListeCriteres()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:581
11	JoomleiFrontHelper->getListe()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:151
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.46 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.750 MB Rangées retournées : 5

SELECT DISTINCT el.critere as crit 
  FROM jos_joomlei_groupesdonnees AS g  
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)  
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)  
  WHERE g.id=3 
  AND el.critere IS NOT NULL  UNION SELECT DISTINCT el.critere_legende as crit  
  FROM jos_joomlei_groupesdonnees AS g  
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)  
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)  
  WHERE g.id=3 
  AND el.critere IS NOT NULL

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	g	const	PRIMARY	PRIMARY	8	const	1	Using index; Using temporary
1	PRIMARY	ch	ref	PRIMARY,FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	5	Using index
1	PRIMARY	el	ref	FK_jos_joomlei_elementsdonnees_1,jos_joomlei_elementsdonnees_idx_critere	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
2	UNION	g	const	PRIMARY	PRIMARY	8	const	1	Using index; Using temporary
2	UNION	ch	ref	PRIMARY,FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	5	Using index
2	UNION	el	ref	FK_jos_joomlei_elementsdonnees_1,jos_joomlei_elementsdonnees_idx_critere	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
NULL	UNION RESULT	<union1,2>	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL

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.02 ms
Table lock	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.03 ms
Removing tmp table	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:284
12	JoomleiModelGroupesdonneess->getListeCriteres()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:581
11	JoomleiFrontHelper->getListe()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:151
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.37 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.750 MB Rangées retournées : 4

SELECT DISTINCT el.critere as crit 
  FROM jos_joomlei_groupesdonnees AS g  
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)  
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)  
  WHERE g.id=42000005 
  AND el.critere IS NOT NULL  UNION SELECT DISTINCT el.critere_legende as crit  
  FROM jos_joomlei_groupesdonnees AS g  
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)  
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)  
  WHERE g.id=42000005 
  AND el.critere IS NOT NULL

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	g	const	PRIMARY	PRIMARY	8	const	1	Using index; Using temporary
1	PRIMARY	ch	ref	PRIMARY,FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	1	Using index
1	PRIMARY	el	ref	FK_jos_joomlei_elementsdonnees_1,jos_joomlei_elementsdonnees_idx_critere	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
2	UNION	g	const	PRIMARY	PRIMARY	8	const	1	Using index; Using temporary
2	UNION	ch	ref	PRIMARY,FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	1	Using index
2	UNION	el	ref	FK_jos_joomlei_elementsdonnees_1,jos_joomlei_elementsdonnees_idx_critere	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
NULL	UNION RESULT	<union1,2>	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
Removing tmp table	0.00 ms
Sending data	0.01 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:284
12	JoomleiModelGroupesdonneess->getListeCriteres()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:581
11	JoomleiFrontHelper->getListe()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:151
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT t.* 
  FROM jos_joomlei_typesdemulticrit AS t 
  WHERE t.id=2

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	const	PRIMARY	PRIMARY	8	const	1

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:254
13	JoomleiGenericHelper->construit_url_xml()	JROOT/administrator/components/com_joomlei/models/listeproduits.php:88
12	JoomleiModelListeproduits->getData()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:732
11	JoomleiFrontHelper->getListe()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:151
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.69 ms Après la dernière requête : 326.85 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.444 MB Rangées retournées : 8

Requêtes dupliquées: #32 #35 #38 #41 #44 #47 #50 #53 #56 #59 #62

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=42000005 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	1
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.16 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.23 ms
Creating sort index	0.04 ms
Removing tmp table	0.07 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:10
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.11 ms Après la dernière requête : 1.07 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.506 MB Rangées retournées : 10

Requêtes dupliquées: #33 #36 #39 #42 #45 #48 #51 #54 #57 #60 #63

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=1 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	10
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.04 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.20 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:351
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.93 ms Après la dernière requête : 0.61 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.518 MB Rangées retournées : 21

Requêtes dupliquées: #34 #37 #40 #43 #46 #49 #52 #55 #58 #61 #64

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=3 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	5
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.29 ms
Creating sort index	0.05 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:433
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.97 ms Après la dernière requête : 1.61 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.546 MB Rangées retournées : 8

Requêtes dupliquées: #29 #35 #38 #41 #44 #47 #50 #53 #56 #59 #62

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=42000005 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	1
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.17 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:10
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 5.09 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.035 MB mémoire avant requête : 15.568 MB Rangées retournées : 10

Requêtes dupliquées: #30 #36 #39 #42 #45 #48 #51 #54 #57 #60 #63

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=1 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	10
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.20 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:351
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.03 ms Après la dernière requête : 0.63 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.581 MB Rangées retournées : 21

Requêtes dupliquées: #31 #37 #40 #43 #46 #49 #52 #55 #58 #61 #64

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=3 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	5
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.24 ms
Creating sort index	0.05 ms
Removing tmp table	0.08 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:433
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.24 ms Après la dernière requête : 1.56 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.593 MB Rangées retournées : 8

Requêtes dupliquées: #29 #32 #38 #41 #44 #47 #50 #53 #56 #59 #62

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=42000005 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	1
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.17 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:10
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 4.13 ms Après la dernière requête : 0.75 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.606 MB Rangées retournées : 10

Requêtes dupliquées: #30 #33 #39 #42 #45 #48 #51 #54 #57 #60 #63

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=1 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	10
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.18 ms
Creating sort index	0.03 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:351
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.13 ms Après la dernière requête : 0.81 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.617 MB Rangées retournées : 21

Requêtes dupliquées: #31 #34 #40 #43 #46 #49 #52 #55 #58 #61 #64

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=3 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	5
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.20 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.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.06 ms
Removing tmp table	0.08 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:433
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.75 ms Après la dernière requête : 2.02 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.629 MB Rangées retournées : 8

Requêtes dupliquées: #29 #32 #35 #41 #44 #47 #50 #53 #56 #59 #62

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=42000005 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	1
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.11 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.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.18 ms
Creating sort index	0.04 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:10
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.75 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.643 MB Rangées retournées : 10

Requêtes dupliquées: #30 #33 #36 #42 #45 #48 #51 #54 #57 #60 #63

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=1 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	10
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.20 ms
Creating sort index	0.04 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:351
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.73 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.654 MB Rangées retournées : 21

Requêtes dupliquées: #31 #34 #37 #43 #46 #49 #52 #55 #58 #61 #64

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=3 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	5
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.22 ms
Creating sort index	0.05 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:433
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.69 ms Après la dernière requête : 1.66 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.663 MB Rangées retournées : 8

Requêtes dupliquées: #29 #32 #35 #38 #44 #47 #50 #53 #56 #59 #62

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=42000005 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	1
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:10
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.67 ms Après la dernière requête : 0.71 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.671 MB Rangées retournées : 10

Requêtes dupliquées: #30 #33 #36 #39 #45 #48 #51 #54 #57 #60 #63

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=1 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	10
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.19 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:351
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.76 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.682 MB Rangées retournées : 21

Requêtes dupliquées: #31 #34 #37 #40 #46 #49 #52 #55 #58 #61 #64

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=3 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	5
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.26 ms
Creating sort index	0.05 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:433
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.70 ms Après la dernière requête : 1.34 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.694 MB Rangées retournées : 8

Requêtes dupliquées: #29 #32 #35 #38 #41 #47 #50 #53 #56 #59 #62

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=42000005 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	1
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.19 ms
Creating sort index	0.04 ms
Removing tmp table	0.05 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:10
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #30 #33 #36 #39 #42 #48 #51 #54 #57 #60 #63

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=1 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	10
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.18 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:351
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.69 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.723 MB Rangées retournées : 21

Requêtes dupliquées: #31 #34 #37 #40 #43 #49 #52 #55 #58 #61 #64

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=3 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	5
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
Creating sort index	0.05 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:433
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.63 ms Après la dernière requête : 1.39 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.749 MB Rangées retournées : 8

Requêtes dupliquées: #29 #32 #35 #38 #41 #44 #50 #53 #56 #59 #62

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=42000005 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	1
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.16 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:10
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.71 ms Après la dernière requête : 0.78 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.765 MB Rangées retournées : 10

Requêtes dupliquées: #30 #33 #36 #39 #42 #45 #51 #54 #57 #60 #63

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=1 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	10
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
Creating sort index	0.05 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:351
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.76 ms Après la dernière requête : 0.60 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.776 MB Rangées retournées : 21

Requêtes dupliquées: #31 #34 #37 #40 #43 #46 #52 #55 #58 #61 #64

SELECT
		g.id as idgroupedonnee, g.champ as nomgroupedonnee, g.typegroupe as typegroupedonnee, g.classecrit as numclassegroupedonnee,
		ch.id as idchampsdonnee, ch.champ as nomchampdonnee, IF(t.contenu<>'null',t.contenu, ch.intitule) as intitulechampdonnee, ch.ordre as ordrechampdonnee, ch.type_champ as typechampdonnee, ch.separateur as separateurchampdonnee,
		ch.classecss as classecss_champ, ch.dataattributes as dataattributes_champ, ch.childrenclassecss as childrenclassecss_champ, ch.icon as icon_champ, ch.childrenicons as childrenicons, 
                el.icon as icon_element, el.classecss as classecss_element,
                el.id as idelementdonnee, el.critere as critereelementdonnee, el.modalite as modaliteelementdonnee, el.critere_legende as critere_legendeelementdonnee, el.modalite_legende as modalite_legendeelementdonnee, el.valeur as valeurelementdonnee,
		IF(tc.contenu<>'null',tc.contenu, el.intitule) as intituleelementdonnee,
		el.ordre as ordreelementdonnee, el.type_affichage as typeelementdonnee,
		el.separateur as separateurelementdonnee, el.fonction as fonctionelementdonnee,
		el.condition as conditionelementdonnee
		
  FROM jos_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN jos_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN jos_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='jos_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='jos_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=3 
  ORDER BY ch.ordre, ch.id, el.ordre, el.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	const	PRIMARY	PRIMARY	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	ch	ref	FK_jos_joomlei_champsdonnees	FK_jos_joomlei_champsdonnees	8	const	5
1	SIMPLE	el	ref	FK_jos_joomlei_elementsdonnees_1	FK_jos_joomlei_elementsdonnees_1	8	ccbruche.ch.id	1	Using where
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where
1	SIMPLE	tc	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.22 ms
Creating sort index	0.05 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php:433
14	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php:198
13	include JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/liste.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.65 ms Après la dernière requête : 1.39 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.787 MB Rangées retournées : 8

Toutes les permanences

Conseil Départemental d'Accès au Droit (CDAD67)

Soliha Alsace

Sous Préfecture Arrondissement Molsheim

Caisse Primaire d'Assurance Maladie du Bas-Rhin

Association Forestière de la Vallée de la Bruche

UTAMS secrétaire autonomie

Chambre de Métiers d'Alsace

SIVOM de la Vallée de la Bruche

Ecrivain public

La Croix Bleue

Inspection du travail

Alsace Habitat

Les partenaires de la Communauté de communes

Vallée de la Bruche

L'accueil est dans notre nature

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

70 requêtes exécutées 48.20 ms

38 doubles découverts!

Conseil Départemental d'Accès au Droit (CDAD67)

Soliha Alsace

Sous Préfecture Arrondissement Molsheim

Caisse Primaire d'Assurance Maladie du Bas-Rhin

Association Forestière de la Vallée de la Bruche

UTAMS secrétaire autonomie

Chambre de Métiers d'Alsace

SIVOM de la Vallée de la Bruche

Ecrivain public

La Croix Bleue

Inspection du travail

Alsace Habitat

Les partenaires de la Communauté de communes

Vallée de la Bruche

L'accueil est dans notre nature

Au service de votre vie quotidienne

Un développement économique à porter de main

La CcVB à votre écoute

Développer ses sens

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

70 requêtes exécutées 48.20 ms

38 doubles découverts!