Tijd zoekopdracht: 3.56 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 4.065 MB Regels teruggegeven: 0
SELECT `data`
  FROM `jc9g2_session`
  WHERE `session_id` = X'306f336b6664326d646f757269356b653174723663366370316f'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_session | const | PRIMARY | PRIMARY | 194 | const | 1 |  | 
| Status | Duration | 
|---|
| Starting | 0.17 ms | 
| checking permissions | 0.03 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.02 ms | 
| System lock | 0.01 ms | 
| table lock | 0.03 ms | 
| init | 0.06 ms | 
| Optimizing | 0.03 ms | 
| Statistics | 2.65 ms | 
| Preparing | 0.08 ms | 
| Executing | 0.04 ms | 
| End of update loop | 0.02 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.02 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.05 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | 
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 | 
| 14 | JSessionStorageDatabase->read() | Zelfde als de call in onderstaande regel. | 
| 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:661 | 
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 | 
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 | 
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 | 
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 | 
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | 
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 | 
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 | 
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | 
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 | 
Tijd zoekopdracht: 0.70 ms Na de laatste zoekopdracht: 3.00 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 4.172 MB Regels teruggegeven: 0
SELECT `session_id`
  FROM `jc9g2_session`
  WHERE `session_id` = X'306f336b6664326d646f757269356b653174723663366370316f' 
  LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index | 
