NOUVEAU : OUVERTURE pour DUOS Couples & SOLOS Femmes
les dimanches, jours fériés et nocturnes de 19h00 à 22h30
majoration 20 %
Notice: Undefined property: ProductViewProduct::$categories in /home/lemondeso/www/components/com_hikashop/views/product/tmpl/listing.php on line 152
ADRESSE
12 rue Durand
34000 Montpellier, FRANCE
34000 Montpellier, FRANCE
Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser.
+33 (0)4 67 02 40 90
+33 (0)4 67 02 40 90
HORAIRES
UNIQUEMENT SUR RESERVATION
Lundi – Samedi 9h30 – 19h
Fermé le dimanche
Lundi – Samedi 9h30 – 19h
Fermé le dimanche
Console de débogage Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1590816217,
"last": 1590816217,
"now": 1590816217
},
"client": {
"forwarded": "18.207.254.88"
},
"token": "cDOcR06Rtytf9WBCchnvuYZVaOAU8imI"
},
"registry": {
"com_hikashop": {
"ssl_redirect": 0,
"user_id": 0,
"zone_id": "73"
},
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly9sZS1tb25kZS1zZW5zaWJsZS5mci9ib3V0aXF1ZS9wcm9kdWN0L2xpc3RpbmcvbWFzc2FnZXMtYS1sLW9jY2lkZW50YWxlPw%3D%3D"
}
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Temps
Mémoire
Temps: 29.68 ms / 29.68 ms Mémoire: 0.393 MB / 0.73 MB Application: afterLoad
Temps: 85.67 ms / 115.35 ms Mémoire: 0.845 MB / 1.58 MB Application: afterInitialise
Temps: 144.58 ms / 259.93 ms Mémoire: 2.239 MB / 3.82 MB Application: afterRoute
Temps: 0.79 ms / 260.73 ms Mémoire: 0.001 MB / 3.82 MB Application: beforeRenderComponent com_hikashop
Temps: 122.50 ms / 383.22 ms Mémoire: 1.088 MB / 4.91 MB Application: afterRenderComponent com_hikashop
Temps: 8.38 ms / 391.60 ms Mémoire: 0.118 MB / 5.02 MB Application: afterDispatch
Temps: 33.87 ms / 425.47 ms Mémoire: 0.264 MB / 5.29 MB Application: Before Access::preloadComponents (all components)
Temps: 3.11 ms / 428.58 ms Mémoire: 0.043 MB / 5.33 MB Application: After Access::preloadComponents (all components)
Temps: 0.03 ms / 428.61 ms Mémoire: 0.000 MB / 5.33 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Temps: 0.69 ms / 429.30 ms Mémoire: 0.009 MB / 5.34 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Temps: 0.49 ms / 429.79 ms Mémoire: 0.004 MB / 5.34 MB Application: beforeRenderModule mod_custom (Ouverture Majorée)
Temps: 9.35 ms / 439.14 ms Mémoire: 0.089 MB / 5.43 MB Application: afterRenderModule mod_custom (Ouverture Majorée)
Temps: 1.11 ms / 440.25 ms Mémoire: 0.004 MB / 5.43 MB Application: beforeRenderModule mod_menu ()
Temps: 3.98 ms / 444.23 ms Mémoire: 0.069 MB / 5.50 MB Application: afterRenderModule mod_menu ()
Temps: 0.04 ms / 444.26 ms Mémoire: 0.000 MB / 5.48 MB Application: beforeRenderModule mod_custom (Mon compte (2))
Temps: 0.35 ms / 444.61 ms Mémoire: 0.003 MB / 5.49 MB Application: afterRenderModule mod_custom (Mon compte (2))
Temps: 0.29 ms / 444.90 ms Mémoire: 0.000 MB / 5.48 MB Application: beforeRenderModule mod_custom (Header Phone)
Temps: 0.30 ms / 445.20 ms Mémoire: 0.004 MB / 5.49 MB Application: afterRenderModule mod_custom (Header Phone)
Temps: 0.03 ms / 445.23 ms Mémoire: 0.000 MB / 5.49 MB Application: beforeRenderModule mod_custom (Mon compte)
Temps: 0.29 ms / 445.51 ms Mémoire: 0.003 MB / 5.49 MB Application: afterRenderModule mod_custom (Mon compte)
Temps: 0.03 ms / 445.54 ms Mémoire: 0.000 MB / 5.49 MB Application: beforeRenderModule mod_custom (cart)
Temps: 0.28 ms / 445.82 ms Mémoire: 0.003 MB / 5.49 MB Application: afterRenderModule mod_custom (cart)
Temps: 0.02 ms / 445.84 ms Mémoire: 0.000 MB / 5.49 MB Application: beforeRenderModule mod_finder ()
Temps: 16.96 ms / 462.80 ms Mémoire: 0.053 MB / 5.54 MB Application: afterRenderModule mod_finder ()
Temps: 0.03 ms / 462.83 ms Mémoire: 0.000 MB / 5.54 MB Application: beforeRenderModule mod_custom ()
Temps: 0.34 ms / 463.18 ms Mémoire: 0.002 MB / 5.54 MB Application: afterRenderModule mod_custom ()
Temps: 0.57 ms / 463.75 ms Mémoire: 0.002 MB / 5.54 MB Application: beforeRenderModule mod_menu ()
Temps: 0.83 ms / 464.58 ms Mémoire: 0.022 MB / 5.57 MB Application: afterRenderModule mod_menu ()
Temps: 0.02 ms / 464.60 ms Mémoire: 0.000 MB / 5.54 MB Application: beforeRenderModule mod_search ()
Temps: 2.12 ms / 466.72 ms Mémoire: 0.010 MB / 5.55 MB Application: afterRenderModule mod_search ()
Temps: 54.83 ms / 521.55 ms Mémoire: 0.624 MB / 6.18 MB Application: afterRender
Total de requêtes base de données : 161.27 ms
7,02 MB (7 361 400 Bytes)
117 requêtes exécutées 161.27 ms
58 doubles découverts!
- Temps de requête : 1.35 ms Mémoire de requête : 0.022 MB mémoire avant requête : 0.890 MB Rangées retournées : 0
SELECT `data`
FROM `lms_session`
WHERE `session_id` = '0d5f03a3c4325a431f377e8e2af8e468'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_session const PRIMARY PRIMARY 194 const 1 100.00 NULL No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 0.79 ms Après la dernière requête : 1.19 ms Mémoire de requête : 0.020 MB mémoire avant requête : 0.964 MB Rangées retournées : 0
SELECT `session_id`
FROM `lms_session`
WHERE `session_id` = '0d5f03a3c4325a431f377e8e2af8e468'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_session const PRIMARY PRIMARY 194 const 1 100.00 Using index No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 2.30 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.003 MB mémoire avant requête : 0.968 MB
INSERT INTO `lms_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('0d5f03a3c4325a431f377e8e2af8e468', 1, 1590816217, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `lms_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('0d5f03a3c4325a431f377e8e2af8e468', 1, 1590816217, 0, '', 0)No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 1.75 ms Après la dernière requête : 3.45 ms Mémoire de requête : 0.028 MB mémoire avant requête : 0.996 MB Rangées retournées : 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `lms_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_extensions ref extension extension 82 const 46 100.00 Using index condition; Using where No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Même appel que celui de la ligne ci-dessous. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.40 ms Après la dernière requête : 2.74 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.023 MB Rangées retournées : 6
SELECT id, rules
FROM `lms_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_viewlevels ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 5 100.00 NULL No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.68 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.033 MB Rangées retournées : 2
SELECT b.id
FROM lms_usergroups AS a
LEFT JOIN lms_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 100.00 Using where; Using index No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 4.12 ms Après la dernière requête : 0.80 ms Mémoire de requête : 0.036 MB mémoire avant requête : 1.053 MB Rangées retournées : 163
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM lms_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_extensions ref extension extension 82 const 264 100.00 Using index condition; Using where; Utilisation du tri complet de type filesort No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Même appel que celui de la ligne ci-dessous. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 3.49 ms Après la dernière requête : 41.37 ms Mémoire de requête : 0.063 MB mémoire avant requête : 1.603 MB Rangées retournées : 44
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM lms_menu AS m
LEFT JOIN lms_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 53 100.00 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 lemondesolms.m.component_id 1 100.00 Using where No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Même appel que celui de la ligne ci-dessous. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1073 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.17 ms Après la dernière requête : 20.95 ms Mémoire de requête : 0.025 MB mémoire avant requête : 1.982 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `lms_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 21 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 20 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Même appel que celui de la ligne ci-dessous. 19 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 18 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 17 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 16 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 15 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 14 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 13 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 12 Joomla\CMS\Factory::getDocument() JROOT/administrator/components/com_hikashop/helpers/helper.php:3789 11 include_once JROOT/administrator/components/com_hikashop/helpers/helper.php JROOT/components/com_hikashop/router.php:128 10 HikashopParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 2.41 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.006 MB mémoire avant requête : 1.973 MB
UPDATE `lms_extensions`
SET `params` = '{\"mediaversion\":\"2fc158c56b3f02826849928f48cc8d39\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_extensions range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 16 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 15 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 14 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 13 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 12 Joomla\CMS\Factory::getDocument() JROOT/administrator/components/com_hikashop/helpers/helper.php:3789 11 include_once JROOT/administrator/components/com_hikashop/helpers/helper.php JROOT/components/com_hikashop/router.php:128 10 HikashopParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.80 ms Après la dernière requête : 5.58 ms Mémoire de requête : 0.036 MB mémoire avant requête : 2.485 MB Rangées retournées : 3
SELECT id, home, template, s.params
FROM lms_template_styles as s
LEFT JOIN lms_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_template INDEX N'A PU ÊTRE UTILISÉ NULL NULL 5 100.00 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 lemondesolms.s.template,const 1 100.00 Using index condition; Using where No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 14 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/administrator/components/com_hikashop/helpers/helper.php:1167 13 hikashop_get() JROOT/administrator/components/com_hikashop/helpers/helper.php:1095 12 hikashop_config() JROOT/administrator/components/com_hikashop/helpers/helper.php:3806 11 include_once JROOT/administrator/components/com_hikashop/helpers/helper.php JROOT/components/com_hikashop/router.php:128 10 HikashopParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 4.44 ms Après la dernière requête : 2.26 ms Mémoire de requête : 0.185 MB mémoire avant requête : 2.517 MB Rangées retournées : 409
SELECT *
FROM lms_hikashop_configid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_config ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 409 100.00 NULL No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/config.php:16 13 hikashopConfigClass->load() JROOT/administrator/components/com_hikashop/helpers/helper.php:1096 12 hikashop_config() JROOT/administrator/components/com_hikashop/helpers/helper.php:3806 11 include_once JROOT/administrator/components/com_hikashop/helpers/helper.php JROOT/components/com_hikashop/router.php:128 10 HikashopParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.16 ms Après la dernière requête : 2.81 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.842 MB Rangées retournées : 1
SELECT category_id
FROM lms_hikashop_category
WHERE category_alias = 'massages-a-l-occidentale'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_category ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 32 100.00 Using where No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 12 JDatabaseDriver->loadResult() JROOT/components/com_hikashop/router.php:278 11 hikashop_retrieve_url_id() JROOT/components/com_hikashop/router.php:224 10 HikashopParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.57 ms Après la dernière requête : 42.02 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.512 MB Rangées retournées : 2
SELECT *
FROM lms_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_languages ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 100.00 Using where; Utilisation du tri complet de type filesort No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 25 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 24 Joomla\CMS\Application\SiteApplication->getParams() JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:88 23 YOOtheme\Theme\Joomla->onSite() Même appel que celui de la ligne ci-dessous. 22 call_user_func_array() JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119 21 YOOtheme\EventManager->trigger() JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42 20 YOOtheme\Application->trigger() JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:74 19 YOOtheme\Theme\Joomla->onInit() Même appel que celui de la ligne ci-dessous. 18 call_user_func_array() JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119 17 YOOtheme\EventManager->trigger() JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42 16 YOOtheme\Application->trigger() JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:104 15 YOOtheme\Theme\Joomla->{closure}() Même appel que celui de la ligne ci-dessous. 14 call_user_func_array() JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119 13 YOOtheme\EventManager->trigger() JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42 12 YOOtheme\Application->trigger() JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58 11 YOOtheme\Application->init() JROOT/plugins/system/yootheme/yootheme.php:178 10 plgSystemYOOtheme->loadTemplate() JROOT/plugins/system/yootheme/yootheme.php:131 9 plgSystemYOOtheme->handleRequest() JROOT/plugins/system/yootheme/yootheme.php:38 8 plgSystemYOOtheme->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:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.12 ms Après la dernière requête : 57.25 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.867 MB Rangées retournées : 1
SELECT *
FROM lms_menu
WHERE id = '123'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_menu const PRIMARY PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 18 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikashop/helpers/helper.php:2036 17 hikashopClass->get() JROOT/administrator/components/com_hikashop/classes/menus.php:20 16 hikashopMenusClass->get() JROOT/administrator/components/com_hikashop/helpers/module.php:204 15 hikashopModuleHelper->_getParams() JROOT/administrator/components/com_hikashop/helpers/module.php:14 14 hikashopModuleHelper->initialize() JROOT/components/com_hikashop/views/product/view.html.php:160 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.37 ms Après la dernière requête : 3.33 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.994 MB Rangées retournées : 0Requêtes dupliquées: #86
SELECT cart.cart_id
FROM lms_hikashop_cart AS cart
WHERE (cart.cart_type = 'cart')
AND (cart.session_id = '0d5f03a3c4325a431f377e8e2af8e468')
ORDER BY cart.cart_current DESC, cart.cart_modified DESCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cart ref session_id session_id 767 const 1 100.00 Using index condition; Using where; Utilisation du tri complet de type filesort No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 17 JDatabaseDriver->loadResult() JROOT/administrator/components/com_hikashop/classes/cart.php:68 16 hikashopCartClass->getCurrentCartId() JROOT/administrator/components/com_hikashop/classes/cart.php:92 15 hikashopCartClass->get() JROOT/administrator/components/com_hikashop/helpers/helper.php:487 14 hikashop_getZone() JROOT/components/com_hikashop/views/product/view.html.php:463 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.79 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.001 MB Rangées retournées : 1
SELECT category_id
FROM lms_hikashop_category
WHERE (category_access = 'all' OR category_access LIKE '%,1,%' OR category_access LIKE '%,9,%')
AND category_id IN ('36')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_category const PRIMARY PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 14 JDatabaseDriver->loadColumn() JROOT/components/com_hikashop/views/product/view.html.php:487 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.02 ms Après la dernière requête : 0.83 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.022 MB Rangées retournées : 0
SELECT *
FROM lms_hikashop_filter
WHERE filter_published = 1
AND (filter_access = 'all' OR filter_access LIKE '%,1,%' OR filter_access LIKE '%,9,%')
ORDER BY filter_orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL Impossible WHERE noticed after reading const tables No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)# Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/filter.php:285 15 hikashopFilterClass->getFilters() JROOT/components/com_hikashop/views/product/view.html.php:125 14 ProductViewProduct->filter() JROOT/components/com_hikashop/views/product/view.html.php:511 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 7.85 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.032 MB Rangées retournées : 3
SELECT hk_parent.*
FROM lms_hikashop_category AS hk_cat
LEFT JOIN lms_hikashop_category AS hk_parent
ON (hk_parent.category_left <= hk_cat.category_left
AND hk_parent.category_right >= hk_cat.category_right)
WHERE hk_cat.category_id = 36
GROUP BY hk_parent.category_id
ORDER BY hk_parent.category_leftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hk_cat const PRIMARY PRIMARY 4 const 1 100.00 Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE hk_parent ALL PRIMARY INDEX N'A PU ÊTRE UTILISÉ NULL NULL 32 100.00 Using where Status Duration starting 0.13 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.24 ms init 0.08 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.04 ms Creating tmp table 0.15 ms Sorting result 0.01 ms executing 0.01 ms Sending data 6.08 ms Creating sort index 0.25 ms end 0.01 ms removing tmp table 0.13 ms end 0.02 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.13 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/category.php:721 16 hikashopCategoryClass->getParents() JROOT/administrator/components/com_hikashop/classes/filter.php:305 15 hikashopFilterClass->getFilters() JROOT/components/com_hikashop/views/product/view.html.php:125 14 ProductViewProduct->filter() JROOT/components/com_hikashop/views/product/view.html.php:511 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.55 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.029 MB mémoire avant requête : 4.049 MB Rangées retournées : 1
SELECT a.*,b.*
FROM lms_hikashop_category AS a
LEFT JOIN lms_hikashop_file AS b
ON a.category_id = b.file_ref_id
AND b.file_type = 'category'
WHERE a.category_id = 36
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b ref file_type file_type 767 const 2 100.00 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.08 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.03 ms executing 0.01 ms Sending data 0.11 ms end 0.01 ms query end 0.06 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikashop/classes/category.php:35 14 hikashopCategoryClass->get() JROOT/components/com_hikashop/views/product/view.html.php:514 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.77 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.029 MB mémoire avant requête : 4.059 MB Rangées retournées : 1
SELECT *
FROM lms_hikashop_category
WHERE category_id = '36'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_category const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 17 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikashop/helpers/helper.php:2036 16 hikashopClass->get() JROOT/administrator/components/com_hikashop/classes/category.php:38 15 hikashopCategoryClass->get() JROOT/administrator/components/com_hikashop/classes/category.php:480 14 hikashopCategoryClass->getChildren() JROOT/components/com_hikashop/views/product/view.html.php:553 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 5.40 ms Après la dernière requête : 12.09 ms Mémoire de requête : 0.062 MB mémoire avant requête : 4.254 MB Rangées retournées : 7
SELECT DISTINCT b.*
FROM lms_hikashop_product_category AS a
LEFT JOIN lms_hikashop_product AS b
ON a.product_id=b.product_id
WHERE (b.product_published = 1)
AND (b.product_type = 'main')
AND (a.category_id IN (36))
AND ((b.product_access = 'all' OR b.product_access LIKE '%,1,%' OR b.product_access LIKE '%,9,%'))
ORDER BY a.ordering ASC
LIMIT 0, 21id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref category_id,product_id category_id 4 const 7 100.00 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE b eq_ref PRIMARY,product_main_index PRIMARY 4 lemondesolms.a.product_id 1 100.00 Using where Status Duration starting 0.15 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.49 ms init 0.16 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.51 ms preparing 0.10 ms Creating tmp table 0.24 ms Sorting result 0.01 ms executing 0.01 ms Sending data 1.85 ms Creating sort index 0.98 ms end 0.02 ms removing tmp table 0.13 ms end 0.02 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/components/com_hikashop/views/product/view.html.php:754 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.20 ms Après la dernière requête : 1.00 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.335 MB Rangées retournées : 7
SELECT *
FROM lms_hikashop_file
WHERE file_ref_id IN (7883,7862,7896,7903,1,7940,7954)
AND file_type IN ('product','file')
ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_file ALL file_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 39 94.87 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.07 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.19 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/product.php:1658 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.99 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.351 MB Rangées retournées : 18
SELECT variant_product_id
FROM lms_hikashop_variant
WHERE variant_product_id IN (7883,7862,7896,7903,1,7940,7954)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_variant range variant_product_id variant_product_id 4 NULL 18 100.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.02 ms Opening tables 0.25 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/product.php:1679 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.02 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.357 MB Rangées retournées : 0
SELECT product_id
FROM lms_hikashop_product_related
WHERE product_related_type = 'options'
AND product_id IN (7883,7862,7896,7903,1,7940,7954)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_product_related index PRIMARY PRIMARY 775 NULL 10 90.00 Using where; Using index Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.23 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.05 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/product.php:1695 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 3.50 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.364 MB Rangées retournées : 18
SELECT product_parent_id, product_id
FROM lms_hikashop_product
WHERE product_parent_id IN ('7883','7862','7896','7903','1','7940','7954')
AND product_published = 1
AND product_type = 'variant'
AND product_sale_start < 1590816217
AND (product_sale_end > 1590816217 OR product_sale_end = 0)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_product ref product_parent_id,product_main_index product_main_index 767 const 267 100.00 Using index condition; Using where Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.07 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.30 ms preparing 0.08 ms executing 0.01 ms Sending data 2.42 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/currency.php:883 17 hikashopCurrencyClass->_loadProductVariants() JROOT/administrator/components/com_hikashop/classes/currency.php:488 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.63 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.029 MB mémoire avant requête : 4.381 MB Rangées retournées : 0
SELECT *
FROM lms_hikashop_discount
WHERE discount_type='discount'
AND discount_published=1
AND (discount_quota>discount_used_times OR discount_quota=0)
AND discount_start < 1590816217
AND (discount_end > 1590816217 OR discount_end = 0)
AND ( (discount_product_id IN ('','0','7883','7862','7896','7903','1','7940','7954')) OR (discount_product_id LIKE '%,7883,%') OR (discount_product_id LIKE '%,7862,%') OR (discount_product_id LIKE '%,7896,%') OR (discount_product_id LIKE '%,7903,%') OR (discount_product_id LIKE '%,1,%') OR (discount_product_id LIKE '%,7940,%') OR (discount_product_id LIKE '%,7954,%') OR (discount_product_id LIKE '%,2,%') OR (discount_product_id LIKE '%,21,%') OR (discount_product_id LIKE '%,7863,%') OR (discount_product_id LIKE '%,7864,%') OR (discount_product_id LIKE '%,7865,%') OR (discount_product_id LIKE '%,7866,%') OR (discount_product_id LIKE '%,7867,%') OR (discount_product_id LIKE '%,7868,%') OR (discount_product_id LIKE '%,7904,%') OR (discount_product_id LIKE '%,7905,%') OR (discount_product_id LIKE '%,7906,%') OR (discount_product_id LIKE '%,7907,%') OR (discount_product_id LIKE '%,7908,%') OR (discount_product_id LIKE '%,7909,%') OR (discount_product_id LIKE '%,7902,%') OR (discount_product_id LIKE '%,7885,%') OR (discount_product_id LIKE '%,7946,%') OR (discount_product_id LIKE '%,7960,%') )
AND (discount_flat_amount != 0 OR discount_percent_amount != 0)
AND (discount_flat_amount = 0 OR discount_currency_id =1)
AND (discount_access = 'all' OR discount_access LIKE '%,1,%' OR discount_access LIKE '%,9,%')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.25 ms checking permissions 0.02 ms Opening tables 0.30 ms init 0.29 ms System lock 0.02 ms optimizing 0.11 ms statistics 0.07 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/currency.php:514 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.06 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.388 MB Rangées retournées : 2
SELECT currency_id
FROM lms_hikashop_currency
WHERE currency_published=1 OR currency_id = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_currency ALL PRIMARY INDEX N'A PU ÊTRE UTILISÉ NULL NULL 181 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.02 ms Opening tables 0.24 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.03 ms executing 0.01 ms Sending data 0.18 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 18 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_hikashop/classes/currency.php:446 17 hikashopCurrencyClass->publishedCurrencies() JROOT/administrator/components/com_hikashop/classes/currency.php:519 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.53 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.392 MB Rangées retournées : 7
SELECT a.*,
CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id
FROM lms_hikashop_price AS a
WHERE a.price_product_id IN (7883,7862,7896,7903,1,7940,7954)
AND a.price_currency_id IN (1,2)
AND (a.price_access = 'all' OR a.price_access LIKE '%,1,%' OR a.price_access LIKE '%,9,%' OR ISNULL(a.price_access))
AND (a.price_users = '' OR a.price_users LIKE '%,0,%')
ORDER BY a.price_site_id ASC, a.price_value DESCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a range price_product_id price_product_id 4 NULL 8 100.00 Using index condition; Using where; Utilisation du tri complet de type filesort Status Duration starting 0.16 ms checking permissions 0.02 ms Opening tables 0.22 ms init 0.09 ms System lock 0.02 ms optimizing 0.07 ms statistics 0.14 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.28 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.05 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/currency.php:531 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.43 ms Après la dernière requête : 0.50 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.412 MB Rangées retournées : 0
SELECT b.*,c.*
FROM lms_hikashop_category AS a
LEFT JOIN lms_hikashop_taxation AS b
ON a.category_namekey=b.category_namekey
LEFT JOIN lms_hikashop_tax AS c
ON b.tax_namekey=c.tax_namekey
WHERE a.category_id = 11
AND b.taxation_published=1
AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') )
AND b.taxation_date_start <= 1590816217
AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1590816217)
AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,1,%' OR b.taxation_access LIKE '%,9,%')
ORDER BY b.taxation_id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.19 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.46 ms init 0.11 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.08 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/currency.php:170 18 hikashopCurrencyClass->getTax() JROOT/administrator/components/com_hikashop/classes/currency.php:57 17 hikashopCurrencyClass->getTaxedPrice() JROOT/administrator/components/com_hikashop/classes/currency.php:603 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.66 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 4.418 MB Rangées retournées : 1
SELECT category_parent_id
FROM lms_hikashop_category
WHERE category_id = 11id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_category const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 19 JDatabaseDriver->loadResult() JROOT/administrator/components/com_hikashop/classes/currency.php:174 18 hikashopCurrencyClass->getTax() JROOT/administrator/components/com_hikashop/classes/currency.php:57 17 hikashopCurrencyClass->getTaxedPrice() JROOT/administrator/components/com_hikashop/classes/currency.php:603 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.94 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.426 MB Rangées retournées : 0
SELECT b.*,c.*
FROM lms_hikashop_category AS a
LEFT JOIN lms_hikashop_taxation AS b
ON a.category_namekey=b.category_namekey
LEFT JOIN lms_hikashop_tax AS c
ON b.tax_namekey=c.tax_namekey
WHERE a.category_id = 3
AND b.taxation_published=1
AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') )
AND b.taxation_date_start <= 1590816217
AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1590816217)
AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,1,%' OR b.taxation_access LIKE '%,9,%')
ORDER BY b.taxation_id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.09 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.07 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.03 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/currency.php:170 18 hikashopCurrencyClass->getTax() JROOT/administrator/components/com_hikashop/classes/currency.php:57 17 hikashopCurrencyClass->getTaxedPrice() JROOT/administrator/components/com_hikashop/classes/currency.php:603 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.62 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.435 MB Rangées retournées : 1
SELECT category_parent_id
FROM lms_hikashop_category
WHERE category_id = 3id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_category const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 19 JDatabaseDriver->loadResult() JROOT/administrator/components/com_hikashop/classes/currency.php:174 18 hikashopCurrencyClass->getTax() JROOT/administrator/components/com_hikashop/classes/currency.php:57 17 hikashopCurrencyClass->getTaxedPrice() JROOT/administrator/components/com_hikashop/classes/currency.php:603 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.84 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.444 MB Rangées retournées : 0
SELECT b.*,c.*
FROM lms_hikashop_category AS a
LEFT JOIN lms_hikashop_taxation AS b
ON a.category_namekey=b.category_namekey
LEFT JOIN lms_hikashop_tax AS c
ON b.tax_namekey=c.tax_namekey
WHERE a.category_id = 1
AND b.taxation_published=1
AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') )
AND b.taxation_date_start <= 1590816217
AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1590816217)
AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,1,%' OR b.taxation_access LIKE '%,9,%')
ORDER BY b.taxation_id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.08 ms statistics 0.06 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/currency.php:170 18 hikashopCurrencyClass->getTax() JROOT/administrator/components/com_hikashop/classes/currency.php:57 17 hikashopCurrencyClass->getTaxedPrice() JROOT/administrator/components/com_hikashop/classes/currency.php:603 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.56 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 4.450 MB Rangées retournées : 1
SELECT category_parent_id
FROM lms_hikashop_category
WHERE category_id = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_category const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 19 JDatabaseDriver->loadResult() JROOT/administrator/components/com_hikashop/classes/currency.php:174 18 hikashopCurrencyClass->getTax() JROOT/administrator/components/com_hikashop/classes/currency.php:57 17 hikashopCurrencyClass->getTaxedPrice() JROOT/administrator/components/com_hikashop/classes/currency.php:603 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.80 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.026 MB mémoire avant requête : 4.457 MB Rangées retournées : 1
SELECT *
FROM lms_hikashop_zone
WHERE zone_id = 73id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE lms_hikashop_zone const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.03 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 19 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikashop/classes/currency.php:191 18 hikashopCurrencyClass->getTax() JROOT/administrator/components/com_hikashop/classes/currency.php:57 17 hikashopCurrencyClass->getTaxedPrice() JROOT/administrator/components/com_hikashop/classes/currency.php:603 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.95 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.027 MB mémoire avant requête : 4.466 MB Rangées retournées : 0
SELECT b.*,c.*
FROM lms_hikashop_category AS a
LEFT JOIN lms_hikashop_taxation AS b
ON a.category_namekey=b.category_namekey
LEFT JOIN lms_hikashop_tax AS c
ON b.tax_namekey=c.tax_namekey
WHERE a.category_id = 11
AND b.taxation_published=1
AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') )
AND b.taxation_date_start <= 1590816217
AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1590816217)
AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,1,%' OR b.taxation_access LIKE '%,9,%')
ORDER BY b.taxation_id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.10 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.11 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/currency.php:170 18 hikashopCurrencyClass->getTax() JROOT/administrator/components/com_hikashop/classes/currency.php:57 17 hikashopCurrencyClass->getTaxedPrice() JROOT/administrator/components/com_hikashop/classes/currency.php:603 16 hikashopCurrencyClass->getProductsPrices() JROOT/administrator/components/com_hikashop/classes/currency.php:451 15 hikashopCurrencyClass->getListingPrices() JROOT/administrator/components/com_hikashop/classes/product.php:1710 14 hikashopProductClass->loadProductsListingData() JROOT/components/com_hikashop/views/product/view.html.php:770 13 ProductViewProduct->listing() JROOT/components/com_hikashop/views/product/view.html.php:28 12 ProductViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1855 10 hikashopController->display() JROOT/components/com_hikashop/controllers/product.php:40 9 productController->listing() JROOT/libraries/src/MVC/Controller/BaseController.php:710 8 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1834 7 hikashopController->execute() JROOT/components/com_hikashop/hikashop.php:79 6 require_once JROOT/components/com_hikashop/hikashop.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.61 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 4.472 MB Rangées retournées : 1