- Sản phẩm
LƯƠNG TÂM - CHẤT LƯỢNG - UY TÍN
Địa chỉ : 1524/13B Kp. Đông Thành, P. Tân Đông Hiệp, Tx. Dĩ An, Bình Dương
Email: noihoiminhanhphat@gmail.com
Hotline: 0903 108 568
Về chúng tôi
- Giới thiệu
- Tuyển Dụng
- Khuyến Mãi
- Chính sách & Quy định
Danh mục sản phẩm
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1539856453,
"last": 1539856453,
"now": 1539856453
},
"token": "FuIh2YAFURHLc097OOAxeRGpwhQVWeHg"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"js_id_currency_orig": "1",
"js_id_currency": "1",
"js_history_sel_lang": "vi-VN",
"js_prev_user_id": 0,
"jshop_checked_language": [
"en-GB",
"vi-VN"
],
"jshop_end_page_buy_product": "\/san-pham\/product\/view\/139\/371.html",
"product_back_value": []
}
}
Time
Memory
Time: 10.47 ms / 10.47 ms Memory: 0.712 MB / 1.05 MB Application: afterLoad
Time: 88.36 ms / 98.82 ms Memory: 6.153 MB / 7.20 MB Application: afterInitialise
Time: 52.73 ms / 151.55 ms Memory: 4.125 MB / 11.33 MB Application: afterRoute
Time: 2.95 ms / 154.50 ms Memory: 0.074 MB / 11.40 MB Application: beforeRenderComponent com_jshopping
Time: 182.65 ms / 337.15 ms Memory: 3.598 MB / 15.00 MB Application: afterRenderComponent com_jshopping
Time: 1.91 ms / 339.06 ms Memory: 0.039 MB / 15.04 MB Application: afterDispatch
Time: 15.88 ms / 354.95 ms Memory: 1.275 MB / 16.31 MB Application: beforeRenderModule mod_vina_cmenu_jshopping (Danh Mục Sản Phẩm)
Time: 17.33 ms / 372.27 ms Memory: 0.728 MB / 17.04 MB Application: afterRenderModule mod_vina_cmenu_jshopping (Danh Mục Sản Phẩm)
Time: 16.15 ms / 388.42 ms Memory: 0.084 MB / 17.12 MB Application: beforeRenderModule mod_je_facebookfanbox (Facebook)
Time: 0.42 ms / 388.84 ms Memory: 0.014 MB / 17.14 MB Application: afterRenderModule mod_je_facebookfanbox (Facebook)
Time: 2.59 ms / 391.43 ms Memory: 0.061 MB / 17.20 MB Application: beforeRenderModule mod_vvisit_counter (Thống kê truy cập)
Time: 14.71 ms / 406.14 ms Memory: 1.250 MB / 18.45 MB Application: afterRenderModule mod_vvisit_counter (Thống kê truy cập)
Time: 0.84 ms / 406.98 ms Memory: 0.000 MB / 18.39 MB Application: beforeRenderModule mod_jshopping_search (Jshopping Search)
Time: 1.43 ms / 408.41 ms Memory: 0.013 MB / 18.40 MB Application: afterRenderModule mod_jshopping_search (Jshopping Search)
Time: 9.30 ms / 417.71 ms Memory: 0.195 MB / 18.60 MB Application: afterRender
Database queries total: 62.52 ms
20.46 MB (21,449,928 Bytes)
72 Queries Logged 62.52 ms
- Query Time: 0.65 ms Query memory: 0.017 MB Memory before query: 3.087 MB Rows returned: 0
SELECT `data`
FROM `veneno_session`
WHERE `session_id` = 'fkh9msjsasdumtbbg9l90qor65'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_session const PRIMARY PRIMARY 766 const 1 100.00 Status Duration starting 0.07 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 0.03 ms init 0.02 ms optimizing 0.01 ms statistics 0.23 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.28 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 13 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:44 12 JSessionStorageDatabase->read() Same as call in the line below. 11 session_start() JROOT/libraries/joomla/session/handler/native.php:259 10 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:49 9 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:81 8 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:636 7 JSession->_start() JROOT/libraries/joomla/session/session.php:596 6 JSession->start() JROOT/libraries/cms/application/cms.php:773 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:51 - Query Time: 2.85 ms After last query: 2.22 ms Query memory: 0.008 MB Memory before query: 3.295 MB
DELETE
FROM `veneno_session`
WHERE `time` < '1539852853'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_session range time time 59 NULL 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.11 ms updating 0.28 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.12 ms query end 2.02 ms closing tables 0.03 ms freeing items 0.08 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:790 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:51 - Query Time: 4.68 ms After last query: 0.15 ms Query memory: 0.010 MB Memory before query: 3.306 MB Rows returned: 0
SELECT `session_id`
FROM `veneno_session`
WHERE `session_id` = 'fkh9msjsasdumtbbg9l90qor65'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_session const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.06 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 4.30 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.00 ms storing result in query cache 0.09 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:799 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:51 - Query Time: 2.32 ms After last query: 0.17 ms Query memory: 0.009 MB Memory before query: 3.322 MB
INSERT INTO `veneno_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('fkh9msjsasdumtbbg9l90qor65', 0, 1, '1539856453', 0, '')EXPLAIN not possible on query: INSERT INTO `veneno_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('fkh9msjsasdumtbbg9l90qor65', 0, 1, '1539856453', 0, '')Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.01 ms update 0.06 ms Waiting for query cache lock 0.01 ms update 0.03 ms end 0.01 ms query end 1.97 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:212 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:799 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:51 - Query Time: 0.99 ms After last query: 4.47 ms Query memory: 0.012 MB Memory before query: 3.698 MB Rows returned: 35
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `veneno_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_extensions ref extension extension 82 const 35 100.00 Using index condition Status Duration starting 0.06 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.03 ms init 0.01 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.02 ms executing 0.00 ms Sending data 0.49 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 9 JDatabaseDriver->loadObjectList() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:448 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:120 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.58 ms After last query: 2.13 ms Query memory: 0.014 MB Memory before query: 3.899 MB Rows returned: 1
SELECT b.id
FROM veneno_usergroups AS a
LEFT JOIN veneno_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 22.22 Using where; Using index Status Duration starting 0.05 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.20 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.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.27 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:835 9 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:904 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:454 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.39 ms After last query: 0.81 ms Query memory: 0.013 MB Memory before query: 3.976 MB Rows returned: 5
SELECT id, rules
FROM `veneno_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 Status Duration starting 0.03 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.13 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.08 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1494 9 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:921 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:454 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 2.13 ms After last query: 7.12 ms Query memory: 0.019 MB Memory before query: 4.571 MB Rows returned: 27
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 veneno_menu AS m
LEFT JOIN veneno_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 ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 205 76.10 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 grlnwmxyhosting_thaibinh.m.component_id 1 100.00 Using where Status Duration starting 0.10 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 0.03 ms init 0.05 ms optimizing 0.04 ms statistics 0.20 ms preparing 0.05 ms executing 0.01 ms Sorting result 0.80 ms Sending data 0.33 ms Waiting for query cache lock 0.01 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.25 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:86 13 JMenuSite->load() JROOT/libraries/cms/menu/menu.php:74 12 JMenu->__construct() JROOT/libraries/cms/menu/site.php:57 11 JMenuSite->__construct() JROOT/libraries/cms/menu/menu.php:145 10 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:439 9 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 8 JApplicationSite->getMenu() JROOT/plugins/system/expiresheaders/expiresheaders.php:24 7 plgSystemExpiresHeaders->plgSystemExpiresHeaders() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:669 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.68 ms After last query: 3.91 ms Query memory: 0.012 MB Memory before query: 5.055 MB Rows returned: 1
SELECT `enabled`
FROM `veneno_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 100.00 Using index condition; Using where Status Duration starting 0.06 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.22 ms preparing 0.03 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.05 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.21 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 8 JDatabaseDriver->loadResult() JROOT/plugins/system/backuponupdate/backuponupdate.php:80 7 require_once JROOT/plugins/system/backuponupdate/backuponupdate.php JROOT/libraries/cms/plugin/helper.php:230 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:669 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.55 ms After last query: 5.74 ms Query memory: 0.021 MB Memory before query: 5.448 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `veneno_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration starting 0.07 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.02 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.24 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1650 16 JDatabaseDriver->loadObject() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 14 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156 13 JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47 12 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:90 11 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274 10 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 9 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 8 JFactory::getDocument() JROOT/plugins/system/backup/backup.php:4 7 require_once JROOT/plugins/system/backup/backup.php JROOT/libraries/cms/plugin/helper.php:230 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:669 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 2.50 ms After last query: 0.48 ms Query memory: 0.016 MB Memory before query: 5.455 MB
UPDATE `veneno_extensions`
SET `params` = '{\"mediaversion\":\"9a8ab6c7165a363ae27301a8f2591498\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_extensions range element_clientid,element_folder_clientid,extension extension 484 NULL 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.01 ms init 0.06 ms updating 0.06 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.17 ms query end 1.98 ms closing tables 0.02 ms freeing items 0.05 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:119 12 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 11 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 10 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 9 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 8 JFactory::getDocument() JROOT/plugins/system/backup/backup.php:4 7 require_once JROOT/plugins/system/backup/backup.php JROOT/libraries/cms/plugin/helper.php:230 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:669 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 1.08 ms After last query: 11.50 ms Query memory: 0.020 MB Memory before query: 6.589 MB Rows returned: 3
SELECT id, home, template, s.params
FROM veneno_template_styles as s
LEFT JOIN veneno_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 e ref element_clientid,element_folder_clientid,extension extension 82 const 5 100.00 Using index condition; Using where 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 5 80.00 Using where; Using join buffer (flat, BNL join) Status Duration starting 0.07 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.03 ms init 0.03 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.05 ms executing 0.01 ms Sending data 0.45 ms Waiting for query cache lock 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.19 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 16 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:484 15 JApplicationSite->getTemplate() JROOT/plugins/system/helix/core/helix.php:65 14 Helix::themeName() JROOT/plugins/system/helix/core/helix.php:114 13 Helix::themePath() JROOT/plugins/system/helix/core/helix.php:302 12 Helix::_Import() JROOT/plugins/system/helix/core/helix.php:290 11 Helix::Import() JROOT/plugins/system/helix/core/helix.php:1592 10 Helix::loadHelixOverwrite() JROOT/plugins/system/helix/helix.php:22 9 plgSystemHelix->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:670 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 3.37 ms After last query: 26.54 ms Query memory: 0.024 MB Memory before query: 9.109 MB Rows returned: 140
SHOW FULL COLUMNS
FROM `veneno_jshopping_config`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_config`Status Duration checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 1.19 ms executing 0.01 ms Sending data 0.28 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.10 ms closing tables 0.01 ms freeing items 0.05 ms updating status 0.02 ms cleaning up 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 17 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 16 JTable->__construct() JROOT/components/com_jshopping/tables/config.php:14 15 jshopConfig->__construct() JROOT/components/com_jshopping/lib/factory.php:24 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1546 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:210 10 jshoppingParseRoute() JROOT/libraries/cms/component/router/legacy.php:104 9 JComponentRouterLegacy->parse() JROOT/libraries/cms/router/site.php:408 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:482 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:235 6 JRouter->parse() JROOT/libraries/cms/router/site.php:131 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1116 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 1.29 ms After last query: 3.14 ms Query memory: 0.020 MB Memory before query: 9.595 MB Rows returned: 1
SELECT *
FROM veneno_jshopping_config
WHERE `id` = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_config const PRIMARY PRIMARY 4 const 1 100.00 Status Duration starting 0.06 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.55 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.06 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.04 ms executing 0.00 ms Sending data 0.06 ms Waiting for query cache lock 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.04 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.19 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1453 16 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 15 JTable->load() JROOT/components/com_jshopping/lib/factory.php:30 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1546 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:210 10 jshoppingParseRoute() JROOT/libraries/cms/component/router/legacy.php:104 9 JComponentRouterLegacy->parse() JROOT/libraries/cms/router/site.php:408 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:482 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:235 6 JRouter->parse() JROOT/libraries/cms/router/site.php:131 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1116 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.56 ms After last query: 1.10 ms Query memory: 0.029 MB Memory before query: 9.603 MB Rows returned: 8
SHOW FULL COLUMNS
FROM `veneno_jshopping_currencies`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_currencies`Status Duration starting 0.07 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.16 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.03 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 21 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 20 JTable->__construct() JROOT/components/com_jshopping/tables/currency.php:14 19 jshopCurrency->__construct() JROOT/libraries/joomla/table/table.php:308 18 JTable::getInstance() JROOT/components/com_jshopping/lib/factory.php:600 17 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:548 16 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:53 15 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:32 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1546 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:210 10 jshoppingParseRoute() JROOT/libraries/cms/component/router/legacy.php:104 9 JComponentRouterLegacy->parse() JROOT/libraries/cms/router/site.php:408 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:482 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:235 6 JRouter->parse() JROOT/libraries/cms/router/site.php:131 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1116 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.53 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 9.649 MB Rows returned: 1
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `veneno_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_currencies ref currency_publish currency_publish 1 const 1 100.00 Using where; Using filesort Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.10 ms Sending data 0.02 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 18 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/currency.php:22 17 jshopCurrency->getAllCurrencies() JROOT/components/com_jshopping/lib/factory.php:549 16 JSFactory::getAllCurrency() JROOT/components/com_jshopping/tables/config.php:53 15 jshopConfig->loadCurrencyValue() JROOT/components/com_jshopping/lib/factory.php:32 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1546 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:210 10 jshoppingParseRoute() JROOT/libraries/cms/component/router/legacy.php:104 9 JComponentRouterLegacy->parse() JROOT/libraries/cms/router/site.php:408 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:482 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:235 6 JRouter->parse() JROOT/libraries/cms/router/site.php:131 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1116 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.97 ms After last query: 2.29 ms Query memory: 0.029 MB Memory before query: 9.864 MB Rows returned: 53Duplicate queries: #18
SHOW FULL COLUMNS
FROM `veneno_jshopping_users`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_users`Status Duration starting 0.06 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.15 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms After opening tables 0.00 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.03 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 21 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 20 JTable->__construct() JROOT/components/com_jshopping/tables/usershopbase.php:14 19 jshopUserShopBase->__construct() JROOT/components/com_jshopping/tables/usershop.php:15 18 jshopUserShop->__construct() JROOT/components/com_jshopping/lib/factory.php:47 17 JSFactory::getUserShop() JROOT/components/com_jshopping/tables/config.php:67 16 jshopConfig->getDisplayPriceFront() JROOT/components/com_jshopping/tables/config.php:288 15 jshopConfig->parseConfigVars() JROOT/components/com_jshopping/lib/factory.php:35 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1546 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:210 10 jshoppingParseRoute() JROOT/libraries/cms/component/router/legacy.php:104 9 JComponentRouterLegacy->parse() JROOT/libraries/cms/router/site.php:408 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:482 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:235 6 JRouter->parse() JROOT/libraries/cms/router/site.php:131 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1116 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.92 ms After last query: 1.19 ms Query memory: 0.029 MB Memory before query: 10.040 MB Rows returned: 53Duplicate queries: #17
SHOW FULL COLUMNS
FROM `veneno_jshopping_users`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_users`Status Duration starting 0.06 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.14 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 21 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 20 JTable->__construct() JROOT/components/com_jshopping/tables/usershopbase.php:14 19 jshopUserShopBase->__construct() JROOT/components/com_jshopping/models/userguest.php:16 18 jshopUserGust->__construct() JROOT/components/com_jshopping/lib/factory.php:66 17 JSFactory::getUserShopGuest() JROOT/components/com_jshopping/tables/config.php:71 16 jshopConfig->getDisplayPriceFront() JROOT/components/com_jshopping/tables/config.php:288 15 jshopConfig->parseConfigVars() JROOT/components/com_jshopping/lib/factory.php:35 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1546 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:210 10 jshoppingParseRoute() JROOT/libraries/cms/component/router/legacy.php:104 9 JComponentRouterLegacy->parse() JROOT/libraries/cms/router/site.php:408 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:482 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:235 6 JRouter->parse() JROOT/libraries/cms/router/site.php:131 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1116 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.55 ms After last query: 1.13 ms Query memory: 0.031 MB Memory before query: 10.214 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `veneno_jshopping_usergroups`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_usergroups`Status Duration starting 0.06 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.14 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms After opening tables 0.00 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.05 ms closing tables 0.01 ms freeing items 0.03 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 25 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 24 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 23 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 22 JTable->__construct() JROOT/components/com_jshopping/tables/usergroup.php:14 21 jshopUserGroup->__construct() JROOT/libraries/joomla/table/table.php:308 20 JTable::getInstance() JROOT/components/com_jshopping/lib/factory.php:600 19 JSFactory::getTable() JROOT/components/com_jshopping/models/userguest.php:30 18 jshopUserGust->load() JROOT/components/com_jshopping/lib/factory.php:67 17 JSFactory::getUserShopGuest() JROOT/components/com_jshopping/tables/config.php:71 16 jshopConfig->getDisplayPriceFront() JROOT/components/com_jshopping/tables/config.php:288 15 jshopConfig->parseConfigVars() JROOT/components/com_jshopping/lib/factory.php:35 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1546 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:210 10 jshoppingParseRoute() JROOT/libraries/cms/component/router/legacy.php:104 9 JComponentRouterLegacy->parse() JROOT/libraries/cms/router/site.php:408 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:482 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:235 6 JRouter->parse() JROOT/libraries/cms/router/site.php:131 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1116 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.50 ms After last query: 0.66 ms Query memory: 0.029 MB Memory before query: 10.295 MB Rows returned: 4
SHOW FULL COLUMNS
FROM `veneno_jshopping_config_display_prices`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_config_display_prices`Status Duration starting 0.06 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.14 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.03 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 21 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 20 JTable->__construct() JROOT/components/com_jshopping/tables/configdisplayprice.php:19 19 jshopConfigDisplayPrice->__construct() JROOT/libraries/joomla/table/table.php:308 18 JTable::getInstance() JROOT/components/com_jshopping/lib/factory.php:600 17 JSFactory::getTable() JROOT/components/com_jshopping/tables/config.php:79 16 jshopConfig->getDisplayPriceFront() JROOT/components/com_jshopping/tables/config.php:288 15 jshopConfig->parseConfigVars() JROOT/components/com_jshopping/lib/factory.php:35 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1546 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:210 10 jshoppingParseRoute() JROOT/libraries/cms/component/router/legacy.php:104 9 JComponentRouterLegacy->parse() JROOT/libraries/cms/router/site.php:408 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:482 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:235 6 JRouter->parse() JROOT/libraries/cms/router/site.php:131 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1116 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.40 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 10.330 MB Rows returned: 1
SELECT *
FROM `veneno_jshopping_config_display_prices`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_config_display_prices ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.14 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 18 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/configdisplayprice.php:38 17 jshopConfigDisplayPrice->getList() JROOT/components/com_jshopping/tables/config.php:80 16 jshopConfig->getDisplayPriceFront() JROOT/components/com_jshopping/tables/config.php:288 15 jshopConfig->parseConfigVars() JROOT/components/com_jshopping/lib/factory.php:35 14 JSFactory::getConfig() JROOT/components/com_jshopping/lib/factory.php:143 13 JSFactory::reloadConfigFieldTLF() JROOT/components/com_jshopping/lib/factory.php:166 12 JSFactory::loadLanguageFile() JROOT/components/com_jshopping/lib/functions.php:1546 11 initLoadJoomshoppingLanguageFile() JROOT/components/com_jshopping/router.php:210 10 jshoppingParseRoute() JROOT/libraries/cms/component/router/legacy.php:104 9 JComponentRouterLegacy->parse() JROOT/libraries/cms/router/site.php:408 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:482 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:235 6 JRouter->parse() JROOT/libraries/cms/router/site.php:131 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1116 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.54 ms After last query: 2.47 ms Query memory: 0.020 MB Memory before query: 10.474 MB Rows returned: 7
select product_id as id, `alias_vi-VN` as alias
from veneno_jshopping_products
where `alias_vi-VN`!=''id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_products ALL NULL NO INDEX KEY COULD BE USED NULL NULL 12 100.00 Using where Status Duration starting 0.03 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.25 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:276 15 JSFactory::getAliasProduct() JROOT/plugins/jshoppingrouter/jshopping_product_seo/jshopping_product_seo.php:42 14 plgJshoppingRouterJshopping_product_seo->onBeforeParseRoute() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 11 JEventDispatcher->trigger() JROOT/components/com_jshopping/router.php:216 10 jshoppingParseRoute() JROOT/libraries/cms/component/router/legacy.php:104 9 JComponentRouterLegacy->parse() JROOT/libraries/cms/router/site.php:408 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:482 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:235 6 JRouter->parse() JROOT/libraries/cms/router/site.php:131 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1116 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.69 ms After last query: 12.03 ms Query memory: 0.009 MB Memory before query: 11.362 MB Rows returned: 1
SELECT *
FROM veneno_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 100.00 Using where; Using filesort Status Duration starting 0.07 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 0.03 ms init 0.03 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sorting result 0.17 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 6 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:164 5 JLanguageHelper::getLanguages() JROOT/libraries/cms/application/site.php:329 4 JApplicationSite->getParams() JROOT/libraries/cms/application/site.php:135 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.56 ms After last query: 5.12 ms Query memory: 0.013 MB Memory before query: 11.512 MB Rows returned: 2
select *
from veneno_jshopping_languagesid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 100.00 Status Duration starting 0.05 ms Waiting for query cache lock 0.11 ms init 0.00 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.13 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 9 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/functions.php:281 8 installNewLanguages() JROOT/components/com_jshopping/loadparams.php:32 7 require JROOT/components/com_jshopping/loadparams.php JROOT/components/com_jshopping/jshopping.php:16 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 1.19 ms After last query: 10.20 ms Query memory: 0.020 MB Memory before query: 12.652 MB Rows returned: 48
SHOW FULL COLUMNS
FROM `veneno_jshopping_products`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products`Status Duration starting 0.11 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.25 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.08 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.09 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 13 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 12 JTable->__construct() JROOT/components/com_jshopping/tables/product.php:15 11 jshopProduct->__construct() JROOT/libraries/joomla/table/table.php:308 10 JTable::getInstance() JROOT/components/com_jshopping/lib/factory.php:600 9 JSFactory::getTable() JROOT/components/com_jshopping/controllers/product.php:44 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.48 ms After last query: 0.65 ms Query memory: 0.014 MB Memory before query: 12.782 MB Rows returned: 1
SELECT *
FROM veneno_jshopping_products
WHERE `product_id` = '371'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_products const PRIMARY PRIMARY 4 const 1 100.00 Status Duration starting 0.04 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.03 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1453 10 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 9 JTable->load() JROOT/components/com_jshopping/controllers/product.php:45 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.76 ms After last query: 1.00 ms Query memory: 0.020 MB Memory before query: 12.894 MB Rows returned: 25
SHOW FULL COLUMNS
FROM `veneno_jshopping_categories`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_categories`Status Duration starting 0.08 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.15 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 13 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 12 JTable->__construct() JROOT/components/com_jshopping/tables/category.php:15 11 jshopCategory->__construct() JROOT/libraries/joomla/table/table.php:308 10 JTable::getInstance() JROOT/components/com_jshopping/lib/factory.php:600 9 JSFactory::getTable() JROOT/components/com_jshopping/controllers/product.php:47 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.47 ms After last query: 0.41 ms Query memory: 0.014 MB Memory before query: 12.974 MB Rows returned: 1Duplicate queries: #44
SELECT *
FROM veneno_jshopping_categories
WHERE `category_id` = '139'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_categories const PRIMARY PRIMARY 4 const 1 100.00 Status Duration starting 0.04 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.14 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.12 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1453 10 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 9 JTable->load() JROOT/components/com_jshopping/controllers/product.php:48 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.56 ms After last query: 0.23 ms Query memory: 0.015 MB Memory before query: 12.984 MB Rows returned: 1
SELECT *
FROM `veneno_jshopping_products_to_categories`
WHERE product_id='371'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_products_to_categories ref PRIMARY,product_id,product_id_2 product_id_2 4 const 1 100.00 Using index Status Duration starting 0.04 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.01 ms optimizing 0.01 ms statistics 0.24 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.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:253 10 jshopProduct->getCategories() JROOT/components/com_jshopping/models/productshop.php:79 9 jshopProductShop->getCategories() JROOT/components/com_jshopping/controllers/product.php:53 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.62 ms After last query: 0.57 ms Query memory: 0.027 MB Memory before query: 13.045 MB Rows returned: 11
SHOW FULL COLUMNS
FROM `veneno_jshopping_products_extra_fields`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products_extra_fields`Status Duration starting 0.07 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.16 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 21 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 20 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 19 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 18 JTable->__construct() JROOT/components/com_jshopping/tables/productfield.php:14 17 jshopProductField->__construct() JROOT/libraries/joomla/table/table.php:308 16 JTable::getInstance() JROOT/components/com_jshopping/lib/factory.php:600 15 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:475 14 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1098 13 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:214 12 JTableAvto->getBuildQueryListProductSimpleList() JROOT/components/com_jshopping/tables/product.php:800 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:493 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:55 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.94 ms After last query: 0.22 ms Query memory: 0.021 MB Memory before query: 13.096 MB Rows returned: 2
SELECT F.id, F.`name_vi-VN` as name, F.`description_vi-VN` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_vi-VN` as groupname, multilist
FROM `veneno_jshopping_products_extra_fields` as F
left join `veneno_jshopping_products_extra_field_groups` as G
on G.id=F.
group
order by G.ordering, F.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE F ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 100.00 Using temporary; Using filesort 1 SIMPLE G eq_ref PRIMARY PRIMARY 4 grlnwmxyhosting_thaibinh.F.group 1 100.00 Using where Status Duration starting 0.04 ms Waiting for query cache lock 0.00 ms init 0.01 ms checking query cache for query 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.03 ms init 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.00 ms Copying to tmp table 0.15 ms Copying to tmp table 0.29 ms Sorting result 0.03 ms Sending data 0.02 ms end 0.00 ms removing tmp table 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfield.php:48 15 jshopProductField->getList() JROOT/components/com_jshopping/lib/factory.php:476 14 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1098 13 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:214 12 JTableAvto->getBuildQueryListProductSimpleList() JROOT/components/com_jshopping/tables/product.php:800 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:493 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:55 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 3.47 ms After last query: 0.18 ms Query memory: 0.017 MB Memory before query: 13.120 MB Rows returned: 0
SELECT prod.product_id, pr_cat.category_id, prod.`name_vi-VN` as name, prod.`short_description_vi-VN` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices
FROM `veneno_jshopping_products_relations` AS relation
INNER JOIN `veneno_jshopping_products` AS prod
ON relation.product_related_id = prod.product_id
LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat
ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `veneno_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE relation.product_id = '371'
AND cat.category_publish='1'
AND prod.product_publish = '1'
AND prod.access IN (1,1)
AND cat.access IN (1,1)
group by prod.product_id
order by relation.idid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE relation ref product_id,product_id_2,product_related_id product_id 4 const 1 100.00 Using where; Using index; Using temporary; Using filesort 1 SIMPLE prod eq_ref PRIMARY,product_publish,access PRIMARY 4 grlnwmxyhosting_thaibinh.relation.product_related_id 1 100.00 Using where 1 SIMPLE pr_cat ref PRIMARY,category_id,product_id,product_id_2 PRIMARY 4 grlnwmxyhosting_thaibinh.relation.product_related_id 1 100.00 Using index 1 SIMPLE cat eq_ref PRIMARY,category_publish,access,category_publish_2 PRIMARY 4 grlnwmxyhosting_thaibinh.pr_cat.category_id 1 100.00 Using where Status Duration starting 0.04 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 2.07 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 0.03 ms init 0.06 ms optimizing 0.03 ms statistics 0.54 ms preparing 0.04 ms executing 0.00 ms Copying to tmp table 0.19 ms Copying to tmp table 0.06 ms Sorting result 0.02 ms Sending data 0.02 ms end 0.01 ms removing tmp table 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:812 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:493 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:55 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.56 ms After last query: 0.52 ms Query memory: 0.026 MB Memory before query: 13.172 MB Rows returned: 3
SHOW FULL COLUMNS
FROM `veneno_jshopping_taxes`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_taxes`Status Duration starting 0.08 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.15 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 19 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 18 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 17 JTable->__construct() JROOT/components/com_jshopping/tables/tax.php:14 16 jshopTax->__construct() JROOT/libraries/joomla/table/table.php:308 15 JTable::getInstance() JROOT/components/com_jshopping/lib/factory.php:600 14 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:342 13 JSFactory::getAllTaxes() JROOT/components/com_jshopping/lib/functions.php:645 12 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:816 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:493 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:55 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.43 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 13.208 MB Rows returned: 1
SELECT tax_id, tax_name, tax_value
FROM `veneno_jshopping_taxes`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_taxes ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Status Duration starting 0.04 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.01 ms After opening tables 0.02 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.13 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.03 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/tax.php:21 15 jshopTax->getAllTaxes() JROOT/components/com_jshopping/lib/factory.php:328 14 JSFactory::getAllTaxesOriginal() JROOT/components/com_jshopping/lib/factory.php:343 13 JSFactory::getAllTaxes() JROOT/components/com_jshopping/lib/functions.php:645 12 listProductUpdateData() JROOT/components/com_jshopping/tables/product.php:816 11 jshopProduct->getRelatedProducts() JROOT/components/com_jshopping/tables/product.php:493 10 jshopProduct->getExtendsData() JROOT/components/com_jshopping/models/productshop.php:101 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:55 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.59 ms After last query: 0.62 ms Query memory: 0.021 MB Memory before query: 13.262 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `veneno_jshopping_products_reviews`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products_reviews`Status Duration starting 0.07 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.15 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 16 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 15 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 14 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 13 JTable->__construct() JROOT/components/com_jshopping/tables/review.php:14 12 jshopReview->__construct() JROOT/libraries/joomla/table/table.php:308 11 JTable::getInstance() JROOT/components/com_jshopping/lib/factory.php:600 10 JSFactory::getTable() JROOT/components/com_jshopping/models/productshop.php:114 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:55 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.57 ms After last query: 1.91 ms Query memory: 0.024 MB Memory before query: 13.453 MB Rows returned: 5
SHOW FULL COLUMNS
FROM `veneno_jshopping_products_extra_field_values`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products_extra_field_values`Status Duration starting 0.08 ms checking permissions 0.01 ms closing tables 0.00 ms Opening tables 0.16 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.07 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 16 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 15 JTable->__construct() JROOT/components/com_jshopping/tables/productfieldvalue.php:15 14 jshopProductFieldValue->__construct() JROOT/libraries/joomla/table/table.php:308 13 JTable::getInstance() JROOT/components/com_jshopping/lib/factory.php:600 12 JSFactory::getTable() JROOT/components/com_jshopping/lib/factory.php:484 11 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/tables/product.php:722 10 jshopProduct->getExtraFields() JROOT/components/com_jshopping/models/productshop.php:152 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:55 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.44 ms After last query: 0.17 ms Query memory: 0.018 MB Memory before query: 13.488 MB Rows returned: 0
SELECT id, `name_vi-VN` as name, field_id
FROM `veneno_jshopping_products_extra_field_values`
order by orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_products_extra_field_values ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using filesort Status Duration starting 0.04 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.14 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/productfieldvalue.php:26 12 jshopProductFieldValue->getAllList() JROOT/components/com_jshopping/lib/factory.php:485 11 JSFactory::getAllProductExtraFieldValue() JROOT/components/com_jshopping/tables/product.php:722 10 jshopProduct->getExtraFields() JROOT/components/com_jshopping/models/productshop.php:152 9 jshopProductShop->prepareView() JROOT/components/com_jshopping/controllers/product.php:55 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.92 ms After last query: 10.76 ms Query memory: 0.019 MB Memory before query: 14.505 MB Rows returned: 4
select id,link
from veneno_menu
where `type`='component'
and published=1
and link like '%option=com_jshopping%'
and client_id=0
and (language='*' or language='vi-VN')
and access IN (1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_menu ALL idx_client_id_parent_id_alias_language,idx_language NO INDEX KEY COULD BE USED NULL NULL 205 76.59 Using where Status Duration starting 0.07 ms Waiting for query cache lock 0.00 ms init 0.01 ms checking query cache for query 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 0.03 ms init 0.04 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.04 ms executing 0.01 ms Sending data 0.24 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/shop_item_menu.php:130 13 shopItemMenu->getList() JROOT/components/com_jshopping/lib/shop_item_menu.php:41 12 shopItemMenu->init() JROOT/components/com_jshopping/lib/shop_item_menu.php:35 11 shopItemMenu::getInstance() JROOT/components/com_jshopping/lib/functions.php:387 10 getShopMainPageItemid() JROOT/components/com_jshopping/helpers/metadata.php:263 9 JshopHelpersMetadata::product() JROOT/components/com_jshopping/controllers/product.php:66 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.40 ms After last query: 1.51 ms Query memory: 0.025 MB Memory before query: 14.608 MB Rows returned: 8
select category_id as id, `alias_vi-VN` as alias
from veneno_jshopping_categories
where `alias_vi-VN`!=''id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_categories ALL NULL NO INDEX KEY COULD BE USED NULL NULL 9 100.00 Using where Status Duration starting 0.05 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.01 ms After opening tables 0.02 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 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.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 20 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/lib/factory.php:242 19 JSFactory::getAliasCategory() JROOT/components/com_jshopping/router.php:58 18 jshoppingBuildRoute() JROOT/libraries/cms/component/router/legacy.php:68 17 JComponentRouterLegacy->build() JROOT/libraries/cms/router/site.php:496 16 JRouterSite->buildSefRoute() JROOT/libraries/cms/router/site.php:465 15 JRouterSite->_buildSefRoute() JROOT/libraries/cms/router/router.php:281 14 JRouter->build() JROOT/libraries/cms/router/site.php:147 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/components/com_jshopping/lib/functions.php:479 11 SEFLink() JROOT/components/com_jshopping/lib/functions.php:139 10 appendExtendPathWay() JROOT/components/com_jshopping/helpers/metadata.php:264 9 JshopHelpersMetadata::product() JROOT/components/com_jshopping/controllers/product.php:66 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 3.06 ms After last query: 0.46 ms Query memory: 0.013 MB Memory before query: 14.638 MB
UPDATE veneno_jshopping_products
SET `hits` = (`hits` + 1)
WHERE `product_id` = '371'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_products range PRIMARY PRIMARY 4 NULL 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms init 0.08 ms updating 0.27 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.34 ms query end 2.08 ms closing tables 0.02 ms freeing items 0.05 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/table/table.php:1228 9 JTable->hit() JROOT/components/com_jshopping/controllers/product.php:68 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.80 ms After last query: 0.20 ms Query memory: 0.014 MB Memory before query: 14.650 MB Rows returned: 1
SELECT I.*, IF(P.image=I.image_name,0,1) as sort
FROM `veneno_jshopping_products_images` as I
left join `veneno_jshopping_products` as P
on P.product_id=I.product_id
WHERE I.product_id = '371'
ORDER BY sort, I.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE I ref product_id product_id 4 const 1 100.00 Using temporary; Using filesort 1 SIMPLE P eq_ref PRIMARY PRIMARY 4 grlnwmxyhosting_thaibinh.I.product_id 1 100.00 Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 0.03 ms init 0.03 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.03 ms executing 0.00 ms Copying to tmp table 0.03 ms Copying to tmp table 0.10 ms Sorting result 0.02 ms Sending data 0.02 ms end 0.00 ms removing tmp table 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.03 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 10 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:333 9 jshopProduct->getImages() JROOT/components/com_jshopping/controllers/product.php:78 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.94 ms After last query: 79.24 ms Query memory: 0.015 MB Memory before query: 14.723 MB Rows returned: 1
SELECT count(review_id)
FROM `veneno_jshopping_products_reviews`
WHERE product_id = '371'
and publish='1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_products_reviews ref product_id,publish product_id 4 const 1 100.00 Using where Status Duration starting 0.07 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.01 ms After opening tables 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.26 ms preparing 0.02 ms executing 0.01 ms Sending data 0.14 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.16 ms Waiting for query cache lock 0.01 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 11 JDatabaseDriver->loadResult() JROOT/components/com_jshopping/tables/product.php:1039 10 jshopProduct->getReviewsCount() JROOT/components/com_jshopping/models/productreviewlist.php:86 9 jshopProductReviewList->load() JROOT/components/com_jshopping/controllers/product.php:110 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.40 ms After last query: 1.24 ms Query memory: 0.015 MB Memory before query: 14.862 MB Rows returned: 0
SELECT *
FROM `veneno_jshopping_products_reviews`
WHERE product_id = '371'
and publish='1'
order by review_id desc
LIMIT 0, 20id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_products_reviews ref product_id,publish product_id 4 const 1 100.00 Using where Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms Sorting result 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.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 11 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/product.php:1031 10 jshopProduct->getReviews() JROOT/components/com_jshopping/models/productreviewlist.php:88 9 jshopProductReviewList->load() JROOT/components/com_jshopping/controllers/product.php:110 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.14 ms After last query: 8.09 ms Query memory: 0.019 MB Memory before query: 15.082 MB Rows returned: 1Duplicate queries: #28
SELECT *
FROM veneno_jshopping_categories
WHERE `category_id` = '139'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_categories const PRIMARY PRIMARY 4 const 1 100.00 Status Duration starting 0.05 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms sending cached result to clien 0.06 ms updating status 0.01 ms cleaning up 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1453 14 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 13 JTable->load() JROOT/templates/vina_veneno/html/com_jshopping/product/product_default.php:5 12 include JROOT/templates/vina_veneno/html/com_jshopping/product/product_default.php JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661 11 JViewLegacy->loadTemplate() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207 10 JViewLegacy->display() JROOT/components/com_jshopping/views/product/view.html.php:13 9 JshoppingViewProduct->display() JROOT/components/com_jshopping/controllers/product.php:133 8 JshoppingControllerProduct->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_jshopping/jshopping.php:25 6 require_once JROOT/components/com_jshopping/jshopping.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.92 ms After last query: 58.82 ms Query memory: 0.023 MB Memory before query: 16.267 MB Rows returned: 1
SELECT id, title, module, position, content, showtitle, params
FROM veneno_modules AS m
WHERE m.published = 1
AND m.id = 201
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-10-18 09:54:13')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-10-18 09:54:13')
AND m.access IN (1,1)
AND m.client_id = 0
ORDER BY position, orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m const PRIMARY,published PRIMARY 4 const 1 100.00 Status Duration starting 0.09 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.13 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.00 ms After opening tables 0.02 ms Waiting for query cache lock 0.00 ms After opening tables 0.04 ms init 0.05 ms optimizing 0.03 ms statistics 0.25 ms preparing 0.03 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 17 JDatabaseDriver->loadObjectList() JROOT/plugins/system/helix/core/classes/menu.php:649 16 HelixMenu->loadModule() JROOT/plugins/system/helix/core/classes/menu.php:259 15 HelixMenu->loadSubContent() JROOT/plugins/system/helix/core/classes/menu.php:242 14 HelixMenu->genMenuItem() JROOT/plugins/system/helix/core/classes/menu.php:580 13 HelixMenu->genMenuItems() JROOT/plugins/system/helix/core/classes/menu.php:501 12 HelixMenu->genMenu() JROOT/plugins/system/helix/core/classes/menu.php:532 11 HelixMenu->showMenu() JROOT/templates/vina_veneno/features/menu.php:65 10 HelixFeatureMenu->onPosition() JROOT/plugins/system/helix/core/helix.php:225 9 Helix::importFeatures() JROOT/plugins/system/helix/core/helix.php:1173 8 Helix::Header() JROOT/templates/vina_veneno/index.php:32 7 require JROOT/templates/vina_veneno/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.64 ms After last query: 1.81 ms Query memory: 0.027 MB Memory before query: 16.392 MB Rows returned: 9
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image
FROM `veneno_jshopping_categories`
WHERE category_parent_id = '0'
AND category_publish = '1'
AND access IN (1,1)
ORDER BY category_id ascid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_categories index category_parent_id,category_publish,access,category_publish_2 PRIMARY 4 NULL 9 77.78 Using where Status Duration starting 0.05 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.08 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 20 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/category.php:34 19 jshopCategory->getSubCategories() JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:131 18 include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190 17 JModuleHelper::renderModule() JROOT/plugins/system/helix/core/classes/menu.php:664 16 HelixMenu->loadModule() JROOT/plugins/system/helix/core/classes/menu.php:259 15 HelixMenu->loadSubContent() JROOT/plugins/system/helix/core/classes/menu.php:242 14 HelixMenu->genMenuItem() JROOT/plugins/system/helix/core/classes/menu.php:580 13 HelixMenu->genMenuItems() JROOT/plugins/system/helix/core/classes/menu.php:501 12 HelixMenu->genMenu() JROOT/plugins/system/helix/core/classes/menu.php:532 11 HelixMenu->showMenu() JROOT/templates/vina_veneno/features/menu.php:65 10 HelixFeatureMenu->onPosition() JROOT/plugins/system/helix/core/helix.php:225 9 Helix::importFeatures() JROOT/plugins/system/helix/core/helix.php:1173 8 Helix::Header() JROOT/templates/vina_veneno/index.php:32 7 require JROOT/templates/vina_veneno/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.86 ms After last query: 2.70 ms Query memory: 0.029 MB Memory before query: 16.477 MB Rows returned: 0
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image
FROM `veneno_jshopping_categories`
WHERE category_parent_id = '1'
AND category_publish = '1'
AND access IN (1,1)
ORDER BY category_id ascid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_categories ref category_parent_id,category_publish,access,category_publish_2 category_parent_id 4 const 1 100.00 Using where Status Duration starting 0.08 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.01 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sorting result 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.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.24 ms Waiting for query cache lock 0.01 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 22 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/category.php:34 21 jshopCategory->getSubCategories() JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20 20 require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97 19 require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135 18 include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190 17 JModuleHelper::renderModule() JROOT/plugins/system/helix/core/classes/menu.php:664 16 HelixMenu->loadModule() JROOT/plugins/system/helix/core/classes/menu.php:259 15 HelixMenu->loadSubContent() JROOT/plugins/system/helix/core/classes/menu.php:242 14 HelixMenu->genMenuItem() JROOT/plugins/system/helix/core/classes/menu.php:580 13 HelixMenu->genMenuItems() JROOT/plugins/system/helix/core/classes/menu.php:501 12 HelixMenu->genMenu() JROOT/plugins/system/helix/core/classes/menu.php:532 11 HelixMenu->showMenu() JROOT/templates/vina_veneno/features/menu.php:65 10 HelixFeatureMenu->onPosition() JROOT/plugins/system/helix/core/helix.php:225 9 Helix::importFeatures() JROOT/plugins/system/helix/core/helix.php:1173 8 Helix::Header() JROOT/templates/vina_veneno/index.php:32 7 require JROOT/templates/vina_veneno/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.43 ms After last query: 0.32 ms Query memory: 0.032 MB Memory before query: 16.514 MB Rows returned: 0
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image
FROM `veneno_jshopping_categories`
WHERE category_parent_id = '1'
AND access IN (1,1)
ORDER BY category_id ascid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_categories ref category_parent_id,access category_parent_id 4 const 1 100.00 Using where Status Duration starting 0.04 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.02 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sorting result 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.04 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.07 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 24 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/category.php:34 23 jshopCategory->getSubCategories() JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71 22 modVinaCMenuJShoppingHelper::getChildCategory() JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117 21 modVinaCMenuJShoppingHelper::getActiveState() JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21 20 require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97 19 require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135 18 include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190 17 JModuleHelper::renderModule() JROOT/plugins/system/helix/core/classes/menu.php:664 16 HelixMenu->loadModule() JROOT/plugins/system/helix/core/classes/menu.php:259 15 HelixMenu->loadSubContent() JROOT/plugins/system/helix/core/classes/menu.php:242 14 HelixMenu->genMenuItem() JROOT/plugins/system/helix/core/classes/menu.php:580 13 HelixMenu->genMenuItems() JROOT/plugins/system/helix/core/classes/menu.php:501 12 HelixMenu->genMenu() JROOT/plugins/system/helix/core/classes/menu.php:532 11 HelixMenu->showMenu() JROOT/templates/vina_veneno/features/menu.php:65 10 HelixFeatureMenu->onPosition() JROOT/plugins/system/helix/core/helix.php:225 9 Helix::importFeatures() JROOT/plugins/system/helix/core/helix.php:1173 8 Helix::Header() JROOT/templates/vina_veneno/index.php:32 7 require JROOT/templates/vina_veneno/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.54 ms After last query: 0.41 ms Query memory: 0.029 MB Memory before query: 16.560 MB Rows returned: 0
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image
FROM `veneno_jshopping_categories`
WHERE category_parent_id = '112'
AND category_publish = '1'
AND access IN (1,1)
ORDER BY category_id ascid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_categories ref category_parent_id,category_publish,access,category_publish_2 category_parent_id 4 const 1 100.00 Using where Status Duration starting 0.04 ms Waiting for query cache lock 0.00 ms init 0.00 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sorting result 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.04 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.18 ms Waiting for query cache lock 0.01 ms updating status 0.00 ms storing result in query cache 0.02 ms cleaning up 0.00 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 22 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/category.php:34 21 jshopCategory->getSubCategories() JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20 20 require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97 19 require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135 18 include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190 17 JModuleHelper::renderModule() JROOT/plugins/system/helix/core/classes/menu.php:664 16 HelixMenu->loadModule() JROOT/plugins/system/helix/core/classes/menu.php:259 15 HelixMenu->loadSubContent() JROOT/plugins/system/helix/core/classes/menu.php:242 14 HelixMenu->genMenuItem() JROOT/plugins/system/helix/core/classes/menu.php:580 13 HelixMenu->genMenuItems() JROOT/plugins/system/helix/core/classes/menu.php:501 12 HelixMenu->genMenu() JROOT/plugins/system/helix/core/classes/menu.php:532 11 HelixMenu->showMenu() JROOT/templates/vina_veneno/features/menu.php:65 10 HelixFeatureMenu->onPosition() JROOT/plugins/system/helix/core/helix.php:225 9 Helix::importFeatures() JROOT/plugins/system/helix/core/helix.php:1173 8 Helix::Header() JROOT/templates/vina_veneno/index.php:32 7 require JROOT/templates/vina_veneno/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.36 ms After last query: 0.21 ms Query memory: 0.032 MB Memory before query: 16.596 MB Rows returned: 0
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image
FROM `veneno_jshopping_categories`
WHERE category_parent_id = '112'
AND access IN (1,1)
ORDER BY category_id ascid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE veneno_jshopping_categories ref category_parent_id,access category_parent_id 4 const 1 100.00 Using where Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms init 0.00 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After opening tables 0.00 ms Waiting for query cache lock 0.00 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 24 JDatabaseDriver->loadObjectList() JROOT/components/com_jshopping/tables/category.php:34 23 jshopCategory->getSubCategories() JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71 22 modVinaCMenuJShoppingHelper::getChildCategory() JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117 21 modVinaCMenuJShoppingHelper::getActiveState() JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21 20 require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97 19 require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135 18 include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190 17 JModuleHelper::renderModule() JROOT/plugins/system/helix/core/classes/menu.php:664 16 HelixMenu->loadModule() JROOT/plugins/system/helix/core/classes/menu.php:259 15 HelixMenu->loadSubContent() JROOT/plugins/system/helix/core/classes/menu.php:242 14 HelixMenu->genMenuItem() JROOT/plugins/system/helix/core/classes/menu.php:580 13 HelixMenu->genMenuItems() JROOT/plugins/system/helix/core/classes/menu.php:501 12 HelixMenu->genMenu() JROOT/plugins/system/helix/core/classes/menu.php:532 11 HelixMenu->showMenu() JROOT/templates/vina_veneno/features/menu.php:65 10 HelixFeatureMenu->onPosition() JROOT/plugins/system/helix/core/helix.php:225 9 Helix::importFeatures() JROOT/plugins/system/helix/core/helix.php:1173 8 Helix::Header() JROOT/templates/vina_veneno/index.php:32 7 require JROOT/templates/vina_veneno/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:54 - Query Time: 0.43 ms After last query: 0.17 ms Query memory: 0.029 MB Memory before query: 16.622 MB Rows returned: 0