| Status | Duration | 
|---|
| Starting | 0.13 ms | 
| checking permissions | 0.03 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.05 ms | 
| Optimizing | 0.03 ms | 
| Statistics | 0.07 ms | 
| Preparing | 0.01 ms | 
| Executing | 0.02 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.05 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | 
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 | 
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 | 
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 | 
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | 
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 | 
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 | 
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | 
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 | 
Tijd zoekopdracht: 9.78 ms Na de laatste zoekopdracht: 0.26 ms Zoekopdracht geheugen: 0.004 MB geheugen voor zoekopdracht: 4.177 MB
INSERT INTO `jc9g2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'306f336b6664326d646f757269356b653174723663366370316f', 1, 1762233915, 0, '', 0)
VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `jc9g2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES 
(X'306f336b6664326d646f757269356b653174723663366370316f', 1, 1762233915, 0, '', 0)
| Status | Duration | 
|---|
| Starting | 0.09 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init for update | 0.03 ms | 
| Update | 8.08 ms | 
| End of update loop | 0.05 ms | 
| Query end | 0.02 ms | 
| Commit | 0.98 ms | 
| Query end | 0.03 ms | 
| closing tables | 0.02 ms | 
| Unlocking tables | 0.03 ms | 
| closing tables | 0.02 ms | 
| Query end | 0.02 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.06 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 | 
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 | 
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 | 
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | 
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 | 
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 | 
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | 
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 | 
Tijd zoekopdracht: 1.57 ms Na de laatste zoekopdracht: 14.62 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 4.778 MB Regels teruggegeven: 8
SELECT id, rules
  FROM `jc9g2_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_viewlevels | ALL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | 8 |  | 
| Status | Duration | 
|---|
| Starting | 0.19 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.06 ms | 
| After opening tables | 0.02 ms | 
| System lock | 0.01 ms | 
| table lock | 0.02 ms | 
| init | 0.03 ms | 
| Optimizing | 0.02 ms | 
| Statistics | 0.03 ms | 
| Preparing | 0.03 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.72 ms | 
| End of update loop | 0.02 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 | 
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 | 
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 | 
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 | 
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 | 
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 | 
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 | 
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | 
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 1.60 ms Na de laatste zoekopdracht: 0.26 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 4.791 MB Regels teruggegeven: 2
SELECT b.id
  FROM jc9g2_usergroups AS a
  LEFT JOIN jc9g2_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt
  WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 |  | 
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 6 | Using where; Using index | 
| Status | Duration | 
|---|
| Starting | 0.10 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.04 ms | 
| Optimizing | 0.02 ms | 
| Statistics | 0.94 ms | 
| Preparing | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| Preparing | 0.04 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.05 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.04 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | 
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 | 
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 | 
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 | 
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 | 
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 | 
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 | 
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 | 
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | 
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 1.04 ms Na de laatste zoekopdracht: 59.42 ms Zoekopdracht geheugen: 0.061 MB geheugen voor zoekopdracht: 8.436 MB Regels teruggegeven: 329
SELECT * 
  FROM jc9g2_hikashop_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_hikashop_config | ALL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | 329 |  | 
| Status | Duration | 
|---|
| Starting | 0.13 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.02 ms | 
| init | 0.12 ms | 
| Optimizing | 0.03 ms | 
| Statistics | 0.04 ms | 
| Preparing | 0.03 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.30 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/config.php:16 | 
| 12 | hikashopConfigClass->load() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1455 | 
| 11 | hikashop_config() | JROOT/administrator/components/com_hikashop/helpers/helper.php:3620 | 
| 10 | include_once JROOT/administrator/components/com_hikashop/helpers/helper.php | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:194 | 
| 9 | plgSystemHikashopgeolocation->process() | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:72 | 
| 8 | plgSystemHikashopgeolocation->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | 
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | 
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | 
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | 
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | 
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 9.56 ms Na de laatste zoekopdracht: 60.92 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 13.775 MB
UPDATE `jc9g2_extensions`
  SET `params` = '{\"mediaversion\":\"b1aac1d1ec5a713cf203414d20a9e351\"}'
  WHERE `type` = 'library' 
  AND `element` = 'joomla'
VERKLAREN niet mogelijk voor zoekopdracht: UPDATE `jc9g2_extensions`
SET `params` = '{\"mediaversion\":\"b1aac1d1ec5a713cf203414d20a9e351\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration | 
|---|
| Starting | 0.16 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.05 ms | 
| After opening tables | 0.02 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init for update | 3.72 ms | 
| Updating | 3.60 ms | 
| End of update loop | 0.05 ms | 
| Query end | 0.01 ms | 
| Commit | 1.47 ms | 
| Query end | 0.03 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.06 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 | 
| 15 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 | 
| 14 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 | 
| 13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | 
| 12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | 
| 11 | Joomla\CMS\Factory::getDocument() | JROOT/administrator/components/com_hikashop/helpers/helper.php:3778 | 
| 10 | include_once JROOT/administrator/components/com_hikashop/helpers/helper.php | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:194 | 
| 9 | plgSystemHikashopgeolocation->process() | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:72 | 
| 8 | plgSystemHikashopgeolocation->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | 
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | 
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | 
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | 
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | 
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 2.36 ms Na de laatste zoekopdracht: 4.69 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 13.893 MB Regels teruggegeven: 1
SELECT * 
  FROM jc9g2_hikashop_geolocation 
  WHERE geolocation_ip ='216.73.216.34' 
  AND geolocation_type IN ('visit', 'bot') 
  ORDER BY geolocation_created DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_hikashop_geolocation | ALL | geolocation_type | INDEX KEY ONTBREEKT | NULL | NULL | 4526 | Using where; Gebruikt bestandssortering | 
| Status | Duration | 
|---|
| Starting | 0.18 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.08 ms | 
| Optimizing | 0.04 ms | 
| Statistics | 0.43 ms | 
| Preparing | 0.04 ms | 
| Sorting result | 0.02 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.02 ms | 
| Creating sort index | 1.05 ms | 
| End of update loop | 0.02 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.08 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | 
| 11 | JDatabaseDriver->loadObject() | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:220 | 
| 10 | plgSystemHikashopgeolocation->getZone() | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:196 | 
| 9 | plgSystemHikashopgeolocation->process() | JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:72 | 
| 8 | plgSystemHikashopgeolocation->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | 
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | 
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | 
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | 
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | 
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 1.37 ms Na de laatste zoekopdracht: 21.07 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 14.985 MB Regels teruggegeven: 38
SELECT *
  FROM jc9g2_rsform_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_rsform_config | ALL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | 38 |  | 
| Status | Duration | 
|---|
| Starting | 0.10 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.03 ms | 
| Optimizing | 0.02 ms | 
| Statistics | 0.03 ms | 
| Preparing | 0.03 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.74 ms | 
| End of update loop | 0.02 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.03 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsform/helpers/config.php:52 | 
| 11 | RSFormProConfig->load() | JROOT/administrator/components/com_rsform/helpers/config.php:19 | 
| 10 | RSFormProConfig->__construct() | JROOT/administrator/components/com_rsform/helpers/config.php:104 | 
| 9 | RSFormProConfig::getInstance() | JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:34 | 
| 8 | plgSystemRsformdeletesubmissions->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 | 
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | 
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 | 
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 | 
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | 
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 6.72 ms Na de laatste zoekopdracht: 75.42 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 17.026 MB Regels teruggegeven: 1
SELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering  
  FROM jc9g2_hikashop_product AS product  
  LEFT JOIN jc9g2_hikashop_product_category AS product_category 
  ON product.product_id = product_category.product_id  
  WHERE (product.product_id = 9) 
  AND ((product.product_access = 'all' OR product.product_access LIKE '%,9,%')) 
  LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | product | const | PRIMARY | PRIMARY | 4 | const | 1 |  | 
| 1 | SIMPLE | product_category | ref | product_id | product_id | 4 | const | 2 |  | 
| Status | Duration | 
|---|
| Starting | 0.19 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.07 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.02 ms | 
| init | 0.12 ms | 
| Optimizing | 0.05 ms | 
| Statistics | 2.99 ms | 
| Preparing | 0.03 ms | 
| Unlocking tables | 0.01 ms | 
| Preparing | 0.06 ms | 
| Executing | 0.01 ms | 
| Sending data | 2.67 ms | 
| End of update loop | 0.03 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.02 ms | 
| Query end | 0.02 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.03 ms | 
| Updating status | 0.05 ms | 
| Reset for next command | 0.03 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | 
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_hikashop/views/product/view.html.php:1463 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 18.67 ms Na de laatste zoekopdracht: 28.30 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 18.487 MB Regels teruggegeven: 0
SELECT cart.cart_id 
  FROM jc9g2_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = '0o3kfd2mdouri5ke1tr6c6cp1o')  
  ORDER BY cart.cart_current DESC, cart.cart_modified DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | cart | ref | session_id | session_id | 767 | const | 1 | Using index condition; Using where; Gebruikt bestandssortering | 
| Status | Duration | 
|---|
| Starting | 0.17 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.02 ms | 
| init | 0.07 ms | 
| Optimizing | 0.04 ms | 
| Statistics | 17.77 ms | 
| Preparing | 0.10 ms | 
| Sorting result | 0.02 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.02 ms | 
| Creating sort index | 0.06 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.05 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | 
| 17 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_hikashop/classes/cart.php:69 | 
| 16 | hikashopCartClass->getCurrentCartId() | JROOT/administrator/components/com_hikashop/classes/cart.php:165 | 
| 15 | hikashopCartClass->get() | JROOT/administrator/components/com_hikashop/helpers/helper.php:585 | 
| 14 | hikashop_getZone() | JROOT/components/com_hikashop/views/product/view.html.php:1509 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 3.22 ms Na de laatste zoekopdracht: 0.44 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 18.497 MB Regels teruggegeven: 1
SELECT * 
  FROM jc9g2_hikashop_currency 
  WHERE currency_id IN (1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_hikashop_currency | const | PRIMARY | PRIMARY | 4 | const | 1 |  | 
| Status | Duration | 
|---|
| Starting | 0.09 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.05 ms | 
| Optimizing | 0.02 ms | 
| Statistics | 2.62 ms | 
| Preparing | 0.03 ms | 
| Unlocking tables | 0.01 ms | 
| Preparing | 0.03 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.05 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/currency.php:2019 | 
| 14 | hikashopCurrencyClass->getCurrencies() | JROOT/components/com_hikashop/views/product/view.html.php:1516 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 3.18 ms Na de laatste zoekopdracht: 7.17 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 18.713 MB
UPDATE jc9g2_hikashop_product 
  SET product_hit = product_hit + 1, product_last_seen_date = 1762233916 
  WHERE product_id = 9
VERKLAREN niet mogelijk voor zoekopdracht: UPDATE jc9g2_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1762233916 WHERE product_id = 9
| Status | Duration | 
|---|
| Starting | 0.13 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init for update | 0.09 ms | 
| Updating | 0.14 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.00 ms | 
| Unlocking tables | 2.44 ms | 
| closing tables | 0.03 ms | 
| Query end | 0.02 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_hikashop/classes/product.php:4264 | 
| 14 | hikashopProductClass->hit() | JROOT/components/com_hikashop/views/product/view.html.php:1559 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.67 ms Na de laatste zoekopdracht: 0.40 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 18.721 MB Regels teruggegeven: 0
SELECT p.*  
  FROM jc9g2_hikashop_product_related AS pr  
  LEFT JOIN jc9g2_hikashop_product AS p 
  ON pr.product_related_id = p.product_id  
  WHERE (pr.product_id = 9) 
  AND (pr.product_related_type = 'options') 
  AND (p.product_published = 1) 
  AND ((p.product_sale_start = '' OR p.product_sale_start <= 1762233916)) 
  AND ((p.product_sale_end = '' OR p.product_sale_end > 1762233916)) 
  AND ((p.product_access = 'all' OR p.product_access LIKE '%,9,%'))  
  ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | NULL | NULL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables | 
| Status | Duration | 
|---|
| Starting | 0.14 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.05 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.10 ms | 
| Optimizing | 0.05 ms | 
| Statistics | 0.04 ms | 
| Preparing | 0.01 ms | 
| Executing | 0.05 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/product/view.html.php:1581 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.36 ms Na de laatste zoekopdracht: 0.10 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 18.728 MB Regels teruggegeven: 0
SELECT p.*, pr.product_related_quantity  
  FROM jc9g2_hikashop_product_related AS pr  
  INNER JOIN jc9g2_hikashop_product AS p 
  ON pr.product_related_id = p.product_id  
  WHERE pr.product_id = 9 
  AND pr.product_related_type = 'bundle' 
  ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | NULL | NULL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables | 
| Status | Duration | 
|---|
| Starting | 0.04 ms | 
| checking permissions | 0.05 ms | 
| Opening tables | 0.02 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.04 ms | 
| Optimizing | 0.02 ms | 
| Statistics | 0.02 ms | 
| Preparing | 0.01 ms | 
| Executing | 0.02 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/product/view.html.php:1598 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.34 ms Na de laatste zoekopdracht: 0.11 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 18.735 MB Regels teruggegeven: 0
SELECT * 
  FROM jc9g2_hikashop_product 
  WHERE (product_parent_id IN (9)) 
  AND (product_published = 1) 
  AND ((product_access = 'all' OR product_access LIKE '%,9,%'))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_hikashop_product | ref | product_parent_id | product_parent_id | 4 | const | 1 | Using where | 
| Status | Duration | 
|---|
| Starting | 0.03 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.01 ms | 
| After opening tables | 0.00 ms | 
| System lock | 0.00 ms | 
| table lock | 0.01 ms | 
| init | 0.03 ms | 
| Optimizing | 0.02 ms | 
| Statistics | 0.06 ms | 
| Preparing | 0.03 ms | 
| Executing | 0.00 ms | 
| Sending data | 0.03 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.00 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.00 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/product/view.html.php:1626 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.29 ms Na de laatste zoekopdracht: 0.06 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 18.744 MB Regels teruggegeven: 0
SELECT v.*, c.*  
  FROM jc9g2_hikashop_variant AS v  
  INNER JOIN jc9g2_hikashop_characteristic AS c 
  ON v.variant_characteristic_id = c.characteristic_id  
  WHERE v.variant_product_id IN (9)  
  ORDER BY v.ordering ASC, c.characteristic_ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | NULL | NULL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables | 
| Status | Duration | 
|---|
| Starting | 0.03 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.00 ms | 
| table lock | 0.01 ms | 
| init | 0.02 ms | 
| Optimizing | 0.01 ms | 
| Statistics | 0.02 ms | 
| Preparing | 0.01 ms | 
| Executing | 0.01 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.00 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.03 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/product/view.html.php:1667 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 2.65 ms Na de laatste zoekopdracht: 0.07 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 18.752 MB Regels teruggegeven: 1
SELECT * 
  FROM jc9g2_hikashop_file 
  WHERE file_ref_id IN (9) 
  AND file_type IN ('product','file') 
  AND (file_access = 'all' OR file_access LIKE '%,9,%') 
  ORDER BY file_ordering ASC, file_id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_hikashop_file | ALL | file_type | INDEX KEY ONTBREEKT | NULL | NULL | 23 | Using where; Gebruikt bestandssortering | 
| Status | Duration | 
|---|
| Starting | 0.03 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.03 ms | 
| Optimizing | 0.02 ms | 
| Statistics | 0.06 ms | 
| Preparing | 0.02 ms | 
| Sorting result | 0.01 ms | 
| Executing | 0.00 ms | 
| Sending data | 0.01 ms | 
| Creating sort index | 2.24 ms | 
| End of update loop | 0.02 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/product/view.html.php:1712 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.38 ms Na de laatste zoekopdracht: 0.17 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 18.761 MB Regels teruggegeven: 2
SELECT currency_id 
  FROM jc9g2_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_hikashop_currency | ALL | PRIMARY | INDEX KEY ONTBREEKT | NULL | NULL | 182 | Using where | 
| Status | Duration | 
|---|
| Starting | 0.07 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.02 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.02 ms | 
| Optimizing | 0.02 ms | 
| Statistics | 0.02 ms | 
| Preparing | 0.02 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.07 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.00 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.00 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | 
| 17 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_hikashop/classes/currency.php:473 | 
| 16 | hikashopCurrencyClass->publishedCurrencies() | JROOT/administrator/components/com_hikashop/classes/currency.php:1674 | 
| 15 | hikashopCurrencyClass->getProductPrices() | JROOT/administrator/components/com_hikashop/classes/currency.php:1636 | 
| 14 | hikashopCurrencyClass->getPrices() | JROOT/components/com_hikashop/views/product/view.html.php:1718 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 5.50 ms Na de laatste zoekopdracht: 0.22 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 18.773 MB Regels teruggegeven: 1
SELECT p.* 
  FROM jc9g2_hikashop_price as p 
  WHERE (p.price_currency_id IN (1,2)) 
  AND (p.price_start_date < 1762233916) 
  AND ((p.price_end_date < 1 OR p.price_end_date > 1762233916)) 
  AND (p.price_product_id IN (9)) 
  AND ((p.price_access = 'all' OR p.price_access LIKE '%,9,%')) 
  AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) 
  ORDER BY p.price_site_id ASC, p.price_value DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | p | ref | price_product_id | price_product_id | 4 | const | 1 | Using where; Gebruikt bestandssortering | 
| Status | Duration | 
|---|
| Starting | 0.09 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.05 ms | 
| Optimizing | 0.03 ms | 
| Statistics | 0.05 ms | 
| Preparing | 0.03 ms | 
| Sorting result | 0.01 ms | 
| Executing | 0.02 ms | 
| Sending data | 0.01 ms | 
| Creating sort index | 4.77 ms | 
| End of update loop | 0.03 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.02 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.02 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/currency.php:1718 | 
| 15 | hikashopCurrencyClass->getProductPrices() | JROOT/administrator/components/com_hikashop/classes/currency.php:1636 | 
| 14 | hikashopCurrencyClass->getPrices() | JROOT/components/com_hikashop/views/product/view.html.php:1718 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 8.60 ms Na de laatste zoekopdracht: 9.31 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 19.007 MB Regels teruggegeven: 1
SELECT b.*,c.* 
  FROM jc9g2_hikashop_category AS a 
  LEFT JOIN jc9g2_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN jc9g2_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 <= 1762233916 
  AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1762233916) 
  AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%') 
  ORDER BY b.taxation_id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | b | system | NULL | INDEX KEY ONTBREEKT | NULL | NULL | 1 |  | 
| 1 | SIMPLE | a | const | PRIMARY,category_namekey | PRIMARY | 4 | const | 1 |  | 
| 1 | SIMPLE | c | system | PRIMARY | INDEX KEY ONTBREEKT | NULL | NULL | 1 |  | 
| Status | Duration | 
|---|
| Starting | 0.17 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.08 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.11 ms | 
| Optimizing | 0.05 ms | 
| Statistics | 7.67 ms | 
| Preparing | 0.04 ms | 
| Unlocking tables | 0.01 ms | 
| Preparing | 0.03 ms | 
| Executing | 0.00 ms | 
| Sending data | 0.04 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.02 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.02 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 20 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/currency.php:199 | 
| 19 | hikashopCurrencyClass->getTax() | JROOT/administrator/components/com_hikashop/classes/currency.php:62 | 
| 18 | hikashopCurrencyClass->getTaxedPrice() | JROOT/administrator/components/com_hikashop/classes/currency.php:2889 | 
| 17 | hikashopCurrencyClass->addTax() | JROOT/administrator/components/com_hikashop/classes/currency.php:1810 | 
| 16 | hikashopCurrencyClass->removeAndAddPrices() | JROOT/administrator/components/com_hikashop/classes/currency.php:1728 | 
| 15 | hikashopCurrencyClass->getProductPrices() | JROOT/administrator/components/com_hikashop/classes/currency.php:1636 | 
| 14 | hikashopCurrencyClass->getPrices() | JROOT/components/com_hikashop/views/product/view.html.php:1718 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 5.34 ms Na de laatste zoekopdracht: 0.29 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 19.019 MB Regels teruggegeven: 1
SELECT * 
  FROM jc9g2_hikashop_zone 
  WHERE zone_id = 150
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_hikashop_zone | const | PRIMARY | PRIMARY | 4 | const | 1 |  | 
| Status | Duration | 
|---|
| Starting | 0.07 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.03 ms | 
| Optimizing | 0.02 ms | 
| Statistics | 4.78 ms | 
| Preparing | 0.03 ms | 
| Unlocking tables | 0.01 ms | 
| Preparing | 0.03 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.03 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | 
| 20 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/classes/currency.php:220 | 
| 19 | hikashopCurrencyClass->getTax() | JROOT/administrator/components/com_hikashop/classes/currency.php:62 | 
| 18 | hikashopCurrencyClass->getTaxedPrice() | JROOT/administrator/components/com_hikashop/classes/currency.php:2889 | 
| 17 | hikashopCurrencyClass->addTax() | JROOT/administrator/components/com_hikashop/classes/currency.php:1810 | 
| 16 | hikashopCurrencyClass->removeAndAddPrices() | JROOT/administrator/components/com_hikashop/classes/currency.php:1728 | 
| 15 | hikashopCurrencyClass->getProductPrices() | JROOT/administrator/components/com_hikashop/classes/currency.php:1636 | 
| 14 | hikashopCurrencyClass->getPrices() | JROOT/components/com_hikashop/views/product/view.html.php:1718 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.54 ms Na de laatste zoekopdracht: 0.58 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 19.035 MB Regels teruggegeven: 0
SELECT * 
  FROM jc9g2_hikashop_discount 
  WHERE (discount_type = 'discount') 
  AND (discount_published = 1) 
  AND (discount_quota > discount_used_times OR discount_quota = 0) 
  AND (discount_start < 1762233916) 
  AND (discount_end > 1762233916 OR discount_end = 0) 
  AND (discount_product_id IN ('','0','9') OR discount_product_id LIKE '%,9,%') 
  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 '%,9,%')) 
  AND ((discount_user_id = '' OR discount_user_id LIKE '%,0,%'))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | NULL | NULL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables | 
| Status | Duration | 
|---|
| Starting | 0.12 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.08 ms | 
| Optimizing | 0.05 ms | 
| Statistics | 0.02 ms | 
| Preparing | 0.01 ms | 
| Executing | 0.02 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.00 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.00 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/currency.php:1778 | 
| 15 | hikashopCurrencyClass->getProductPrices() | JROOT/administrator/components/com_hikashop/classes/currency.php:1636 | 
| 14 | hikashopCurrencyClass->getPrices() | JROOT/components/com_hikashop/views/product/view.html.php:1718 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.81 ms Na de laatste zoekopdracht: 14.72 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 19.878 MB Regels teruggegeven: 2
SELECT category_id 
  FROM jc9g2_hikashop_product_category 
  WHERE product_id IN (9) 
  ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_hikashop_product_category | ref | product_id | product_id | 4 | const | 2 | Using where; Gebruikt bestandssortering | 
| Status | Duration | 
|---|
| Starting | 0.13 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.04 ms | 
| Optimizing | 0.03 ms | 
| Statistics | 0.07 ms | 
| Preparing | 0.03 ms | 
| Sorting result | 0.03 ms | 
| Executing | 0.00 ms | 
| Sending data | 0.01 ms | 
| Creating sort index | 0.11 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | 
| 17 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_hikashop/classes/product.php:1221 | 
| 16 | hikashopProductClass->getCategories() | JROOT/administrator/components/com_hikashop/classes/field.php:303 | 
| 15 | hikashopFieldClass->getCategories() | JROOT/administrator/components/com_hikashop/classes/field.php:188 | 
| 14 | hikashopFieldClass->getFields() | JROOT/components/com_hikashop/views/product/view.html.php:1860 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.34 ms Na de laatste zoekopdracht: 0.16 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 19.888 MB Regels teruggegeven: 2
SELECT hk_parent.category_id, hk_parent.category_parent_id 
  FROM jc9g2_hikashop_category AS hk_parent 
  WHERE  hk_parent.category_id IN (2,12)  
  ORDER BY hk_parent.category_left
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | hk_parent | range | PRIMARY | PRIMARY | 4 | NULL | 2 | Using index condition; Gebruikt bestandssortering | 
| Status | Duration | 
|---|
| Starting | 0.05 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.02 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.00 ms | 
| table lock | 0.01 ms | 
| init | 0.02 ms | 
| Optimizing | 0.01 ms | 
| Statistics | 0.03 ms | 
| Preparing | 0.01 ms | 
| Sorting result | 0.01 ms | 
| Executing | 0.00 ms | 
| Sending data | 0.01 ms | 
| Creating sort index | 0.04 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.00 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/category.php:784 | 
| 16 | hikashopCategoryClass->getParents() | JROOT/administrator/components/com_hikashop/classes/field.php:308 | 
| 15 | hikashopFieldClass->getCategories() | JROOT/administrator/components/com_hikashop/classes/field.php:188 | 
| 14 | hikashopFieldClass->getFields() | JROOT/components/com_hikashop/views/product/view.html.php:1860 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.34 ms Na de laatste zoekopdracht: 0.07 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 19.900 MB Regels teruggegeven: 1
SELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id 
  FROM jc9g2_hikashop_category AS hk_parent 
  WHERE  hk_parent.category_id IN (1)  
  ORDER BY hk_parent.category_left
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | hk_parent | const | PRIMARY | PRIMARY | 4 | const | 1 |  | 
| Status | Duration | 
|---|
| Starting | 0.04 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.02 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.02 ms | 
| Optimizing | 0.01 ms | 
| Statistics | 0.03 ms | 
| Preparing | 0.05 ms | 
| Unlocking tables | 0.01 ms | 
| Preparing | 0.01 ms | 
| Executing | 0.00 ms | 
| Sending data | 0.01 ms | 
| End of update loop | 0.00 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.00 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.01 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 18 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/category.php:784 | 
| 17 | hikashopCategoryClass->getParents() | JROOT/administrator/components/com_hikashop/classes/category.php:795 | 
| 16 | hikashopCategoryClass->getParents() | JROOT/administrator/components/com_hikashop/classes/field.php:308 | 
| 15 | hikashopFieldClass->getCategories() | JROOT/administrator/components/com_hikashop/classes/field.php:188 | 
| 14 | hikashopFieldClass->getFields() | JROOT/components/com_hikashop/views/product/view.html.php:1860 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 3.20 ms Na de laatste zoekopdracht: 0.14 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 19.911 MB Regels teruggegeven: 0
SELECT * 
  FROM jc9g2_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='product' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%')  
  AND ((((field_with_sub_categories = 0 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,12,%'))OR (field_with_sub_categories = 1 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,12,%'))) 
  AND field_products="") OR (field_products LIKE '%,9,%')) 
  ORDER BY a.`field_ordering` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | a | ALL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | 15 | Using where; Gebruikt bestandssortering | 
| Status | Duration | 
|---|
| Starting | 0.06 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.02 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.00 ms | 
| table lock | 0.01 ms | 
| init | 0.06 ms | 
| Optimizing | 0.04 ms | 
| Statistics | 0.02 ms | 
| Preparing | 0.02 ms | 
| Sorting result | 0.01 ms | 
| Executing | 0.00 ms | 
| Sending data | 0.01 ms | 
| Creating sort index | 2.63 ms | 
| End of update loop | 0.03 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.07 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.03 ms | 
| Updating status | 0.03 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/field.php:167 | 
| 15 | hikashopFieldClass->getData() | JROOT/administrator/components/com_hikashop/classes/field.php:189 | 
| 14 | hikashopFieldClass->getFields() | JROOT/components/com_hikashop/views/product/view.html.php:1860 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.65 ms Na de laatste zoekopdracht: 0.29 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 19.920 MB Regels teruggegeven: 0
SELECT * 
  FROM jc9g2_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='item' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%')  
  AND ((((field_with_sub_categories = 0 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,12,%'))OR (field_with_sub_categories = 1 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,12,%'))) 
  AND field_products="") OR (field_products LIKE '%,9,%')) 
  ORDER BY a.`field_ordering` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | a | ALL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | 15 | Using where; Gebruikt bestandssortering | 
| Status | Duration | 
|---|
| Starting | 0.11 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.02 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.00 ms | 
| table lock | 0.01 ms | 
| init | 0.11 ms | 
| Optimizing | 0.05 ms | 
| Statistics | 0.02 ms | 
| Preparing | 0.03 ms | 
| Sorting result | 0.01 ms | 
| Executing | 0.00 ms | 
| Sending data | 0.02 ms | 
| Creating sort index | 0.04 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.00 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/field.php:167 | 
| 15 | hikashopFieldClass->getData() | JROOT/administrator/components/com_hikashop/classes/field.php:189 | 
| 14 | hikashopFieldClass->getFields() | JROOT/components/com_hikashop/views/product/view.html.php:1885 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.53 ms Na de laatste zoekopdracht: 1.57 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 19.986 MB Regels teruggegeven: 0
SELECT a.* 
  FROM jc9g2_hikashop_badge AS a 
  WHERE a.badge_start <= 1762233916 
  AND (a.badge_end >= 1762233916 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = -1) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 350219028) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '12' OR badge_category_id LIKE '%,12,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '12' OR badge_category_id LIKE '%,12,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | NULL | NULL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables | 
| Status | Duration | 
|---|
| Starting | 0.13 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.06 ms | 
| Optimizing | 0.04 ms | 
| Statistics | 0.03 ms | 
| Preparing | 0.01 ms | 
| Executing | 0.02 ms | 
| End of update loop | 0.00 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.00 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/classes/badge.php:151 | 
| 14 | hikashopBadgeClass->loadBadges() | JROOT/components/com_hikashop/views/product/view.html.php:1910 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.79 ms Na de laatste zoekopdracht: 14.91 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 20.297 MB Regels teruggegeven: 2
SELECT b.*  
  FROM jc9g2_hikashop_product_category AS a  
  LEFT JOIN jc9g2_hikashop_category AS b 
  ON a.category_id = b.category_id  
  WHERE a.product_id = 9 
  ORDER BY a.product_category_id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | a | ref | product_id | product_id | 4 | const | 2 | Using where; Gebruikt bestandssortering | 
| 1 | SIMPLE | b | eq_ref | PRIMARY | PRIMARY | 4 | hovenie2_regen.a.category_id | 1 |  | 
| Status | Duration | 
|---|
| Starting | 0.14 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.06 ms | 
| Optimizing | 0.03 ms | 
| Statistics | 0.07 ms | 
| Preparing | 0.03 ms | 
| Sorting result | 0.01 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.02 ms | 
| Creating sort index | 0.10 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/product/view.html.php:2080 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 19.69 ms Na de laatste zoekopdracht: 6.93 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 20.479 MB Regels teruggegeven: 0
SELECT a.id 
  FROM jc9g2_menu AS a 
  INNER JOIN `jc9g2_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5,7) 
  AND a.client_id=0 
  AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' 
  AND a.language IN ('*', '', 'nl-NL')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | b | ALL | idx_menutype | INDEX KEY ONTBREEKT | NULL | NULL | 5 | Using where | 
