Activités associatives

Yoga

Yoga' riane

2 place des Sports
67130 Wisches
06 26 61 32 94
catherine.schaub@hotmail.fr

Zumba

Gym à Natz

06 72 38 46 08
vir.piquet@gmail.com

Zumba

Le Repère

06 77 32 90 24

Zumba

MJC - Barembach

Zumba et danse kids

Association BENKADY

07 60 07 47 96
associationbenkady@gmail.com

Zumba fitness

ZUMBA MOOVIN'

Zumba fitness

Association BENKADY

Zumba kids

Mjc Barembach

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": 1701957226,
                "last": 1701957226,
                "now": 1701957226
            },
            "token": "jnepw6aBMCK2KBnuTmSZq77bd4JY77XU"
        },
        "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,9"
    },
    "__joomlei_liste": {
        "joomlei_listefiches": [
            "215003571",
            "215003575",
            "215003572",
            "215003576",
            "215003577",
            "215003574",
            "215003573",
            "215003578"
        ],
        "joomlei_liensfiches": [
            "/vivre-dans-la-vallee/les-services-de-proximite/jeunesse/activites-associatives/F215003571_yoga-.html",
            "/vivre-dans-la-vallee/les-services-de-proximite/jeunesse/activites-associatives/F215003575_zumba-.html",
            "/vivre-dans-la-vallee/les-services-de-proximite/jeunesse/activites-associatives/F215003572_zumba-.html",
            "/vivre-dans-la-vallee/les-services-de-proximite/jeunesse/activites-associatives/F215003576_zumba-.html",
            "/vivre-dans-la-vallee/les-services-de-proximite/jeunesse/activites-associatives/F215003577_zumba-et-danse-kids-.html",
            "/vivre-dans-la-vallee/les-services-de-proximite/jeunesse/activites-associatives/F215003574_zumba-fitness-.html",
            "/vivre-dans-la-vallee/les-services-de-proximite/jeunesse/activites-associatives/F215003573_zumba-fitness-.html",
            "/vivre-dans-la-vallee/les-services-de-proximite/jeunesse/activites-associatives/F215003578_zumba-kids-.html"
        ],
        "joomlei_nomsfiches": [
            "Yoga",
            "Zumba",
            "Zumba",
            "Zumba",
            "Zumba et danse kids",
            "Zumba fitness",
            "Zumba fitness",
            "Zumba kids"
        ]
    }
}

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

Status	Duration
Starting	0.11 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 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.01 ms

#	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'6a366931356f736365387671317663657174666a6d666e697639', 1, 1701957226, 0, '', 0)

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.00 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	13.17 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.04 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.27 ms Après la dernière requête : 4.28 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.04 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 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.32 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.054 MB Rangées retournées : 1

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 1

Explication

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

Profil

Status	Duration
Starting	0.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.03 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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.37 ms Après la dernière requête : 34.82 ms Mémoire de requête : 0.021 MB mémoire avant requête : 7.225 MB Rangées retournées : 0

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

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 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.23 ms Après la dernière requête : 13.70 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.573 MB Rangées retournées : 32

SELECT *

  FROM jos_rsform_config

Explication

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

Profil

Status	Duration
Starting	0.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.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"8b8d72953fcd33233e4befc1a19194b0\"}'

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

Explication

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

Profil

Status	Duration
Starting	0.06 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 for update	0.09 ms
Updating	0.10 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.92 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
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.33 ms Après la dernière requête : 5.76 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.612 MB Rangées retournées : 1

Requêtes dupliquées: #9

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

Explication

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

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 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.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.02 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: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.30 ms Après la dernière requête : 0.09 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.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 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
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.25 ms Après la dernière requête : 10.60 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=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.04 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 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
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.01 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
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.20 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=34

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php: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.493 MB Rangées retournées : 1

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

Explication

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 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.41 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=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.09 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 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
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.20 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=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.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.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.19 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.513 MB Rangées retournées : 1

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php: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.22 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.520 MB Rangées retournées : 1

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

