coucoucoucou222

Vos offices de tourisme

Selestat

Bureau d'accueil de Sélestat

Situé au cœur de la vieille ville, entre la Maison du Pain d'Alsace et la Bibliothèque Humaniste, n'hésitez pas à venir faire une petite halte pour profiter des informations avisé...

Ville

L'Office de la Vallée de Villé

L'équipe de l'Office de la Vallée de Villé est heureux de vous accueillir tout au long de l'année. Escale rêvée à quelques kilomètres de la Route des Vins, la Vallée de Villé vous envoûtera par son atmosphère...

Sainte Marie aux Mines

Office de tourisme du Val d'Argent

Ouvert toute l'année, l'Office de Tourisme du Val d'Argent vous accueille, vous conseille pour vos séjours ou loisirs sur le territoire. - Nous sommes situés à 450 kms de Paris, Strasbourg 60 kms, Mulhouse 80 kms, ...

Les Offices de Tourisme d’Alsace Centrale et leurs partenaires sont heureux de vous proposer la carte d’hôtes Alsace Centrale, l’originale

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1746164867,
                "last": 1746164867,
                "now": 1746164868
            },
            "token": "P7JKRmiIu3xHdh64ZhmJEBjEDBqQreIx"
        },
        "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"
        }
    },
    "__joomlei": {
        "alea_session": "0,23"
    },
    "__joomlei_liste": {
        "joomlei_listefiches": [
            "222004489",
            "224000040",
            "228000618"
        ],
        "joomlei_liensfiches": [
            "/fr/vos-offices-de-tourisme-fr/F222004489_bureau-d-accueil-de-selestat-.html",
            "/fr/vos-offices-de-tourisme-fr/F224000040_l-office-de-la-vallee-de-ville-.html",
            "/fr/vos-offices-de-tourisme-fr/F228000618_office-de-tourisme-du-val-d-argent-.html"
        ],
        "joomlei_nomsfiches": [
            "Bureau d'accueil de S\u00e9lestat",
            "L'Office de la Vall\u00e9e de Vill\u00e9",
            "Office de tourisme du Val d'Argent"
        ]
    }
}

Profil d'information

Occupation de la mémoire

Requêtes de base de données

39 requêtes exécutées 23.33 ms

6 doubles découverts!

3 requêtes dupliquées: #9 #10 #31

3 requêtes dupliquées: #34 #35 #36

Temps de requête : 0.37 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.028 MB Rangées retournées : 0

SELECT `session_id`

  FROM `ix40h_session`

  WHERE `session_id` = X'3531363939656162646631393463313764306139396530643466303635326632' 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	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:828
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:386
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 : 3.51 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.003 MB mémoire avant requête : 4.032 MB

INSERT INTO `ix40h_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3531363939656162646631393463313764306139396530643466303635326632', 1, 1746164867, 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `ix40h_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3531363939656162646631393463313764306139396530643466303635326632', 1, 1746164867, 0, '', 0)

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.09 ms
Waiting for query cache lock	0.00 ms
Update	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	3.02 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
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:386
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 : 2.18 ms Après la dernière requête : 3.78 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.577 MB Rangées retournées : 5

SELECT id, rules

  FROM `ix40h_viewlevels`

Explication

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

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.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.00 ms
Sending data	1.77 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.05 ms
Reset for next command	0.02 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.34 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.587 MB Rangées retournées : 2

SELECT b.id

  FROM ix40h_usergroups AS a

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

  WHERE a.id = 9

Explication

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

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.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 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 : 1.02 ms Après la dernière requête : 14.93 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.248 MB Rangées retournées : 2

SHOW FULL COLUMNS 
  FROM `ix40h_tagz_config`

Explication

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

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.33 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.02 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.04 ms
closing tables	0.01 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.14 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.08 ms
Reset for next command	0.02 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/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_tagz/tables/config.php:24
10	TagzTableConfig->__construct()	JROOT/libraries/src/Table/Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_tagz/helpers/tagz.php:694
8	TagzHelper::getParams()	JROOT/plugins/system/tagz/tagz.php:117
7	plgSystemTagz->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
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.25 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.274 MB Rangées retournées : 1

