All items are built to order, and may experience delivery times in upwards of 4 weeks. Please call for accurate delivery times.
Vertical Mounting Bracket for 4150
This mount is designed to hold the tool named in the title. All mounts are thermoplastic welded for ..
Product #: PP-HOL-4150-V
Regular price: $235.00
$235.00
This mount is designed to hold the tool named in the title. All mounts are thermoplastic welded for ..
Product #: PP-HOL-4150-V
Regular price: $235.00
$235.00
Vertical Mounting Bracket for 4150
This mount is designed to hold the tool named in the title. All mounts are thermoplastic welded for strength and durability. You may use any type of fasteners to mount the bracket, just be sure that you are on a clean level surface. There are minor variances in tools, so please verify your tool matches the tool shown. If you are unsure, please call us.
Product Search
Product Information
Shopping Cart
Your shopping cart is empty!
Shop Now Online
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1738677676,
"last": 1738677676,
"now": 1738677676
}
},
"registry": {
"current_theme": "custom",
"current_direction": "ltr",
"current_key_sufix": "_custom_ltr"
},
"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": [
797
],
"continue_shopping_url": "https://pptexas.com/shop-now/holmatro-mounts/holmatro-hydraulic-line-mounts/vertical-mounting-bracket-for-4150"
}
}
Time
Memory
Time: 37.60 ms / 37.60 ms Memory: 0.720 MB / 1.08 MB Application: afterLoad
Time: 1240.10 ms / 1277.70 ms Memory: 2.639 MB / 3.72 MB Application: afterInitialise
Time: 50.69 ms / 1328.39 ms Memory: 0.699 MB / 4.42 MB Application: afterRoute
Time: 0.50 ms / 1328.89 ms Memory: 0.013 MB / 4.44 MB Application: beforeRenderComponent com_eshop
Time: 105.30 ms / 1434.20 ms Memory: 0.908 MB / 5.34 MB Application: afterRenderComponent com_eshop
Time: 0.63 ms / 1434.82 ms Memory: 0.007 MB / 5.35 MB Application: afterDispatch
Time: 51.30 ms / 1486.12 ms Memory: 0.585 MB / 5.94 MB Application: beforeRenderModule mod_custom (Copyright)
Time: 1.63 ms / 1487.75 ms Memory: 0.008 MB / 5.94 MB Application: afterRenderModule mod_custom (Copyright)
Time: 0.06 ms / 1487.81 ms Memory: -0.002 MB / 5.94 MB Application: beforeRenderModule mod_custom (Footer-Social)
Time: 0.14 ms / 1487.95 ms Memory: 0.004 MB / 5.95 MB Application: afterRenderModule mod_custom (Footer-Social)
Time: 0.04 ms / 1487.99 ms Memory: -0.001 MB / 5.95 MB Application: beforeRenderModule mod_custom (Contact Footer)
Time: 0.09 ms / 1488.08 ms Memory: 0.003 MB / 5.95 MB Application: afterRenderModule mod_custom (Contact Footer)
Time: 0.04 ms / 1488.12 ms Memory: 0.001 MB / 5.95 MB Application: beforeRenderModule mod_eshop_advanced_search (Product Search)
Time: 7.19 ms / 1495.31 ms Memory: 0.130 MB / 6.08 MB Application: afterRenderModule mod_eshop_advanced_search (Product Search)
Time: 0.06 ms / 1495.37 ms Memory: -0.048 MB / 6.03 MB Application: beforeRenderModule mod_cinch_menu (Product Information)
Time: 9.95 ms / 1505.33 ms Memory: 0.128 MB / 6.16 MB Application: afterRenderModule mod_cinch_menu (Product Information)
Time: 0.04 ms / 1505.36 ms Memory: 0.006 MB / 6.17 MB Application: beforeRenderModule mod_eshop_cart (Shopping Cart)
Time: 8.50 ms / 1513.87 ms Memory: 0.035 MB / 6.20 MB Application: afterRenderModule mod_eshop_cart (Shopping Cart)
Time: 0.04 ms / 1513.91 ms Memory: -0.001 MB / 6.20 MB Application: beforeRenderModule mod_eshop_category (Shop Now Online)
Time: 12.73 ms / 1526.64 ms Memory: 0.205 MB / 6.40 MB Application: afterRenderModule mod_eshop_category (Shop Now Online)
Time: 0.09 ms / 1526.73 ms Memory: -0.017 MB / 6.39 MB Application: beforeRenderModule mod_custom (Shop Now Disclaimer)
Time: 0.11 ms / 1526.84 ms Memory: 0.003 MB / 6.39 MB Application: afterRenderModule mod_custom (Shop Now Disclaimer)
Time: 0.04 ms / 1526.88 ms Memory: -0.001 MB / 6.39 MB Application: beforeRenderModule mod_custom (Header - My Account only)
Time: 0.07 ms / 1526.95 ms Memory: 0.003 MB / 6.39 MB Application: afterRenderModule mod_custom (Header - My Account only)
Time: 10.71 ms / 1537.66 ms Memory: 0.326 MB / 6.72 MB Application: afterRender
Database queries total: 1066.16 ms
7.55 MB (7,914,456 Bytes)
84 Queries Logged 1066.16 ms
- Query Time: 0.48 ms Query memory: 0.023 MB Memory before query: 1.572 MB Rows returned: 0
SELECT `data`
FROM `ka4p8_session`
WHERE `session_id` = X'3865643038633032376665336435313538633831356563356562353961386133'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_session const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.22 ms After last query: 2.49 ms Query memory: 0.020 MB Memory before query: 1.650 MB Rows returned: 0
SELECT `session_id`
FROM `ka4p8_session`
WHERE `session_id` = X'3865643038633032376665336435313538633831356563356562353961386133'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_session const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 666.69 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.655 MB
INSERT INTO `ka4p8_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3865643038633032376665336435313538633831356563356562353961386133', 1, 1738677676, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `ka4p8_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3865643038633032376665336435313538633831356563356562353961386133', 1, 1738677676, 0, '', 0)Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms update 0.07 ms end 0.00 ms query end 666.45 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 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:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.97 ms After last query: 5.01 ms Query memory: 0.040 MB Memory before query: 1.691 MB Rows returned: 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ka4p8_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_extensions ref extension extension 82 const 46 100.00 Using index condition; Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.28 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.31 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 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.59 ms After last query: 4.89 ms Query memory: 0.021 MB Memory before query: 1.800 MB Rows returned: 5
SELECT id, rules
FROM `ka4p8_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.25 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 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.43 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.812 MB Rows returned: 2
SELECT b.id
FROM ka4p8_usergroups AS a
LEFT JOIN ka4p8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 100.00 Using where; Using index Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.15 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.20 ms After last query: 1.76 ms Query memory: 0.030 MB Memory before query: 1.835 MB Rows returned: 102
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ka4p8_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_extensions ref extension extension 82 const 159 100.00 Using index condition; Using where; Using filesort Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.88 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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.58 ms After last query: 28.26 ms Query memory: 0.022 MB Memory before query: 2.391 MB Rows returned: 1
SELECT `value`
FROM `ka4p8_admintools_storage`
WHERE `key` = 'cparams'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_admintools_storage const PRIMARY PRIMARY 402 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.24 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:122 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:37 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:49 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:409 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:892 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__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:667 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.45 ms After last query: 3.86 ms Query memory: 0.021 MB Memory before query: 2.479 MB Rows returned: 0
SELECT *
FROM `ka4p8_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_admintools_wafexceptions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.18 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:729 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:640 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:901 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__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:667 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.42 ms After last query: 70.22 ms Query memory: 0.021 MB Memory before query: 3.207 MB Rows returned: 0
SELECT *
FROM `ka4p8_admintools_ipautoban`
WHERE `ip` = '3.143.243.70'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/plugins/system/admintools/feature/autoipfiltering.php:74 11 AtsystemFeatureAutoipfiltering->isIPBlocked() JROOT/plugins/system/admintools/feature/autoipfiltering.php:23 10 AtsystemFeatureAutoipfiltering->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:308 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:144 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.19 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 3.213 MB Rows returned: 1
SELECT *
FROM `ka4p8_admintools_storage`
WHERE `key` LIKE 'timestamp_%'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_admintools_storage range PRIMARY PRIMARY 402 NULL 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/feature/abstract.php:277 12 AtsystemFeatureAbstract->loadTimestamps() JROOT/plugins/system/admintools/feature/abstract.php:356 11 AtsystemFeatureAbstract->getTimestamp() JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:115 10 AtsystemFeatureDisableobsoleteadmins->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:308 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:144 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 16.99 ms Query memory: 0.021 MB Memory before query: 3.226 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `ka4p8_admintools_redirects`
WHERE ((`dest` = 'shop-now/holmatro-mounts/holmatro-hydraulic-line-mounts/vertical-mounting-bracket-for-4150') OR (`dest` = 'shop-now/holmatro-mounts/holmatro-hydraulic-line-mounts/vertical-mounting-bracket-for-4150') OR ('shop-now/holmatro-mounts/holmatro-hydraulic-line-mounts/vertical-mounting-bracket-for-4150' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_admintools_redirects ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:91 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:308 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:144 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.48 ms After last query: 0.79 ms Query memory: 0.024 MB Memory before query: 3.250 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ka4p8_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.10 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.06 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/k2/k2.php:47 8 plgSystemK2->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 362.54 ms After last query: 0.25 ms Query memory: 0.006 MB Memory before query: 3.242 MB
UPDATE `ka4p8_extensions`
SET `params` = '{\"mediaversion\":\"0005b4e2f803ac4d0b3fd8ca869f7ec5\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_extensions range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.07 ms updating 0.07 ms end 0.01 ms query end 362.19 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/k2/k2.php:47 8 plgSystemK2->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 30.60 ms Query memory: 0.023 MB Memory before query: 3.712 MB Rows returned: 34
SELECT *
FROM ka4p8_rsform_configid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_rsform_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 34 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 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:28 8 plgSystemRsformdeletesubmissions->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.14 ms After last query: 8.21 ms Query memory: 0.076 MB Memory before query: 3.760 MB Rows returned: 65
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 ka4p8_menu AS m
LEFT JOIN ka4p8_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 100 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 pptexas_db2019.m.component_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.23 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.56 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 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:417 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:533 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:1141 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.69 ms After last query: 20.86 ms Query memory: 0.021 MB Memory before query: 4.189 MB Rows returned: 1
SELECT `query`
FROM ka4p8_eshop_urls
WHERE md5_key = "f8161cbc13a2dcd347e07fc0edfae240"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1307 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.31 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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:415 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:1142 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.49 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 4.198 MB Rows returned: 1
SELECT *
FROM `ka4p8_admintools_wafblacklists`
WHERE `verb` IN('','GET')
AND `option` IN('','com_eshop')
AND `view` IN('','product')
AND `task` IN('','product.')
AND `enabled` = '1'
GROUP BY `query`
ORDER BY `query` ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_admintools_wafblacklists ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 100.00 Using where; Using temporary; Using filesort Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms Creating tmp table 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.05 ms Creating sort index 0.02 ms end 0.00 ms removing tmp table 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/admintools/feature/wafblacklist.php:92 10 AtsystemFeatureWafblacklist->onAfterRoute() JROOT/plugins/system/admintools/admintools/main.php:308 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:154 8 plgSystemAdmintools->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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.56 ms After last query: 4.93 ms Query memory: 0.022 MB Memory before query: 4.245 MB Rows returned: 1
SELECT *
FROM ka4p8_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.21 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 12 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 11 Joomla\CMS\Application\SiteApplication->getParams() JROOT/components/com_k2/helpers/utilities.php:243 10 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:235 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:438 8 plgSystemK2->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:1190 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.71 ms After last query: 6.59 ms Query memory: 0.025 MB Memory before query: 4.329 MB Rows returned: 4
SELECT id, home, template, s.params
FROM ka4p8_template_styles as s
LEFT JOIN ka4p8_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 6 66.67 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 pptexas_db2019.s.template,const 1 100.00 Using index condition; Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.19 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.00 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/jquery.php:52 13 JHtmlJquery::framework() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 11 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 10 Joomla\CMS\HTML\HTMLHelper::_() JROOT/administrator/components/com_k2/helpers/html.php:259 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:438 8 plgSystemK2->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:1190 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.51 ms After last query: 52.75 ms Query memory: 0.057 MB Memory before query: 4.603 MB Rows returned: 276
SELECT config_key, config_value
FROM ka4p8_eshop_configsid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 276 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.00 ms Sending data 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:67 10 EShopHelper::getConfig() JROOT/components/com_eshop/helpers/helper.php:192 9 EShopHelper::getConfigValue() JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php:21 8 require_once JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php JROOT/administrator/components/com_eshop/libraries/bootstrap.php:16 7 require_once JROOT/administrator/components/com_eshop/libraries/bootstrap.php JROOT/components/com_eshop/eshop.php:26 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.83 ms After last query: 12.64 ms Query memory: 0.040 MB Memory before query: 4.765 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.product_canoncial_link, 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 ka4p8_eshop_products AS a
INNER JOIN ka4p8_eshop_productdetails AS b
ON (a.id = b.product_id)
WHERE a.id = 797
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 IS NULL OR a.product_available_date <= '2025-02-04 14:01:18')
AND (a.product_end_date = '0000-00-00 00:00:00' OR a.product_end_date IS NULL OR a.product_end_date >= '2025-02-04 14:01:18')
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 filtered Extra 1 SIMPLE a const PRIMARY,published PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b ref product_id,idx_language product_id 5 const 1 100.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 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:119 12 EShopModelProduct->_loadData() JROOT/components/com_eshop/models/product.php:67 11 EShopModelProduct->getData() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423 10 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_eshop/views/product/view.html.php:185 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:108 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.66 ms Query memory: 0.022 MB Memory before query: 4.843 MB Rows returned: 3
SELECT *
FROM ka4p8_eshop_currencies
WHERE published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_currencies ref idx_published idx_published 2 const 2 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/currency.php:76 11 EShopCurrency->__construct() JROOT/components/com_eshop/helpers/currency.php:44 10 EShopCurrency::getInstance() JROOT/components/com_eshop/views/product/view.html.php:186 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:108 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.66 ms After last query: 1.18 ms Query memory: 0.024 MB Memory before query: 4.857 MB Rows returned: 21
SELECT a.id, a.category_parent_id, b.category_name, b.category_alias
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.published = 1
AND b.language = 'en-GB'
AND ((category_customergroups = "") OR (category_customergroups IS NULL) OR (category_customergroups = "1") OR (category_customergroups LIKE "1,%") OR (category_customergroups LIKE "%,1,%") OR (category_customergroups LIKE "%,1"))id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b ref category_id,idx_language idx_language 22 const 25 100.00 Using index condition; Using where 1 SIMPLE a eq_ref PRIMARY,published PRIMARY 4 pptexas_db2019.b.category_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.16 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.22 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1167 11 EShopHelper::getAllCategories() JROOT/components/com_eshop/helpers/helper.php:5862 10 EShopHelper::getCategoriesBreadcrumb() JROOT/components/com_eshop/views/product/view.html.php:260 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:108 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.19 ms After last query: 0.78 ms Query memory: 0.005 MB Memory before query: 4.879 MB
UPDATE ka4p8_eshop_products
SET hits = hits + 1
WHERE id = 797id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_products range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.02 ms updating 0.05 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/helpers/helper.php:679 10 EShopHelper::updateHits() JROOT/components/com_eshop/views/product/view.html.php:274 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:108 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.18 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 4.885 MB Rows returned: 1
SELECT product_manage_stock, product_stock_display, product_show_availability, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
FROM ka4p8_eshop_products
WHERE id = 797id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_products const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:2822 10 EShopHelper::getProductInventory() JROOT/components/com_eshop/views/product/view.html.php:387 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:108 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 1.07 ms Query memory: 0.022 MB Memory before query: 4.893 MB Rows returned: 0
SELECT a.*
FROM ka4p8_eshop_tags AS a
INNER JOIN ka4p8_eshop_producttags AS b
ON (a.id = b.tag_id)
WHERE a.published = 1
AND b.product_id = 797id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.16 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:1928 10 EShopHelper::getProductTags() JROOT/components/com_eshop/views/product/view.html.php:414 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:108 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.07 ms Query memory: 0.021 MB Memory before query: 4.898 MB Rows returned: 0
SELECT *
FROM ka4p8_eshop_productattachments
WHERE product_id = 797
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:424 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:108 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.49 ms After last query: 9.78 ms Query memory: 0.021 MB Memory before query: 4.931 MB Rows returned: 0
SELECT pi.*
FROM ka4p8_eshop_productimages AS pi
WHERE product_id = 797
AND published = 1
ORDER BY pi.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pi ref idx_product_id,idx_published idx_product_id 5 const 1 100.00 Using where; Using filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.02 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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:1906 10 EShopHelper::getProductImages() JROOT/components/com_eshop/views/product/view.html.php:457 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:108 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.11 ms Query memory: 0.021 MB Memory before query: 4.937 MB Rows returned: 0
SELECT quantity, price
FROM ka4p8_eshop_productdiscounts
WHERE product_id = 797
AND published = 1
AND customergroup_id = 1
AND (date_start = '0000-00-00 00:00:00' OR date_start IS NULL OR date_start <= '2025-02-04 14:01:18')
AND (date_end = '0000-00-00 00:00:00' OR date_end IS NULL OR date_end >= '2025-02-04 14:01:18')
AND quantity > 1
ORDER BY priorityid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms executing 0.01 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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:2228 10 EShopHelper::getDiscountPrices() JROOT/components/com_eshop/views/product/view.html.php:548 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:108 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.944 MB Rows returned: 0
SELECT o.id, o.option_type, o.option_image, od.option_name, od.option_desc, po.required, po.id AS product_option_id
FROM ka4p8_eshop_options AS o
INNER JOIN ka4p8_eshop_optiondetails AS od
ON (o.id = od.option_id)
INNER JOIN ka4p8_eshop_productoptions AS po
ON (o.id = po.option_id)
WHERE po.product_id = 797
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 filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.23 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 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:1699 10 EShopHelper::getProductOptions() JROOT/components/com_eshop/views/product/view.html.php:549 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:108 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 4.950 MB Rows returned: 0Duplicate queries: #54
SELECT a.id, b.attributegroup_name
FROM ka4p8_eshop_attributegroups AS a
INNER JOIN ka4p8_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 filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 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:892 10 EShopHelper::getAttributeGroups() JROOT/components/com_eshop/views/product/view.html.php:551 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:108 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 4.963 MB Rows returned: 0
SELECT p.*, pd.product_name, pd.product_alias, pd.product_desc, pd.product_short_desc, pd.product_page_title, pd.product_page_heading, pd.product_alt_image, pd.meta_key, pd.meta_desc
FROM ka4p8_eshop_products AS p
INNER JOIN ka4p8_eshop_productdetails AS pd
ON (p.id = pd.product_id)
INNER JOIN ka4p8_eshop_productrelations AS pr
ON (p.id = pr.related_product_id)
WHERE p.published = 1
AND pr.product_id = 797
AND pd.language = 'en-GB'
ORDER BY p.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.10 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms executing 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 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:1496 10 EShopHelper::getProductRelations() JROOT/components/com_eshop/views/product/view.html.php:563 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:108 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.41 ms After last query: 1.68 ms Query memory: 0.021 MB Memory before query: 5.034 MB Rows returned: 0
SELECT m.id, m.manufacturer_image, m.manufacturer_email, md.manufacturer_name
FROM ka4p8_eshop_products AS p
INNER JOIN ka4p8_eshop_manufacturers AS m
ON (p.manufacturer_id = m.id)
INNER JOIN ka4p8_eshop_manufacturerdetails AS md
ON (m.id = md.manufacturer_id)
WHERE p.id = 797
AND md.language = 'en-GB'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.17 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 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:1464 10 EShopHelper::getProductManufacturer() JROOT/components/com_eshop/views/product/view.html.php:680 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:108 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.49 ms After last query: 3.47 ms Query memory: 0.026 MB Memory before query: 5.048 MB Rows returned: 47
SELECT a.id, b.product_id, b.product_name, b.product_page_title, pc.category_id
FROM ka4p8_eshop_products AS a
INNER JOIN ka4p8_eshop_productdetails AS b
ON (a.id = b.product_id)
INNER JOIN ka4p8_eshop_productcategories AS pc
ON (a.id = pc.product_id)
WHERE a.published = 1
AND pc.category_id = 6
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 IS NULL OR a.product_available_date <= '2025-02-04 14:01:18')
AND (a.product_end_date = '0000-00-00 00:00:00' OR a.product_end_date IS NULL OR a.product_end_date >= '2025-02-04 14:01:18')
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"))
ORDER BY a.ordering ASC,a.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pc ref product_id,category_id category_id 5 const 38 100.00 Using where; Using temporary; Using filesort 1 SIMPLE a eq_ref PRIMARY,published PRIMARY 4 pptexas_db2019.pc.product_id 1 100.00 Using where 1 SIMPLE b ref product_id,idx_language product_id 5 pptexas_db2019.pc.product_id 1 100.00 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.14 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.80 ms Creating sort index 0.05 ms end 0.00 ms removing tmp table 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 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:5799 10 EShopHelper::getProductsNavigation() JROOT/components/com_eshop/views/product/view.html.php:713 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:108 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.32 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 5.053 MB Rows returned: 0
SELECT DISTINCT(label_id)
FROM ka4p8_eshop_labelelements
WHERE (element_type = "product"
AND element_id = 797) OR (element_type = "manufacturer"
AND element_id = (SELECT manufacturer_id
FROM ka4p8_eshop_products
WHERE id = 797)) OR (element_type = "category"
AND element_id IN (SELECT category_id
FROM ka4p8_eshop_productcategories
WHERE product_id = 797))id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables 3 DEPENDENT SUBQUERY ka4p8_eshop_productcategories ref product_id,category_id product_id 5 const 1 100.00 Using where 2 SUBQUERY ka4p8_eshop_products const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.12 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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:6075 10 EShopHelper::getProductLabels() JROOT/components/com_eshop/views/product/view.html.php:714 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:108 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 5.059 MB Rows returned: 1
SELECT product_quantity
FROM ka4p8_eshop_products
WHERE id = 797id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_products const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 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:6083 10 EShopHelper::getProductLabels() JROOT/components/com_eshop/views/product/view.html.php:714 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:108 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 7.09 ms Query memory: 0.026 MB Memory before query: 5.096 MB Rows returned: 1
SELECT product_name, product_alias
FROM ka4p8_eshop_productdetails
WHERE product_id = 781
AND language = 'en-GB'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_productdetails ref product_id,idx_language product_id 5 const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 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:5604 20 EShopHelper::getElementAlias() JROOT/components/com_eshop/router.php:160 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/custom/views/product/default.php:177 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 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: 2.33 ms Query memory: 0.026 MB Memory before query: 5.171 MB Rows returned: 1
SELECT id
FROM ka4p8_eshop_urls
WHERE md5_key="85922e73a7718b7a9dfdb3f97a310de1"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1307 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.31 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:368 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/custom/views/product/default.php:177 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 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.15 ms After last query: 0.08 ms Query memory: 0.010 MB Memory before query: 5.181 MB
UPDATE ka4p8_eshop_urls
SET query="view=product&id=781&catid=6"
WHERE id = 1475id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.03 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:386 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/custom/views/product/default.php:177 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 0.24 ms Query memory: 0.026 MB Memory before query: 5.191 MB Rows returned: 1
SELECT product_name, product_alias
FROM ka4p8_eshop_productdetails
WHERE product_id = 804
AND language = 'en-GB'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_productdetails ref product_id,idx_language product_id 5 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:5604 20 EShopHelper::getElementAlias() JROOT/components/com_eshop/router.php:160 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/custom/views/product/default.php:201 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 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.13 ms Query memory: 0.026 MB Memory before query: 5.203 MB Rows returned: 1
SELECT id
FROM ka4p8_eshop_urls
WHERE md5_key="f2d3ff3d465fe9efd1da2af0bbf19da1"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1307 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.30 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 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:368 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/custom/views/product/default.php:201 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 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.14 ms After last query: 0.06 ms Query memory: 0.010 MB Memory before query: 5.213 MB
UPDATE ka4p8_eshop_urls
SET query="view=product&id=804&catid=6"
WHERE id = 1495id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:386 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/custom/views/product/default.php:201 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 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.32 ms After last query: 0.22 ms Query memory: 0.023 MB Memory before query: 5.222 MB Rows returned: 0
SELECT price
FROM ka4p8_eshop_productspecials
WHERE product_id = 797
AND published = 1
AND customergroup_id = 1
AND (date_start = '0000-00-00 00:00:00' OR date_start IS NULL OR date_start <= '2025-02-04 14:01:18')
AND (date_end = '0000-00-00 00:00:00' OR date_end IS NULL OR date_end >= '2025-02-04 14:01:18')
ORDER BY priority
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.02 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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:2271 14 EShopHelper::getSpecialPrice() JROOT/components/com_eshop/helpers/helper.php:2468 13 EShopHelper::getProductPriceArray() JROOT/components/com_eshop/themes/custom/views/product/default.php:947 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 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.09 ms Query memory: 0.023 MB Memory before query: 5.231 MB Rows returned: 0
SELECT a.*
FROM ka4p8_eshop_discounts AS a
INNER JOIN ka4p8_eshop_discountelements AS b
ON (a.id = b.discount_id)
WHERE a.published = 1
AND b.element_type = "product"
AND (b.element_id = 797 OR b.element_id = 0)
AND ((a.discount_customergroups = "") OR (a.discount_customergroups IS NULL) OR (a.discount_customergroups = "1") OR (a.discount_customergroups LIKE "1,%") OR (a.discount_customergroups LIKE "%,1,%") OR (a.discount_customergroups LIKE "%,1"))
AND (a.discount_start_date = '0000-00-00 00:00:00' OR a.discount_start_date IS NULL OR a.discount_start_date <= '2025-02-04 14:01:18')
AND (a.discount_end_date = '0000-00-00 00:00:00' OR a.discount_end_date IS NULL OR a.discount_end_date >= '2025-02-04 14:01:18')
ORDER BY a.id DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.19 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 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:2307 14 EShopHelper::getSpecialPrice() JROOT/components/com_eshop/helpers/helper.php:2468 13 EShopHelper::getProductPriceArray() JROOT/components/com_eshop/themes/custom/views/product/default.php:947 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 5.240 MB Rows returned: 0
SELECT a.*
FROM ka4p8_eshop_discounts AS a
INNER JOIN ka4p8_eshop_discountelements AS b
ON (a.id = b.discount_id)
WHERE a.published = 1
AND ((b.element_type = "manufacturer"
AND (b.element_id = (SELECT manufacturer_id
FROM ka4p8_eshop_products
WHERE id = 797) OR b.element_id = 0)) OR (b.element_type = "category"
AND (b.element_id IN (SELECT category_id
FROM ka4p8_eshop_productcategories
WHERE product_id = 797) OR b.element_id = 0)))
AND ((a.discount_customergroups = "") OR (a.discount_customergroups IS NULL) OR (a.discount_customergroups = "1") OR (a.discount_customergroups LIKE "1,%") OR (a.discount_customergroups LIKE "%,1,%") OR (a.discount_customergroups LIKE "%,1"))
AND (a.discount_start_date = '0000-00-00 00:00:00' OR a.discount_start_date IS NULL OR a.discount_start_date <= '2025-02-04 14:01:18')
AND (a.discount_end_date = '0000-00-00 00:00:00' OR a.discount_end_date IS NULL OR a.discount_end_date >= '2025-02-04 14:01:18')
ORDER BY a.id DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables 3 DEPENDENT SUBQUERY ka4p8_eshop_productcategories ref product_id,category_id product_id 5 const 1 100.00 Using where 2 SUBQUERY ka4p8_eshop_products const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 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:2333 14 EShopHelper::getSpecialPrice() JROOT/components/com_eshop/helpers/helper.php:2468 13 EShopHelper::getProductPriceArray() JROOT/components/com_eshop/themes/custom/views/product/default.php:947 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 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.17 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 5.246 MB Rows returned: 0
SELECT price
FROM ka4p8_eshop_productdiscounts
WHERE product_id = 797
AND published = 1
AND customergroup_id = 1
AND (date_start = '0000-00-00 00:00:00' OR date_start IS NULL OR date_start <= '2025-02-04 14:01:18')
AND (date_end = '0000-00-00 00:00:00' OR date_end IS NULL OR date_end >= '2025-02-04 14:01:18')
AND quantity = 1
ORDER BY priorityid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/components/com_eshop/helpers/helper.php:2189 14 EShopHelper::getDiscountPrice() JROOT/components/com_eshop/helpers/helper.php:2469 13 EShopHelper::getProductPriceArray() JROOT/components/com_eshop/themes/custom/views/product/default.php:947 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 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.29 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 5.255 MB Rows returned: 1
SELECT COUNT(*)
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_productcategories AS b
ON (a.id = b.category_id)
WHERE b.product_id = 797
AND b.main_category = 1
AND ((a.category_cart_mode_customergroups = "") OR (a.category_cart_mode_customergroups IS NULL) OR (a.category_cart_mode_customergroups = "1") OR (a.category_cart_mode_customergroups LIKE "1,%") OR (a.category_cart_mode_customergroups LIKE "%,1,%") OR (a.category_cart_mode_customergroups LIKE "%,1"))id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b ref product_id,category_id,idx_main_category product_id 5 const 1 100.00 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 pptexas_db2019.b.category_id 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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/helper.php:6727 13 EShopHelper::isCartMode() JROOT/components/com_eshop/themes/custom/views/product/default.php:1209 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 5.263 MB Rows returned: 1
SELECT COUNT(*)
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_productcategories AS b
ON (a.id = b.category_id)
WHERE b.product_id = 797
AND b.main_category = 1
AND ((a.category_cart_mode_customergroups = "") OR (a.category_cart_mode_customergroups IS NULL) OR (a.category_cart_mode_customergroups = "1") OR (a.category_cart_mode_customergroups LIKE "1,%") OR (a.category_cart_mode_customergroups LIKE "%,1,%") OR (a.category_cart_mode_customergroups LIKE "%,1"))id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b ref product_id,category_id,idx_main_category product_id 5 const 1 100.00 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 pptexas_db2019.b.category_id 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 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/helper.php:6727 13 EShopHelper::isCartMode() JROOT/components/com_eshop/themes/custom/views/product/default.php:1249 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 6 require_once JROOT/components/com_eshop/eshop.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 7.65 ms Query memory: 0.023 MB Memory before query: 5.356 MB Rows returned: 1
SELECT COUNT(*)
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_productcategories AS b
ON (a.id = b.category_id)
WHERE b.product_id = 797
AND b.main_category = 1
AND ((a.category_cart_mode_customergroups = "") OR (a.category_cart_mode_customergroups IS NULL) OR (a.category_cart_mode_customergroups = "1") OR (a.category_cart_mode_customergroups LIKE "1,%") OR (a.category_cart_mode_customergroups LIKE "%,1,%") OR (a.category_cart_mode_customergroups LIKE "%,1"))id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b ref product_id,category_id,idx_main_category product_id 5 const 1 100.00 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 pptexas_db2019.b.category_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_eshop/helpers/helper.php:6727 13 EShopHelper::isCartMode() JROOT/components/com_eshop/themes/custom/views/product/default.php:2377 12 include JROOT/components/com_eshop/themes/custom/views/product/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/administrator/components/com_eshop/libraries/mvc/view.php:92 10 EShopView->display() JROOT/components/com_eshop/views/product/view.html.php:739 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:108 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.09 ms After last query: 47.70 ms Query memory: 0.027 MB Memory before query: 5.937 MB Rows returned: 9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ka4p8_modules AS m
LEFT JOIN ka4p8_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ka4p8_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-02-04 14:01:18')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-02-04 14:01:18')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 399 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 21 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 pptexas_db2019.m.module,const 1 100.00 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 pptexas_db2019.m.id 3 100.00 Using where; Using index Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.29 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.04 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.34 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() Same as call in the line below. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 16 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 15 Joomla\CMS\Helper\ModuleHelper::load() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 14 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 13 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/t3/includes/core/template.php:633 12 T3Template->countModules() JROOT/templates/t3_bs3_blank/local/tpls/blocks/header.php:22 11 include JROOT/templates/t3_bs3_blank/local/tpls/blocks/header.php JROOT/plugins/system/t3/includes/core/template.php:195 10 T3Template->loadBlock() JROOT/templates/t3_bs3_blank/local/tpls/default.php:32 9 include JROOT/templates/t3_bs3_blank/local/tpls/default.php JROOT/plugins/system/t3/includes/core/template.php:221 8 T3Template->loadLayout() JROOT/templates/t3_bs3_blank/index.php:34 7 require JROOT/templates/t3_bs3_blank/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.95 ms After last query: 6.82 ms Query memory: 0.030 MB Memory before query: 5.981 MB Rows returned: 21
SELECT a.*, a.category_parent_id AS parent_id, b.category_name AS title
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.published = 1
AND b.language = "en-GB"
AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
ORDER BY b.category_name ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b ref category_id,idx_language idx_language 22 const 25 100.00 Using index condition; Using where; Using filesort 1 SIMPLE a eq_ref PRIMARY,published PRIMARY 4 pptexas_db2019.b.category_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.49 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_eshop_advanced_search/helper.php:109 11 modEShopAdvancedSearchHelper::getCategories() JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php:24 10 include JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 6.028 MB Rows returned: 1
SELECT a.id, b.manufacturer_id, b.manufacturer_name
FROM ka4p8_eshop_manufacturers AS a
INNER JOIN ka4p8_eshop_manufacturerdetails AS b
ON (a.id = b.manufacturer_id)
WHERE a.published = 1
AND language = 'en-GB'
AND ((a.manufacturer_customergroups = "") OR (a.manufacturer_customergroups IS NULL) OR (a.manufacturer_customergroups = "1") OR (a.manufacturer_customergroups LIKE "1,%") OR (a.manufacturer_customergroups LIKE "%,1,%") OR (a.manufacturer_customergroups LIKE "%,1"))
ORDER BY b.manufacturer_name ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a system PRIMARY,idx_published NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL 1 SIMPLE b system manufacturer_id,idx_language NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_eshop_advanced_search/helper.php:181 11 modEShopAdvancedSearchHelper::getManufacturers() JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php:25 10 include JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.15 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 6.035 MB Rows returned: 0Duplicate queries: #32
SELECT a.id, b.attributegroup_name
FROM ka4p8_eshop_attributegroups AS a
INNER JOIN ka4p8_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 filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:892 12 EShopHelper::getAttributeGroups() JROOT/modules/mod_eshop_advanced_search/helper.php:189 11 modEShopAdvancedSearchHelper::getAttributeGroups() JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php:26 10 include JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.13 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 6.042 MB Rows returned: 0
SELECT o.id, od.option_name
FROM ka4p8_eshop_options AS o
INNER JOIN ka4p8_eshop_optiondetails AS od
ON o.id = od.option_id
WHERE o.published = 1
AND od.language = "en-GB"
ORDER BY od.option_name ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_eshop_advanced_search/helper.php:297 11 modEShopAdvancedSearchHelper::getOptions() JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php:27 10 include JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.12 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 6.047 MB Rows returned: 1
SELECT left_symbol, right_symbol
FROM ka4p8_eshop_currencies
WHERE currency_code = 'USD'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_currencies ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 100.00 Using where Status Duration starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php:39 10 include JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.37 ms After last query: 0.46 ms Query memory: 0.023 MB Memory before query: 6.056 MB Rows returned: 4
SELECT a.*, b.weight_name, b.weight_unit
FROM ka4p8_eshop_weights AS a
INNER JOIN ka4p8_eshop_weightdetails AS b
ON (a.id = b.weight_id)
WHERE a.published = 1
AND b.language = "en-GB"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 100.00 Using where 1 SIMPLE a ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 4 75.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.15 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/weight.php:54 12 EShopWeight->__construct() JROOT/components/com_eshop/helpers/weight.php:35 11 EShopWeight::getInstance() JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php:43 10 include JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.44 ms Query memory: 0.023 MB Memory before query: 6.066 MB Rows returned: 3
SELECT a.*, b.length_name, b.length_unit
FROM ka4p8_eshop_lengths AS a
INNER JOIN ka4p8_eshop_lengthdetails AS b
ON (a.id = b.length_id)
WHERE a.published = 1
AND b.language = "en-GB"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 100.00 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 pptexas_db2019.b.length_id 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.13 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/length.php:54 12 EShopLength->__construct() JROOT/components/com_eshop/helpers/length.php:35 11 EShopLength::getInstance() JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php:48 10 include JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.45 ms After last query: 1.21 ms Query memory: 0.025 MB Memory before query: 6.080 MB Rows returned: 1
SELECT id
FROM ka4p8_eshop_urls
WHERE md5_key="06a943c59f33a34bb5924aaf72cd2995"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1307 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.31 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:368 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_advanced_search/tmpl/default.php:15 11 require JROOT/modules/mod_eshop_advanced_search/tmpl/default.php JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php:149 10 include JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.13 ms After last query: 0.05 ms Query memory: 0.009 MB Memory before query: 6.089 MB
UPDATE ka4p8_eshop_urls
SET query="task=search"
WHERE id = 359id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.03 ms updating 0.02 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:386 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_advanced_search/tmpl/default.php:15 11 require JROOT/modules/mod_eshop_advanced_search/tmpl/default.php JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php:149 10 include JROOT/modules/mod_eshop_advanced_search/mod_eshop_advanced_search.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.51 ms After last query: 16.63 ms Query memory: 0.023 MB Memory before query: 6.200 MB Rows returned: 0
SELECT *
FROM ka4p8_eshop_coupons
WHERE coupon_code = ''
AND (coupon_start_date = '0000-00-00 00:00:00' OR coupon_start_date IS NULL OR coupon_start_date <= '2025-02-04 14:01:18')
AND (coupon_end_date = '0000-00-00 00:00:00' OR coupon_end_date IS NULL OR coupon_end_date >= '2025-02-04 14:01:18')
AND published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_coupons ref idx_published idx_published 2 const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/coupon.php:181 14 EShopCoupon->getCouponData() JROOT/components/com_eshop/helpers/coupon.php:33 13 EShopCoupon->getCosts() JROOT/components/com_eshop/models/cart.php:139 12 EShopModelCart->getCouponCosts() JROOT/components/com_eshop/models/cart.php:83 11 EShopModelCart->getCosts() JROOT/modules/mod_eshop_cart/mod_eshop_cart.php:75 10 include JROOT/modules/mod_eshop_cart/mod_eshop_cart.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.63 ms Query memory: 0.023 MB Memory before query: 6.207 MB Rows returned: 0
SELECT *
FROM ka4p8_eshop_vouchers
WHERE voucher_code = ''
AND (voucher_start_date = '0000-00-00 00:00:00' OR voucher_start_date IS NULL OR voucher_start_date <= '2025-02-04 14:01:18')
AND (voucher_end_date = '0000-00-00 00:00:00' OR voucher_end_date IS NULL OR voucher_end_date >= '2025-02-04 14:01:18')
AND published = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_eshop/helpers/voucher.php:77 14 EShopVoucher->getVoucherData() JROOT/components/com_eshop/helpers/voucher.php:31 13 EShopVoucher->getCosts() JROOT/components/com_eshop/models/cart.php:153 12 EShopModelCart->getVoucherCosts() JROOT/components/com_eshop/models/cart.php:85 11 EShopModelCart->getCosts() JROOT/modules/mod_eshop_cart/mod_eshop_cart.php:75 10 include JROOT/modules/mod_eshop_cart/mod_eshop_cart.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.68 ms After last query: 1.67 ms Query memory: 0.023 MB Memory before query: 6.225 MB Rows returned: 6
SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.category_parent_id = 0
AND a.published = 1
AND b.language = 'en-GB'
AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
ORDER BY b.category_name ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b ref category_id,idx_language idx_language 22 const 25 100.00 Using index condition; Using where; Using filesort 1 SIMPLE a eq_ref PRIMARY,category_parent_id,published PRIMARY 4 pptexas_db2019.b.category_id 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.04 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.33 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1130 12 EShopHelper::getCategories() JROOT/modules/mod_eshop_category/helper.php:27 11 modEShopCategoryHelper::getCategories() JROOT/modules/mod_eshop_category/mod_eshop_category.php:24 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.86 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 6.235 MB Rows returned: 2
SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.category_parent_id = 27
AND a.published = 1
AND b.language = 'en-GB'
AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
ORDER BY b.category_name ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref PRIMARY,category_parent_id,published category_parent_id 5 const 2 100.00 Using where; Using temporary; Using filesort 1 SIMPLE b ref category_id,idx_language category_id 5 pptexas_db2019.a.id 4 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.22 ms Creating sort index 0.04 ms end 0.00 ms removing tmp table 1.34 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1130 12 EShopHelper::getCategories() JROOT/modules/mod_eshop_category/helper.php:73 11 modEShopCategoryHelper::getCategories() JROOT/modules/mod_eshop_category/mod_eshop_category.php:24 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 0.14 ms Query memory: 0.028 MB Memory before query: 6.253 MB Rows returned: 3
SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.category_parent_id = 24
AND a.published = 1
AND b.language = 'en-GB'
AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
ORDER BY b.category_name ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref PRIMARY,category_parent_id,published category_parent_id 5 const 3 100.00 Using where; Using temporary; Using filesort 1 SIMPLE b ref category_id,idx_language category_id 5 pptexas_db2019.a.id 4 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.18 ms Creating sort index 0.03 ms end 0.02 ms removing tmp table 0.07 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1130 12 EShopHelper::getCategories() JROOT/modules/mod_eshop_category/helper.php:73 11 modEShopCategoryHelper::getCategories() JROOT/modules/mod_eshop_category/mod_eshop_category.php:24 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.53 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 6.268 MB Rows returned: 3
SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.category_parent_id = 22
AND a.published = 1
AND b.language = 'en-GB'
AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
ORDER BY b.category_name ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref PRIMARY,category_parent_id,published category_parent_id 5 const 3 100.00 Using where; Using temporary; Using filesort 1 SIMPLE b ref category_id,idx_language category_id 5 pptexas_db2019.a.id 4 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.17 ms Creating sort index 0.03 ms end 0.00 ms removing tmp table 0.06 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1130 12 EShopHelper::getCategories() JROOT/modules/mod_eshop_category/helper.php:73 11 modEShopCategoryHelper::getCategories() JROOT/modules/mod_eshop_category/mod_eshop_category.php:24 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.75 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 6.277 MB Rows returned: 4
SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.category_parent_id = 23
AND a.published = 1
AND b.language = 'en-GB'
AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
ORDER BY b.category_name ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref PRIMARY,category_parent_id,published category_parent_id 5 const 4 100.00 Using where; Using temporary; Using filesort 1 SIMPLE b ref category_id,idx_language category_id 5 pptexas_db2019.a.id 4 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.25 ms Creating sort index 0.05 ms end 0.01 ms removing tmp table 0.09 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1130 12 EShopHelper::getCategories() JROOT/modules/mod_eshop_category/helper.php:73 11 modEShopCategoryHelper::getCategories() JROOT/modules/mod_eshop_category/mod_eshop_category.php:24 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.61 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 6.287 MB Rows returned: 0
SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.category_parent_id = 37
AND a.published = 1
AND b.language = 'en-GB'
AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
ORDER BY b.category_name ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref PRIMARY,category_parent_id,published category_parent_id 5 const 1 100.00 Using where; Using temporary; Using filesort 1 SIMPLE b ref category_id,idx_language category_id 5 pptexas_db2019.a.id 4 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.18 ms Creating sort index 0.02 ms end 0.00 ms removing tmp table 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1130 12 EShopHelper::getCategories() JROOT/modules/mod_eshop_category/helper.php:73 11 modEShopCategoryHelper::getCategories() JROOT/modules/mod_eshop_category/mod_eshop_category.php:24 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.53 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 6.294 MB Rows returned: 3
SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)
WHERE a.category_parent_id = 9
AND a.published = 1
AND b.language = 'en-GB'
AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))
ORDER BY b.category_name ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref PRIMARY,category_parent_id,published category_parent_id 5 const 2 100.00 Using where; Using temporary; Using filesort 1 SIMPLE b ref category_id,idx_language category_id 5 pptexas_db2019.a.id 4 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.17 ms Creating sort index 0.03 ms end 0.00 ms removing tmp table 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php:1130 12 EShopHelper::getCategories() JROOT/modules/mod_eshop_category/helper.php:73 11 modEShopCategoryHelper::getCategories() JROOT/modules/mod_eshop_category/mod_eshop_category.php:24 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.48 ms After last query: 0.64 ms Query memory: 0.025 MB Memory before query: 6.304 MB Rows returned: 1
SELECT id
FROM ka4p8_eshop_urls
WHERE md5_key="9328f0dec5c5a2eff6ca6d98963d0bd3"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1307 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.35 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:368 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.14 ms After last query: 0.07 ms Query memory: 0.009 MB Memory before query: 6.314 MB
UPDATE ka4p8_eshop_urls
SET query="view=category&id=27"
WHERE id = 11id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.02 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:386 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.40 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 6.324 MB Rows returned: 1
SELECT id
FROM ka4p8_eshop_urls
WHERE md5_key="54edb1c90bb72ccecad32da441cfc92c"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1307 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.28 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:368 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.13 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 6.334 MB
UPDATE ka4p8_eshop_urls
SET query="view=category&id=24"
WHERE id = 47id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:386 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 6.344 MB Rows returned: 1
SELECT id
FROM ka4p8_eshop_urls
WHERE md5_key="6b2deffeae601f4473d9040a62a6508e"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1307 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.28 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:368 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.12 ms After last query: 0.06 ms Query memory: 0.009 MB Memory before query: 6.353 MB
UPDATE ka4p8_eshop_urls
SET query="view=category&id=22"
WHERE id = 23id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:386 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 6.364 MB Rows returned: 1
SELECT id
FROM ka4p8_eshop_urls
WHERE md5_key="8dcb72a5f8351db5357ce7a61cdb2f14"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1307 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.28 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:368 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.13 ms After last query: 0.06 ms Query memory: 0.009 MB Memory before query: 6.373 MB
UPDATE ka4p8_eshop_urls
SET query="view=category&id=23"
WHERE id = 969id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:386 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.46 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 6.383 MB Rows returned: 1
SELECT id
FROM ka4p8_eshop_urls
WHERE md5_key="12f97091faa084abf1951f125893462e"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1307 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.32 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:368 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.13 ms After last query: 0.06 ms Query memory: 0.009 MB Memory before query: 6.393 MB
UPDATE ka4p8_eshop_urls
SET query="view=category&id=37"
WHERE id = 1580id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:386 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 6.403 MB Rows returned: 1
SELECT id
FROM ka4p8_eshop_urls
WHERE md5_key="c241fc322b05d3d8f4dd4d9e7e3cde4f"id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1307 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.30 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/components/com_eshop/router.php:368 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.14 ms After last query: 0.07 ms Query memory: 0.009 MB Memory before query: 6.412 MB
UPDATE ka4p8_eshop_urls
SET query="view=category&id=9"
WHERE id = 41id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_eshop_urls range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/router.php:386 18 EshopRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_eshop_category/tmpl/default.php:32 11 require JROOT/modules/mod_eshop_category/tmpl/default.php JROOT/modules/mod_eshop_category/mod_eshop_category.php:77 10 include JROOT/modules/mod_eshop_category/mod_eshop_category.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.40 ms After last query: 6.61 ms Query memory: 0.022 MB Memory before query: 6.441 MB Rows returned: 0
SELECT *
FROM ka4p8_jmap_metainfo
WHERE `linkurl` = 'https://pptexas.com/shop-now/holmatro-mounts/holmatro-hydraulic-line-mounts/vertical-mounting-bracket-for-4150'
AND `published` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_jmap_metainfo ref published published 1 const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:429 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 6.447 MB Rows returned: 0
SELECT *
FROM ka4p8_jmap_canonicals
WHERE `linkurl` = 'https://pptexas.com/shop-now/holmatro-mounts/holmatro-hydraulic-line-mounts/vertical-mounting-bracket-for-4150'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_jmap_canonicals ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:508 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 2.86 ms Query memory: 0.020 MB Memory before query: 6.699 MB Rows returned: 0
SELECT *
FROM ka4p8_jmap_headings
WHERE `linkurl` = 'https://pptexas.com/shop-now/holmatro-mounts/holmatro-hydraulic-line-mounts/vertical-mounting-bracket-for-4150'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ka4p8_jmap_headings ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 8 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:819 7 plgSystemJMap->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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
64 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
9 × SELECT id
FROM ka4p8_eshop_urls7 × SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)3 × SELECT COUNT(*)
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_productcategories AS b
ON (a.id = b.category_id)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ka4p8_extensions`2 × SELECT product_name, product_alias
FROM ka4p8_eshop_productdetails2 × SELECT a.*
FROM ka4p8_eshop_discounts AS a
INNER JOIN ka4p8_eshop_discountelements AS b
ON (a.id = b.discount_id)2 × SELECT a.id, b.attributegroup_name
FROM ka4p8_eshop_attributegroups AS a
INNER JOIN ka4p8_eshop_attributegroupdetails AS b
ON (a.id = b.attributegroup_id)1 × SELECT `data`
FROM `ka4p8_session`1 × SELECT m.id, m.manufacturer_image, m.manufacturer_email, md.manufacturer_name
FROM ka4p8_eshop_products AS p
INNER JOIN ka4p8_eshop_manufacturers AS m
ON (p.manufacturer_id = m.id)
INNER JOIN ka4p8_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 ka4p8_eshop_products AS a
INNER JOIN ka4p8_eshop_productdetails AS b
ON (a.id = b.product_id)
INNER JOIN ka4p8_eshop_productcategories AS pc
ON (a.id = pc.product_id)1 × SELECT DISTINCT(label_id)
FROM ka4p8_eshop_labelelements1 × SELECT product_quantity
FROM ka4p8_eshop_products1 × SELECT price
FROM ka4p8_eshop_productspecials1 × SELECT price
FROM ka4p8_eshop_productdiscounts1 × SELECT a.*, a.category_parent_id AS parent_id, b.category_name AS title
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ka4p8_modules AS m
LEFT JOIN ka4p8_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ka4p8_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT a.id, b.manufacturer_id, b.manufacturer_name
FROM ka4p8_eshop_manufacturers AS a
INNER JOIN ka4p8_eshop_manufacturerdetails AS b
ON (a.id = b.manufacturer_id)1 × SELECT o.id, od.option_name
FROM ka4p8_eshop_options AS o
INNER JOIN ka4p8_eshop_optiondetails AS od
ON o.id = od.option_id1 × SELECT left_symbol, right_symbol
FROM ka4p8_eshop_currencies1 × SELECT a.*, b.weight_name, b.weight_unit
FROM ka4p8_eshop_weights AS a
INNER JOIN ka4p8_eshop_weightdetails AS b
ON (a.id = b.weight_id)1 × SELECT a.*, b.length_name, b.length_unit
FROM ka4p8_eshop_lengths AS a
INNER JOIN ka4p8_eshop_lengthdetails AS b
ON (a.id = b.length_id)1 × SELECT *
FROM ka4p8_eshop_coupons1 × SELECT *
FROM ka4p8_eshop_vouchers1 × SELECT *
FROM ka4p8_jmap_metainfo1 × SELECT *
FROM ka4p8_jmap_canonicals1 × SELECT p.*, pd.product_name, pd.product_alias, pd.product_desc, pd.product_short_desc, pd.product_page_title, pd.product_page_heading, pd.product_alt_image, pd.meta_key, pd.meta_desc
FROM ka4p8_eshop_products AS p
INNER JOIN ka4p8_eshop_productdetails AS pd
ON (p.id = pd.product_id)
INNER JOIN ka4p8_eshop_productrelations AS pr
ON (p.id = pr.related_product_id)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 ka4p8_eshop_options AS o
INNER JOIN ka4p8_eshop_optiondetails AS od
ON (o.id = od.option_id)
INNER JOIN ka4p8_eshop_productoptions AS po
ON (o.id = po.option_id)1 × SELECT `session_id`
FROM `ka4p8_session`1 × SELECT `query`
FROM ka4p8_eshop_urls1 × SELECT id, rules
FROM `ka4p8_viewlevels1 × SELECT b.id
FROM ka4p8_usergroups AS a
LEFT JOIN ka4p8_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 ka4p8_extensions1 × SELECT `value`
FROM `ka4p8_admintools_storage`1 × SELECT *
FROM `ka4p8_admintools_wafexceptions`1 × SELECT *
FROM `ka4p8_admintools_ipautoban`1 × SELECT *
FROM `ka4p8_admintools_storage`1 × SELECT `source`,`keepurlparams`
FROM `ka4p8_admintools_redirects`1 × SELECT *
FROM ka4p8_rsform_confi1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM ka4p8_menu AS m
LEFT JOIN ka4p8_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM `ka4p8_admintools_wafblacklists`1 × SELECT quantity, price
FROM ka4p8_eshop_productdiscounts1 × SELECT *
FROM ka4p8_languages1 × SELECT id, home, template, s.params
FROM ka4p8_template_styles as s
LEFT JOIN ka4p8_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT config_key, config_value
FROM ka4p8_eshop_config1 × SELECT a.*, b.product_name, b.product_alias, b.product_desc, b.product_short_desc, b.product_page_title, b.product_page_heading, b.product_alt_image, b.product_canoncial_link, 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 ka4p8_eshop_products AS a
INNER JOIN ka4p8_eshop_productdetails AS b
ON (a.id = b.product_id)1 × SELECT *
FROM ka4p8_eshop_currencies1 × SELECT a.id, a.category_parent_id, b.category_name, b.category_alias
FROM ka4p8_eshop_categories AS a
INNER JOIN ka4p8_eshop_categorydetails AS b
ON (a.id = b.category_id)1 × SELECT product_manage_stock, product_stock_display, product_show_availability, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id
FROM ka4p8_eshop_products1 × SELECT a.*
FROM ka4p8_eshop_tags AS a
INNER JOIN ka4p8_eshop_producttags AS b
ON (a.id = b.tag_id)1 × SELECT *
FROM ka4p8_eshop_productattachments1 × SELECT pi.*
FROM ka4p8_eshop_productimages AS pi1 × SELECT *
FROM ka4p8_jmap_headings
OTHER Tables:
1 × INSERT INTO `ka4p8_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3865643038633032376665336435313538633831356563356562353961386133', 1, 1738677676, 0, '', 01 × UPDATE `ka4p8_extensions`
SET `params` = '{\"mediaversion\":\"0005b4e2f803ac4d0b3fd8ca869f7ec5\"}'1 × UPDATE ka4p8_eshop_products
SET hits = hits + 11 × UPDATE ka4p8_eshop_urls
SET query="view=product&id=781&catid=6"1 × UPDATE ka4p8_eshop_urls
SET query="view=product&id=804&catid=6"1 × UPDATE ka4p8_eshop_urls
SET query="task=search"1 × UPDATE ka4p8_eshop_urls
SET query="view=category&id=27"1 × UPDATE ka4p8_eshop_urls
SET query="view=category&id=24"1 × UPDATE ka4p8_eshop_urls
SET query="view=category&id=22"1 × UPDATE ka4p8_eshop_urls
SET query="view=category&id=23"1 × UPDATE ka4p8_eshop_urls
SET query="view=category&id=37"1 × UPDATE ka4p8_eshop_urls
SET query="view=category&id=9"