Explication

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.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: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.20 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.528 MB Rangées retournées : 1

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php: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.21 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.535 MB Rangées retournées : 1

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

Explication

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.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.02 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.23 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.542 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.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
12	JoomleiModelParametress->getParametre()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:743
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php: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.22 ms Après la dernière requête : 0.07 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=43

Explication

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	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.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.17 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.555 MB Rangées retournées : 1

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

Explication

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 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: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.23 ms Après la dernière requête : 1.06 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.605 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.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.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.65 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.616 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.01 ms
Table lock	0.07 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.04 ms
Removing tmp table	0.01 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.01 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.02 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.64 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.634 MB Rangées retournées : 5

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

Explication

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

Profil

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

Pile d'appels

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

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.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.02 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.36 ms Après la dernière requête : 272.49 ms Mémoire de requête : 0.025 MB mémoire avant requête : 14.095 MB Rangées retournées : 1

SELECT p.id, p.ordering, p.published, IF(t.contenu<>'null',t.contenu, p.name) as name, p.classe_css, p.modeaff, p.modeaff, p.datcre, p.proprietaire, p.datmaj, p.modified_by, p.entite, p.marquage 
  FROM jos_joomlei_moteurs as p 
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  ON (p.id = t.idref 
  and t.tableref='jos_joomlei_moteurs' 
  and t.langue='fr') 
  WHERE p.id = 42000002 
  ORDER BY ordering;

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	8	const	1
1	SIMPLE	t	ref	PRIMARY,dnctraduction_contenus_idx_idref	PRIMARY	4	const	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.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomlei/models/moteurs.php:68
15	JoomleiModelMoteurs->getData()	JROOT/modules/mod_joomleimoteur/helper.php:38
14	modJoomleiMoteurHelper->getTableau()	JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php:211
13	include JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:381
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.04 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.103 MB Rangées retournées : 0

SELECT DISTINCT e.valeur  
  FROM jos_joomlei_zonesmoteur as z 
  INNER JOIN  jos_joomlei_souszonesmoteur as s 
  ON z.id=s.zone 
  INNER JOIN  jos_joomlei_groupesmoteur as g 
  ON s.id=g.souszone 
  INNER JOIN  jos_joomlei_elementmoteur as e 
  on g.id=e.idgroupe  
  WHERE z.moteur=42000002 
  and INSTR(g.typectrl,'dyn') > 0  
  and g.champ='elcriterio'  
  and z.published=1 
  and s.published=1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z	ref	PRIMARY,FK_jos_joomlei_zonesmoteur_1	FK_jos_joomlei_zonesmoteur_1	9	const	1	Using where; Using temporary
1	SIMPLE	s	ALL	PRIMARY,FK_jos_joomlei_souszonesmoteur_1	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where
1	SIMPLE	g	ALL	PRIMARY,FK_jos_joomlei_groupesmoteur_1,FK_jos_joomlei_groupesmoteur_2	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Using where
1	SIMPLE	e	ref	FK_jos_joomlei_elementmoteur_2	FK_jos_joomlei_elementmoteur_2	9	ccbruche.g.id	7

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.00 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
Removing tmp table	0.01 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.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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/modules/mod_joomleimoteur/helper.php:57
14	modJoomleiMoteurHelper->getTableau()	JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php:211
13	include JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:381
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.47 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.024 MB mémoire avant requête : 14.114 MB Rangées retournées : 1

SELECT p.*, IF(t.contenu<>'null',t.contenu, p.intit_fr) as intitule  
  FROM jos_joomlei_zonesmoteur as p 
  LEFT 
  OUTER JOIN dnctraduction_contenus as t  
  ON (p.id = t.idref 
  and t.tableref='jos_joomlei_zonesmoteur' 
  and t.langue='fr')  
  WHERE moteur=42000002 
  and p.published=1  
  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ref	FK_jos_joomlei_zonesmoteur_1	FK_jos_joomlei_zonesmoteur_1	9	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

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.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.15 ms
Creating sort index	0.02 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_joomleimoteur/helper.php:96
14	modJoomleiMoteurHelper->getTableau()	JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php:211
13	include JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:381
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.45 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 14.124 MB Rangées retournées : 1

