Toutes les permanences

TRIER_PAR :

Nom

44 RESULTATS

UNIAT

28 Rue du Faubourg de Saverne
67000 Strasbourg
03 88 15 00 05
uniat@uniat-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.

Sécurité sociale - L'assurance maladie - Bas-Rhin

SOS Aide aux Habitants

15 Rue Schlmeister
67100 Strasbourg
03 88 79 79 30
secretariat@sos-aide-aux-habitants.fr
SITE_WEB

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

Pôle d'équilibre territorial et rural - Bruche Mossig

Espace Info Energie - PETR Bruche Mossig

1 rue Gambrinus
67190 Mutzig
03 88 97 47 96
SITE_WEB

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

Inter CE

114 Grand Rue
67130 Schirmeck
03 88 47 14 61
ass.interce@orange.fr

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

Le Planning Familial 67

13 Rue du 22 Novembre
67000 Strasbourg
03 88 32 28 28
mfpf67@wanadoo.fr
SITE_WEB

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

Agence départementale d'information sur le logement

ADIL - Aide au logement

ADIL - aide au logement

5 rue Hannong
67000 Strasbourg
03 88 21 07 06
SITE_WEB

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

Colibri Bruche - Relais Assistants Maternels de la Vallée de la Bruche

Place du marché
Centre Médico Social
67130 Schirmeck
03 88 49 68 81
ram.colibri@orange.fr
SITE_WEB

La permanence a lieu au Centre Médico Social Place du Marché 67130 SCHIRMECK Bâtiment au fond de la Place du Marché (ancienne bibliothèque)

Pôle emploi

16b Rue Gaston Romazzotti
67129 Molsheim
3949
SITE_WEB

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

ADAR de la montagne

68a Rue de l'Eglise
67130 Schirmeck
03 88 97 08 94
adar.montagne@chambagri.fr
SITE_WEB

La permanence a lieu au 68a Rue de l'Eglise 67130 SCHIRMECK

CAF du Bas-Rhin

22 Route de l'hôpital
67092 Strasbourg cedex
3230
SITE_WEB

La permanence a lieu au Centre Médico Social Place du Marché
67130 SCHIRMECK
Bâtiment au fond de la Place du Marché (ancienne bibliothèque)

Centre d'information sur les droits de femmes et des famillles.

CIDFF - Droits des Femmes

Centre national d'information des droits des femme

24 Rue du 22 Novembre
67000 Strasbourg
03 88 32 03 22
cidff67.strasbourg@orange.fr
SITE_WEB

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

Bruche Emploi

114 Grand Rue
67130 Schirmeck
03 88 47 15 57
bruche.emploi@orange.fr
SITE_WEB

La permanence a lieu au rez-de-chaussée dans la salle Bureau Bruche Emploi

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": 1701956935,
                "last": 1701956935,
                "now": 1701956935
            },
            "token": "fmxnWXBpqaDpPh5IHWrbDhSLBSYeZUPW"
        },
        "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,66"
    },
    "__joomlei_liste": {
        "joomlei_listefiches": [
            "215003130",
            "215003136",
            "215003234",
            "215003066",
            "215004793",
            "215003131",
            "215003064",
            "215003235",
            "215003062",
            "215003204",
            "215003229",
            "215003063"
        ],
        "joomlei_liensfiches": [
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003130_uniat-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003136_sos-aide-aux-habitants-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003234_espace-info-energie-petr-bruche-mossig-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003066_inter-ce-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215004793_le-planning-familial-67-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003131_adil-aide-au-logement-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003064_colibri-bruche-relais-assistants-maternels-de-la-vallee-de-la-bruche-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003235_pole-emploi-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003062_adar-de-la-montagne-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003204_caf-du-bas-rhin-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003229_cidff-droits-des-femmes-.html",
            "/vivre-dans-la-vallee/maison-de-la-vallee/toutes-les-permanences/F215003063_bruche-emploi-.html"
        ],
        "joomlei_nomsfiches": [
            "UNIAT",
            "SOS Aide aux Habitants",
            "Espace Info Energie - PETR Bruche Mossig",
            "Inter CE",
            "Le Planning Familial 67",
            "ADIL - Aide au logement",
            "Colibri Bruche - Relais Assistants Maternels de la Vall\u00e9e de la Bruche",
            "P\u00f4le emploi",
            "ADAR de la montagne",
            "CAF du Bas-Rhin",
            "CIDFF - Droits des Femmes",
            "Bruche Emploi"
        ]
    }
}

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'716534356731727171317066333264316168616c307473706574', 1, 1701956935, 0, '', 0)

Profil

Status	Duration
Starting	0.06 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.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.96 ms
Closing tables	0.04 ms
Unlocking tables	0.01 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
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.31 ms Après la dernière requête : 4.43 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.05 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.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.07 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.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.26 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.053 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.04 ms
Checking permissions	0.00 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.05 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 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
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.33 ms Après la dernière requête : 27.79 ms Mémoire de requête : 0.021 MB mémoire avant requête : 7.224 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.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.03 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 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.21 ms Après la dernière requête : 10.58 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.572 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.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.02 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 : 4.11 ms Après la dernière requête : 17.90 ms Mémoire de requête : 0.006 MB mémoire avant requête : 11.928 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"6c411a90040a8689c3388bbab6899161\"}'

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