SELECT *

  FROM ix40h_tagz_config

  WHERE `name` = 'config'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_tagz/helpers/tagz.php:695
8	TagzHelper::getParams()	JROOT/plugins/system/tagz/tagz.php:117
7	plgSystemTagz->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
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.76 ms Après la dernière requête : 24.24 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.117 MB Rangées retournées : 42

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

  FROM `ix40h_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dnctraduction','com_dnctraduction2','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_joomlei','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_tagz','com_templates','com_users','com_wrapper')

Explication

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

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.14 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
8	RegularLabs\Library\SystemPlugin->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:1190
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 : 3.31 ms Après la dernière requête : 4.85 ms Mémoire de requête : 0.004 MB mémoire avant requête : 10.785 MB

UPDATE `ix40h_extensions`

  SET `params` = '{\"mediaversion\":\"167e52f5259b61f3b669d5f28f6f9162\"}'

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

Explication

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

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.12 ms
Updating	0.08 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	2.63 ms
Writing to binlog	0.02 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.13 ms
Reset for next command	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #10 #31

SELECT p.valeur 
  FROM ix40h_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.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.00 ms
Unlocking tables	1.49 ms
Preparing	0.02 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.05 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/components/com_joomlei/helpers/jdncaddons.php:440
11	JDncAddons::get_urlasp()	JROOT/administrator/components/com_joomlei/defines.php:153
10	require JROOT/administrator/components/com_joomlei/defines.php	JROOT/components/com_joomlei/helpers/jdncaddons.php:5
9	include_once JROOT/components/com_joomlei/helpers/jdncaddons.php	JROOT/libraries/loader.php:260
8	JLoader::load()	JROOT/administrator/components/com_joomlei/defines.php:153
7	include JROOT/administrator/components/com_joomlei/defines.php	JROOT/components/com_joomlei/joomlei.php:15
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #9 #31

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

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 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.23 ms Après la dernière requête : 7.72 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.319 MB Rangées retournées : 1

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

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 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:744
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.18 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.325 MB Rangées retournées : 1

SELECT p.valeur 
  FROM ix40h_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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.06 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:744
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.27 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.331 MB Rangées retournées : 1

SELECT p.valeur 
  FROM ix40h_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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 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:744
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:91
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT p.valeur 
  FROM ix40h_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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 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:744
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.13 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.343 MB Rangées retournées : 1

SELECT p.valeur 
  FROM ix40h_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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 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:744
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.13 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.348 MB Rangées retournées : 1

SELECT p.valeur 
  FROM ix40h_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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 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:744
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.13 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.355 MB Rangées retournées : 1

SELECT p.valeur 
  FROM ix40h_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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 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:744
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.13 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.361 MB Rangées retournées : 1

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

Explication

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

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 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:744
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.12 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.367 MB Rangées retournées : 1

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

Explication

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

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 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:744
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:97
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 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:744
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:98
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 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:744
11	JoomleiGenericHelper::getParametre()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:101
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 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:744
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.22 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.417 MB Rangées retournées : 1

SELECT * 
  FROM ix40h_joomlei_champsdetri 
  WHERE id = 7

Explication

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

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.05 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:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomlei/models/champsdetri.php:57
12	JoomleiModelChampsdetri->getData()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:498
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.15 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.424 MB Rangées retournées : 1

SELECT * 
  FROM ix40h_joomlei_champsdetri 
  WHERE id = 8

Explication

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

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 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:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomlei/models/champsdetri.php:57
12	JoomleiModelChampsdetri->getData()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:498
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.58 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.433 MB Rangées retournées : 3

SELECT DISTINCT el.critere as crit 
  FROM ix40h_joomlei_groupesdonnees AS g  
  LEFT 
  OUTER JOIN ix40h_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)  
  LEFT 
  OUTER JOIN ix40h_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)  
  WHERE g.id=621000002 
  AND el.critere IS NOT NULL  UNION SELECT DISTINCT el.critere_legende as crit  
  FROM ix40h_joomlei_groupesdonnees AS g  
  LEFT 
  OUTER JOIN ix40h_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)  
  LEFT 
  OUTER JOIN ix40h_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)  
  WHERE g.id=621000002 
  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_ix40h_joomlei_champsdonnees	FK_ix40h_joomlei_champsdonnees	8	const	1	Using index
1	PRIMARY	el	ref	FK_ix40h_joomlei_elementsdonnees_1,ix40h_joomlei_elementsdonnees_idx_critere	FK_ix40h_joomlei_elementsdonnees_1	8	g10fq1_cartedhote.ch.id	1	Using where
2	UNION	g	const	PRIMARY	PRIMARY	8	const	1	Using index; Using temporary
2	UNION	ch	ref	PRIMARY,FK_ix40h_joomlei_champsdonnees	FK_ix40h_joomlei_champsdonnees	8	const	1	Using index
2	UNION	el	ref	FK_ix40h_joomlei_elementsdonnees_1,ix40h_joomlei_elementsdonnees_idx_critere	FK_ix40h_joomlei_elementsdonnees_1	8	g10fq1_cartedhote.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.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.07 ms
Optimizing	0.01 ms
Statistics	0.08 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.02 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:578
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.49 ms Après la dernière requête : 0.88 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.471 MB Rangées retournées : 0

SELECT p.*, c.name as nomchamp, c.nompnames as nompnames,
        c.sqlselection, c.multiple,  
  CASE c.nompnames  WHEN "elcriterio" THEN cr.name  WHEN "elgendro" THEN ge.name  WHEN "alcat" THEN ca.name  WHEN "eltypo" THEN ty.name  ELSE p.valeur END as valeur_clair,  IFNULL(mo.name, 'Toutes modalités') as nommod  
  FROM ix40h_joomlei_champsdesmulticrit AS p 
  LEFT 
  OUTER JOIN ix40h_joomlei_champsmulticrit AS c 
  ON p.idchamp=c.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_criteres AS cr 
  ON p.valeur=cr.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_modalites AS mo 
  ON p.valeur=mo.critere 
  and p.modalidad=mo.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_genres AS ge 
  ON p.valeur=ge.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_categories AS ca 
  ON p.valeur=ca.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_types AS ty 
  ON p.valeur=ty.id 
  WHERE p.idmulticrit=621000001 
  AND c.nompnames='dispodu' 
  GROUP BY p.id 
  ORDER BY p.idchamp ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,nomunique	nomunique	137	const	1
1	SIMPLE	p	ref\|filter	idx_gna,FK_ix40h_joomlei_champsdesmulticrit_3	idx_gna\|FK_ix40h_joomlei_champsdesmulticrit_3	8\|8	const	1 (50%)	Using where; Using rowid filter
1	SIMPLE	cr	eq_ref	PRIMARY	PRIMARY	8	g10fq1_cartedhote.p.valeur	1	Using where
1	SIMPLE	mo	eq_ref	PRIMARY,FK_ix40h_joomlei_modalites_1	PRIMARY	16	g10fq1_cartedhote.p.modalidad,g10fq1_cartedhote.p.valeur	1	Using where
1	SIMPLE	ge	eq_ref	PRIMARY	PRIMARY	8	g10fq1_cartedhote.p.valeur	1	Using where
1	SIMPLE	ca	eq_ref	PRIMARY	PRIMARY	8	g10fq1_cartedhote.p.valeur	1	Using where
1	SIMPLE	ty	eq_ref	PRIMARY	PRIMARY	8	g10fq1_cartedhote.p.valeur	1	Using where

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Sorting result	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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/champsdesmulticrits.php:91
13	JoomleiModelChampsdesmulticrits->getData()	JROOT/components/com_joomlei/helpers/dispo_lei.php:29
12	include JROOT/components/com_joomlei/helpers/dispo_lei.php	JROOT/components/com_joomlei/helpers/joomlei_helper.php:714
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.34 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.478 MB Rangées retournées : 0

SELECT p.*, c.name as nomchamp, c.nompnames as nompnames,
        c.sqlselection, c.multiple,  
  CASE c.nompnames  WHEN "elcriterio" THEN cr.name  WHEN "elgendro" THEN ge.name  WHEN "alcat" THEN ca.name  WHEN "eltypo" THEN ty.name  ELSE p.valeur END as valeur_clair,  IFNULL(mo.name, 'Toutes modalités') as nommod  
  FROM ix40h_joomlei_champsdesmulticrit AS p 
  LEFT 
  OUTER JOIN ix40h_joomlei_champsmulticrit AS c 
  ON p.idchamp=c.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_criteres AS cr 
  ON p.valeur=cr.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_modalites AS mo 
  ON p.valeur=mo.critere 
  and p.modalidad=mo.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_genres AS ge 
  ON p.valeur=ge.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_categories AS ca 
  ON p.valeur=ca.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_types AS ty 
  ON p.valeur=ty.id 
  WHERE p.idmulticrit=621000001 
  AND c.nompnames='dispoau' 
  GROUP BY p.id 
  ORDER BY p.idchamp ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,nomunique	nomunique	137	const	1
1	SIMPLE	p	ref\|filter	idx_gna,FK_ix40h_joomlei_champsdesmulticrit_3	idx_gna\|FK_ix40h_joomlei_champsdesmulticrit_3	8\|8	const	1 (50%)	Using where; Using rowid filter
1	SIMPLE	cr	eq_ref	PRIMARY	PRIMARY	8	g10fq1_cartedhote.p.valeur	1	Using where
1	SIMPLE	mo	eq_ref	PRIMARY,FK_ix40h_joomlei_modalites_1	PRIMARY	16	g10fq1_cartedhote.p.modalidad,g10fq1_cartedhote.p.valeur	1	Using where
1	SIMPLE	ge	eq_ref	PRIMARY	PRIMARY	8	g10fq1_cartedhote.p.valeur	1	Using where
1	SIMPLE	ca	eq_ref	PRIMARY	PRIMARY	8	g10fq1_cartedhote.p.valeur	1	Using where
1	SIMPLE	ty	eq_ref	PRIMARY	PRIMARY	8	g10fq1_cartedhote.p.valeur	1	Using where

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 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.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Sorting result	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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/champsdesmulticrits.php:91
13	JoomleiModelChampsdesmulticrits->getData()	JROOT/components/com_joomlei/helpers/dispo_lei.php:32
12	include JROOT/components/com_joomlei/helpers/dispo_lei.php	JROOT/components/com_joomlei/helpers/joomlei_helper.php:714
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.18 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.468 MB Rangées retournées : 1

SELECT t.* 
  FROM ix40h_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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 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: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:729
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.22 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.475 MB Rangées retournées : 1

SELECT m.* 
  FROM ix40h_joomlei_multicrit AS m 
  WHERE m.id=621000001

Explication

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

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 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:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:271
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:729
11	JoomleiFrontHelper->getListe()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:151
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT cm.valeur, cm.modalidad, cm.minimo, cm.maximo ,c.nompnames  
  FROM ix40h_joomlei_champsdesmulticrit AS cm 
  LEFT 
  OUTER JOIN ix40h_joomlei_champsmulticrit AS c 
  ON cm.idchamp=c.id 
  WHERE cm.idmulticrit=621000001

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cm	ref	idx_gna	idx_gna	8	const	1
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	8	g10fq1_cartedhote.cm.idchamp	1

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 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/administrator/components/com_joomlei/helpers/joomleigeneric.php:301
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:729
11	JoomleiFrontHelper->getListe()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:151
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #9 #10

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomlei/models/parametress.php:80
17	JoomleiModelParametress->getParametre()	JROOT/components/com_joomlei/helpers/jdncaddons.php:440
16	JDncAddons::get_urlasp()	JROOT/administrator/components/com_joomlei/defines.php:153
15	include JROOT/administrator/components/com_joomlei/defines.php	JROOT/components/com_joomlei/helpers/jdncaddons.php:12
14	JDncAddons->__construct()	JROOT/administrator/components/com_joomlei/helpers/joomleigeneric.php:394
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:729
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.90 ms Après la dernière requête : 316.39 ms Mémoire de requête : 0.039 MB mémoire avant requête : 12.967 MB Rangées retournées : 7

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM ix40h_modules AS m

  LEFT JOIN ix40h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN ix40h_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND m.language IN ('fr-FR','*')

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	published,newsfeeds,idx_language	published	1	const	16	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	g10fq1_cartedhote.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	g10fq1_cartedhote.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.27 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
17	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
16	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:19
11	YOOtheme\Theme\Joomla\ModulesRenderer->render()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:474
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.58 ms Après la dernière requête : 18.18 ms Mémoire de requête : 0.111 MB mémoire avant requête : 14.439 MB Rangées retournées : 1

SELECT custom_data 
  FROM ix40h_extensions 
  WHERE element = 'yootheme' 
  AND folder = 'system' 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.07 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.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.14 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
40	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
39	JDatabaseDriver->loadAssoc()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Database.php:48
38	YOOtheme\Joomla\Database->fetchAssoc()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Storage.php:25
37	YOOtheme\Joomla\Storage->__construct()	Même appel que celui de la ligne ci-dessous.
36	ReflectionClass->newInstanceArgs()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:183
35	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:156
34	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:322
33	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:91
32	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:406
31	YOOtheme\Container->resolveDependencies()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:355
30	YOOtheme\Container->resolveArguments()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:181
29	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:156
28	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:322
27	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:91
26	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:406
25	YOOtheme\Container->resolveDependencies()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:355
24	YOOtheme\Container->resolveArguments()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:265
23	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
22	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
21	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
20	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
19	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeListener.php:70
16	YOOtheme\Theme\Joomla\ThemeListener::YOOtheme\Theme\Joomla\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/StreamWrapper.php:49
15	YOOtheme\Theme\Joomla\StreamWrapper->url_stat()	Même appel que celui de la ligne ci-dessous.
14	file_exists()	JROOT/libraries/src/Filesystem/Path.php:335
13	Joomla\CMS\Filesystem\Path::find()	JROOT/libraries/src/MVC/View/HtmlView.php:676
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_joomlei/views/listeproduits/view.html.php:628
10	JoomleiViewListeproduits->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomlei/controller.php:28
8	JoomleiController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomlei/joomlei.php:62
6	require_once JROOT/components/com_joomlei/joomlei.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.28 ms Après la dernière requête : 29.96 ms Mémoire de requête : 0.024 MB mémoire avant requête : 19.091 MB Rangées retournées : 2

Requêtes dupliquées: #35 #36

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 ix40h_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN ix40h_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN ix40h_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='ix40h_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='ix40h_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=621000002 
  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_ix40h_joomlei_champsdonnees	FK_ix40h_joomlei_champsdonnees	8	const	1
1	SIMPLE	el	ref	FK_ix40h_joomlei_elementsdonnees_1	FK_ix40h_joomlei_elementsdonnees_1	8	g10fq1_cartedhote.ch.id	1	Using where
1	SIMPLE	t	ref	PRIMARY,dnctraduction_contenus_idx_idref	PRIMARY	4	g10fq1_cartedhote.ch.id	1	Using where
1	SIMPLE	tc	ref	PRIMARY,dnctraduction_contenus_idx_idref	PRIMARY	4	g10fq1_cartedhote.el.id	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1478
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yootheme_child/html/com_joomlei/listeproduits/mosaic_fiche_standard.php:358
14	include JROOT/templates/yootheme_child/html/com_joomlei/listeproduits/mosaic_fiche_standard.php	JROOT/templates/yootheme_child/html/com_joomlei/listeproduits/liste.php:302
13	include JROOT/templates/yootheme_child/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.26 ms Mémoire de requête : 0.024 MB mémoire avant requête : 19.153 MB Rangées retournées : 2

Requêtes dupliquées: #34 #36

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 ix40h_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN ix40h_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN ix40h_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='ix40h_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='ix40h_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=621000002 
  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_ix40h_joomlei_champsdonnees	FK_ix40h_joomlei_champsdonnees	8	const	1
1	SIMPLE	el	ref	FK_ix40h_joomlei_elementsdonnees_1	FK_ix40h_joomlei_elementsdonnees_1	8	g10fq1_cartedhote.ch.id	1	Using where
1	SIMPLE	t	ref	PRIMARY,dnctraduction_contenus_idx_idref	PRIMARY	4	g10fq1_cartedhote.ch.id	1	Using where
1	SIMPLE	tc	ref	PRIMARY,dnctraduction_contenus_idx_idref	PRIMARY	4	g10fq1_cartedhote.el.id	1	Using where

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.00 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.18 ms
Creating sort index	0.02 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1478
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yootheme_child/html/com_joomlei/listeproduits/mosaic_fiche_standard.php:358
14	include JROOT/templates/yootheme_child/html/com_joomlei/listeproduits/mosaic_fiche_standard.php	JROOT/templates/yootheme_child/html/com_joomlei/listeproduits/liste.php:302
13	include JROOT/templates/yootheme_child/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.62 ms Après la dernière requête : 0.98 ms Mémoire de requête : 0.024 MB mémoire avant requête : 19.166 MB Rangées retournées : 2

Requêtes dupliquées: #34 #35

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 ix40h_joomlei_groupesdonnees AS g
		
  LEFT 
  OUTER JOIN ix40h_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
		
  LEFT 
  OUTER JOIN ix40h_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='ix40h_joomlei_champsdonnees' 
  and t.langue='fr')
		
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='ix40h_joomlei_elementsdonnees' 
  and tc.langue='fr') 
  WHERE g.id=621000002 
  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_ix40h_joomlei_champsdonnees	FK_ix40h_joomlei_champsdonnees	8	const	1
1	SIMPLE	el	ref	FK_ix40h_joomlei_elementsdonnees_1	FK_ix40h_joomlei_elementsdonnees_1	8	g10fq1_cartedhote.ch.id	1	Using where
1	SIMPLE	t	ref	PRIMARY,dnctraduction_contenus_idx_idref	PRIMARY	4	g10fq1_cartedhote.ch.id	1	Using where
1	SIMPLE	tc	ref	PRIMARY,dnctraduction_contenus_idx_idref	PRIMARY	4	g10fq1_cartedhote.el.id	1	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_joomlei/models/groupesdonneess.php:225
16	JoomleiModelGroupesdonneess->getDonneesAffichage()	JROOT/components/com_joomlei/helpers/joomlei_helper.php:1478
15	JoomleiFrontHelper->merge_lei_groupedonnee()	JROOT/templates/yootheme_child/html/com_joomlei/listeproduits/mosaic_fiche_standard.php:358
14	include JROOT/templates/yootheme_child/html/com_joomlei/listeproduits/mosaic_fiche_standard.php	JROOT/templates/yootheme_child/html/com_joomlei/listeproduits/liste.php:302
13	include JROOT/templates/yootheme_child/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.26 ms Après la dernière requête : 1.65 ms Mémoire de requête : 0.020 MB mémoire avant requête : 19.126 MB Rangées retournées : 4

SELECT language,id

  FROM `ix40h_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	ix40h_menu	ALL	idx_client_id_parent_id_alias_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	75	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.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 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.41 ms Après la dernière requête : 0.88 ms Mémoire de requête : 0.020 MB mémoire avant requête : 19.205 MB Rangées retournées : 3

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

  FROM `ix40h_menu` AS `c`

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

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

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

  WHERE c.id = 151

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	3	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	g10fq1_cartedhote.a2.id	1

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.05 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 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.33 ms Après la dernière requête : 11.26 ms Mémoire de requête : 0.020 MB mémoire avant requête : 20.018 MB Rangées retournées : 0

