Speedster Bike Rack - 4, 5 or 6 Berth
PRICE (Ex. GST)
CODE
SIZES
UN-POWDER COATED
POWDER COATED
RS502-4
4 Berth
..
Product #: RS502
PRICE (Ex. GST)
CODE
SIZES
UN-POWDER COATED
POWDER COATED
RS502-4
4 Berth
..
Product #: RS502
Speedster Bike Rack - 4, 5 or 6 Berth
Call for Price: 1300117328
Available Options
*
Sizes:
Our range includes a vairety of options and sizes for Senior (Adult), Junior & Prep/Kindergarten.
Features:
- Clear anodised structural grade aluminium Seat Plank or Seat Slat,
- Reinforced panels, Exclusive to Aluminium Seating SpecialistsTM,
- Optional powder coated seat supports (Price P.O.A.*),
- High quality cast aluminium flush fitting End Caps,
- Stainless steel Nylok self locking fasteners, and/or
- Clear anodised structural grade aluminium Seat Plank or Seat Slat,
- Reinforced panels, Exclusive to Aluminium Seating SpecialistsTM,
- Optional powder coated seat supports (Price P.O.A.*),
- High quality cast aluminium flush fitting End Caps,
- Stainless steel Nylok self locking fasteners, and/or
- Heavy Duty Rubber Feet.
Standard Sizes (Other sizes availabe upon request):
| PRICE (Ex. GST) | |||
| CODE | SIZES | UN-POWDER COATED | POWDER COATED |
| RS502-4 | 4 Berth | $330.00 | $351.00 |
| RS502-5 | 5 Berth | $397.00 | $426.00 |
| RS502-6 | 6 Berth | $464.00 | $495.00 |
Dimensions: 500mm (W) x 300mm (H)
|
DID YOU KNOW? We manufacture seating in a variety of sizes. Ask us for a quote for your custom size requirements. |
Webbed by Who Media
Copyright ©2019 -2024Aluminium Seating Specialists
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1732385201,
"last": 1732385201,
"now": 1732385201
},
"client": {
"forwarded": "3.144.101.75"
},
"token": "B4zBNTRq1pnaeCN8uT7jgN2GdMIOJgf3"
},
"registry": {
"com_installer": {
"message": "",
"extension_message": ""
}
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"viewed_product_ids": [
68
],
"continue_shopping_url": "https://benchseating.com.au/index.php/bench-seating/bike-racks-change-room-seating/speedster-bike-rack"
}
}
Time
Memory
Time: 11.26 ms / 11.26 ms Memory: 1.839 MB / 2.22 MB Application: afterLoad
Time: 71.29 ms / 82.56 ms Memory: 8.273 MB / 10.49 MB Application: afterInitialise
Time: 28.93 ms / 111.49 ms Memory: 3.552 MB / 14.04 MB Application: afterRoute
Time: 0.55 ms / 112.04 ms Memory: 0.013 MB / 14.06 MB Application: beforeRenderComponent com_eshop
Time: 42.07 ms / 154.10 ms Memory: 3.001 MB / 17.06 MB Application: afterRenderComponent com_eshop
Time: 1.29 ms / 155.40 ms Memory: 0.124 MB / 17.18 MB Application: afterDispatch
Time: 95.85 ms / 251.24 ms Memory: 6.654 MB / 23.84 MB Application: Before Access::preloadComponents (all components)
Time: 0.58 ms / 251.82 ms Memory: 0.056 MB / 23.89 MB Application: After Access::preloadComponents (all components)
Time: 0.06 ms / 251.88 ms Memory: -0.003 MB / 23.89 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.42 ms / 252.29 ms Memory: 0.089 MB / 23.98 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 105.44 ms / 357.73 ms Memory: 1.275 MB / 25.25 MB Application: afterRender
Database queries total: 44.36 ms
26.64 MB (27,931,200 Bytes)
96 Queries Logged 44.36 ms
17 duplicate found!
- Query Time: 0.51 ms Query memory: 0.023 MB Memory before query: 3.932 MB Rows returned: 0
SELECT `data`
FROM `ksft0_session`
WHERE `session_id` = X'6365626362623564303331356636396162343766303833313338656464663838'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.08 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.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.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:854 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.27 ms After last query: 0.83 ms Query memory: 0.020 MB Memory before query: 4.090 MB Rows returned: 0
SELECT `session_id`
FROM `ksft0_session`
WHERE `session_id` = X'6365626362623564303331356636396162343766303833313338656464663838'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 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 Commit 0.01 ms Query end 0.01 ms closing tables 0.02 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.01 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.66 ms After last query: 0.05 ms Query memory: 0.004 MB Memory before query: 4.095 MB
INSERT INTO `ksft0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6365626362623564303331356636396162343766303833313338656464663838', 1, 1732385201, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `ksft0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6365626362623564303331356636396162343766303833313338656464663838', 1, 1732385201, 0, '', 0)Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.35 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.01 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.51 ms After last query: 1.85 ms Query memory: 0.025 MB Memory before query: 4.313 MB Rows returned: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ksft0_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ref extension extension 82 const 42 Using index condition; Using where Status Duration Starting 0.03 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.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 1.59 ms Query memory: 0.021 MB Memory before query: 4.506 MB Rows returned: 5
SELECT id, rules
FROM `ksft0_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.02 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.36 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.518 MB Rows returned: 2
SELECT b.id
FROM ksft0_usergroups AS a
LEFT JOIN ksft0_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.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.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 0.46 ms Query memory: 0.030 MB Memory before query: 4.586 MB Rows returned: 105
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ksft0_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 265 Using where; Using filesort Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.24 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 4.03 ms Query memory: 0.021 MB Memory before query: 5.295 MB Rows returned: 0
SELECT `path`
FROM ksft0_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_ignored ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:53 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:29 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 5.302 MB Rows returned: 0
SELECT `file`
FROM ksft0_rsfirewall_hashes
WHERE `type`='protect'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_hashes ALL NULL NO INDEX KEY COULD BE USED NULL NULL 84 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 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.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:60 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:29 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 5.307 MB Rows returned: 66
SELECT *
FROM ksft0_rsfirewall_configurationid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_configuration ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 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.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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/config.php:68 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:29 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.71 ms After last query: 3.23 ms Query memory: 0.024 MB Memory before query: 5.842 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `ksft0_rsfirewall_logs`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ksft0_rsfirewall_logs`Status Duration Starting 0.02 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.22 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.06 ms closing tables 0.01 ms checking permissions 0.01 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 Removing tmp table 0.07 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.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 12 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 11 RsfirewallTableLogs->__construct() JROOT/libraries/src/Table/Table.php:320 10 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_rsfirewall/helpers/log.php:23 9 RSFirewallLogger->__construct() JROOT/administrator/components/com_rsfirewall/helpers/log.php:77 8 RSFirewallLogger::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:56 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 7.08 ms Query memory: 0.022 MB Memory before query: 6.925 MB Rows returned: 1Duplicate queries: #13
SELECT template
FROM ksft0_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 8 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 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.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 6.932 MB Rows returned: 1Duplicate queries: #12
SELECT template
FROM ksft0_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 8 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 1.92 ms Query memory: 0.021 MB Memory before query: 7.227 MB Rows returned: 2
SELECT extension, file, type
FROM ksft0_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rokcommon_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using filesort Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.04 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.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:131 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:75 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 14.45 ms Query memory: 0.025 MB Memory before query: 9.079 MB Rows returned: 1
SELECT id,template
FROM ksft0_template_styles
WHERE client_id=0
AND home=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_template_styles ALL idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 8 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/administrator/components/com_widgetkit/widgetkit.php:23 16 plgSystemWidgetkit->{closure}() JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240 15 YOOtheme\Framework\Container->offsetGet() JROOT/administrator/components/com_widgetkit/src/Application.php:49 14 YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}() Same as call in the line below. 13 call_user_func_array() JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113 12 YOOtheme\Framework\Event\EventDispatcher->trigger() JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149 11 YOOtheme\Framework\Application->boot() JROOT/administrator/components/com_widgetkit/widgetkit.php:91 10 include JROOT/administrator/components/com_widgetkit/widgetkit.php JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6 9 include JROOT/administrator/components/com_widgetkit/widgetkit-app.php JROOT/plugins/system/widgetkit/widgetkit.php:9 8 plgSystemWidgetkit->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.29 ms After last query: 5.98 ms Query memory: 0.023 MB Memory before query: 9.854 MB Rows returned: 28
SELECT *
FROM ksft0_rsform_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsform_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 28 Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php:50 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php:17 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php:102 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26 8 plgSystemRsformdeletesubmissions->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.64 ms After last query: 0.43 ms Query memory: 0.026 MB Memory before query: 9.885 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `ksft0_extensions`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ksft0_extensions`Status Duration Starting 0.02 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.16 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.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.07 ms closing tables 0.01 ms checking permissions 0.01 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 Removing tmp table 0.06 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.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 11 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Extension.php:32 10 Joomla\CMS\Table\Extension->__construct() JROOT/libraries/src/Table/Table.php:320 9 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/roksprocket/roksprocket.php:45 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 9.913 MB Rows returned: 1
SELECT `extension_id`
FROM `ksft0_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:47 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 9.920 MB Rows returned: 1Duplicate queries: #21
SELECT *
FROM ksft0_extensions
WHERE `extension_id` = '10180'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 9.924 MB Rows returned: 1
SELECT `extension_id`
FROM `ksft0_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:70 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 9.930 MB Rows returned: 1Duplicate queries: #19
SELECT *
FROM ksft0_extensions
WHERE `extension_id` = '10180'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.53 ms After last query: 10.58 ms Query memory: 0.026 MB Memory before query: 10.680 MB Rows returned: 5
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM ksft0_menu AS m
LEFT JOIN ksft0_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 23 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 benseat_bench.m.component_id 1 Using where 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.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.12 ms End of update loop 0.01 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.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:445 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:561 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1169 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 5.39 ms Query memory: 0.021 MB Memory before query: 11.258 MB Rows returned: 1
SELECT `query`
FROM ksft0_eshop_urls
WHERE md5_key = "37561907597367cf388cfc62e254f4ac"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 155 Using where Status Duration Starting 0.02 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.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:440 9 EshopRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1170 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.29 ms After last query: 0.12 ms Query memory: 0.020 MB Memory before query: 11.263 MB Rows returned: 0
SELECT *
FROM ksft0_rsfirewall_hashes
WHERE (`type`='3.10.3' OR `type`='protect')
AND `flag`!='C'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_hashes ALL NULL NO INDEX KEY COULD BE USED NULL NULL 84 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 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.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.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:1068 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 11.296 MB Rows returned: 0
SELECT *
FROM ksft0_rsfirewall_snapshots
WHERE `type`='protect'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_snapshots ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 9 RSFirewallSnapshot::get() JROOT/plugins/system/rsfirewall/rsfirewall.php:1091 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 11.302 MB Rows returned: 0
SELECT `ip`,`reason`
FROM ksft0_rsfirewall_lists
WHERE (`ip`='3.144.101.75' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_lists ref published,type,ip published 1 const 1 Using where Status Duration Starting 0.03 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.02 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:174 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:153 9 plgSystemRsfirewall->isWhitelisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1127 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 11.308 MB Rows returned: 0
SELECT `ip`,`reason`
FROM ksft0_rsfirewall_lists
WHERE (`ip`='3.144.101.75' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_lists ref published,type,ip published 1 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.02 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:174 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:143 9 plgSystemRsfirewall->isBlacklisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1131 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 11.313 MB Rows returned: 0
SELECT *
FROM ksft0_rsfirewall_exceptions
WHERE `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_exceptions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.01 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:719 9 plgSystemRsfirewall->isException() JROOT/plugins/system/rsfirewall/rsfirewall.php:1262 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 11.319 MB Rows returned: 6
SELECT id, home, template, s.params
FROM ksft0_template_styles as s
LEFT JOIN ksft0_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 5 Using index condition; Using where 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 8 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.03 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.04 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.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.07 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/gantry5/gantry5.php:195 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 8 plgSystemGantry5->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 8.56 ms Query memory: 0.026 MB Memory before query: 12.505 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ksft0_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 23 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 22 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 20 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 19 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 18 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 17 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 16 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 15 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 14 Joomla\CMS\Factory::getDocument() JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163 13 Gantry\Framework\Theme->init() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67 12 Gantry\Component\Theme\AbstractTheme->__construct() JROOT/templates/rt_isotope/includes/theme.php:28 11 plgSystemGantry5->{closure}() JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118 10 Pimple\Container->offsetGet() JROOT/plugins/system/gantry5/gantry5.php:234 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 8 plgSystemGantry5->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.65 ms After last query: 0.10 ms Query memory: 0.008 MB Memory before query: 12.499 MB
UPDATE `ksft0_extensions`
SET `params` = '{\"mediaversion\":\"3e60ef3c5a744b72c60a7bea4502345c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `ksft0_extensions` SET `params` = '{\"mediaversion\":\"3e60ef3c5a744b72c60a7bea4502345c\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.04 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.34 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.01 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 18 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 17 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 16 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 15 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 14 Joomla\CMS\Factory::getDocument() JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163 13 Gantry\Framework\Theme->init() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67 12 Gantry\Component\Theme\AbstractTheme->__construct() JROOT/templates/rt_isotope/includes/theme.php:28 11 plgSystemGantry5->{closure}() JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118 10 Pimple\Container->offsetGet() JROOT/plugins/system/gantry5/gantry5.php:234 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 8 plgSystemGantry5->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.37 ms After last query: 3.62 ms Query memory: 0.023 MB Memory before query: 13.488 MB Rows returned: 4
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM ksft0_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'rt_isotope'
ORDER BY s.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s index idx_template,idx_client_id,idx_client_id_home PRIMARY 4 NULL 8 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 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.03 ms Preparing 0.02 ms Sorting result 0.01 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.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.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46 14 Gantry\Joomla\StyleHelper::loadStyles() JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50 13 Gantry\Framework\Assignments->loadAssignments() JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:303 12 Gantry\Component\Assignments\AbstractAssignments->init() JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104 11 Gantry\Component\Assignments\AbstractAssignments->scores() JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91 10 Gantry\Component\Assignments\AbstractAssignments->select() JROOT/plugins/system/gantry5/gantry5.php:246 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 8 plgSystemGantry5->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 1.22 ms Query memory: 0.025 MB Memory before query: 13.698 MB Rows returned: 8
SELECT *
FROM ksft0_rokcandy
WHERE published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rokcandy ALL NULL NO INDEX KEY COULD BE USED NULL NULL 8 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 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.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27 13 RokCandyHelper::getUserMacros() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 10 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17 9 RokCandyHelper::getMacros() JROOT/plugins/system/rokcandy/rokcandy.php:28 8 plgSystemRokCandy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 3.44 ms Query memory: 0.019 MB Memory before query: 14.049 MB Rows returned: 1
SELECT *
FROM ksft0_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.02 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.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.03 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.01 ms Reset for next command 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 5.75 ms Query memory: 0.033 MB Memory before query: 15.001 MB Rows returned: 254
SELECT config_key, config_value
FROM ksft0_eshop_configsid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 254 Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.14 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:32 9 EshopHelper::getConfig() JROOT/components/com_eshop/helpers/helper.php:134 8 EshopHelper::getConfigValue() JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php:8 7 require_once JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php JROOT/components/com_eshop/eshop.php:27 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.53 ms After last query: 7.22 ms Query memory: 0.040 MB Memory before query: 15.879 MB Rows returned: 1
SELECT a.*, b.product_name, b.product_alias, b.product_desc, b.product_short_desc, b.product_page_title, b.product_page_heading, b.product_alt_image, b.meta_key, b.meta_desc, b.tab1_title, b.tab1_content, b.tab2_title, b.tab2_content, b.tab3_title, b.tab3_content, b.tab4_title, b.tab4_content, b.tab5_title, b.tab5_content
FROM ksft0_eshop_products AS a
INNER JOIN ksft0_eshop_productdetails AS b
ON (a.id = b.product_id)
WHERE a.id = 68
AND a.published = 1
AND b.language = "en-GB"
AND ((a.product_customergroups = "") OR (a.product_customergroups IS NULL) OR (a.product_customergroups = "1") OR (a.product_customergroups LIKE "1,%") OR (a.product_customergroups LIKE "%,1,%") OR (a.product_customergroups LIKE "%,1"))
AND (a.product_available_date = "0000-00-00 00:00:00" OR a.product_available_date <= '2024-11-24 04:06:42')
AND ((a.product_languages = "") OR (a.product_languages IS NULL) OR (a.product_languages = "en-GB") OR (a.product_languages LIKE "en-GB,%") OR (a.product_languages LIKE "%,en-GB,%") OR (a.product_languages LIKE "%,en-GB"))id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,published PRIMARY 4 const 1 1 SIMPLE b ref product_id product_id 5 const 1 Using where Status Duration Starting 0.05 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.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.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.03 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_eshop/models/product.php:114 12 EShopModelProduct->_loadData() JROOT/components/com_eshop/models/product.php:59 11 EShopModelProduct->getData() JROOT/libraries/src/MVC/View/HtmlView.php:425 10 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_eshop/views/product/view.html.php:33 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 15.903 MB Rows returned: 3Duplicate queries: #67
SELECT *
FROM ksft0_eshop_currencies
WHERE published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_currencies ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where Status Duration Starting 0.02 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.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/currency.php:52 10 EshopCurrency->__construct() JROOT/components/com_eshop/views/product/view.html.php:34 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.50 ms Query memory: 0.022 MB Memory before query: 15.950 MB Rows returned: 8
SELECT a.id, a.category_parent_id, b.category_name
FROM ksft0_eshop_categories AS a
INNER JOIN ksft0_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.published = 1
AND b.language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b ALL category_id NO INDEX KEY COULD BE USED NULL NULL 8 Using where 1 SIMPLE a eq_ref PRIMARY,published PRIMARY 4 benseat_bench.b.category_id 1 Using where Status Duration Starting 0.02 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.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:4866 10 EshopHelper::getCategoriesBreadcrumb() JROOT/components/com_eshop/views/product/view.html.php:100 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 15.971 MB Rows returned: 8
SELECT a.id, a.category_parent_id, b.category_alias
FROM ksft0_eshop_categories AS a
INNER JOIN ksft0_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE b.language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b ALL category_id NO INDEX KEY COULD BE USED NULL NULL 8 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 benseat_bench.b.category_id 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:4814 11 EshopHelper::getCategoryPath() JROOT/components/com_eshop/helpers/route.php:78 10 EshopRoute::getCategoryRoute() JROOT/components/com_eshop/views/product/view.html.php:105 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.54 ms After last query: 0.06 ms Query memory: 0.005 MB Memory before query: 15.978 MB
UPDATE ksft0_eshop_products
SET hits = hits + 1
WHERE id = 68EXPLAIN not possible on query: UPDATE ksft0_eshop_products SET hits = hits + 1 WHERE id = 68Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.03 ms Updating 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.27 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/helpers/helper.php:582 10 EshopHelper::updateHits() JROOT/components/com_eshop/views/product/view.html.php:115 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 15.989 MB Rows returned: 1
SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
FROM ksft0_eshop_products
WHERE id = 68id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_products const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/helper.php:2425 10 EshopHelper::getProductInventory() JROOT/components/com_eshop/views/product/view.html.php:191 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 15.995 MB Rows returned: 1
SELECT stockstatus_name
FROM ksft0_eshop_stockstatusdetails
WHERE stockstatus_id = 2
AND language = "en-GB"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_stockstatusdetails ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Using where Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_eshop/helpers/helper.php:604 10 EshopHelper::getStockStatusName() JROOT/components/com_eshop/views/product/view.html.php:201 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.45 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 16.002 MB Rows returned: 0
SELECT a.*
FROM ksft0_eshop_tags AS a
INNER JOIN ksft0_eshop_producttags AS b
ON (a.id = b.tag_id)
WHERE a.published = 1
AND b.product_id = 68id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE b ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 1.03 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 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 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.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1563 10 EshopHelper::getProductTags() JROOT/components/com_eshop/views/product/view.html.php:215 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.67 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 16.008 MB Rows returned: 0
SELECT *
FROM ksft0_eshop_productattachments
WHERE product_id = 68
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_productattachments ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.31 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/views/product/view.html.php:225 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 3.77 ms Query memory: 0.022 MB Memory before query: 16.476 MB Rows returned: 1
SELECT pi.*
FROM ksft0_eshop_productimages AS pi
WHERE product_id = 68
ORDER BY pi.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pi ALL NULL NO INDEX KEY COULD BE USED NULL NULL 25 Using where; Using filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.18 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.06 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1541 10 EshopHelper::getProductImages() JROOT/components/com_eshop/views/product/view.html.php:255 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.55 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 16.484 MB Rows returned: 0
SELECT quantity, price
FROM ksft0_eshop_productdiscounts
WHERE product_id = 68
AND published = 1
AND customergroup_id = 1
AND (date_start <= "2024-11-24 05:06:42" OR date_start = "0000-00-00 00:00:00")
AND (date_end >= "2024-11-24 05:06:42" OR date_end = "0000-00-00 00:00:00")
AND quantity > 1
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_productdiscounts ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.15 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1872 10 EshopHelper::getDiscountPrices() JROOT/components/com_eshop/views/product/view.html.php:310 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.76 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 16.491 MB Rows returned: 1
SELECT o.id, o.option_type, o.option_image, od.option_name, od.option_desc, po.required, po.id AS product_option_id
FROM ksft0_eshop_options AS o
INNER JOIN ksft0_eshop_optiondetails AS od
ON (o.id = od.option_id)
INNER JOIN ksft0_eshop_productoptions AS po
ON (o.id = po.option_id)
WHERE po.product_id = 68
AND od.language = 'en-GB'
AND o.published = 1
ORDER BY od.option_name ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE po ref product_id,option_id product_id 5 const 1 Using where; Using temporary; Using filesort 1 SIMPLE o eq_ref PRIMARY PRIMARY 4 benseat_bench.po.option_id 1 Using where 1 SIMPLE od ALL option_id NO INDEX KEY COULD BE USED NULL NULL 4 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.22 ms Creating sort index 0.04 ms Removing tmp table 0.07 ms Creating sort index 0.01 ms End of update loop 0.01 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.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1497 10 EshopHelper::getProductOptions() JROOT/components/com_eshop/views/product/view.html.php:311 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.82 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 16.498 MB Rows returned: 2
SELECT a.id, b.attributegroup_name
FROM ksft0_eshop_attributegroups AS a
INNER JOIN ksft0_eshop_attributegroupdetails AS b
ON (a.id = b.attributegroup_id)
WHERE a.published = 1
AND b.language = 'en-GB'
ORDER BY a.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using temporary; Using filesort 1 SIMPLE b ALL attributegroup_id NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.31 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.02 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:814 10 EshopHelper::getAttributeGroups() JROOT/components/com_eshop/views/product/view.html.php:313 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.63 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 16.507 MB Rows returned: 0
SELECT ad.attribute_name, pad.value
FROM ksft0_eshop_attributes AS a
INNER JOIN ksft0_eshop_attributedetails AS ad
ON (a.id = ad.attribute_id)
INNER JOIN ksft0_eshop_productattributes AS pa
ON (a.id = pa.attribute_id)
INNER JOIN ksft0_eshop_productattributedetails AS pad
ON (pa.id = pad.productattribute_id)
WHERE a.attributegroup_id = 1
AND a.published = 1
AND pa.published = 1
AND pa.product_id = 68
AND ad.language = "en-GB"
AND pad.language = 'en-GB'
ORDER BY ad.attribute_name ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pad ALL productattribute_id NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using temporary; Using filesort 1 SIMPLE pa eq_ref PRIMARY,product_id,attribute_id PRIMARY 4 benseat_bench.pad.productattribute_id 1 Using where 1 SIMPLE a eq_ref PRIMARY,attributegroup_id PRIMARY 4 benseat_bench.pa.attribute_id 1 Using where 1 SIMPLE ad ref attribute_id attribute_id 5 benseat_bench.pa.attribute_id 1 Using where Status Duration Starting 0.04 ms checking permissions 0.02 ms Opening tables 1.06 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.04 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.01 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:877 10 EshopHelper::getAttributes() JROOT/components/com_eshop/views/product/view.html.php:318 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 16.513 MB Rows returned: 0
SELECT ad.attribute_name, pad.value
FROM ksft0_eshop_attributes AS a
INNER JOIN ksft0_eshop_attributedetails AS ad
ON (a.id = ad.attribute_id)
INNER JOIN ksft0_eshop_productattributes AS pa
ON (a.id = pa.attribute_id)
INNER JOIN ksft0_eshop_productattributedetails AS pad
ON (pa.id = pad.productattribute_id)
WHERE a.attributegroup_id = 2
AND a.published = 1
AND pa.published = 1
AND pa.product_id = 68
AND ad.language = "en-GB"
AND pad.language = 'en-GB'
ORDER BY ad.attribute_name ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pad ALL productattribute_id NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using temporary; Using filesort 1 SIMPLE pa eq_ref PRIMARY,product_id,attribute_id PRIMARY 4 benseat_bench.pad.productattribute_id 1 Using where 1 SIMPLE a eq_ref PRIMARY,attributegroup_id PRIMARY 4 benseat_bench.pa.attribute_id 1 Using where 1 SIMPLE ad ref attribute_id attribute_id 5 benseat_bench.pa.attribute_id 1 Using where 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.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:877 10 EshopHelper::getAttributes() JROOT/components/com_eshop/views/product/view.html.php:318 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.95 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 16.519 MB Rows returned: 0
SELECT p.*, pd.product_name, pd.product_alias, pd.product_desc, pd.product_short_desc, pd.meta_key, pd.meta_desc
FROM ksft0_eshop_products AS p
INNER JOIN ksft0_eshop_productdetails AS pd
ON (p.id = pd.product_id)
INNER JOIN ksft0_eshop_productrelations AS pr
ON (p.id = pr.related_product_id)
WHERE p.published = 1
AND pr.product_id = 68
AND pd.language = 'en-GB'
ORDER BY p.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pr ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using temporary; Using filesort 1 SIMPLE p eq_ref PRIMARY,published PRIMARY 4 benseat_bench.pr.related_product_id 1 Using where 1 SIMPLE pd ref product_id product_id 5 benseat_bench.pr.related_product_id 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.18 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.06 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.18 ms Creating sort index 0.02 ms Removing tmp table 0.05 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.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.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1301 10 EshopHelper::getProductRelations() JROOT/components/com_eshop/views/product/view.html.php:322 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.51 ms After last query: 0.41 ms Query memory: 0.021 MB Memory before query: 16.565 MB Rows returned: 0
SELECT m.id, m.manufacturer_email, md.manufacturer_name
FROM ksft0_eshop_products AS p
INNER JOIN ksft0_eshop_manufacturers AS m
ON (p.manufacturer_id = m.id)
INNER JOIN ksft0_eshop_manufacturerdetails AS md
ON (m.id = md.manufacturer_id)
WHERE p.id = 68
AND md.language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.83 ms After opening tables 0.08 ms System lock 0.01 ms table lock 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.05 ms Unlocking tables 0.01 ms closing tables 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.11 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.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 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 File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/helper.php:1271 10 EshopHelper::getProductManufacturer() JROOT/components/com_eshop/views/product/view.html.php:384 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.63 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 16.572 MB Rows returned: 3
SELECT a.id, b.product_id, b.product_name, b.product_page_title, pc.category_id
FROM ksft0_eshop_products AS a
INNER JOIN ksft0_eshop_productdetails AS b
ON (a.id = b.product_id)
INNER JOIN ksft0_eshop_productcategories AS pc
ON (a.id = pc.product_id)
WHERE a.published = 1
AND pc.category_id = 27
AND b.language = 'en-GB'
AND ((a.product_customergroups = "") OR (a.product_customergroups IS NULL) OR (a.product_customergroups = "1") OR (a.product_customergroups LIKE "1,%") OR (a.product_customergroups LIKE "%,1,%") OR (a.product_customergroups LIKE "%,1"))
ORDER BY a.ordering ASC,a.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pc ref product_id,category_id category_id 5 const 3 Using where; Using temporary; Using filesort 1 SIMPLE a eq_ref PRIMARY,published PRIMARY 4 benseat_bench.pc.product_id 1 Using where 1 SIMPLE b ref product_id product_id 5 benseat_bench.pc.product_id 1 Using where 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.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.07 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:4774 10 EshopHelper::getProductsNavigation() JROOT/components/com_eshop/views/product/view.html.php:398 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.50 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 16.578 MB Rows returned: 0
SELECT DISTINCT(label_id)
FROM ksft0_eshop_labelelements
WHERE (element_type = "product"
AND element_id = 68) OR (element_type = "manufacturer"
AND element_id = (SELECT manufacturer_id
FROM ksft0_eshop_products
WHERE id = 68)) OR (element_type = "category"
AND element_id IN (SELECT category_id
FROM ksft0_eshop_productcategories
WHERE product_id = 68))id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY ksft0_eshop_labelelements ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using temporary 3 DEPENDENT SUBQUERY ksft0_eshop_productcategories ref product_id,category_id product_id 5 const 1 Using where 2 SUBQUERY ksft0_eshop_products 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.03 ms Optimizing 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.03 ms Statistics 0.01 ms Executing 0.01 ms Sending data 0.01 ms Preparing 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Creating tmp table 0.02 ms Executing 0.01 ms Sending data 0.02 ms Removing tmp table 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/components/com_eshop/helpers/helper.php:5068 10 EshopHelper::getProductLabels() JROOT/components/com_eshop/views/product/view.html.php:399 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 16.583 MB Rows returned: 1
SELECT product_quantity
FROM ksft0_eshop_products
WHERE id = 68id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_products const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_eshop/helpers/helper.php:5076 10 EshopHelper::getProductLabels() JROOT/components/com_eshop/views/product/view.html.php:399 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 16.589 MB Rows returned: 0
SELECT id
FROM ksft0_eshop_labels
WHERE label_out_of_stock_products = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_labels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/components/com_eshop/helpers/helper.php:5091 10 EshopHelper::getProductLabels() JROOT/components/com_eshop/views/product/view.html.php:399 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 1.53 ms Query memory: 0.024 MB Memory before query: 16.821 MB Rows returned: 8
SELECT a.id, a.category_parent_id, b.category_alias
FROM ksft0_eshop_categories AS a
INNER JOIN ksft0_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE b.language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b ALL category_id NO INDEX KEY COULD BE USED NULL NULL 8 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 benseat_bench.b.category_id 1 Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:4814 14 EshopHelper::getCategoryPath() JROOT/components/com_eshop/helpers/route.php:41 13 EshopRoute::getProductRoute() JROOT/components/com_eshop/themes/default/views/product/default.php:89 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 16.829 MB Rows returned: 1
SELECT product_name, product_alias
FROM ksft0_eshop_productdetails
WHERE product_id = 64
AND language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_productdetails ref product_id product_id 5 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.02 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 21 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/helper.php:4595 20 EshopHelper::getElementAlias() JROOT/components/com_eshop/router.php:129 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:89 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.027 MB Memory before query: 16.840 MB Rows returned: 8
SELECT a.id, a.category_parent_id, b.category_alias
FROM ksft0_eshop_categories AS a
INNER JOIN ksft0_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE b.language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b ALL category_id NO INDEX KEY COULD BE USED NULL NULL 8 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 benseat_bench.b.category_id 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:4814 20 EshopHelper::getCategoryPath() JROOT/components/com_eshop/router.php:133 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:89 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.91 ms Query memory: 0.026 MB Memory before query: 16.970 MB Rows returned: 1
SELECT id
FROM ksft0_eshop_urls
WHERE md5_key="cfc76498b1b558853a194ff2da7e0796"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 155 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 20 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:396 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:89 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.03 ms Query memory: 0.010 MB Memory before query: 16.980 MB
UPDATE ksft0_eshop_urls
SET query="view=product&id=64&catid=27"
WHERE md5_key="cfc76498b1b558853a194ff2da7e0796"EXPLAIN not possible on query: UPDATE ksft0_eshop_urls SET query="view=product&id=64&catid=27" WHERE md5_key="cfc76498b1b558853a194ff2da7e0796"Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Updating 0.07 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:413 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:89 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 16.990 MB Rows returned: 8
SELECT a.id, a.category_parent_id, b.category_alias
FROM ksft0_eshop_categories AS a
INNER JOIN ksft0_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE b.language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b ALL category_id NO INDEX KEY COULD BE USED NULL NULL 8 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 benseat_bench.b.category_id 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:4814 14 EshopHelper::getCategoryPath() JROOT/components/com_eshop/helpers/route.php:41 13 EshopRoute::getProductRoute() JROOT/components/com_eshop/themes/default/views/product/default.php:101 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 16.997 MB Rows returned: 1
SELECT product_name, product_alias
FROM ksft0_eshop_productdetails
WHERE product_id = 69
AND language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_productdetails ref product_id product_id 5 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 21 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/helper.php:4595 20 EshopHelper::getElementAlias() JROOT/components/com_eshop/router.php:129 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:101 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.03 ms Query memory: 0.027 MB Memory before query: 17.009 MB Rows returned: 8
SELECT a.id, a.category_parent_id, b.category_alias
FROM ksft0_eshop_categories AS a
INNER JOIN ksft0_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE b.language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b ALL category_id NO INDEX KEY COULD BE USED NULL NULL 8 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 benseat_bench.b.category_id 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:4814 20 EshopHelper::getCategoryPath() JROOT/components/com_eshop/router.php:133 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:101 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.05 ms Query memory: 0.031 MB Memory before query: 17.028 MB Rows returned: 1
SELECT id
FROM ksft0_eshop_urls
WHERE md5_key="40ff25a653a428dce37f9a22a796acf2"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 155 Using where Status Duration Starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 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.01 ms Reset for next command 0.02 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 20 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:396 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:101 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 0.02 ms Query memory: 0.010 MB Memory before query: 17.044 MB
UPDATE ksft0_eshop_urls
SET query="view=product&id=69&catid=27"
WHERE md5_key="40ff25a653a428dce37f9a22a796acf2"EXPLAIN not possible on query: UPDATE ksft0_eshop_urls SET query="view=product&id=69&catid=27" WHERE md5_key="40ff25a653a428dce37f9a22a796acf2"Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.01 ms Updating 0.07 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:413 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:101 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.51 ms Query memory: 0.024 MB Memory before query: 17.095 MB Rows returned: 3Duplicate queries: #37
SELECT *
FROM ksft0_eshop_currencies
WHERE published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_currencies ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where Status Duration Starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 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.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 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.02 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/currency.php:52 14 EshopCurrency->__construct() JROOT/components/com_eshop/helpers/option.php:31 13 EshopOption::renderOption() JROOT/components/com_eshop/themes/default/views/product/default.php:596 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 0.05 ms Query memory: 0.040 MB Memory before query: 17.107 MB Rows returned: 1
SELECT a.*, b.product_name, b.product_alias, b.product_desc, b.product_short_desc, b.meta_key, b.meta_desc, b.tab1_title, b.tab1_content, b.tab2_title, b.tab2_content, b.tab3_title, b.tab3_content, b.tab4_title, b.tab4_content, b.tab5_title, b.tab5_content
FROM ksft0_eshop_products AS a
INNER JOIN ksft0_eshop_productdetails AS b
ON (a.id = b.product_id)
WHERE b.language = 'en-GB'
AND a.id = 68id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b ref product_id product_id 5 const 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 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.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/helper.php:1192 14 EshopHelper::getProduct() JROOT/components/com_eshop/helpers/option.php:34 13 EshopOption::renderOption() JROOT/components/com_eshop/themes/default/views/product/default.php:596 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 17.118 MB Rows returned: 1
SELECT id
FROM ksft0_eshop_productoptions
WHERE product_id = 68
AND option_id = 4id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_productoptions ref|filter product_id,option_id product_id|option_id 5|5 const 1 (13%) Using where; Using rowid filter Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_eshop/helpers/option.php:42 13 EshopOption::renderOption() JROOT/components/com_eshop/themes/default/views/product/default.php:596 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.08 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 17.127 MB Rows returned: 3
SELECT ovd.value, pov.id, pov.price, pov.price_sign, pov.price_type, pov.image
FROM ksft0_eshop_optionvalues AS ov
INNER JOIN ksft0_eshop_optionvaluedetails AS ovd
ON (ov.id = ovd.optionvalue_id)
INNER JOIN ksft0_eshop_productoptionvalues AS pov
ON (ovd.optionvalue_id = pov.option_value_id)
WHERE ov.published = 1
AND pov.product_option_id = 291
AND ovd.language = "en-GB"
ORDER BY ovd.value * 1 ASC, ovd.value ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pov ref product_option_id,option_value_id product_option_id 5 const 3 Using where; Using temporary; Using filesort 1 SIMPLE ov eq_ref PRIMARY PRIMARY 4 benseat_bench.pov.option_value_id 1 Using where 1 SIMPLE ovd ref optionvalue_id optionvalue_id 5 benseat_bench.pov.option_value_id 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.49 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.04 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.07 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/option.php:99 13 EshopOption::renderOption() JROOT/components/com_eshop/themes/default/views/product/default.php:596 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 26.26 ms Query memory: 0.034 MB Memory before query: 20.996 MB Rows returned: 2
SELECT a.menutype
FROM ksft0_menu_types AS a
WHERE a.client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where 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.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 42 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 41 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_menus/helpers/menus.php:154 40 MenusHelper::getMenuTypes() JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71 39 Gantry\Framework\Menu->getMenus() JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115 38 Gantry\Component\Menu\AbstractMenu->instance() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679 37 Twig_Template->getAttribute() JROOT/cache/gantry5/rt_isotope/twig/37/37a0ac366059bf353afae7cfd4b5c8a778fd1f71984226d2275e67f317119c8e.php:20 36 __TwigTemplate_5b5b56e453fcbe04e6f2828324ee69bbd92c3c5b928d32404ba557f69823b0fe->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 35 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 34 Twig_Template->display() JROOT/cache/gantry5/rt_isotope/twig/9c/9c00d1735ec0bcaa3f1fd1001228d6614e4817f14a41b3fdd6ae6207f9cd54a7.php:42 33 __TwigTemplate_bdad8b08f8fa7c70a94f2b21431ef24575725c78ca89cc55bdb96ec4bfa84507->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 32 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 31 Twig_Template->display() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411 30 Twig_Template->render() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 29 Twig_Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 28 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 27 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 26 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 22 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 21 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677 20 Twig_Template->getAttribute() JROOT/cache/gantry5/rt_isotope/twig/49/492d1e7a7ca7a52e1271f33098158458fa3fcf8829d04f8ecc601992ec58acf1.php:36 19 __TwigTemplate_bc5256947d637f57339f86e44d4b01f57adf64c8132c0c4df0e20efd8febf1c5->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 18 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 17 Twig_Template->display() JROOT/cache/gantry5/rt_isotope/twig/9b/9b64d755cfc3307e6d5c51ff4d93621eb96e5006f6b71bc1cdaf3a7e88dfb3c5.php:24 16 __TwigTemplate_86adb04cb9a88671f1b6047ae304df659dd9453db20d014493865bae65561f14->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 15 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 14 Twig_Template->display() JROOT/cache/gantry5/rt_isotope/twig/bd/bd3159a8e42ce6ece98cffed0cb4a25ee51be352c4a6df0e3d4be4476adbc7b8.php:24 13 __TwigTemplate_85b466219d62aa6ce15fcd74c189c0d135606086dc09f8a3c2c0f109d5a6ba42->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 12 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 11 Twig_Template->display() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411 10 Twig_Template->render() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 9 Twig_Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/rt_isotope/index.php:23 7 require JROOT/templates/rt_isotope/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.81 ms After last query: 2.35 ms Query memory: 0.037 MB Memory before query: 21.289 MB Rows returned: 0
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ksft0_modules AS m
LEFT JOIN ksft0_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ksft0_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 <= '2024-11-23 18:06:41')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-23 18:06:41')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 227 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 72 Using index condition; Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 benseat_bench.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 benseat_bench.m.module,const 1 Using index condition; Using where Status Duration Starting 0.05 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.05 ms Statistics 0.06 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.33 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.02 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.01 ms Reset for next command 0.01 ms # Caller File and line number 50 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 49 JDatabaseDriver->loadObjectList() Same as call in the line below. 48 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 47 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 46 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 45 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 44 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233 43 Gantry\Framework\Platform->displayModules() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679 42 Twig_Template->getAttribute() JROOT/cache/gantry5/rt_isotope/twig/20/20f0cde54140c291a5525073bd22e7721649fbc45a3f6b5fbfed0df51c5f4ce9.php:31 41 __TwigTemplate_f01a5b84ee0cec623aabd540ea2397438ca809e9d2616509a70d7c22212a2dcb->block_particle() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 40 Twig_Template->displayBlock() JROOT/cache/gantry5/rt_isotope/twig/36/365e982630a09a10456905ed409d08f5108c9fd21addd8e2710666d35be1f672.php:57 39 __TwigTemplate_8cb6b67c5ab42c64b01cbf82224703aef24f5a8a98784519b0bf83625ebd7302->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 38 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 37 Twig_Template->display() JROOT/cache/gantry5/rt_isotope/twig/20/20f0cde54140c291a5525073bd22e7721649fbc45a3f6b5fbfed0df51c5f4ce9.php:24 36 __TwigTemplate_f01a5b84ee0cec623aabd540ea2397438ca809e9d2616509a70d7c22212a2dcb->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 35 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 34 Twig_Template->display() JROOT/cache/gantry5/rt_isotope/twig/d1/d14d8dc92feca3c6783231c915b60463a0e20557d0eac02e3d3b546304ee12b4.php:32 33 __TwigTemplate_a647566f2cbfaf88b55c637cae7296f3091675edae693d6b80a1499c287a9204->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 32 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 31 Twig_Template->display() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411 30 Twig_Template->render() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 29 Twig_Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 28 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 27 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 26 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 22 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 21 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677 20 Twig_Template->getAttribute() JROOT/cache/gantry5/rt_isotope/twig/49/492d1e7a7ca7a52e1271f33098158458fa3fcf8829d04f8ecc601992ec58acf1.php:36 19 __TwigTemplate_bc5256947d637f57339f86e44d4b01f57adf64c8132c0c4df0e20efd8febf1c5->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 18 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 17 Twig_Template->display() JROOT/cache/gantry5/rt_isotope/twig/9b/9b64d755cfc3307e6d5c51ff4d93621eb96e5006f6b71bc1cdaf3a7e88dfb3c5.php:24 16 __TwigTemplate_86adb04cb9a88671f1b6047ae304df659dd9453db20d014493865bae65561f14->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 15 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 14 Twig_Template->display() JROOT/cache/gantry5/rt_isotope/twig/bd/bd3159a8e42ce6ece98cffed0cb4a25ee51be352c4a6df0e3d4be4476adbc7b8.php:24 13 __TwigTemplate_85b466219d62aa6ce15fcd74c189c0d135606086dc09f8a3c2c0f109d5a6ba42->doDisplay() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432 12 Twig_Template->displayWithErrorHandling() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403 11 Twig_Template->display() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411 10 Twig_Template->render() JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 9 Twig_Environment->render() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/rt_isotope/index.php:23 7 require JROOT/templates/rt_isotope/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 21.60 ms Query memory: 0.004 MB Memory before query: 22.985 MB
LOCK TABLES `ksft0_extensions` WRITE
EXPLAIN not possible on query: LOCK TABLES `ksft0_extensions` WRITEStatus Duration Starting 0.03 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 Query end 0.01 ms Commit 0.01 ms Query end 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.01 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:551 8 JDatabaseDriverMysqli->lockTable() JROOT/plugins/system/updatenotification/updatenotification.php:78 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.60 ms After last query: 0.02 ms Query memory: 0.004 MB Memory before query: 22.990 MB
UPDATE `ksft0_extensions`
SET `params` = '{\"lastrun\":1732385202}'
WHERE `type` = 'plugin'
AND `folder` = 'system'
AND `element` = 'updatenotification'EXPLAIN not possible on query: UPDATE `ksft0_extensions` SET `params` = '{\"lastrun\":1732385202}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms init for update 0.07 ms Updating 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.30 ms Query end 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.01 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/updatenotification/updatenotification.php:89 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.14 ms After last query: 1.92 ms Query memory: 0.004 MB Memory before query: 23.155 MB
UNLOCK TABLES
EXPLAIN not possible on query: UNLOCK TABLESStatus Duration Starting 0.01 ms Commit implicit 0.01 ms starting 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms starting 0.01 ms Query end 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.01 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:926 8 JDatabaseDriverMysqli->unlockTables() JROOT/plugins/system/updatenotification/updatenotification.php:103 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.75 ms After last query: 1.33 ms Query memory: 0.021 MB Memory before query: 23.221 MB Rows returned: 1
SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
FROM `ksft0_update_sites` AS `a`
INNER JOIN ksft0_update_sites_extensions AS b
ON a.update_site_id = b.update_site_id
WHERE a.enabled = 1
AND b.extension_id IN (700)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 20 Using where; Using temporary 1 SIMPLE b eq_ref PRIMARY PRIMARY 8 benseat_bench.a.update_site_id,const 1 Using index; Distinct Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.99 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Creating tmp table 0.04 ms Executing 0.01 ms Sending data 0.22 ms Removing tmp table 0.08 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Updater/Updater.php:248 9 Joomla\CMS\Updater\Updater->getUpdateSites() JROOT/libraries/src/Updater/Updater.php:127 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.41 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 23.229 MB Rows returned: 15
SELECT DISTINCT update_site_id
FROM ksft0_updates
WHERE `update_site_id` IN ( SELECT update_site_id
FROM ksft0_update_sites
WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1732363602')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY ksft0_updates ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where; Using temporary 1 PRIMARY ksft0_update_sites eq_ref PRIMARY PRIMARY 4 benseat_bench.ksft0_updates.update_site_id 1 Using where; Distinct Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.57 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.02 ms Creating tmp table 0.02 ms Executing 0.01 ms Sending data 0.38 ms Removing tmp table 0.02 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Updater/Updater.php:426 9 Joomla\CMS\Updater\Updater->getSitesWithUpdates() JROOT/libraries/src/Updater/Updater.php:140 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.50 ms After last query: 0.04 ms Query memory: 0.004 MB Memory before query: 23.233 MB
DELETE
FROM `ksft0_updates`
WHERE `update_site_id` = '1'EXPLAIN not possible on query: DELETE FROM `ksft0_updates` WHERE `update_site_id` = '1'Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Updating 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.19 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.01 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/Updater.php:165 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 1.38 ms Query memory: 0.022 MB Memory before query: 23.289 MB Rows returned: 1
SELECT `name`
FROM `ksft0_update_sites`
WHERE `update_site_id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_update_sites const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/src/Updater/UpdateAdapter.php:195 12 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteName() JROOT/libraries/src/Updater/UpdateAdapter.php:222 11 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 0.03 ms Query memory: 0.006 MB Memory before query: 23.295 MB
UPDATE `ksft0_update_sites`
SET `enabled` = '0'
WHERE `update_site_id` = '1'EXPLAIN not possible on query: UPDATE `ksft0_update_sites` SET `enabled` = '0' WHERE `update_site_id` = '1'Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.03 ms Updating 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.18 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.01 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/UpdateAdapter.php:160 12 Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite() JROOT/libraries/src/Updater/UpdateAdapter.php:245 11 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.51 ms After last query: 26.24 ms Query memory: 0.006 MB Memory before query: 23.401 MB
UPDATE `ksft0_update_sites`
SET `enabled` = '1'
WHERE `update_site_id` = '1'EXPLAIN not possible on query: UPDATE `ksft0_update_sites` SET `enabled` = '1' WHERE `update_site_id` = '1'Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.03 ms Updating 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.20 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.02 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/UpdateAdapter.php:160 12 Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite() JROOT/libraries/src/Updater/UpdateAdapter.php:265 11 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.68 ms After last query: 0.79 ms Query memory: 0.026 MB Memory before query: 23.418 MB Rows returned: 14
SHOW FULL COLUMNS
FROM `ksft0_updates`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ksft0_updates`Status Duration Starting 0.02 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.19 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.06 ms closing tables 0.01 ms checking permissions 0.01 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 Removing tmp table 0.06 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.01 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 15 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Update.php:32 14 Joomla\CMS\Table\Update->__construct() JROOT/libraries/src/Table/Table.php:320 13 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:126 12 Joomla\CMS\Updater\Adapter\CollectionAdapter->_startElement() Same as call in the line below. 11 xml_parse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:243 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 0.62 ms Query memory: 0.021 MB Memory before query: 23.440 MB Rows returned: 0Duplicate queries: #86
SELECT `update_id`
FROM `ksft0_updates`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_updates ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 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.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Update.php:114 10 Joomla\CMS\Table\Update->find() JROOT/libraries/src/Updater/Updater.php:338 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 23.445 MB Rows returned: 1Duplicate queries: #87
SELECT `extension_id`
FROM `ksft0_extensions`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ref element_clientid,element_folder_clientid,extension extension 887 const,const,const,const 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 10 Joomla\CMS\Table\Extension->find() JROOT/libraries/src/Updater/Updater.php:348 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 23.452 MB Rows returned: 1Duplicate queries: #88
SELECT *
FROM ksft0_extensions
WHERE `extension_id` = '700'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 10 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Updater/Updater.php:358 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 23.458 MB Rows returned: 0Duplicate queries: #83
SELECT `update_id`
FROM `ksft0_updates`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_updates ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Update.php:114 10 Joomla\CMS\Table\Update->find() JROOT/libraries/src/Updater/Updater.php:338 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 23.463 MB Rows returned: 1Duplicate queries: #84
SELECT `extension_id`
FROM `ksft0_extensions`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ref element_clientid,element_folder_clientid,extension extension 887 const,const,const,const 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 10 Joomla\CMS\Table\Extension->find() JROOT/libraries/src/Updater/Updater.php:348 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 23.469 MB Rows returned: 1Duplicate queries: #85
SELECT *
FROM ksft0_extensions
WHERE `extension_id` = '700'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 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.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 10 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Updater/Updater.php:358 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 23.469 MB
INSERT INTO `ksft0_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`)
VALUES ('1','700','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','','')EXPLAIN not possible on query: INSERT INTO `ksft0_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) VALUES ('1','700','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','','')Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.01 ms Update 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.20 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1421 10 JDatabaseDriver->insertObject() JROOT/libraries/src/Table/Table.php:813 9 Joomla\CMS\Table\Table->store() JROOT/libraries/src/Updater/Updater.php:177 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 23.473 MB
UPDATE `ksft0_update_sites`
SET `last_check_timestamp` = '1732385202'
WHERE `update_site_id` = '1'EXPLAIN not possible on query: UPDATE `ksft0_update_sites` SET `last_check_timestamp` = '1732385202' WHERE `update_site_id` = '1'Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Updating 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.20 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.02 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/Updater.php:455 9 Joomla\CMS\Updater\Updater->updateLastCheckTimestamp() JROOT/libraries/src/Updater/Updater.php:182 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 2.09 ms Query memory: 0.021 MB Memory before query: 23.612 MB Rows returned: 1
SELECT u.*,`e`.`manifest_cache`
FROM `ksft0_updates` AS `u`
LEFT JOIN `ksft0_extensions` AS `e`
ON `e`.`extension_id` = `u`.`extension_id`
WHERE `u`.`extension_id` != '0'
AND `u`.`extension_id` = '700'
ORDER BY `u`.`name` asc
LIMIT 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE u ALL NULL NO INDEX KEY COULD BE USED NULL NULL 115 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 benseat_bench.u.extension_id 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 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 Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.09 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_installer/models/update.php:217 9 InstallerModelUpdate->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:189 8 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/plugins/system/updatenotification/updatenotification.php:136 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.60 ms After last query: 1.93 ms Query memory: 0.024 MB Memory before query: 23.816 MB Rows returned: 8
SHOW FULL COLUMNS
FROM `ksft0_assets`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ksft0_assets`Status Duration Starting 0.02 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.15 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.05 ms closing tables 0.01 ms checking permissions 0.01 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 Removing tmp table 0.06 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.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 11 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Asset.php:61 10 Joomla\CMS\Table\Asset->__construct() JROOT/libraries/src/Table/Table.php:320 9 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/updatenotification/updatenotification.php:297 8 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 23.832 MB Rows returned: 1
SELECT id
FROM ksft0_assets
WHERE parent_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_assets ref idx_parent_id idx_parent_id 4 const 1 Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Table/Nested.php:1219 9 Joomla\CMS\Table\Nested->getRootId() JROOT/plugins/system/updatenotification/updatenotification.php:297 8 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.46 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 23.841 MB Rows returned: 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ksft0_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eshop','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_roksprocket','com_rsfirewall','com_rsform','com_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 187 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 11 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 10 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 9 Joomla\CMS\Access\Access::getAssetRules() JROOT/plugins/system/updatenotification/updatenotification.php:298 8 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.92 ms After last query: 0.56 ms Query memory: 0.020 MB Memory before query: 23.978 MB Rows returned: 2
SELECT `user_id`
FROM `ksft0_user_usergroup_map`
WHERE `group_id` IN('8')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_user_usergroup_map index NULL PRIMARY 8 NULL 3 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.57 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 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.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 9 JDatabaseDriver->loadColumn() JROOT/plugins/system/updatenotification/updatenotification.php:333 8 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 23.983 MB Rows returned: 1
SELECT `id`,`username`,`email`
FROM `ksft0_users`
WHERE `id` IN('542','543')
AND `block` = 0
AND `sendEmail` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_users range PRIMARY,idx_block idx_block 5 NULL 2 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.02 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.18 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.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.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/updatenotification/updatenotification.php:373 8 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 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
78 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
5 × SELECT a.id, a.category_parent_id, b.category_alias
FROM ksft0_eshop_categories AS a
INNER JOIN ksft0_eshop_categorydetails AS b
ON (a.id = b.category_id)4 × SELECT *
FROM ksft0_extensions4 × SELECT `extension_id`
FROM `ksft0_extensions`2 × SELECT id
FROM ksft0_eshop_urls2 × SELECT *
FROM ksft0_eshop_currencies2 × SELECT product_name, product_alias
FROM ksft0_eshop_productdetails2 × SELECT `ip`,`reason`
FROM ksft0_rsfirewall_lists2 × SELECT template
FROM ksft0_template_styles as s2 × SELECT `update_id`
FROM `ksft0_updates`2 × SELECT ad.attribute_name, pad.value
FROM ksft0_eshop_attributes AS a
INNER JOIN ksft0_eshop_attributedetails AS ad
ON (a.id = ad.attribute_id)
INNER JOIN ksft0_eshop_productattributes AS pa
ON (a.id = pa.attribute_id)
INNER JOIN ksft0_eshop_productattributedetails AS pad
ON (pa.id = pad.productattribute_id)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ksft0_extensions`1 × SELECT p.*, pd.product_name, pd.product_alias, pd.product_desc, pd.product_short_desc, pd.meta_key, pd.meta_desc
FROM ksft0_eshop_products AS p
INNER JOIN ksft0_eshop_productdetails AS pd
ON (p.id = pd.product_id)
INNER JOIN ksft0_eshop_productrelations AS pr
ON (p.id = pr.related_product_id)1 × SELECT m.id, m.manufacturer_email, md.manufacturer_name
FROM ksft0_eshop_products AS p
INNER JOIN ksft0_eshop_manufacturers AS m
ON (p.manufacturer_id = m.id)
INNER JOIN ksft0_eshop_manufacturerdetails AS md
ON (m.id = md.manufacturer_id)1 × SELECT a.id, b.product_id, b.product_name, b.product_page_title, pc.category_id
FROM ksft0_eshop_products AS a
INNER JOIN ksft0_eshop_productdetails AS b
ON (a.id = b.product_id)
INNER JOIN ksft0_eshop_productcategories AS pc
ON (a.id = pc.product_id)1 × SELECT DISTINCT(label_id)
FROM ksft0_eshop_labelelements1 × SELECT a.id, b.attributegroup_name
FROM ksft0_eshop_attributegroups AS a
INNER JOIN ksft0_eshop_attributegroupdetails AS b
ON (a.id = b.attributegroup_id)1 × SELECT product_quantity
FROM ksft0_eshop_products1 × SELECT id
FROM ksft0_eshop_labels1 × SELECT `data`
FROM `ksft0_session`1 × SELECT ovd.value, pov.id, pov.price, pov.price_sign, pov.price_type, pov.image
FROM ksft0_eshop_optionvalues AS ov
INNER JOIN ksft0_eshop_optionvaluedetails AS ovd
ON (ov.id = ovd.optionvalue_id)
INNER JOIN ksft0_eshop_productoptionvalues AS pov
ON (ovd.optionvalue_id = pov.option_value_id)1 × SELECT a.*, b.product_name, b.product_alias, b.product_desc, b.product_short_desc, b.meta_key, b.meta_desc, b.tab1_title, b.tab1_content, b.tab2_title, b.tab2_content, b.tab3_title, b.tab3_content, b.tab4_title, b.tab4_content, b.tab5_title, b.tab5_content
FROM ksft0_eshop_products AS a
INNER JOIN ksft0_eshop_productdetails AS b
ON (a.id = b.product_id)1 × SELECT id
FROM ksft0_eshop_productoptions1 × SELECT quantity, price
FROM ksft0_eshop_productdiscounts1 × SELECT a.menutype
FROM ksft0_menu_types AS a1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ksft0_modules AS m
LEFT JOIN ksft0_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ksft0_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
FROM `ksft0_update_sites` AS `a`
INNER JOIN ksft0_update_sites_extensions AS b
ON a.update_site_id = b.update_site_id1 × SELECT DISTINCT update_site_id
FROM ksft0_updates1 × SELECT `name`
FROM `ksft0_update_sites`1 × SELECT u.*,`e`.`manifest_cache`
FROM `ksft0_updates` AS `u`
LEFT JOIN `ksft0_extensions` AS `e`
ON `e`.`extension_id` = `u`.`extension_id`1 × SELECT id
FROM ksft0_assets1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `ksft0_assets`1 × SELECT `user_id`
FROM `ksft0_user_usergroup_map`1 × SELECT o.id, o.option_type, o.option_image, od.option_name, od.option_desc, po.required, po.id AS product_option_id
FROM ksft0_eshop_options AS o
INNER JOIN ksft0_eshop_optiondetails AS od
ON (o.id = od.option_id)
INNER JOIN ksft0_eshop_productoptions AS po
ON (o.id = po.option_id)1 × SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
FROM ksft0_eshop_products1 × SELECT pi.*
FROM ksft0_eshop_productimages AS pi1 × SELECT *
FROM ksft0_rsfirewall_hashes1 × SELECT id, rules
FROM `ksft0_viewlevels1 × SELECT b.id
FROM ksft0_usergroups AS a
LEFT JOIN ksft0_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ksft0_extensions1 × SELECT `path`
FROM ksft0_rsfirewall_ignored1 × SELECT `file`
FROM ksft0_rsfirewall_hashes1 × SELECT *
FROM ksft0_rsfirewall_configuratio1 × SELECT extension, file, type
FROM ksft0_rokcommon_configs1 × SELECT id,template
FROM ksft0_template_styles1 × SELECT *
FROM ksft0_rsform_confi1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM ksft0_menu AS m
LEFT JOIN ksft0_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `query`
FROM ksft0_eshop_urls1 × SELECT *
FROM ksft0_rsfirewall_snapshots1 × SELECT *
FROM ksft0_eshop_productattachments1 × SELECT *
FROM ksft0_rsfirewall_exceptions1 × SELECT id, home, template, s.params
FROM ksft0_template_styles as s
LEFT JOIN ksft0_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM ksft0_template_styles AS s1 × SELECT *
FROM ksft0_rokcandy1 × SELECT *
FROM ksft0_languages1 × SELECT config_key, config_value
FROM ksft0_eshop_config1 × SELECT a.*, b.product_name, b.product_alias, b.product_desc, b.product_short_desc, b.product_page_title, b.product_page_heading, b.product_alt_image, b.meta_key, b.meta_desc, b.tab1_title, b.tab1_content, b.tab2_title, b.tab2_content, b.tab3_title, b.tab3_content, b.tab4_title, b.tab4_content, b.tab5_title, b.tab5_content
FROM ksft0_eshop_products AS a
INNER JOIN ksft0_eshop_productdetails AS b
ON (a.id = b.product_id)1 × SELECT a.id, a.category_parent_id, b.category_name
FROM ksft0_eshop_categories AS a
INNER JOIN ksft0_eshop_categorydetails AS b
ON (a.id = b.category_id)1 × SELECT `session_id`
FROM `ksft0_session`1 × SELECT stockstatus_name
FROM ksft0_eshop_stockstatusdetails1 × SELECT a.*
FROM ksft0_eshop_tags AS a
INNER JOIN ksft0_eshop_producttags AS b
ON (a.id = b.tag_id)1 × SELECT `id`,`username`,`email`
FROM `ksft0_users`
OTHER Tables:
1 × INSERT INTO `ksft0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6365626362623564303331356636396162343766303833313338656464663838', 1, 1732385201, 0, '', 01 × UNLOCK TABLE
1 × UPDATE `ksft0_update_sites`
SET `last_check_timestamp` = '1732385202'1 × INSERT INTO `ksft0_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`)
VALUES ('1','700','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','',''1 × SHOW FULL COLUMNS
FROM `ksft0_updates1 × UPDATE `ksft0_update_sites`
SET `enabled` = '1'1 × UPDATE `ksft0_update_sites`
SET `enabled` = '0'1 × DELETE
FROM `ksft0_updates`1 × UPDATE `ksft0_extensions`
SET `params` = '{\"lastrun\":1732385202}'1 × SHOW FULL COLUMNS
FROM `ksft0_rsfirewall_logs1 × LOCK TABLES `ksft0_extensions` WRIT
1 × UPDATE ksft0_eshop_urls
SET query="view=product&id=69&catid=27"1 × UPDATE ksft0_eshop_urls
SET query="view=product&id=64&catid=27"1 × UPDATE ksft0_eshop_products
SET hits = hits + 11 × UPDATE `ksft0_extensions`
SET `params` = '{\"mediaversion\":\"3e60ef3c5a744b72c60a7bea4502345c\"}'1 × SHOW FULL COLUMNS
FROM `ksft0_extensions1 × SHOW FULL COLUMNS
FROM `ksft0_assets