Query Time: 0.26 ms Query memory: 0.020 MB Memory before query: 4.027 MB Rows returned: 0
SELECT `session_id`
FROM `ix40h_session`
WHERE `session_id` = X'3265343830383535666363616533306530366561386364653264353137626433'
LIMIT 1
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 |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.04 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.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 2.28 ms After last query: 0.06 ms Query memory: 0.003 MB Memory before query: 4.032 MB
INSERT INTO `ix40h_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3265343830383535666363616533306530366561386364653264353137626433', 1, 1743565373, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `ix40h_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3265343830383535666363616533306530366561386364653264353137626433', 1, 1743565373, 0, '', 0)
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 for update | 0.01 ms |
Update | 0.07 ms |
Waiting for query cache lock | 0.00 ms |
Update | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 2.00 ms |
Writing to binlog | 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 1.87 ms After last query: 3.41 ms Query memory: 0.020 MB Memory before query: 4.577 MB Rows returned: 5
SELECT id, rules
FROM `ix40h_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ix40h_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.00 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 1.55 ms |
End of update loop | 0.03 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.01 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.11 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 0.53 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 4.587 MB Rows returned: 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
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 |
Status | Duration |
---|
Starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.10 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.07 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.69 ms After last query: 14.35 ms Query memory: 0.022 MB Memory before query: 7.247 MB Rows returned: 2
SHOW FULL COLUMNS
FROM `ix40h_tagz_config`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ix40h_tagz_config`
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.00 ms |
closing tables | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.28 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
checking permissions | 0.04 ms |
closing tables | 0.00 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.08 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.22 ms After last query: 0.27 ms Query memory: 0.020 MB Memory before query: 7.274 MB Rows returned: 1
SELECT *
FROM ix40h_tagz_config
WHERE `name` = 'config'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ix40h_tagz_config | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | |
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.01 ms |
table lock | 0.00 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.59 ms After last query: 24.46 ms Query memory: 0.023 MB Memory before query: 10.545 MB Rows returned: 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')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ix40h_assets | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 136 | Using where |
Status | Duration |
---|
Starting | 0.07 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.01 ms |
Statistics | 0.09 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.13 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 2.05 ms After last query: 4.67 ms Query memory: 0.004 MB Memory before query: 11.212 MB
UPDATE `ix40h_extensions`
SET `params` = '{\"mediaversion\":\"bc7cb0d843a8af7753c490f7203d0a16\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `ix40h_extensions`
SET `params` = '{\"mediaversion\":\"bc7cb0d843a8af7753c490f7203d0a16\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.03 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 for update | 0.06 ms |
Updating | 0.07 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 | 1.70 ms |
Writing to binlog | 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 1.57 ms After last query: 3.75 ms Query memory: 0.022 MB Memory before query: 11.790 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=1
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 | |
Status | Duration |
---|
Starting | 0.03 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.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.00 ms |
Unlocking tables | 1.32 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.16 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 11.780 MB Rows returned: 1
Duplicate queries:
#9 #31SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=1
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 | |
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.00 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 0.35 ms After last query: 7.23 ms Query memory: 0.022 MB Memory before query: 12.745 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=33
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 | |
Status | Duration |
---|
Starting | 0.20 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.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 0.14 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 12.751 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=34
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 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.14 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 12.757 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=35
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 | |
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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.14 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 12.763 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=36
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 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.12 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 12.769 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=37
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 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.11 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 12.775 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=38
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 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.11 ms After last query: 0.01 ms Query memory: 0.022 MB Memory before query: 12.782 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=39
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 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.11 ms After last query: 0.01 ms Query memory: 0.022 MB Memory before query: 12.788 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=40
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 | |
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.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.11 ms After last query: 0.01 ms Query memory: 0.022 MB Memory before query: 12.794 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=41
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 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.10 ms After last query: 0.01 ms Query memory: 0.022 MB Memory before query: 12.800 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=42
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 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.11 ms After last query: 0.01 ms Query memory: 0.022 MB Memory before query: 12.806 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=43
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 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.11 ms After last query: 0.01 ms Query memory: 0.022 MB Memory before query: 12.812 MB Rows returned: 1
SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=45
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 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.48 ms After last query: 0.74 ms Query memory: 0.022 MB Memory before query: 12.844 MB Rows returned: 1
SELECT *
FROM ix40h_joomlei_champsdetri
WHERE id = 7
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ix40h_joomlei_champsdetri | const | PRIMARY | PRIMARY | 8 | const | 1 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.23 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.03 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 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.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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.15 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 12.850 MB Rows returned: 1
SELECT *
FROM ix40h_joomlei_champsdetri
WHERE id = 8
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ix40h_joomlei_champsdetri | const | PRIMARY | PRIMARY | 8 | const | 1 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 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.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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.61 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 12.860 MB Rows returned: 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
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 | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.00 ms |
Opening tables | 0.15 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.06 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Creating tmp table | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.01 ms |
Creating tmp table | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
Removing tmp table | 0.00 ms |
Sending data | 0.00 ms |
Executing | 0.00 ms |
Sending data | 0.01 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.00 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.06 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 1.13 ms After last query: 0.81 ms Query memory: 0.023 MB Memory before query: 12.897 MB Rows returned: 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
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 |
Status | Duration |
---|
Starting | 0.08 ms |
checking permissions | 0.00 ms |
Opening tables | 0.66 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.07 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.33 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 12.905 MB Rows returned: 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
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 |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 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.00 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 0.31 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 12.895 MB Rows returned: 1
SELECT t.*
FROM ix40h_joomlei_typesdemulticrit AS t
WHERE t.id=2
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | t | const | PRIMARY | PRIMARY | 8 | const | 1 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.11 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 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.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 0.39 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 12.902 MB Rows returned: 1
SELECT m.*
FROM ix40h_joomlei_multicrit AS m
WHERE m.id=621000001
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | const | PRIMARY | PRIMARY | 8 | const | 1 | |
Status | Duration |
---|
Starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.14 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.05 ms |
Unlocking tables | 0.00 ms |
closing tables | 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.20 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 12.911 MB Rows returned: 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
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 | |
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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.14 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 12.935 MB Rows returned: 1
Duplicate queries:
#9 #10SELECT p.valeur
FROM ix40h_joomlei_parametres as p
WHERE p.numero=1
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 | |
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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.93 ms After last query: 351.62 ms Query memory: 0.039 MB Memory before query: 13.394 MB Rows returned: 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 ('en-GB','*')
ORDER BY m.position, m.ordering
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; Using 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 |
Status | Duration |
---|
Starting | 0.14 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.11 ms |
Preparing | 0.04 ms |
Sorting result | 0.01 ms |
Executing | 0.02 ms |
Sending data | 0.01 ms |
Creating sort index | 0.23 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.01 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 1.04 ms After last query: 21.38 ms Query memory: 0.111 MB Memory before query: 14.891 MB Rows returned: 1
SELECT custom_data
FROM ix40h_extensions
WHERE element = 'yootheme'
AND folder = 'system'
LIMIT 1
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 |
Status | Duration |
---|
Starting | 0.15 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.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.12 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.23 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.03 ms |
# | Caller | File and line number |
---|
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() | Same as call in the line below. |
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() | Same as call in the line below. |
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 |
Query Time: 1.51 ms After last query: 28.07 ms Query memory: 0.024 MB Memory before query: 19.542 MB Rows returned: 2
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='en')
LEFT
OUTER JOIN dnctraduction_contenus as tc
on (el.id = tc.idref
and tc.tableref='ix40h_joomlei_elementsdonnees'
and tc.langue='en')
WHERE g.id=621000002
ORDER BY ch.ordre, ch.id, el.ordre, el.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | g | const | PRIMARY | PRIMARY | 8 | const | 1 | Using temporary; Using 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 |
Status | Duration |
---|
Starting | 0.20 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.10 ms |
Optimizing | 0.03 ms |
Statistics | 0.12 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.46 ms |
Creating sort index | 0.04 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.08 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 0.66 ms After last query: 1.23 ms Query memory: 0.024 MB Memory before query: 19.605 MB Rows returned: 2
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='en')
LEFT
OUTER JOIN dnctraduction_contenus as tc
on (el.id = tc.idref
and tc.tableref='ix40h_joomlei_elementsdonnees'
and tc.langue='en')
WHERE g.id=621000002
ORDER BY ch.ordre, ch.id, el.ordre, el.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | g | const | PRIMARY | PRIMARY | 8 | const | 1 | Using temporary; Using 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 |
Status | Duration |
---|
Starting | 0.09 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.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.09 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.00 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 0.60 ms After last query: 0.98 ms Query memory: 0.024 MB Memory before query: 19.617 MB Rows returned: 2
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='en')
LEFT
OUTER JOIN dnctraduction_contenus as tc
on (el.id = tc.idref
and tc.tableref='ix40h_joomlei_elementsdonnees'
and tc.langue='en')
WHERE g.id=621000002
ORDER BY ch.ordre, ch.id, el.ordre, el.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | g | const | PRIMARY | PRIMARY | 8 | const | 1 | Using temporary; Using 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 |
Status | Duration |
---|
Starting | 0.09 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.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.17 ms |
Creating sort index | 0.02 ms |
Removing tmp table | 0.05 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.00 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
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 |
Query Time: 0.23 ms After last query: 1.64 ms Query memory: 0.020 MB Memory before query: 19.577 MB Rows returned: 4
SELECT language,id
FROM `ix40h_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
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 | NO INDEX KEY COULD BE USED | NULL | NULL | 75 | Using where |
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.05 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.61 ms After last query: 0.89 ms Query memory: 0.020 MB Memory before query: 19.656 MB Rows returned: 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 = 152
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 | |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.27 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.02 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.03 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.05 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 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 |
# | Caller | File and line number |
---|
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 |
Query Time: 0.20 ms After last query: 7.90 ms Query memory: 0.020 MB Memory before query: 20.469 MB Rows returned: 0
SELECT `params`
FROM `ix40h_tagz`
WHERE `component_id` = 152
AND `component_type` = "menu"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ix40h_tagz | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | Using where |
Status | Duration |
---|
Starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.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 |
# | Caller | File and line number |
---|
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 |
Query Time: 4.49 ms After last query: 6.27 ms Query memory: 0.003 MB Memory before query: 20.816 MB
DELETE
FROM `ix40h_session`
WHERE `time` < 1743564473
EXPLAIN not possible on query: DELETE
FROM `ix40h_session`
WHERE `time` < 1743564473
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 for update | 0.03 ms |
Updating | 1.21 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 | 3.11 ms |
Writing to binlog | 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 |
# | Caller | File and line number |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:150 |
6 | Joomla\CMS\Session\MetadataManager->deletePriorTo() | JROOT/plugins/system/sessiongc/sessiongc.php:74 |
5 | PlgSystemSessionGc->onAfterRespond() | JROOT/libraries/joomla/event/event.php:70 |
4 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
3 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
2 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:247 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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='en')
LEFT
OUTER JOIN dnctraduction_contenus as tc
on (el.id = tc.idref
and tc.tableref='ix40h_joomlei_elementsdonnees'
and tc.langue='en')
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`