SELECT p.*,IF(t.contenu<>'null',t.contenu, p.intit_fr) as intitule 
  FROM jos_joomlei_souszonesmoteur as p 
  LEFT 
  OUTER JOIN dnctraduction_contenus as t  
  ON (p.id = t.idref 
  and t.tableref='jos_joomlei_souszonesmoteur' 
  and t.langue='fr')  
  WHERE zone=42000002 
  and p.published=1  
  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ref	FK_jos_joomlei_souszonesmoteur_1	FK_jos_joomlei_souszonesmoteur_1	8	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

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.04 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.13 ms
Creating sort index	0.02 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_joomleimoteur/helper.php:119
14	modJoomleiMoteurHelper->getTableau()	JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php:211
13	include JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:381
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.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 14.134 MB Rangées retournées : 1

SELECT p.*, IF(t.contenu<>'null',t.contenu, p.nom) as intitule  
  FROM jos_joomlei_groupesmoteur as p  
  LEFT 
  OUTER JOIN dnctraduction_contenus as t  
  ON (p.id = t.idref 
  and t.tableref='jos_joomlei_groupesmoteur' 
  and t.langue='fr')  
  WHERE p.souszone=42000002 
  ORDER BY p.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ref	FK_jos_joomlei_groupesmoteur_2	FK_jos_joomlei_groupesmoteur_2	8	const	1	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_joomleimoteur/helper.php:137
14	modJoomleiMoteurHelper->getTableau()	JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php:211
13	include JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:381
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.04 ms Mémoire de requête : 0.031 MB mémoire avant requête : 14.144 MB Rangées retournées : 24

SELECT p.*,IF(t.contenu<>'null',t.contenu, p.intitule_fr) as intitule 
  FROM jos_joomlei_elementmoteur as p 
  LEFT 
  OUTER JOIN dnctraduction_contenus as t  
  ON (p.id = t.idref 
  and t.tableref='jos_joomlei_elementmoteur' 
  and t.langue='fr')  
  WHERE idgroupe=42000002 
  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ref	FK_jos_joomlei_elementmoteur_2	FK_jos_joomlei_elementmoteur_2	9	const	24	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	t	ALL	PRIMARY,dnctraduction_contenus_idx_idref	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.03 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.02 ms
Optimizing	0.01 ms
Statistics	0.02 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.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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_joomleimoteur/helper.php:160
14	modJoomleiMoteurHelper->getTableau()	JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php:211
13	include JROOT/modules/mod_joomleimoteur/mod_joomleimoteur.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:381
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.81 ms Après la dernière requête : 15.51 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.634 MB Rangées retournées : 10

Requêtes dupliquées: #34 #36 #38 #40 #42 #44 #46

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.00 ms
Table lock	0.00 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.22 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.71 ms Après la dernière requête : 0.76 ms Mémoire de requête : 0.039 MB mémoire avant requête : 15.755 MB Rangées retournées : 21

Requêtes dupliquées: #35 #37 #39 #41 #43 #45 #47

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.22 ms
Creating sort index	0.07 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

Requêtes dupliquées: #32 #36 #38 #40 #42 #44 #46

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.25 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.70 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.781 MB Rangées retournées : 21

Requêtes dupliquées: #33 #37 #39 #41 #43 #45 #47

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.02 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.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
Creating sort index	0.05 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

Requêtes dupliquées: #32 #34 #38 #40 #42 #44 #46

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

Pile d'appels

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

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

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

Requêtes dupliquées: #33 #35 #39 #41 #43 #45 #47

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.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.21 ms
Creating sort index	0.05 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.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: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.57 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.836 MB Rangées retournées : 10

Requêtes dupliquées: #32 #34 #36 #40 #42 #44 #46

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1481
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yoo_salt/html/com_joomlei/listeproduits/mosaic_fiche.php: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.51 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.847 MB Rangées retournées : 21

