Coolabah Shaded Table & Seat Seting
PRICE (Ex. GST)
CODE
SIZE
POWDER COATED
APPROX. SEATING CAPACITY
TSR01-24
..
Product #: TSR01-24
PRICE (Ex. GST)
CODE
SIZE
POWDER COATED
APPROX. SEATING CAPACITY
TSR01-24
..
Product #: TSR01-24
Coolabah Shaded Table & Seat Seting
Call for Price: 1300117328
Available Options
*
Table and Seat Combination Settings:
Our range includes a vairety of options and sizes for Senior (Adult), Junior & Prep/Kindergarten Picnic/Table & Seat Settings.
Features:
- Clear anodised structural grade aluminium Seat Plank,
- Reinforced panels, Exclusive to Aluminium Seating SpecialistsTM,
- Optional powder coated seat supports (Price P.O.A.*),
- High quality cast aluminium flush fitting End Caps, and;
- Stainless steel Nylok self locking fasteners.
- Clear anodised structural grade aluminium Seat Plank,
- Reinforced panels, Exclusive to Aluminium Seating SpecialistsTM,
- Optional powder coated seat supports (Price P.O.A.*),
- High quality cast aluminium flush fitting End Caps, and;
- Stainless steel Nylok self locking fasteners.
Standard Sizes (Other sizes availabe upon request):
| PRICE (Ex. GST) | |||
| CODE | SIZE | POWDER COATED | APPROX. SEATING CAPACITY |
| TSR01-24 | 2400mm (L) | $3,729.00 | 8 people per setting |
Dimensions: 2400mm (L) x 1700mm (W) x 810mm (Table Ht) x 510mm (Seat Ht) x 2400mm (Roof width) x 2400mm (Roof Ht)
|
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": 1713533803,
"last": 1713533803,
"now": 1713533803
},
"client": {
"forwarded": "18.224.30.118"
},
"token": "GvdGJeCTj7CPhp6qcKLuQIZdZLUcFwSq"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"viewed_product_ids": [
56
],
"continue_shopping_url": "https://www.benchseating.com.au/index.php/bench-seating/shaded-table-seat-settings-shelter/coolabah-shaded-table-seat-setting"
}
}
Time
Memory
Time: 25.42 ms / 25.42 ms Memory: 1.837 MB / 2.22 MB Application: afterLoad
Time: 148.55 ms / 173.97 ms Memory: 8.276 MB / 10.49 MB Application: afterInitialise
Time: 68.79 ms / 242.77 ms Memory: 3.552 MB / 14.05 MB Application: afterRoute
Time: 1.08 ms / 243.85 ms Memory: 0.014 MB / 14.06 MB Application: beforeRenderComponent com_eshop
Time: 108.50 ms / 352.35 ms Memory: 2.952 MB / 17.01 MB Application: afterRenderComponent com_eshop
Time: 2.74 ms / 355.09 ms Memory: 0.187 MB / 17.20 MB Application: afterDispatch
Time: 123.30 ms / 478.39 ms Memory: 5.804 MB / 23.00 MB Application: afterRender
Database queries total: 89.08 ms
23.97 MB (25,137,704 Bytes)
67 Queries Logged 89.08 ms
9 duplicate found!
- Query Time: 1.29 ms Query memory: 0.023 MB Memory before query: 3.930 MB Rows returned: 0
SELECT `data`
FROM `ksft0_session`
WHERE `session_id` = X'3637393765333038656331396234383837333366396339643134303235613361'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.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.79 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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.49 ms After last query: 1.65 ms Query memory: 0.020 MB Memory before query: 4.089 MB Rows returned: 0
SELECT `session_id`
FROM `ksft0_session`
WHERE `session_id` = X'3637393765333038656331396234383837333366396339643134303235613361'
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.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.03 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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: 1.33 ms After last query: 0.13 ms Query memory: 0.004 MB Memory before query: 4.094 MB
INSERT INTO `ksft0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3637393765333038656331396234383837333366396339643134303235613361', 1, 1713533803, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `ksft0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3637393765333038656331396234383837333366396339643134303235613361', 1, 1713533803, 0, '', 0)Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 0.12 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.78 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.02 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.79 ms After last query: 3.85 ms Query memory: 0.025 MB Memory before query: 4.312 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.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.04 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.24 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.03 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.41 ms After last query: 3.31 ms Query memory: 0.021 MB Memory before query: 4.504 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.04 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.54 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 4.516 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.06 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.07 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.04 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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: 1.07 ms After last query: 0.82 ms Query memory: 0.030 MB Memory before query: 4.585 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.06 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.03 ms Statistics 0.07 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.54 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.44 ms After last query: 7.55 ms Query memory: 0.021 MB Memory before query: 5.294 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.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.05 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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.51 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 5.300 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.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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.49 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 5.306 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.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 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: 1.31 ms After last query: 6.62 ms Query memory: 0.024 MB Memory before query: 5.841 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.05 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.45 ms After opening tables 0.02 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.02 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.12 ms closing tables 0.02 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 closing tables 0.01 ms Removing tmp table 0.16 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.55 ms After last query: 15.85 ms Query memory: 0.022 MB Memory before query: 6.927 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.06 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.04 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.03 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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.47 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 6.934 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.04 ms checking permissions 0.03 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.04 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 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 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.52 ms After last query: 4.86 ms Query memory: 0.021 MB Memory before query: 7.229 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.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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.68 ms After last query: 32.60 ms Query memory: 0.025 MB Memory before query: 9.082 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.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.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.49 ms After last query: 11.06 ms Query memory: 0.023 MB Memory before query: 9.857 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.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.02 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller 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: 1.22 ms After last query: 0.75 ms Query memory: 0.026 MB Memory before query: 9.887 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.04 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.46 ms After opening tables 0.02 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.12 ms closing tables 0.02 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.14 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.49 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 9.916 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.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.09 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 closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 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 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.41 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 9.922 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.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.06 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.41 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 9.926 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.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.06 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.40 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 9.932 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.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.05 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.83 ms After last query: 23.78 ms Query memory: 0.026 MB Memory before query: 10.682 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.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.21 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller 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: 1.98 ms After last query: 13.23 ms Query memory: 0.021 MB Memory before query: 11.260 MB Rows returned: 1
SELECT `query`
FROM ksft0_eshop_urls
WHERE md5_key = "76e7a4008138a8617c99fc75e264e97c"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.04 ms checking permissions 0.01 ms Opening tables 1.31 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms Unlocking tables 0.02 ms closing tables 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.16 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller 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.56 ms After last query: 0.25 ms Query memory: 0.020 MB Memory before query: 11.265 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.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.04 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.03 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.40 ms After last query: 0.60 ms Query memory: 0.021 MB Memory before query: 11.298 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.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.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 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 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.50 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 11.304 MB Rows returned: 0
SELECT `ip`,`reason`
FROM ksft0_rsfirewall_lists
WHERE (`ip`='18.224.30.118' 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.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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/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.48 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 11.310 MB Rows returned: 0
SELECT `ip`,`reason`
FROM ksft0_rsfirewall_lists
WHERE (`ip`='18.224.30.118' 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.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.02 ms Statistics 0.05 ms Preparing 0.05 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 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/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.39 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 11.315 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.04 ms checking permissions 0.01 ms Opening tables 0.02 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.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.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.76 ms After last query: 0.56 ms Query memory: 0.022 MB Memory before query: 11.321 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.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.09 ms Executing 0.01 ms Sending data 0.14 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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.60 ms After last query: 21.78 ms Query memory: 0.026 MB Memory before query: 12.507 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.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.05 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller 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: 1.28 ms After last query: 0.22 ms Query memory: 0.008 MB Memory before query: 12.501 MB
UPDATE `ksft0_extensions`
SET `params` = '{\"mediaversion\":\"f3f56d54cbfdc7173f79a3349e1c5868\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `ksft0_extensions` SET `params` = '{\"mediaversion\":\"f3f56d54cbfdc7173f79a3349e1c5868\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init for update 0.10 ms Updating 0.14 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.70 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.03 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.60 ms After last query: 7.44 ms Query memory: 0.023 MB Memory before query: 13.490 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.06 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.03 ms Statistics 0.07 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.02 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.58 ms After last query: 2.71 ms Query memory: 0.025 MB Memory before query: 13.700 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.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.03 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.03 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 closing tables 0.01 ms Unlocking tables 0.03 ms closing tables 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 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.60 ms After last query: 9.63 ms Query memory: 0.019 MB Memory before query: 14.051 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.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.03 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.02 ms Creating sort index 0.09 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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: 2.84 ms After last query: 11.08 ms Query memory: 0.033 MB Memory before query: 15.003 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.04 ms checking permissions 0.01 ms Opening tables 1.98 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.05 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.02 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.28 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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: 4.23 ms After last query: 15.78 ms Query memory: 0.040 MB Memory before query: 15.881 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 = 56
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-04-19 23:36:43')
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.14 ms checking permissions 0.02 ms Opening tables 1.71 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.13 ms Unlocking tables 0.01 ms closing tables 0.02 ms init 0.15 ms Optimizing 0.09 ms Statistics 0.78 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.66 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 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: 1.51 ms After last query: 0.52 ms Query memory: 0.022 MB Memory before query: 15.906 MB Rows returned: 3Duplicate queries: #62
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.04 ms checking permissions 0.03 ms Opening tables 0.89 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.03 ms Unlocking tables 0.01 ms closing tables 0.05 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.03 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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: 1.93 ms After last query: 1.15 ms Query memory: 0.022 MB Memory before query: 15.952 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.05 ms checking permissions 0.01 ms Opening tables 0.96 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.06 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.14 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.03 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.53 ms After last query: 0.55 ms Query memory: 0.022 MB Memory before query: 15.974 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.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.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.02 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: 1.16 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 15.981 MB
UPDATE ksft0_eshop_products
SET hits = hits + 1
WHERE id = 56EXPLAIN not possible on query: UPDATE ksft0_eshop_products SET hits = hits + 1 WHERE id = 56Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init for update 0.05 ms Updating 0.12 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.61 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.02 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.51 ms After last query: 0.36 ms Query memory: 0.022 MB Memory before query: 15.992 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 = 56id 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.06 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.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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 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: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: 2.03 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 15.999 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.05 ms checking permissions 0.01 ms Opening tables 1.53 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.03 ms Optimizing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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: 2.68 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 16.005 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 = 56id 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.04 ms checking permissions 0.01 ms Opening tables 2.06 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 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.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.05 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: 2.30 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 16.011 MB Rows returned: 0
SELECT *
FROM ksft0_eshop_productattachments
WHERE product_id = 56
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.04 ms checking permissions 0.01 ms Opening tables 1.80 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.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.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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: 1.12 ms After last query: 8.53 ms Query memory: 0.022 MB Memory before query: 16.479 MB Rows returned: 1
SELECT pi.*
FROM ksft0_eshop_productimages AS pi
WHERE product_id = 56
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.05 ms checking permissions 0.01 ms Opening tables 0.34 ms After opening tables 0.02 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.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.22 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 ms # Caller 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.97 ms After last query: 1.13 ms Query memory: 0.021 MB Memory before query: 16.487 MB Rows returned: 0
SELECT quantity, price
FROM ksft0_eshop_productdiscounts
WHERE product_id = 56
AND published = 1
AND customergroup_id = 1
AND (date_start <= "2024-04-19 13:36:43" OR date_start = "0000-00-00 00:00:00")
AND (date_end >= "2024-04-19 13:36:43" 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.06 ms checking permissions 0.01 ms Opening tables 0.32 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.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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: 4.18 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 16.494 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 = 56
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.06 ms checking permissions 0.01 ms Opening tables 2.60 ms After opening tables 0.03 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.07 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.04 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.08 ms Creating tmp table 0.05 ms Sorting result 0.04 ms Executing 0.01 ms Sending data 0.49 ms Creating sort index 0.09 ms Removing tmp table 0.17 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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: 2.52 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 16.501 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.05 ms checking permissions 0.01 ms Opening tables 1.79 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms Unlocking tables 0.03 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.06 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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: 5.72 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 16.510 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 = 56
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.06 ms checking permissions 0.01 ms Opening tables 4.80 ms After opening tables 0.02 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.08 ms Unlocking tables 0.01 ms closing tables 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.16 ms Preparing 0.06 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.04 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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.69 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 16.516 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 = 56
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.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.04 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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: 2.52 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 16.522 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 = 56
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.05 ms checking permissions 0.01 ms Opening tables 0.99 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.08 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.04 ms Creating tmp table 0.15 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.43 ms Creating sort index 0.06 ms Removing tmp table 0.09 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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: 2.61 ms After last query: 0.86 ms Query memory: 0.021 MB Memory before query: 16.568 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 = 56
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.06 ms checking permissions 0.01 ms Opening tables 1.96 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.05 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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: 2.95 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 16.575 MB Rows returned: 2
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 = 30
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 2 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.07 ms checking permissions 0.01 ms Opening tables 1.00 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.06 ms Optimizing 0.04 ms Statistics 0.70 ms Preparing 0.05 ms Creating tmp table 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.56 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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: 2.35 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 16.580 MB Rows returned: 0
SELECT DISTINCT(label_id)
FROM ksft0_eshop_labelelements
WHERE (element_type = "product"
AND element_id = 56) OR (element_type = "manufacturer"
AND element_id = (SELECT manufacturer_id
FROM ksft0_eshop_products
WHERE id = 56)) OR (element_type = "category"
AND element_id IN (SELECT category_id
FROM ksft0_eshop_productcategories
WHERE product_id = 56))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.06 ms checking permissions 0.01 ms Opening tables 0.86 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.07 ms Optimizing 0.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.04 ms Statistics 0.02 ms Executing 0.01 ms Sending data 0.02 ms Preparing 0.04 ms Optimizing 0.02 ms Statistics 0.63 ms Preparing 0.06 ms Creating tmp table 0.05 ms Executing 0.01 ms Sending data 0.03 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 closing tables 0.03 ms Unlocking tables 0.01 ms closing tables 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: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.36 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 16.586 MB Rows returned: 1
SELECT product_quantity
FROM ksft0_eshop_products
WHERE id = 56id 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.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.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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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: 1.20 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 16.592 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.03 ms checking permissions 0.01 ms Opening tables 0.78 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.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 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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.58 ms After last query: 3.57 ms Query memory: 0.024 MB Memory before query: 16.823 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.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.05 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.48 ms After last query: 0.34 ms Query memory: 0.026 MB Memory before query: 16.831 MB Rows returned: 1
SELECT product_name, product_alias
FROM ksft0_eshop_productdetails
WHERE product_id = 63
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.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.06 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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: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.56 ms After last query: 0.10 ms Query memory: 0.027 MB Memory before query: 16.843 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.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 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 closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.03 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.59 ms After last query: 2.42 ms Query memory: 0.026 MB Memory before query: 16.972 MB Rows returned: 1
SELECT id
FROM ksft0_eshop_urls
WHERE md5_key="8cded4f1acbe24e9771455caed907884"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.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.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.15 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 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 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.48 ms After last query: 0.08 ms Query memory: 0.010 MB Memory before query: 16.982 MB
UPDATE ksft0_eshop_urls
SET query="view=product&id=63&catid=30"
WHERE md5_key="8cded4f1acbe24e9771455caed907884"EXPLAIN not possible on query: UPDATE ksft0_eshop_urls SET query="view=product&id=63&catid=30" WHERE md5_key="8cded4f1acbe24e9771455caed907884"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.02 ms table lock 0.01 ms init for update 0.04 ms Updating 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller 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.47 ms After last query: 1.04 ms Query memory: 0.024 MB Memory before query: 17.034 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.04 ms checking permissions 0.01 ms Opening tables 0.02 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.02 ms Preparing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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.83 ms After last query: 0.19 ms Query memory: 0.040 MB Memory before query: 17.045 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 = 56id 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.06 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.11 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 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 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: 1.11 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 17.057 MB Rows returned: 1
SELECT id
FROM ksft0_eshop_productoptions
WHERE product_id = 56
AND option_id = 3id 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 (31%) Using where; Using rowid filter 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.04 ms Optimizing 0.02 ms Statistics 0.64 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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: 2.73 ms After last query: 0.08 ms Query memory: 0.028 MB Memory before query: 17.076 MB Rows returned: 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)
WHERE ov.published = 1
AND pov.product_option_id = 298
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 1 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.06 ms checking permissions 0.04 ms Opening tables 0.92 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.07 ms Unlocking tables 0.01 ms closing tables 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.04 ms Executing 0.01 ms Sending data 0.89 ms Creating sort index 0.05 ms Removing tmp table 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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: 2.15 ms After last query: 60.85 ms Query memory: 0.034 MB Memory before query: 20.949 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.08 ms checking permissions 0.02 ms Opening tables 1.54 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.02 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 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 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 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: 8.32 ms After last query: 4.84 ms Query memory: 0.037 MB Memory before query: 21.242 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-04-19 13:36:43')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 13:36:43')
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.13 ms checking permissions 0.02 ms Opening tables 3.05 ms After opening tables 0.05 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.05 ms Unlocking tables 0.01 ms closing tables 0.02 ms init 0.06 ms Optimizing 0.08 ms Statistics 0.16 ms Preparing 0.10 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 4.11 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 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
58 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × 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)2 × SELECT *
FROM ksft0_extensions2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ksft0_extensions`2 × SELECT *
FROM ksft0_eshop_currencies2 × SELECT template
FROM ksft0_template_styles as s2 × SELECT `ip`,`reason`
FROM ksft0_rsfirewall_lists2 × SELECT `extension_id`
FROM `ksft0_extensions`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)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 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 *
FROM ksft0_eshop_productattachments1 × SELECT pi.*
FROM ksft0_eshop_productimages AS pi1 × SELECT quantity, price
FROM ksft0_eshop_productdiscounts1 × 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 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 `data`
FROM `ksft0_session`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 product_quantity
FROM ksft0_eshop_products1 × SELECT id
FROM ksft0_eshop_labels1 × SELECT product_name, product_alias
FROM ksft0_eshop_productdetails1 × SELECT id
FROM ksft0_eshop_urls1 × 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 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.menutype
FROM ksft0_menu_types AS a1 × 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 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 *
FROM ksft0_rsform_confi1 × 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 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 `session_id`
FROM `ksft0_session`1 × SELECT `query`
FROM ksft0_eshop_urls1 × SELECT *
FROM ksft0_rsfirewall_hashes1 × SELECT *
FROM ksft0_rsfirewall_snapshots1 × 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 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
OTHER Tables:
1 × INSERT INTO `ksft0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3637393765333038656331396234383837333366396339643134303235613361', 1, 1713533803, 0, '', 01 × SHOW FULL COLUMNS
FROM `ksft0_rsfirewall_logs1 × SHOW FULL COLUMNS
FROM `ksft0_extensions1 × UPDATE `ksft0_extensions`
SET `params` = '{\"mediaversion\":\"f3f56d54cbfdc7173f79a3349e1c5868\"}'1 × UPDATE ksft0_eshop_products
SET hits = hits + 11 × UPDATE ksft0_eshop_urls
SET query="view=product&id=63&catid=30"