Madison Wall Mounted Bench Seat
PRICE (Ex. GST)
CODE
SIZES
UN-POWDER COATED
POWDER COATED
APPROX. SEATING CA..
Product #: AS009
PRICE (Ex. GST)
CODE
SIZES
UN-POWDER COATED
POWDER COATED
APPROX. SEATING CA..
Product #: AS009
Madison Wall Mounted Bench Seat
Call for Price: 1300117328
Available Options
*
Bench Seating:
Our range includes a vairety of options and sizes for Senior (Adult), Junior & Prep/Kindergarten Bench Seats.
Features:
- Clear anodised structural grade aluminium Seat Plank or Seat Slat,
- Reinforced panels, Exclusive to Aluminium Seating SpecialistsTM,
- Optional powder coated seat supports (Price P.O.A.*),
- High quality cast aluminium flush fitting End Caps or Plastic End Caps,
- Stainless steel Nylok self locking fasteners and/or;
- Heavy Duty Rubber Feet.
- Clear anodised structural grade aluminium Seat Plank or Seat Slat,
- Reinforced panels, Exclusive to Aluminium Seating SpecialistsTM,
- Optional powder coated seat supports (Price P.O.A.*),
- High quality cast aluminium flush fitting End Caps or Plastic End Caps,
- Stainless steel Nylok self locking fasteners and/or;
- Heavy Duty Rubber Feet.
Standard Sizes (Other sizes availabe upon request):
| PRICE (Ex. GST) | ||||
| CODE | SIZES | UN-POWDER COATED | POWDER COATED | APPROX. SEATING CAPACITY |
| AS009-18 | 1800mm (L) | $212.00 | $222.00 | 3 people per seat |
| AS009-2 | 2000mm (L) | $243.00 | $253.00 | 4 people per seat |
| AS009-24 | 2400mm (L) | $304.00 | $320.00 | 5 people per seat |
| AS009-3 | 3000mm (L) | $335.00 | $351.00 | 6 people per seat |
| AS009-4 | 4000mm (L) | $433.00 | $454.00 | 8 people per seat |
Dimensions: 250mm (Seat Panel W) x 365mm (Overall Size from wall)
|
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": 1732295974,
"last": 1732295974,
"now": 1732295974
},
"client": {
"forwarded": "3.148.108.201"
},
"token": "kUpK2kBk9m2xS364f10ibDAsD7U0DzTw"
},
"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": [
48
],
"continue_shopping_url": "https://benchseating.com.au/index.php/bench-seating/madison-wall-mounted-bench-seat"
}
}
Time
Memory
Time: 10.89 ms / 10.89 ms Memory: 1.839 MB / 2.22 MB Application: afterLoad
Time: 71.95 ms / 82.85 ms Memory: 8.273 MB / 10.49 MB Application: afterInitialise
Time: 30.22 ms / 113.07 ms Memory: 3.552 MB / 14.04 MB Application: afterRoute
Time: 0.55 ms / 113.62 ms Memory: 0.013 MB / 14.06 MB Application: beforeRenderComponent com_eshop
Time: 51.68 ms / 165.30 ms Memory: 2.973 MB / 17.03 MB Application: afterRenderComponent com_eshop
Time: 1.32 ms / 166.62 ms Memory: 0.124 MB / 17.15 MB Application: afterDispatch
Time: 54.04 ms / 220.66 ms Memory: 5.867 MB / 23.02 MB Application: afterRender
Database queries total: 44.71 ms
24.07 MB (25,243,256 Bytes)
69 Queries Logged 44.71 ms
8 duplicate found!
- Query Time: 0.96 ms Query memory: 0.023 MB Memory before query: 3.931 MB Rows returned: 0
SELECT `data`
FROM `ksft0_session`
WHERE `session_id` = X'6265616633626634306434343838333865336234353462363233376238646333'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.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.46 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:854 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.26 ms After last query: 0.84 ms Query memory: 0.020 MB Memory before query: 4.090 MB Rows returned: 0
SELECT `session_id`
FROM `ksft0_session`
WHERE `session_id` = X'6265616633626634306434343838333865336234353462363233376238646333'
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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.02 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.60 ms After last query: 0.05 ms Query memory: 0.004 MB Memory before query: 4.095 MB
INSERT INTO `ksft0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6265616633626634306434343838333865336234353462363233376238646333', 1, 1732295974, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `ksft0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6265616633626634306434343838333865336234353462363233376238646333', 1, 1732295974, 0, '', 0)Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.30 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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.48 ms After last query: 1.83 ms Query memory: 0.025 MB Memory before query: 4.313 MB Rows returned: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ksft0_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ref extension extension 82 const 42 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 1.57 ms Query memory: 0.021 MB Memory before query: 4.505 MB Rows returned: 5
SELECT id, rules
FROM `ksft0_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.31 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.517 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.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.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.54 ms After last query: 0.51 ms Query memory: 0.030 MB Memory before query: 4.586 MB Rows returned: 105
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ksft0_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 265 Using where; Using filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.24 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 4.07 ms Query memory: 0.021 MB Memory before query: 5.295 MB Rows returned: 0
SELECT `path`
FROM ksft0_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_ignored ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.26 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 5.301 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.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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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.25 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 5.307 MB Rows returned: 66
SELECT *
FROM ksft0_rsfirewall_configurationid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_configuration ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 Status Duration Starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/config.php:68 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:29 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.67 ms After last query: 3.23 ms Query memory: 0.024 MB Memory before query: 5.842 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `ksft0_rsfirewall_logs`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ksft0_rsfirewall_logs`Status Duration Starting 0.02 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.22 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.06 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.07 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 12 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 11 RsfirewallTableLogs->__construct() JROOT/libraries/src/Table/Table.php:320 10 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_rsfirewall/helpers/log.php:23 9 RSFirewallLogger->__construct() JROOT/administrator/components/com_rsfirewall/helpers/log.php:77 8 RSFirewallLogger::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:56 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 7.02 ms Query memory: 0.022 MB Memory before query: 6.924 MB Rows returned: 1Duplicate queries: #13
SELECT template
FROM ksft0_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 8 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 6.931 MB Rows returned: 1Duplicate queries: #12
SELECT template
FROM ksft0_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 8 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/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.29 ms After last query: 1.90 ms Query memory: 0.021 MB Memory before query: 7.227 MB Rows returned: 2
SELECT extension, file, type
FROM ksft0_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rokcommon_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using filesort Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.04 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:131 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:75 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 14.38 ms Query memory: 0.025 MB Memory before query: 9.079 MB Rows returned: 1
SELECT id,template
FROM ksft0_template_styles
WHERE client_id=0
AND home=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_template_styles ALL idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 8 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.26 ms After last query: 5.98 ms Query memory: 0.023 MB Memory before query: 9.854 MB Rows returned: 28
SELECT *
FROM ksft0_rsform_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsform_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 28 Status Duration Starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php:50 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php:17 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php:102 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26 8 plgSystemRsformdeletesubmissions->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.61 ms After last query: 0.43 ms Query memory: 0.026 MB Memory before query: 9.885 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `ksft0_extensions`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ksft0_extensions`Status Duration Starting 0.02 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.06 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.06 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.29 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 9.913 MB Rows returned: 1
SELECT `extension_id`
FROM `ksft0_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:47 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 9.920 MB Rows returned: 1Duplicate queries: #21
SELECT *
FROM ksft0_extensions
WHERE `extension_id` = '10180'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 9.924 MB Rows returned: 1
SELECT `extension_id`
FROM `ksft0_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.23 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 9.930 MB Rows returned: 1Duplicate queries: #19
SELECT *
FROM ksft0_extensions
WHERE `extension_id` = '10180'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 10.75 ms Query memory: 0.026 MB Memory before query: 10.679 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.04 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.80 ms After last query: 5.47 ms Query memory: 0.021 MB Memory before query: 11.258 MB Rows returned: 1
SELECT `query`
FROM ksft0_eshop_urls
WHERE md5_key = "ee576d3fae3c98d891fbe77291b56d7c"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 155 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 1.35 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.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.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:440 9 EshopRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1170 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 0.12 ms Query memory: 0.020 MB Memory before query: 11.263 MB Rows returned: 0
SELECT *
FROM ksft0_rsfirewall_hashes
WHERE (`type`='3.10.3' OR `type`='protect')
AND `flag`!='C'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_hashes ALL NULL NO INDEX KEY COULD BE USED NULL NULL 84 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:1068 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 0.27 ms Query memory: 0.021 MB Memory before query: 11.296 MB Rows returned: 0
SELECT *
FROM ksft0_rsfirewall_snapshots
WHERE `type`='protect'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_snapshots ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.02 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 9 RSFirewallSnapshot::get() JROOT/plugins/system/rsfirewall/rsfirewall.php:1091 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 11.302 MB Rows returned: 0
SELECT `ip`,`reason`
FROM ksft0_rsfirewall_lists
WHERE (`ip`='3.148.108.201' 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.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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.23 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 11.307 MB Rows returned: 0
SELECT `ip`,`reason`
FROM ksft0_rsfirewall_lists
WHERE (`ip`='3.148.108.201' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_lists ref published,type,ip published 1 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:174 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php: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.23 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 11.313 MB Rows returned: 0
SELECT *
FROM ksft0_rsfirewall_exceptions
WHERE `published`='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rsfirewall_exceptions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.34 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 11.319 MB Rows returned: 6
SELECT id, home, template, s.params
FROM ksft0_template_styles as s
LEFT JOIN ksft0_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 5 Using index condition; Using where 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 8 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/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.29 ms After last query: 8.51 ms Query memory: 0.026 MB Memory before query: 12.504 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 23 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 22 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 20 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 19 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 18 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 17 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 16 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 15 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 14 Joomla\CMS\Factory::getDocument() JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163 13 Gantry\Framework\Theme->init() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67 12 Gantry\Component\Theme\AbstractTheme->__construct() JROOT/templates/rt_isotope/includes/theme.php:28 11 plgSystemGantry5->{closure}() JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118 10 Pimple\Container->offsetGet() JROOT/plugins/system/gantry5/gantry5.php:234 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 8 plgSystemGantry5->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.54 ms After last query: 0.10 ms Query memory: 0.008 MB Memory before query: 12.499 MB
UPDATE `ksft0_extensions`
SET `params` = '{\"mediaversion\":\"f698af8feb67c8a4e4644476907b5547\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `ksft0_extensions` SET `params` = '{\"mediaversion\":\"f698af8feb67c8a4e4644476907b5547\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.04 ms Updating 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.26 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 18 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 17 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 16 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 15 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 14 Joomla\CMS\Factory::getDocument() JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163 13 Gantry\Framework\Theme->init() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67 12 Gantry\Component\Theme\AbstractTheme->__construct() JROOT/templates/rt_isotope/includes/theme.php:28 11 plgSystemGantry5->{closure}() JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118 10 Pimple\Container->offsetGet() JROOT/plugins/system/gantry5/gantry5.php:234 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:57 8 plgSystemGantry5->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 3.67 ms Query memory: 0.023 MB Memory before query: 13.488 MB Rows returned: 4
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM ksft0_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'rt_isotope'
ORDER BY s.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s index idx_template,idx_client_id,idx_client_id_home PRIMARY 4 NULL 8 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/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.28 ms After last query: 1.25 ms Query memory: 0.025 MB Memory before query: 13.698 MB Rows returned: 8
SELECT *
FROM ksft0_rokcandy
WHERE published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_rokcandy ALL NULL NO INDEX KEY COULD BE USED NULL NULL 8 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27 13 RokCandyHelper::getUserMacros() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 10 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17 9 RokCandyHelper::getMacros() JROOT/plugins/system/rokcandy/rokcandy.php:28 8 plgSystemRokCandy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 3.50 ms Query memory: 0.019 MB Memory before query: 14.049 MB Rows returned: 1
SELECT *
FROM ksft0_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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: 1.56 ms After last query: 5.94 ms Query memory: 0.033 MB Memory before query: 15.001 MB Rows returned: 254
SELECT config_key, config_value
FROM ksft0_eshop_configsid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 254 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 1.06 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.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:32 9 EshopHelper::getConfig() JROOT/components/com_eshop/helpers/helper.php:134 8 EshopHelper::getConfigValue() JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php:8 7 require_once JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php JROOT/components/com_eshop/eshop.php:27 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.98 ms After last query: 7.98 ms Query memory: 0.040 MB Memory before query: 15.879 MB Rows returned: 1
SELECT a.*, b.product_name, b.product_alias, b.product_desc, b.product_short_desc, b.product_page_title, b.product_page_heading, b.product_alt_image, b.meta_key, b.meta_desc, b.tab1_title, b.tab1_content, b.tab2_title, b.tab2_content, b.tab3_title, b.tab3_content, b.tab4_title, b.tab4_content, b.tab5_title, b.tab5_content
FROM ksft0_eshop_products AS a
INNER JOIN ksft0_eshop_productdetails AS b
ON (a.id = b.product_id)
WHERE a.id = 48
AND a.published = 1
AND b.language = "en-GB"
AND ((a.product_customergroups = "") OR (a.product_customergroups IS NULL) OR (a.product_customergroups = "1") OR (a.product_customergroups LIKE "1,%") OR (a.product_customergroups LIKE "%,1,%") OR (a.product_customergroups LIKE "%,1"))
AND (a.product_available_date = "0000-00-00 00:00:00" OR a.product_available_date <= '2024-11-23 03:19:34')
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.06 ms checking permissions 0.01 ms Opening tables 1.04 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.08 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.20 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_eshop/models/product.php:114 12 EShopModelProduct->_loadData() JROOT/components/com_eshop/models/product.php:59 11 EShopModelProduct->getData() JROOT/libraries/src/MVC/View/HtmlView.php:425 10 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_eshop/views/product/view.html.php:33 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.70 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 15.904 MB Rows returned: 3Duplicate queries: #64
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.03 ms checking permissions 0.01 ms Opening tables 0.33 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms # Caller File and line number 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.23 ms After last query: 0.54 ms Query memory: 0.022 MB Memory before query: 15.950 MB Rows returned: 8
SELECT a.id, a.category_parent_id, b.category_name
FROM ksft0_eshop_categories AS a
INNER JOIN ksft0_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.published = 1
AND b.language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b ALL category_id NO INDEX KEY COULD BE USED NULL NULL 8 Using where 1 SIMPLE a eq_ref PRIMARY,published PRIMARY 4 benseat_bench.b.category_id 1 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.61 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.02 ms Optimizing 0.02 ms Statistics 0.16 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.52 ms After last query: 0.04 ms Query memory: 0.005 MB Memory before query: 15.956 MB
UPDATE ksft0_eshop_products
SET hits = hits + 1
WHERE id = 48EXPLAIN not possible on query: UPDATE ksft0_eshop_products SET hits = hits + 1 WHERE id = 48Status 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 for update 0.04 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.22 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/helpers/helper.php:582 10 EshopHelper::updateHits() JROOT/components/com_eshop/views/product/view.html.php:115 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 15.967 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 = 48id 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.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/helper.php:2425 10 EshopHelper::getProductInventory() JROOT/components/com_eshop/views/product/view.html.php:191 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.76 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 15.974 MB Rows returned: 1
SELECT stockstatus_name
FROM ksft0_eshop_stockstatusdetails
WHERE stockstatus_id = 2
AND language = "en-GB"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_stockstatusdetails ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.42 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_eshop/helpers/helper.php:604 10 EshopHelper::getStockStatusName() JROOT/components/com_eshop/views/product/view.html.php:201 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.90 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 15.980 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 = 48id 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.03 ms checking permissions 0.01 ms Opening tables 0.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.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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1563 10 EshopHelper::getProductTags() JROOT/components/com_eshop/views/product/view.html.php:215 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.76 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 15.986 MB Rows returned: 0
SELECT *
FROM ksft0_eshop_productattachments
WHERE product_id = 48
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.02 ms checking permissions 0.01 ms Opening tables 0.41 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/views/product/view.html.php:225 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.70 ms After last query: 3.90 ms Query memory: 0.021 MB Memory before query: 16.454 MB Rows returned: 0
SELECT pi.*
FROM ksft0_eshop_productimages AS pi
WHERE product_id = 48
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.02 ms checking permissions 0.01 ms Opening tables 0.33 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1541 10 EshopHelper::getProductImages() JROOT/components/com_eshop/views/product/view.html.php:255 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.68 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 16.460 MB Rows returned: 0
SELECT quantity, price
FROM ksft0_eshop_productdiscounts
WHERE product_id = 48
AND published = 1
AND customergroup_id = 1
AND (date_start <= "2024-11-23 04:19:34" OR date_start = "0000-00-00 00:00:00")
AND (date_end >= "2024-11-23 04:19:34" OR date_end = "0000-00-00 00:00:00")
AND quantity > 1
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_productdiscounts ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.29 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1872 10 EshopHelper::getDiscountPrices() JROOT/components/com_eshop/views/product/view.html.php:310 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.02 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 16.467 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 = 48
AND od.language = 'en-GB'
AND o.published = 1
ORDER BY od.option_name ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE po ref product_id,option_id product_id 5 const 1 Using where; Using temporary; Using filesort 1 SIMPLE o eq_ref PRIMARY PRIMARY 4 benseat_bench.po.option_id 1 Using where 1 SIMPLE od ALL option_id NO INDEX KEY COULD BE USED NULL NULL 4 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.94 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.02 ms Statistics 0.17 ms Preparing 0.16 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.22 ms Creating sort index 0.04 ms Removing tmp table 0.07 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php: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: 1.08 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 16.474 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.04 ms checking permissions 0.01 ms Opening tables 0.59 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.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:814 10 EshopHelper::getAttributeGroups() JROOT/components/com_eshop/views/product/view.html.php:313 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.91 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 16.483 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 = 48
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.05 ms checking permissions 0.01 ms Opening tables 1.10 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.04 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.32 ms Preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 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.39 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 16.490 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 = 48
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.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Creating tmp table 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.01 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:877 10 EshopHelper::getAttributes() JROOT/components/com_eshop/views/product/view.html.php:318 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.27 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 16.495 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 = 48
AND pd.language = 'en-GB'
ORDER BY p.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE pr ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using temporary; Using filesort 1 SIMPLE p eq_ref PRIMARY,published PRIMARY 4 benseat_bench.pr.related_product_id 1 Using where 1 SIMPLE pd ref product_id product_id 5 benseat_bench.pr.related_product_id 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.36 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.04 ms Optimizing 0.02 ms Statistics 0.18 ms Preparing 0.02 ms Creating tmp table 0.06 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.20 ms Creating sort index 0.02 ms Removing tmp table 0.05 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.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: 1.13 ms After last query: 0.42 ms Query memory: 0.021 MB Memory before query: 16.541 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 = 48
AND md.language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.59 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.18 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/helper.php: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: 1.43 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 16.548 MB Rows returned: 7
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 = 23
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 7 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.06 ms checking permissions 0.01 ms Opening tables 0.33 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.19 ms Preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.45 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:4774 10 EshopHelper::getProductsNavigation() JROOT/components/com_eshop/views/product/view.html.php:398 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.98 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 16.554 MB Rows returned: 0
SELECT DISTINCT(label_id)
FROM ksft0_eshop_labelelements
WHERE (element_type = "product"
AND element_id = 48) OR (element_type = "manufacturer"
AND element_id = (SELECT manufacturer_id
FROM ksft0_eshop_products
WHERE id = 48)) OR (element_type = "category"
AND element_id IN (SELECT category_id
FROM ksft0_eshop_productcategories
WHERE product_id = 48))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.05 ms checking permissions 0.01 ms Opening tables 0.30 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Statistics 0.02 ms Executing 0.01 ms Sending data 0.01 ms Preparing 0.02 ms Optimizing 0.01 ms Statistics 0.16 ms Preparing 0.02 ms Creating tmp table 0.02 ms Executing 0.01 ms Sending data 0.02 ms Removing tmp table 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/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.24 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 16.560 MB Rows returned: 1
SELECT product_quantity
FROM ksft0_eshop_products
WHERE id = 48id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_products const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_eshop/helpers/helper.php: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.18 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 16.565 MB Rows returned: 0
SELECT id
FROM ksft0_eshop_labels
WHERE label_out_of_stock_products = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_labels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.85 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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.34 ms After last query: 1.84 ms Query memory: 0.024 MB Memory before query: 16.812 MB Rows returned: 8Duplicate queries: #60
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.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.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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:4814 14 EshopHelper::getCategoryPath() JROOT/components/com_eshop/helpers/route.php:41 13 EshopRoute::getProductRoute() JROOT/components/com_eshop/themes/default/views/product/default.php:89 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 16.821 MB Rows returned: 1
SELECT product_name, product_alias
FROM ksft0_eshop_productdetails
WHERE product_id = 43
AND language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_productdetails ref product_id product_id 5 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 21 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/helper.php:4595 20 EshopHelper::getElementAlias() JROOT/components/com_eshop/router.php:129 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:89 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.95 ms Query memory: 0.026 MB Memory before query: 16.951 MB Rows returned: 1
SELECT id
FROM ksft0_eshop_urls
WHERE md5_key="1c34235716d54edff1f54d0b3efb4301"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 155 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 20 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:396 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:89 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.03 ms Query memory: 0.010 MB Memory before query: 16.961 MB
UPDATE ksft0_eshop_urls
SET query="view=product&id=43&catid=23"
WHERE md5_key="1c34235716d54edff1f54d0b3efb4301"EXPLAIN not possible on query: UPDATE ksft0_eshop_urls SET query="view=product&id=43&catid=23" WHERE md5_key="1c34235716d54edff1f54d0b3efb4301"Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Updating 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:413 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:89 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 16.971 MB Rows returned: 8Duplicate queries: #56
SELECT a.id, a.category_parent_id, b.category_alias
FROM ksft0_eshop_categories AS a
INNER JOIN ksft0_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE b.language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b ALL category_id NO INDEX KEY COULD BE USED NULL NULL 8 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 benseat_bench.b.category_id 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.24 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 16.979 MB Rows returned: 1
SELECT product_name, product_alias
FROM ksft0_eshop_productdetails
WHERE product_id = 60
AND language = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_productdetails ref product_id product_id 5 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 21 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/helper.php:4595 20 EshopHelper::getElementAlias() JROOT/components/com_eshop/router.php:129 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:101 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 16.990 MB Rows returned: 1
SELECT id
FROM ksft0_eshop_urls
WHERE md5_key="8fd9a4c090fca5f08655e7c6eb046948"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 155 Using where Status Duration Starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.24 ms After last query: 0.02 ms Query memory: 0.010 MB Memory before query: 17.000 MB
UPDATE ksft0_eshop_urls
SET query="view=product&id=60&catid=23"
WHERE md5_key="8fd9a4c090fca5f08655e7c6eb046948"EXPLAIN not possible on query: UPDATE ksft0_eshop_urls SET query="view=product&id=60&catid=23" WHERE md5_key="8fd9a4c090fca5f08655e7c6eb046948"Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.01 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:413 19 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/components/com_eshop/themes/default/views/product/default.php:101 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.53 ms Query memory: 0.024 MB Memory before query: 17.051 MB Rows returned: 3Duplicate queries: #37
SELECT *
FROM ksft0_eshop_currencies
WHERE published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_currencies ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where Status Duration Starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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.36 ms After last query: 0.06 ms Query memory: 0.045 MB Memory before query: 17.072 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 = 48id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b ref product_id product_id 5 const 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.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.03 ms Preparing 0.02 ms Unlocking tables 0.01 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/helper.php:1192 14 EshopHelper::getProduct() JROOT/components/com_eshop/helpers/option.php:34 13 EshopOption::renderOption() JROOT/components/com_eshop/themes/default/views/product/default.php:596 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 17.090 MB Rows returned: 1
SELECT id
FROM ksft0_eshop_productoptions
WHERE product_id = 48
AND option_id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksft0_eshop_productoptions ref product_id,option_id product_id 5 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.21 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_eshop/helpers/option.php:42 13 EshopOption::renderOption() JROOT/components/com_eshop/themes/default/views/product/default.php:596 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.81 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 17.099 MB Rows returned: 5
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 = 208
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 5 Using where; Using temporary; Using filesort 1 SIMPLE ov eq_ref PRIMARY PRIMARY 4 benseat_bench.pov.option_value_id 1 Using where 1 SIMPLE ovd ref optionvalue_id optionvalue_id 5 benseat_bench.pov.option_value_id 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.94 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.04 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.18 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.21 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/option.php:99 13 EshopOption::renderOption() JROOT/components/com_eshop/themes/default/views/product/default.php:596 12 include JROOT/components/com_eshop/themes/default/views/product/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:426 9 EShopViewProduct->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_eshop/eshop.php:101 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.31 ms After last query: 27.18 ms Query memory: 0.034 MB Memory before query: 20.967 MB Rows returned: 2
SELECT a.menutype
FROM ksft0_menu_types AS a
WHERE a.client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.88 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 Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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: 3.05 ms After last query: 2.42 ms Query memory: 0.037 MB Memory before query: 21.261 MB Rows returned: 0
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ksft0_modules AS m
LEFT JOIN ksft0_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ksft0_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-22 17:19:34')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-22 17:19:34')
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.07 ms checking permissions 0.01 ms Opening tables 0.61 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.04 ms Optimizing 0.04 ms Statistics 0.19 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 1.74 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 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
59 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT *
FROM ksft0_eshop_currencies2 × SELECT product_name, product_alias
FROM ksft0_eshop_productdetails2 × SELECT ad.attribute_name, pad.value
FROM ksft0_eshop_attributes AS a
INNER JOIN ksft0_eshop_attributedetails AS ad
ON (a.id = ad.attribute_id)
INNER JOIN ksft0_eshop_productattributes AS pa
ON (a.id = pa.attribute_id)
INNER JOIN ksft0_eshop_productattributedetails AS pad
ON (pa.id = pad.productattribute_id)2 × SELECT `ip`,`reason`
FROM ksft0_rsfirewall_lists2 × SELECT `extension_id`
FROM `ksft0_extensions`2 × 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 template
FROM ksft0_template_styles as s2 × SELECT *
FROM ksft0_extensions2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ksft0_extensions`2 × SELECT id
FROM ksft0_eshop_urls1 × SELECT a.menutype
FROM ksft0_menu_types AS a1 × 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 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 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 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 stockstatus_name
FROM ksft0_eshop_stockstatusdetails1 × 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 product_quantity
FROM ksft0_eshop_products1 × SELECT id
FROM ksft0_eshop_labels1 × SELECT id
FROM ksft0_eshop_productoptions1 × SELECT `data`
FROM `ksft0_session`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)1 × SELECT product_manage_stock, product_stock_display, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
FROM ksft0_eshop_products1 × SELECT 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 id, rules
FROM `ksft0_viewlevels1 × SELECT b.id
FROM ksft0_usergroups AS a
LEFT JOIN ksft0_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ksft0_extensions1 × SELECT `path`
FROM ksft0_rsfirewall_ignored1 × SELECT `file`
FROM ksft0_rsfirewall_hashes1 × SELECT *
FROM ksft0_rsfirewall_configuratio1 × SELECT extension, file, type
FROM ksft0_rokcommon_configs1 × SELECT id,template
FROM ksft0_template_styles1 × SELECT *
FROM ksft0_rsform_confi1 × SELECT `query`
FROM ksft0_eshop_urls1 × 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_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 `session_id`
FROM `ksft0_session`1 × 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'6265616633626634306434343838333865336234353462363233376238646333', 1, 1732295974, 0, '', 01 × SHOW FULL COLUMNS
FROM `ksft0_rsfirewall_logs1 × SHOW FULL COLUMNS
FROM `ksft0_extensions1 × UPDATE `ksft0_extensions`
SET `params` = '{\"mediaversion\":\"f698af8feb67c8a4e4644476907b5547\"}'1 × UPDATE ksft0_eshop_products
SET hits = hits + 11 × UPDATE ksft0_eshop_urls
SET query="view=product&id=43&catid=23"1 × UPDATE ksft0_eshop_urls
SET query="view=product&id=60&catid=23"