Requêtes dupliquées: #33 #35 #37 #41 #43 #45 #47

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.05 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.25 ms
Creating sort index	0.06 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

Requêtes dupliquées: #32 #34 #36 #38 #42 #44 #46

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

Explication

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

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.18 ms
Creating sort index	0.03 ms
Removing tmp table	0.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.71 ms Après la dernière requête : 0.56 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.871 MB Rangées retournées : 21

Requêtes dupliquées: #33 #35 #37 #39 #43 #45 #47

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.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.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.02 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.66 ms Après la dernière requête : 1.55 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.884 MB Rangées retournées : 10

Requêtes dupliquées: #32 #34 #36 #38 #40 #44 #46

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

Pile d'appels

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

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

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

Requêtes dupliquées: #33 #35 #37 #39 #41 #45 #47

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.03 ms
Preparing	0.02 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
Creating sort index	0.05 ms
Removing tmp table	0.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.71 ms Après la dernière requête : 1.53 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.910 MB Rangées retournées : 10

Requêtes dupliquées: #32 #34 #36 #38 #40 #42 #46

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.00 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.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.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 : 0.70 ms Après la dernière requête : 0.51 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.921 MB Rangées retournées : 21

Requêtes dupliquées: #33 #35 #37 #39 #41 #43 #47

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.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.21 ms
Creating sort index	0.05 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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.51 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.934 MB Rangées retournées : 10

Requêtes dupliquées: #32 #34 #36 #38 #40 #42 #44

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.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.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: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.70 ms Après la dernière requête : 0.50 ms Mémoire de requête : 0.038 MB mémoire avant requête : 15.946 MB Rangées retournées : 21

Requêtes dupliquées: #33 #35 #37 #39 #41 #43 #45

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.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Creating tmp table	0.04 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.04 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

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

SELECT params 
  FROM jos_extensions AS e 
  WHERE e.element='com_widgetkit'

Explication

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

Profil

Status	Duration
Starting	0.03 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.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.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:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:254
13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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 : 4.43 ms Mémoire de requête : 0.020 MB mémoire avant requête : 16.430 MB Rangées retournées : 0

SELECT id,placeholder

  FROM `jos_gdpr_checkbox`

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_gdpr_checkbox	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	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.00 ms
Statistics	0.01 ms
Preparing	0.03 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.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
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/gdpr/gdpr.php:1433
7	plgSystemGdpr->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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 : 0.05 ms Mémoire de requête : 0.020 MB mémoire avant requête : 16.435 MB Rangées retournées : 1

SELECT language,id

  FROM `jos_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explication

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

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.01 ms
Executing	0.00 ms
Sending data	0.15 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.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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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 : 0.85 ms Mémoire de requête : 0.021 MB mémoire avant requête : 16.520 MB Rangées retournées : 0

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

  FROM `jos_menu` AS `c`

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

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

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

  WHERE c.id = 711

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.027 MB mémoire avant requête : 16.591 MB Rangées retournées : 54

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

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_contactenhanced','com_content','com_contenthistory','com_cpanel','com_dnctraduction','com_dnctraduction2','com_fields','com_finder','com_gdpr','com_installer','com_jce','com_joomlaupdate','com_joomlei','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mijopolls','com_modules','com_newsfeeds','com_pfforum','com_pfprojects','com_pfrepo','com_pftasks','com_pfusers','com_plugins','com_postinstall','com_privacy','com_projectfork','com_redirect','com_regularlabsmanager','com_rsform','com_rstbox','com_search','com_tags','com_templates','com_users','com_virtualdomains','com_weblinks','com_widgetkit','com_wrapper','com_zoo')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_assets	range	idx_asset_name	idx_asset_name	202	NULL	56	Using index condition

Profil

Status	Duration
Starting	0.05 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.05 ms
Optimizing	0.01 ms
Statistics	0.12 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.31 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.00 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/Access/Access.php:429
13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
9	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_rstbox/helpers/helper.php:269
8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select b.* 
  from jos_rstbox b 
  where b.published = 1  
  AND b.testmode=0

Explication

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

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.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.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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/helper.php:283
8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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]

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

Tables sélectionnées :

16 × 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')

14 × SELECT p.valeur 
  FROM jos_joomlei_parametres as p

2 × 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)

1 × SELECT `session_id` 
  FROM `jos_session`

1 × SELECT p.*, IF(t.contenu<>'null',t.contenu, p.nom) as intitule  
  FROM jos_joomlei_groupesmoteur as p  
  LEFT 
  OUTER JOIN dnctraduction_contenus as t  
  ON (p.id = t.idref 
  and t.tableref='jos_joomlei_groupesmoteur' 
  and t.langue='fr')

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jos_assets`

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `jos_menu` AS `c` 
  INNER JOIN `jos_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `jos_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `jos_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT language,id 
  FROM `jos_menu`

1 × SELECT id,placeholder 
  FROM `jos_gdpr_checkbox