| 1 | SIMPLE | a | ALL | idx_client_id_parent_id_alias_language,idx_menutype,idx_language | INDEX KEY ONTBREEKT | NULL | NULL | 90 | Using where; Using join buffer (flat, BNL join) | 
| Status | Duration | 
|---|
| Starting | 0.20 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.06 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.07 ms | 
| Optimizing | 0.06 ms | 
| Statistics | 5.48 ms | 
| Preparing | 0.16 ms | 
| Executing | 0.01 ms | 
| Sending data | 13.09 ms | 
| End of update loop | 0.05 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.03 ms | 
| Query end | 0.02 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.03 ms | 
| Updating status | 0.05 ms | 
| Reset for next command | 0.02 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | 
| 17 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_hikashop/classes/menus.php:333 | 
| 16 | hikashopMenusClass->loadAMenuItemId() | JROOT/administrator/components/com_hikashop/classes/menus.php:236 | 
| 15 | hikashopMenusClass->getCheckoutURL() | JROOT/administrator/components/com_hikashop/helpers/cart.php:255 | 
| 14 | hikashopCartHelper->getJS() | JROOT/components/com_hikashop/views/product/view.html.php:2115 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 0.87 ms Na de laatste zoekopdracht: 0.42 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 20.488 MB Regels teruggegeven: 7
SELECT a.id 
  FROM jc9g2_menu AS a 
  INNER JOIN `jc9g2_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5,7) 
  AND a.client_id=0 
  AND a.link LIKE 'index.php?option=com_hikashop&view=%' 
  AND a.language IN ('*', '', 'nl-NL')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | b | ALL | idx_menutype | INDEX KEY ONTBREEKT | NULL | NULL | 5 | Using where | 
| 1 | SIMPLE | a | ALL | idx_client_id_parent_id_alias_language,idx_menutype,idx_language | INDEX KEY ONTBREEKT | NULL | NULL | 90 | Using where; Using join buffer (flat, BNL join) | 
| Status | Duration | 
|---|
| Starting | 0.13 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.06 ms | 
| Optimizing | 0.04 ms | 
| Statistics | 0.11 ms | 
| Preparing | 0.06 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.13 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.00 ms | 
| Commit | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.00 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.04 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.02 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | 
| 17 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_hikashop/classes/menus.php:333 | 
| 16 | hikashopMenusClass->loadAMenuItemId() | JROOT/administrator/components/com_hikashop/classes/menus.php:241 | 
| 15 | hikashopMenusClass->getCheckoutURL() | JROOT/administrator/components/com_hikashop/helpers/cart.php:255 | 
| 14 | hikashopCartHelper->getJS() | JROOT/components/com_hikashop/views/product/view.html.php:2115 | 
| 13 | ProductViewProduct->show() | JROOT/components/com_hikashop/views/product/view.html.php:29 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 10.77 ms Na de laatste zoekopdracht: 0.65 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 20.502 MB Regels teruggegeven: 0
SELECT a.*, c.currency_symbol 
  FROM jc9g2_hikashop_shipping AS a  
  INNER JOIN jc9g2_hikashop_currency AS c 
  ON c.currency_id = a.shipping_currency_id  
  WHERE (a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' OR a.shipping_params LIKE '%s:20:\"shipping_per_product\";i:1%') 
  ORDER BY a.shipping_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | NULL | NULL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables | 
| Status | Duration | 
|---|
| Starting | 0.10 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 3.53 ms | 
| After opening tables | 0.42 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.14 ms | 
| Optimizing | 0.04 ms | 
| Statistics | 6.10 ms | 
| Preparing | 0.03 ms | 
| Unlocking tables | 0.01 ms | 
| Preparing | 0.01 ms | 
| Executing | 0.04 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.02 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.03 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:45 | 
| 18 | plgHikashopShippingmanual_prices->_getShippings() | JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:324 | 
| 17 | plgHikashopShippingmanual_prices->onHikashopBeforeDisplayView() | JROOT/libraries/joomla/event/event.php:70 | 
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 
| 15 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | 
| 14 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2879 | 
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/product/view.html.php:30 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 1.66 ms Na de laatste zoekopdracht: 7.62 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 20.540 MB Regels teruggegeven: 1
SELECT * 
  FROM jc9g2_extensions 
  WHERE folder='hikashop' 
  AND element='shippingmanual_prices' 
  AND type='plugin'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where | 
| Status | Duration | 
|---|
| Starting | 0.14 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.02 ms | 
| System lock | 0.01 ms | 
| table lock | 0.03 ms | 
| init | 0.08 ms | 
| Optimizing | 0.05 ms | 
| Statistics | 0.15 ms | 
| Preparing | 0.05 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.72 ms | 
| End of update loop | 0.02 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | 
| 19 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/classes/plugins.php:113 | 
| 18 | hikashopPluginsClass->getByName() | JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:328 | 
| 17 | plgHikashopShippingmanual_prices->onHikashopBeforeDisplayView() | JROOT/libraries/joomla/event/event.php:70 | 
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 
| 15 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | 
| 14 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2879 | 
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/product/view.html.php:30 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 6.15 ms Na de laatste zoekopdracht: 19.51 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 20.799 MB Regels teruggegeven: 1
SELECT * 
  FROM jc9g2_extensions 
  WHERE folder='system' 
  AND element='hikashopsocial' 
  AND type='plugin'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where | 
| Status | Duration | 
|---|
| Starting | 0.15 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.07 ms | 
| Optimizing | 0.04 ms | 
| Statistics | 0.14 ms | 
| Preparing | 0.09 ms | 
| Executing | 0.01 ms | 
| Sending data | 2.52 ms | 
| End of update loop | 2.63 ms | 
| Query end | 0.03 ms | 
| Commit | 0.02 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | 
| 25 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/classes/plugins.php:113 | 
| 24 | hikashopPluginsClass->getByName() | JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php:12 | 
| 23 | include JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 22 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 21 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show_default.php:45 | 
| 20 | include JROOT/components/com_hikashop/views/product/tmpl/show_default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 19 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 18 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show.php:97 | 
| 17 | include JROOT/components/com_hikashop/views/product/tmpl/show.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 15 | hikashopView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | 
| 14 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2924 | 
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/product/view.html.php:30 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 3.30 ms Na de laatste zoekopdracht: 0.29 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 20.813 MB Regels teruggegeven: 0
SELECT * 
  FROM jc9g2_extensions 
  WHERE folder='content' 
  AND element='hikashopsocial' 
  AND type='plugin'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where | 
| Status | Duration | 
|---|
| Starting | 0.08 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.02 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.09 ms | 
| Optimizing | 0.04 ms | 
| Statistics | 2.60 ms | 
| Preparing | 0.07 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.09 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.03 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | 
| 25 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/classes/plugins.php:113 | 
| 24 | hikashopPluginsClass->getByName() | JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php:16 | 
| 23 | include JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 22 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 21 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show_default.php:45 | 
| 20 | include JROOT/components/com_hikashop/views/product/tmpl/show_default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 19 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 18 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show.php:97 | 
| 17 | include JROOT/components/com_hikashop/views/product/tmpl/show.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 15 | hikashopView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | 
| 14 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2924 | 
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/product/view.html.php:30 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 11.96 ms Na de laatste zoekopdracht: 85.42 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 21.372 MB Regels teruggegeven: 0
SELECT `m`.`tag_id`,`t`.*
  FROM `jc9g2_contentitem_tag_map` AS m 
  INNER JOIN `jc9g2_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`
  WHERE `m`.`type_alias` = 'com_hikashop.product' 
  AND `m`.`content_item_id` = 9 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5,7)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | INDEX KEY ONTBREEKT | NULL | NULL | 1 | Using where | 
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hovenie2_regen.m.tag_id | 1 | Using where | 
| Status | Duration | 
|---|
| Starting | 0.20 ms | 
| checking permissions | 0.02 ms | 
| Opening tables | 0.06 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.17 ms | 
| Optimizing | 0.06 ms | 
| Statistics | 8.14 ms | 
| Preparing | 0.11 ms | 
| Executing | 0.01 ms | 
| Sending data | 2.69 ms | 
| End of update loop | 0.04 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.05 ms | 
| Reset for next command | 0.02 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | 
| 24 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_hikashop/views/product/tmpl/show_block_tags.php:35 | 
| 23 | include JROOT/components/com_hikashop/views/product/tmpl/show_block_tags.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 22 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 21 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show_default.php:222 | 
| 20 | include JROOT/components/com_hikashop/views/product/tmpl/show_default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 19 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 18 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show.php:97 | 
| 17 | include JROOT/components/com_hikashop/views/product/tmpl/show.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 15 | hikashopView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | 
| 14 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2924 | 
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/product/view.html.php:30 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 11.00 ms Na de laatste zoekopdracht: 75.40 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 22.061 MB Regels teruggegeven: 1
SELECT * 
  FROM jc9g2_extensions 
  WHERE folder='hikashop' 
  AND element='google_products' 
  AND type='plugin'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | jc9g2_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where | 
| Status | Duration | 
|---|
| Starting | 0.12 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.06 ms | 
| Optimizing | 2.44 ms | 
| Statistics | 5.18 ms | 
| Preparing | 0.12 ms | 
| Executing | 0.01 ms | 
| Sending data | 2.56 ms | 
| End of update loop | 0.03 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | 
| 25 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/classes/plugins.php:113 | 
| 24 | hikashopPluginsClass->getByName() | JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:12 | 
| 23 | include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 22 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 21 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show_default.php:266 | 
| 20 | include JROOT/components/com_hikashop/views/product/tmpl/show_default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 19 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 18 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show.php:97 | 
| 17 | include JROOT/components/com_hikashop/views/product/tmpl/show.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 15 | hikashopView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | 
| 14 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2924 | 
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/product/view.html.php:30 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 15.03 ms Na de laatste zoekopdracht: 0.44 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 22.077 MB Regels teruggegeven: 0
SELECT * 
  FROM jc9g2_hikashop_vote 
  WHERE vote_type = 'product' 
  AND vote_published > 0 
  AND vote_ref_id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | NULL | NULL | NULL | INDEX KEY ONTBREEKT | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables | 
| Status | Duration | 
|---|
| Starting | 0.11 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 12.01 ms | 
| After opening tables | 0.05 ms | 
| System lock | 0.01 ms | 
| table lock | 0.02 ms | 
| init | 0.07 ms | 
| Optimizing | 0.04 ms | 
| Statistics | 0.03 ms | 
| Preparing | 0.01 ms | 
| Executing | 0.02 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 2.34 ms | 
| Query end | 0.03 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 24 | JDatabaseDriver->loadObjectList() | JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:89 | 
| 23 | include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 22 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 21 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show_default.php:266 | 
| 20 | include JROOT/components/com_hikashop/views/product/tmpl/show_default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 19 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 18 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show.php:97 | 
| 17 | include JROOT/components/com_hikashop/views/product/tmpl/show.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 15 | hikashopView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | 
| 14 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2924 | 
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/product/view.html.php:30 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 6.26 ms Na de laatste zoekopdracht: 1.21 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 22.100 MB Regels teruggegeven: 5
SELECT a.id, a.link, a.params 
  FROM jc9g2_menu AS a 
  INNER JOIN `jc9g2_menu_types` AS b 
  ON a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5,7) 
  AND a.client_id=0 
  AND (a.link='index.php?option=com_hikashop&view=category&layout=listing' OR a.link='index.php?option=com_hikashop&view=product&layout=listing') 
  AND a.language IN ('*', '', 'nl-NL')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | b | ALL | idx_menutype | INDEX KEY ONTBREEKT | NULL | NULL | 5 | Using where | 
| 1 | SIMPLE | a | ALL | idx_client_id_parent_id_alias_language,idx_menutype,idx_language | INDEX KEY ONTBREEKT | NULL | NULL | 90 | Using where; Using join buffer (flat, BNL join) | 
| Status | Duration | 
|---|
| Starting | 0.16 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.05 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.02 ms | 
| table lock | 0.01 ms | 
| init | 0.08 ms | 
| Optimizing | 0.10 ms | 
| Statistics | 0.13 ms | 
| Preparing | 2.58 ms | 
| Executing | 0.02 ms | 
| Sending data | 2.76 ms | 
| End of update loop | 0.04 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.02 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.02 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.02 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 25 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1272 | 
| 24 | hikashop_contentLink() | JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:163 | 
| 23 | include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 22 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 21 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show_default.php:266 | 
| 20 | include JROOT/components/com_hikashop/views/product/tmpl/show_default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 19 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 18 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show.php:97 | 
| 17 | include JROOT/components/com_hikashop/views/product/tmpl/show.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 15 | hikashopView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | 
| 14 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2924 | 
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/product/view.html.php:30 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 5.68 ms Na de laatste zoekopdracht: 0.31 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 22.123 MB Regels teruggegeven: 2
SELECT c.category_id 
  FROM jc9g2_hikashop_product_category AS pc 
  INNER JOIN jc9g2_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1 
  WHERE pc.product_id = 9 
  ORDER BY pc.product_category_id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | pc | ref | category_id,product_id | product_id | 4 | const | 2 | Using where; Gebruikt bestandssortering | 
| 1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | hovenie2_regen.pc.category_id | 1 | Using where | 
| Status | Duration | 
|---|
| Starting | 0.11 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.04 ms | 
| Optimizing | 0.03 ms | 
| Statistics | 4.88 ms | 
| Preparing | 0.09 ms | 
| Sorting result | 0.02 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.02 ms | 
| Creating sort index | 0.09 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.02 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.05 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | 
| 25 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1283 | 
| 24 | hikashop_contentLink() | JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:163 | 
| 23 | include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 22 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 21 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show_default.php:266 | 
| 20 | include JROOT/components/com_hikashop/views/product/tmpl/show_default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 19 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 18 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show.php:97 | 
| 17 | include JROOT/components/com_hikashop/views/product/tmpl/show.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 15 | hikashopView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | 
| 14 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2924 | 
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/product/view.html.php:30 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 3.34 ms Na de laatste zoekopdracht: 0.51 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 22.147 MB Regels teruggegeven: 4
SELECT a.id 
  FROM jc9g2_menu AS a 
  INNER JOIN `jc9g2_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5,7) 
  AND a.client_id=0 
  AND a.link LIKE 'index.php?option=com_hikashop&view=category&layout=%' 
  AND a.language IN ('*', '', 'nl-NL')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | b | ALL | idx_menutype | INDEX KEY ONTBREEKT | NULL | NULL | 5 | Using where | 