SELECT `params`

  FROM `ix40h_tagz`

  WHERE `component_id` = 151 
  AND `component_type` = "menu"

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ix40h_tagz	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	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.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.04 ms
Reset for next command	0.01 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/plugins/system/tagz/tagz.php:546
9	plgSystemTagz->getTagParams()	JROOT/plugins/system/tagz/tagz.php:163
8	plgSystemTagz->init()	JROOT/plugins/system/tagz/tagz.php:133
7	plgSystemTagz->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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]

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

Tables sélectionnées :

15 × SELECT p.valeur 
  FROM ix40h_joomlei_parametres as p

3 × 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 ix40h_joomlei_groupesdonnees AS g
   
  LEFT 
  OUTER JOIN ix40h_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)
   
  LEFT 
  OUTER JOIN ix40h_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)
   
  LEFT 
  OUTER JOIN dnctraduction_contenus as t 
  on (ch.id = t.idref 
  and t.tableref='ix40h_joomlei_champsdonnees' 
  and t.langue='fr')
   
  LEFT 
  OUTER JOIN dnctraduction_contenus as tc 
  on (el.id = tc.idref 
  and tc.tableref='ix40h_joomlei_elementsdonnees' 
  and tc.langue='fr')

2 × SELECT * 
  FROM ix40h_joomlei_champsdetri