1 × SELECT params 
  FROM jos_extensions AS e

1 × SELECT p.*,IF(t.contenu<>'null',t.contenu, p.intitule_fr) as intitule 
  FROM jos_joomlei_elementmoteur as p 
  LEFT 
  OUTER JOIN dnctraduction_contenus as t  
  ON (p.id = t.idref 
  and t.tableref='jos_joomlei_elementmoteur' 
  and t.langue='fr')

1 × SELECT p.*, IF(t.contenu<>'null',t.contenu, p.intit_fr) as intitule  
  FROM jos_joomlei_zonesmoteur as p 
  LEFT 
  OUTER JOIN dnctraduction_contenus as t  
  ON (p.id = t.idref 
  and t.tableref='jos_joomlei_zonesmoteur' 
  and t.langue='fr')

1 × SELECT p.*,IF(t.contenu<>'null',t.contenu, p.intit_fr) as intitule 
  FROM jos_joomlei_souszonesmoteur as p 
  LEFT 
  OUTER JOIN dnctraduction_contenus as t  
  ON (p.id = t.idref 
  and t.tableref='jos_joomlei_souszonesmoteur' 
  and t.langue='fr')

1 × SELECT id, rules 
  FROM `jos_viewlevels

1 × SELECT DISTINCT e.valeur  
  FROM jos_joomlei_zonesmoteur as z 
  INNER JOIN  jos_joomlei_souszonesmoteur as s 
  ON z.id=s.zone 
  INNER JOIN  jos_joomlei_groupesmoteur as g 
  ON s.id=g.souszone 
  INNER JOIN  jos_joomlei_elementmoteur as e 
  on g.id=e.idgroupe

1 × SELECT p.id, p.ordering, p.published, IF(t.contenu<>'null',t.contenu, p.name) as name, p.classe_css, p.modeaff, p.modeaff, p.datcre, p.proprietaire, p.datmaj, p.modified_by, p.entite, p.marquage 
  FROM jos_joomlei_moteurs as p 
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  ON (p.id = t.idref 
  and t.tableref='jos_joomlei_moteurs' 
  and t.langue='fr')

1 × SELECT t.* 
  FROM jos_joomlei_typesdemulticrit AS t

1 × SELECT * 
  FROM jos_joomlei_champsdetri

```
1 × SELECT * 
  FROM jos_rsform_confi
```

1 × SELECT * 
  FROM jos_virtualdomain

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

```
1 × select b.* 
  from jos_rstbox b
```

Autres tables :

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6a366931356f736365387671317663657174666a6d666e697639', 1, 1701957226, 0, '', 0

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"8b8d72953fcd33233e4befc1a19194b0\"}'

Activités associatives

Yoga

Zumba

Zumba

Zumba

Zumba et danse kids

Zumba fitness

Zumba fitness

Zumba kids

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

53 requêtes exécutées 37.45 ms

18 doubles découverts!

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

Tables sélectionnées :

Autres tables :

Yoga

Zumba

Zumba

Zumba

Zumba et danse kids

Zumba fitness

Zumba fitness

Zumba kids

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

53 requêtes exécutées 37.45 ms

18 doubles découverts!

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

Tables sélectionnées :

Autres tables :