Explication

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

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.00 ms
Init for update	0.07 ms
Updating	0.05 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	3.83 ms
Closing tables	0.01 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
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.21 ms Après la dernière requête : 5.11 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.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.03 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.18 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.00 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.03 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.41 ms Après la dernière requête : 7.19 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.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: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.05 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.00 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.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.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.00 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.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.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.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.00 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.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
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.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.506 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.00 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: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.03 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.00 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: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.14 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.519 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.00 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: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.17 ms Après la dernière requête : 0.03 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.00 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.02 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.18 ms Après la dernière requête : 0.05 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.01 ms
Checking permissions	0.00 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.03 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.14 ms Après la dernière requête : 0.09 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.01 ms
Checking permissions	0.00 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: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.12 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.01 ms
Checking permissions	0.00 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.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: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.12 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.554 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.01 ms
Checking permissions	0.00 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.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 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.12 ms Après la dernière requête : 0.03 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.01 ms
Checking permissions	0.00 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.00 ms
Unlocking tables	0.01 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 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: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.31 ms Après la dernière requête : 0.90 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.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.03 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	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
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.08 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.55 ms Après la dernière requête : 0.44 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.04 ms
Optimizing	0.04 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.09 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.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.39 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.749 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.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.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.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.41 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.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.04 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.00 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.03 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.01 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.19 ms Après la dernière requête : 1.10 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.00 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
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 : 0.93 ms Après la dernière requête : 333.66 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.436 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.17 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	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.28 ms
Creating sort index	0.05 ms
Removing tmp table	0.06 ms
Creating sort index	0.02 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.72 ms Après la dernière requête : 1.14 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.499 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.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.02 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.02 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.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: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.07 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.511 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.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.10 ms
Statistics	0.07 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.04 ms
Creating sort index	0.02 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 : 2.23 ms Après la dernière requête : 1.47 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.540 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.06 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.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.65 ms Après la dernière requête : 0.79 ms Mémoire de requête : 0.035 MB mémoire avant requête : 15.560 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.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.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.04 ms
Creating sort index	0.02 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.72 ms Après la dernière requête : 0.68 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.572 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.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.23 ms
Creating sort index	0.05 ms
Removing tmp table	0.07 ms
Creating sort index	0.02 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.67 ms Après la dernière requête : 1.44 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.584 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.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.05 ms
Creating tmp table	0.02 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.02 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.65 ms Après la dernière requête : 0.77 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.597 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.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.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.02 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.79 ms Après la dernière requête : 0.67 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.608 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.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.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: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.05 ms Après la dernière requête : 1.38 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.619 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.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.18 ms
Creating sort index	0.03 ms
Removing tmp table	0.44 ms
Creating sort index	0.02 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.85 ms Après la dernière requête : 0.98 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.632 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.13 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.07 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.26 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.68 ms Après la dernière requête : 0.72 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.643 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.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.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 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.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.70 ms Après la dernière requête : 1.59 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.654 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.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.19 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.03 ms
Starting cleanup	0.00 ms
Freeing items	0.03 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.74 ms Après la dernière requête : 0.77 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.667 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.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.05 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.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: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.82 ms Après la dernière requête : 0.73 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.679 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.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.03 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.25 ms
Creating sort index	0.05 ms
Removing tmp table	0.07 ms
Creating sort index	0.02 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.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.69 ms Après la dernière requête : 1.43 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.691 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.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.05 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.02 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.69 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.705 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.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.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.03 ms
Removing tmp table	0.04 ms
Creating sort index	0.02 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.71 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.716 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.08 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.03 ms
Optimizing	0.02 ms
Statistics	0.03 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.23 ms
Creating sort index	0.05 ms
Removing tmp table	0.08 ms
Creating sort index	0.02 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.67 ms Après la dernière requête : 1.47 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.743 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.00 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.19 ms
Creating sort index	0.03 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: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.72 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.753 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.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.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.23 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.02 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.74 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.765 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.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.04 ms
Optimizing	0.02 ms
Statistics	0.03 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.23 ms
Creating sort index	0.05 ms
Removing tmp table	0.07 ms
Creating sort index	0.02 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.68 ms Après la dernière requête : 1.40 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.775 MB Rangées retournées : 8

Toutes les permanences

UNIAT

SOS Aide aux Habitants

Espace Info Energie - PETR Bruche Mossig

Inter CE

Le Planning Familial 67

ADIL - Aide au logement

Colibri Bruche - Relais Assistants Maternels de la Vallée de la Bruche

Pôle emploi

ADAR de la montagne

CAF du Bas-Rhin

CIDFF - Droits des Femmes

Bruche Emploi

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 41.70 ms

38 doubles découverts!

UNIAT

SOS Aide aux Habitants

Espace Info Energie - PETR Bruche Mossig

Inter CE

Le Planning Familial 67

ADIL - Aide au logement

Colibri Bruche - Relais Assistants Maternels de la Vallée de la Bruche

Pôle emploi

ADAR de la montagne

CAF du Bas-Rhin

CIDFF - Droits des Femmes

Bruche Emploi

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 41.70 ms

38 doubles découverts!