2 × SELECT p.*, c.name as nomchamp, c.nompnames as nompnames,
         c.sqlselection, c.multiple,  
  CASE c.nompnames  WHEN "elcriterio" THEN cr.name  WHEN "elgendro" THEN ge.name  WHEN "alcat" THEN ca.name  WHEN "eltypo" THEN ty.name  ELSE p.valeur END as valeur_clair,  IFNULL(mo.name, 'Toutes modalités') as nommod  
  FROM ix40h_joomlei_champsdesmulticrit AS p 
  LEFT 
  OUTER JOIN ix40h_joomlei_champsmulticrit AS c 
  ON p.idchamp=c.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_criteres AS cr 
  ON p.valeur=cr.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_modalites AS mo 
  ON p.valeur=mo.critere 
  and p.modalidad=mo.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_genres AS ge 
  ON p.valeur=ge.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_categories AS ca 
  ON p.valeur=ca.id 
  LEFT 
  OUTER JOIN ix40h_joomlei_types AS ty 
  ON p.valeur=ty.id

1 × SELECT `session_id` 
  FROM `ix40h_session`

1 × SELECT id, rules 
  FROM `ix40h_viewlevels

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

1 × SELECT * 
  FROM ix40h_tagz_config

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

1 × SELECT DISTINCT el.critere as crit 
  FROM ix40h_joomlei_groupesdonnees AS g  
  LEFT 
  OUTER JOIN ix40h_joomlei_champsdonnees AS ch 
  on (g.id=ch.idparent)  
  LEFT 
  OUTER JOIN ix40h_joomlei_elementsdonnees AS el 
  on (ch.id=el.idparent)

1 × SELECT t.* 
  FROM ix40h_joomlei_typesdemulticrit AS t

1 × SELECT m.* 
  FROM ix40h_joomlei_multicrit AS m

1 × SELECT cm.valeur, cm.modalidad, cm.minimo, cm.maximo ,c.nompnames  
  FROM ix40h_joomlei_champsdesmulticrit AS cm 
  LEFT 
  OUTER JOIN ix40h_joomlei_champsmulticrit AS c 
  ON cm.idchamp=c.id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM ix40h_modules AS m 
  LEFT JOIN ix40h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN ix40h_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT custom_data 
  FROM ix40h_extensions

1 × SELECT language,id 
  FROM `ix40h_menu`

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

1 × SELECT `params` 
  FROM `ix40h_tagz`

Autres tables :

1 × INSERT INTO `ix40h_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3531363939656162646631393463313764306139396530643466303635326632', 1, 1746164867, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `ix40h_tagz_config

1 × UPDATE `ix40h_extensions` 
  SET `params` = '{\"mediaversion\":\"167e52f5259b61f3b669d5f28f6f9162\"}'