| 1 | SIMPLE | a | ALL | idx_client_id_parent_id_alias_language,idx_menutype,idx_language | INDEX KEY ONTBREEKT | NULL | NULL | 90 | Using where; Using join buffer (flat, BNL join) | 
| Status | Duration | 
|---|
| Starting | 0.14 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.04 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.05 ms | 
| Optimizing | 0.03 ms | 
| Statistics | 2.51 ms | 
| Preparing | 0.12 ms | 
| Executing | 0.01 ms | 
| Sending data | 0.16 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.00 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.03 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | 
| 26 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_hikashop/classes/menus.php:333 | 
| 25 | hikashopMenusClass->loadAMenuItemId() | JROOT/administrator/components/com_hikashop/helpers/helper.php:1318 | 
| 24 | hikashop_contentLink() | JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php:163 | 
| 23 | include JROOT/components/com_hikashop/views/product/tmpl/show_microdata.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 22 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 21 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show_default.php:266 | 
| 20 | include JROOT/components/com_hikashop/views/product/tmpl/show_default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 19 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 18 | hikashopView->loadTemplate() | JROOT/components/com_hikashop/views/product/tmpl/show.php:97 | 
| 17 | include JROOT/components/com_hikashop/views/product/tmpl/show.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 
| 16 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2970 | 
| 15 | hikashopView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | 
| 14 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2924 | 
| 13 | hikashopView->display() | JROOT/components/com_hikashop/views/product/view.html.php:30 | 
| 12 | ProductViewProduct->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 
| 11 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2631 | 
| 10 | hikashopController->display() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2344 | 
| 9 | hikashopController->show() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 
| 8 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_hikashop/helpers/helper.php:2609 | 
| 7 | hikashopController->execute() | JROOT/components/com_hikashop/hikashop.php:88 | 
| 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:225 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 9.96 ms Na de laatste zoekopdracht: 20.27 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 22.560 MB Regels teruggegeven: 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jc9g2_modules AS m
  LEFT JOIN jc9g2_modules_menu AS mm 
  ON mm.moduleid = m.id
  LEFT JOIN jc9g2_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-11-04 05:25:15') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-11-04 05:25:15') 
  AND m.access IN (1,1,5,7) 
  AND m.client_id = 0 
  AND (mm.menuid = 155 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | 
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 15 | Using index condition; Using where; Gebruikt bestandssortering | 
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | hovenie2_regen.m.id | 1 | Using where; Using index | 
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | hovenie2_regen.m.module,const | 1 | Using index condition; Using where | 
| Status | Duration | 
|---|
| Starting | 0.18 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.05 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init | 0.07 ms | 
| Optimizing | 0.06 ms | 
| Statistics | 0.71 ms | 
| Preparing | 0.09 ms | 
| Sorting result | 0.02 ms | 
| Executing | 0.00 ms | 
| Sending data | 0.02 ms | 
| Creating sort index | 8.25 ms | 
| End of update loop | 0.04 ms | 
| Query end | 0.01 ms | 
| Commit | 0.01 ms | 
| Query end | 0.00 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.00 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.03 ms | 
| Updating status | 0.04 ms | 
| Reset for next command | 0.02 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 
| 18 | JDatabaseDriver->loadObjectList() | Zelfde als de call in onderstaande regel. | 
| 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | 
| 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 | 
| 15 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 | 
| 14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 | 
| 13 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 | 
| 12 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/regenbuffer/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54 | 
| 11 | Warp\Joomla\Helper\WidgetsHelper->count() | JROOT/templates/regenbuffer/layouts/theme.config.php:26 | 
| 10 | include JROOT/templates/regenbuffer/layouts/theme.config.php | JROOT/templates/regenbuffer/layouts/theme.php:10 | 
| 9 | include JROOT/templates/regenbuffer/layouts/theme.php | JROOT/templates/regenbuffer/warp/src/Warp/Helper/TemplateHelper.php:49 | 
| 8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/regenbuffer/index.php:16 | 
| 7 | require JROOT/templates/regenbuffer/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | 
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | 
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | 
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | 
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | 
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
Tijd zoekopdracht: 1.41 ms Na de laatste zoekopdracht: 100.77 ms Zoekopdracht geheugen: 0.004 MB geheugen voor zoekopdracht: 23.089 MB
DELETE 
  FROM `jc9g2_session`
  WHERE `time` < 1762233016
VERKLAREN niet mogelijk voor zoekopdracht: DELETE 
FROM `jc9g2_session`
WHERE `time` < 1762233016
| Status | Duration | 
|---|
| Starting | 0.08 ms | 
| checking permissions | 0.01 ms | 
| Opening tables | 0.03 ms | 
| After opening tables | 0.01 ms | 
| System lock | 0.01 ms | 
| table lock | 0.01 ms | 
| init for update | 0.07 ms | 
| Updating | 0.20 ms | 
| End of update loop | 0.01 ms | 
| Query end | 0.01 ms | 
| Commit | 0.73 ms | 
| Query end | 0.01 ms | 
| closing tables | 0.01 ms | 
| Unlocking tables | 0.01 ms | 
| closing tables | 0.01 ms | 
| Query end | 0.01 ms | 
| Starting cleanup | 0.01 ms | 
| Freeing items | 0.01 ms | 
| Updating status | 0.06 ms | 
| Reset for next command | 0.01 ms | 
| # | Caller | Bestand en regelnummer | 
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/session/storage/database.php:156 | 
| 7 | JSessionStorageDatabase->gc() | JROOT/libraries/src/Session/Session.php:837 | 
| 6 | Joomla\CMS\Session\Session->gc() | JROOT/plugins/system/sessiongc/sessiongc.php:60 | 
| 5 | PlgSystemSessionGc->onAfterRespond() | JROOT/libraries/joomla/event/event.php:70 | 
| 4 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 
| 3 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | 
| 2 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:247 | 
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 | 
4 × SELECT * 
  FROM jc9g2_extensions
3 × SELECT a.id 
  FROM jc9g2_menu AS a 
  INNER JOIN `jc9g2_menu_types` as b 
  on a.menutype = b.menutype
2 × SELECT * 
  FROM jc9g2_hikashop_field as a
1 × SELECT `data` 
  FROM `jc9g2_session`
1 × SELECT * 
  FROM jc9g2_hikashop_zone
1 × SELECT c.category_id 
  FROM jc9g2_hikashop_product_category AS pc 
  INNER JOIN jc9g2_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1
1 × SELECT a.id, a.link, a.params 
  FROM jc9g2_menu AS a 
  INNER JOIN `jc9g2_menu_types` AS b 
  ON a.menutype = b.menutype
1 × SELECT * 
  FROM jc9g2_hikashop_vote
1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jc9g2_contentitem_tag_map` AS m  
  INNER JOIN `jc9g2_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`
1 × SELECT a.*, c.currency_symbol 
  FROM jc9g2_hikashop_shipping AS a  
  INNER JOIN jc9g2_hikashop_currency AS c 
  ON c.currency_id = a.shipping_currency_id
1 × SELECT b.*  
  FROM jc9g2_hikashop_product_category AS a  
  LEFT JOIN jc9g2_hikashop_category AS b 
  ON a.category_id = b.category_id
1 × SELECT a.* 
  FROM jc9g2_hikashop_badge AS a
1 × SELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id 
  FROM jc9g2_hikashop_category AS hk_parent
1 × SELECT hk_parent.category_id, hk_parent.category_parent_id 
  FROM jc9g2_hikashop_category AS hk_parent
1 × SELECT category_id 
  FROM jc9g2_hikashop_product_category
1 × SELECT * 
  FROM jc9g2_hikashop_discount
1 × SELECT b.*,c.* 
  FROM jc9g2_hikashop_category AS a 
  LEFT JOIN jc9g2_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN jc9g2_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey
1 × SELECT `session_id` 
  FROM `jc9g2_session`
1 × SELECT cart.cart_id 
  FROM jc9g2_hikashop_cart AS cart
1 × SELECT id, rules 
  FROM `jc9g2_viewlevels
1 × SELECT b.id 
  FROM jc9g2_usergroups AS a 
  LEFT JOIN jc9g2_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt
1 × SELECT * 
  FROM jc9g2_hikashop_confi
1 × SELECT * 
  FROM jc9g2_hikashop_geolocation
1 × SELECT * 
  FROM jc9g2_rsform_confi
1 × SELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering  
  FROM jc9g2_hikashop_product AS product  
  LEFT JOIN jc9g2_hikashop_product_category AS product_category 
  ON product.product_id = product_category.product_id
1 × SELECT * 
  FROM jc9g2_hikashop_currency
1 × SELECT p.* 
  FROM jc9g2_hikashop_price as p
1 × SELECT p.*  
  FROM jc9g2_hikashop_product_related AS pr  
  LEFT JOIN jc9g2_hikashop_product AS p 
  ON pr.product_related_id = p.product_id
1 × SELECT p.*, pr.product_related_quantity  
  FROM jc9g2_hikashop_product_related AS pr  
  INNER JOIN jc9g2_hikashop_product AS p 
  ON pr.product_related_id = p.product_id
1 × SELECT * 
  FROM jc9g2_hikashop_product
1 × SELECT v.*, c.*  
  FROM jc9g2_hikashop_variant AS v  
  INNER JOIN jc9g2_hikashop_characteristic AS c 
  ON v.variant_characteristic_id = c.characteristic_id
1 × SELECT * 
  FROM jc9g2_hikashop_file
1 × SELECT currency_id 
  FROM jc9g2_hikashop_currency
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM jc9g2_modules AS m 
  LEFT JOIN jc9g2_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jc9g2_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id