markdown:
**Đị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
{ "__default": { "session": { "counter": 1, "timer": { "start": 1534439500, "last": 1534439500, "now": 1534439500 }, "token": "F6BVupA3PigK7s5CXUTx1K4j2M2Khnby" }, "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\/n%E1%BB%93i-h%C6%A1i-%C4%91%E1%BB%91t-c%E1%BB%A7i.html&Itemid=Danh%20m%E1%BB%A5c%20s%E1%BA%A3n%20ph%E1%BA%A9m", "jshop_end_page_list_product": "\/san-pham\/n%E1%BB%93i-h%C6%A1i-%C4%91%E1%BB%91t-c%E1%BB%A7i.html&Itemid=Danh%20m%E1%BB%A5c%20s%E1%BA%A3n%20ph%E1%BA%A9m" } }
SELECT `data`
FROM `veneno_session`
WHERE `session_id`
='cll0ucb5ajearnnjv0j55babu1'
|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.17 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.11 ms|
|checking permissions||0.02 ms|
|Opening tables||0.04 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.01 ms|
|After opening tables||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|After opening tables||0.04 ms|
|init||0.05 ms|
|optimizing||0.03 ms|
|statistics||0.07 ms|
|preparing||0.02 ms|
|executing||0.03 ms|
|end||0.02 ms|
|query end||0.02 ms|
|closing tables||0.02 ms|
|freeing items||0.05 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.01 ms|
|storing result in query cache||0.07 ms|
|cleaning up||0.02 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|
SELECT `session_id`
FROM `veneno_session`
WHERE `session_id`
='cll0ucb5ajearnnjv0j55babu1'
LIMIT 1
|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||Using index|
|Status||Duration|
|starting||0.09 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.08 ms|
|checking permissions||0.02 ms|
|Opening tables||0.03 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.01 ms|
|After opening tables||0.01 ms|
|Waiting for query cache lock||0.01 ms|
|After opening tables||0.04 ms|
|init||0.03 ms|
|optimizing||0.02 ms|
|statistics||0.06 ms|
|preparing||0.02 ms|
|executing||0.02 ms|
|end||0.01 ms|
|query end||0.01 ms|
|closing tables||0.02 ms|
|freeing items||0.05 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.01 ms|
|storing result in query cache||0.06 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|
INSERT INTO `veneno_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('cll0ucb5ajearnnjv0j55babu1', 0, 1, '1534439500', 0, '')
|Status||Duration|
|starting||0.09 ms|
|checking permissions||0.02 ms|
|Opening tables||0.02 ms|
|After opening tables||0.01 ms|
|System lock||0.02 ms|
|Table lock||0.01 ms|
|After opening tables||0.01 ms|
|init||0.03 ms|
|update||0.16 ms|
|Waiting for query cache lock||0.02 ms|
|update||0.12 ms|
|end||0.02 ms|
|query end||2.73 ms|
|closing tables||0.05 ms|
|freeing items||0.06 ms|
|updating status||0.03 ms|
|cleaning up||0.02 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|
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
=1
|id||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.17 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.02 ms|
|checking permissions||0.01 ms|
|sending cached result to clien||0.05 ms|
|updating status||0.02 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|
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.11 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.07 ms|
|updating status||0.02 ms|
|cleaning up||0.02 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|
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.lft
|id||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.15 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.14 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|Opening tables||0.04 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.01 ms|
|After opening tables||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|After opening tables||0.05 ms|
|init||0.05 ms|
|optimizing||0.05 ms|
|statistics||0.13 ms|
|preparing||0.08 ms|
|executing||0.02 ms|
|Sorting result||0.21 ms|
|Sending data||0.19 ms|
|Waiting for query cache lock||0.02 ms|
|Sending data||0.11 ms|
|end||0.03 ms|
|query end||0.02 ms|
|closing tables||0.02 ms|
|freeing items||0.06 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.01 ms|
|storing result in query cache||0.26 ms|
|cleaning up||0.11 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|
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.10 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.11 ms|
|checking permissions||0.03 ms|
|Opening tables||0.04 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.02 ms|
|After opening tables||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|After opening tables||0.04 ms|
|init||0.04 ms|
|optimizing||0.03 ms|
|statistics||0.11 ms|
|preparing||0.04 ms|
|executing||0.02 ms|
|Sending data||0.06 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.02 ms|
|freeing items||0.05 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.01 ms|
|storing result in query cache||0.24 ms|
|cleaning up||0.03 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|
UPDATE `veneno_extensions`
SET `params`
='{\"mediaversion\":\"aa1ab4a33c7eb6514634cdbeb49d3f20\"}'
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.22 ms|
|checking permissions||0.02 ms|
|Opening tables||0.03 ms|
|After opening tables||0.02 ms|
|System lock||0.01 ms|
|Table lock||0.01 ms|
|After opening tables||0.01 ms|
|init||0.14 ms|
|updating||0.12 ms|
|end||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|end||0.27 ms|
|query end||2.63 ms|
|closing tables||0.03 ms|
|freeing items||0.06 ms|
|updating status||0.03 ms|
|cleaning up||0.01 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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_config`
|Status||Duration|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|closing tables||0.04 ms|
|executing||0.02 ms|
|Sending data||0.31 ms|
|end||0.03 ms|
|query end||0.03 ms|
|closing tables||0.02 ms|
|removing tmp table||0.32 ms|
|closing tables||0.02 ms|
|freeing items||0.07 ms|
|updating status||0.05 ms|
|cleaning up||0.02 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|
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.14 ms|
|Waiting for query cache lock||0.03 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.03 ms|
|sending cached result to clien||0.15 ms|
|updating status||0.02 ms|
|cleaning up||0.02 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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_currencies`
|Status||Duration|
|starting||0.17 ms|
|checking permissions||0.02 ms|
|closing tables||0.02 ms|
|Opening tables||0.52 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.01 ms|
|After opening tables||0.02 ms|
|init||0.03 ms|
|optimizing||0.03 ms|
|statistics||0.03 ms|
|preparing||0.03 ms|
|executing||0.01 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.04 ms|
|After opening tables||0.02 ms|
|checking permissions||0.16 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|closing tables||0.02 ms|
|executing||0.01 ms|
|Sending data||0.06 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.01 ms|
|removing tmp table||0.24 ms|
|closing tables||0.03 ms|
|freeing items||0.06 ms|
|updating status||0.03 ms|
|cleaning up||0.01 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|
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `veneno_jshopping_currencies`
WHERE currency_publish
='1'
ORDER BY currency_ordering
|id||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.07 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.06 ms|
|updating status||0.02 ms|
|cleaning up||0.02 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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_users`
|Status||Duration|
|starting||0.14 ms|
|checking permissions||0.02 ms|
|closing tables||0.01 ms|
|Opening tables||0.48 ms|
|After opening tables||0.02 ms|
|System lock||0.01 ms|
|Table lock||0.01 ms|
|After opening tables||0.02 ms|
|init||0.02 ms|
|optimizing||0.02 ms|
|statistics||0.03 ms|
|preparing||0.04 ms|
|executing||0.03 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.03 ms|
|After opening tables||0.03 ms|
|checking permissions||0.16 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|closing tables||0.03 ms|
|executing||0.02 ms|
|Sending data||0.16 ms|
|end||0.03 ms|
|query end||0.02 ms|
|closing tables||0.02 ms|
|removing tmp table||0.21 ms|
|closing tables||0.02 ms|
|freeing items||0.06 ms|
|updating status||0.04 ms|
|cleaning up||0.02 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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_users`
|Status||Duration|
|starting||0.14 ms|
|checking permissions||0.03 ms|
|closing tables||0.02 ms|
|Opening tables||0.48 ms|
|After opening tables||0.03 ms|
|System lock||0.02 ms|
|Table lock||0.02 ms|
|After opening tables||0.02 ms|
|init||0.04 ms|
|optimizing||0.03 ms|
|statistics||0.04 ms|
|preparing||0.04 ms|
|executing||0.03 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.03 ms|
|After opening tables||0.03 ms|
|checking permissions||0.14 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|closing tables||0.03 ms|
|executing||0.02 ms|
|Sending data||0.14 ms|
|end||0.03 ms|
|query end||0.02 ms|
|closing tables||0.02 ms|
|removing tmp table||0.22 ms|
|closing tables||0.02 ms|
|freeing items||0.06 ms|
|updating status||0.03 ms|
|cleaning up||0.01 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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_usergroups`
|Status||Duration|
|starting||0.16 ms|
|checking permissions||0.03 ms|
|closing tables||0.02 ms|
|Opening tables||0.40 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.02 ms|
|After opening tables||0.02 ms|
|init||0.03 ms|
|optimizing||0.02 ms|
|statistics||0.03 ms|
|preparing||0.03 ms|
|executing||0.01 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.02 ms|
|After opening tables||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|closing tables||0.03 ms|
|executing||0.02 ms|
|Sending data||0.06 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.02 ms|
|removing tmp table||0.21 ms|
|closing tables||0.02 ms|
|freeing items||0.06 ms|
|updating status||0.03 ms|
|cleaning up||0.01 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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_config_display_prices`
|Status||Duration|
|starting||0.09 ms|
|checking permissions||0.02 ms|
|closing tables||0.01 ms|
|Opening tables||0.17 ms|
|After opening tables||0.02 ms|
|System lock||0.01 ms|
|Table lock||0.01 ms|
|After opening tables||0.01 ms|
|init||0.02 ms|
|optimizing||0.02 ms|
|statistics||0.02 ms|
|preparing||0.02 ms|
|executing||0.01 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.02 ms|
|After opening tables||0.01 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|closing tables||0.02 ms|
|executing||0.01 ms|
|Sending data||0.03 ms|
|end||0.02 ms|
|query end||0.02 ms|
|closing tables||0.01 ms|
|removing tmp table||0.07 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|
|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|
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.04 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.06 ms|
|updating status||0.03 ms|
|cleaning up||0.02 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|
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.06 ms|
|Waiting for query cache lock||0.03 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.05 ms|
|updating status||0.02 ms|
|cleaning up||0.02 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|
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.06 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.06 ms|
|updating status||0.02 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/lib/factory.php:242|
|11||JSFactory::getAliasCategory()||JROOT/components/com_jshopping/router.php:287|
|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|
select
*
from veneno_jshopping_languages
|id||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.19 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.05 ms|
|updating status||0.02 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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_categories`
|Status||Duration|
|starting||0.22 ms|
|checking permissions||0.02 ms|
|closing tables||0.01 ms|
|Opening tables||0.39 ms|
|After opening tables||0.03 ms|
|System lock||0.02 ms|
|Table lock||0.02 ms|
|After opening tables||0.02 ms|
|init||0.02 ms|
|optimizing||0.02 ms|
|statistics||0.03 ms|
|preparing||0.04 ms|
|executing||0.02 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.02 ms|
|After opening tables||0.02 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|closing tables||0.02 ms|
|executing||0.01 ms|
|Sending data||0.06 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.01 ms|
|removing tmp table||0.14 ms|
|closing tables||0.02 ms|
|freeing items||0.05 ms|
|updating status||0.03 ms|
|cleaning up||0.02 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/category.php:56|
|8||JshoppingControllerCategory->view()||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|
SELECT
*
FROM veneno_jshopping_categories
WHERE `category_id`
='1'
|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.06 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.05 ms|
|updating status||0.02 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/category.php:57|
|8||JshoppingControllerCategory->view()||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|
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 ordering asc
|id||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; Using filesort|
|Status||Duration|
|starting||0.16 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.05 ms|
|updating status||0.02 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/category.php:34|
|10||jshopCategory->getSubCategories()||JROOT/components/com_jshopping/tables/category.php:119|
|9||jshopCategory->getChildCategories()||JROOT/components/com_jshopping/controllers/category.php:66|
|8||JshoppingControllerCategory->view()||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|
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.06 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.06 ms|
|updating status||0.03 ms|
|cleaning up||0.02 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:38|
|9||JshopHelpersMetadata::category()||JROOT/components/com_jshopping/controllers/category.php:69|
|8||JshoppingControllerCategory->view()||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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_vendors`
|Status||Duration|
|starting||0.19 ms|
|checking permissions||0.02 ms|
|closing tables||0.02 ms|
|Opening tables||0.43 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.02 ms|
|After opening tables||0.02 ms|
|init||0.03 ms|
|optimizing||0.03 ms|
|statistics||0.05 ms|
|preparing||0.05 ms|
|executing||0.02 ms|
|Filling schema table||0.03 ms|
|Opening tables||0.03 ms|
|After opening tables||0.02 ms|
|checking permissions||0.07 ms|
|checking permissions||0.05 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|closing tables||0.03 ms|
|executing||0.02 ms|
|Sending data||0.12 ms|
|end||0.02 ms|
|query end||0.02 ms|
|closing tables||0.02 ms|
|removing tmp table||0.13 ms|
|closing tables||0.02 ms|
|freeing items||0.07 ms|
|updating status||0.03 ms|
|cleaning up||0.02 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/vendor.php:15|
|15||jshopVendor->__construct()||JROOT/libraries/joomla/table/table.php:308|
|14||JTable::getInstance()||JROOT/components/com_jshopping/lib/factory.php:600|
|13||JSFactory::getTable()||JROOT/components/com_jshopping/lib/factory.php:414|
|12||JSFactory::getMainVendor()||JROOT/components/com_jshopping/lib/functions.php:1409|
|11||getBuildFilterListProduct()||JROOT/components/com_jshopping/tables/category.php:304|
|10||jshopCategory->getFilterListProduct()||JROOT/components/com_jshopping/models/productlist.php:168|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
SELECT id
FROM veneno_jshopping_vendors
WHERE `main`
=1
|id||select_type||table||type||possible_keys||key||key_len||ref||rows||filtered||Extra|
|1||SIMPLE||veneno_jshopping_vendors||ref||main|main |1||const||1||100.00||Using index|
|Status||Duration|
|starting||0.06 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.01 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.04 ms|
|updating status||0.02 ms|
|cleaning up||0.01 ms|
|#||Caller||File and line number|
|15||JDatabaseDriverMysqli->execute()||JROOT/libraries/joomla/database/driver.php:1728|
|14||JDatabaseDriver->loadResult()||JROOT/components/com_jshopping/tables/vendor.php:23|
|13||jshopVendor->loadMain()||JROOT/components/com_jshopping/lib/factory.php:415|
|12||JSFactory::getMainVendor()||JROOT/components/com_jshopping/lib/functions.php:1409|
|11||getBuildFilterListProduct()||JROOT/components/com_jshopping/tables/category.php:304|
|10||jshopCategory->getFilterListProduct()||JROOT/components/com_jshopping/models/productlist.php:168|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
SELECT
*
FROM veneno_jshopping_vendors
WHERE `id`
='1'
|id||select_type||table||type||possible_keys||key||key_len||ref||rows||filtered||Extra|
|1||SIMPLE||veneno_jshopping_vendors||const||PRIMARY|PRIMARY |4||const||1||100.00|
|Status||Duration|
|starting||0.05 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.05 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:1453|
|15||JDatabaseDriver->loadAssoc()||JROOT/libraries/joomla/table/table.php:719|
|14||JTable->load()||JROOT/components/com_jshopping/tables/vendor.php:24|
|13||jshopVendor->loadMain()||JROOT/components/com_jshopping/lib/factory.php:415|
|12||JSFactory::getMainVendor()||JROOT/components/com_jshopping/lib/functions.php:1409|
|11||getBuildFilterListProduct()||JROOT/components/com_jshopping/tables/category.php:304|
|10||jshopCategory->getFilterListProduct()||JROOT/components/com_jshopping/models/productlist.php:168|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_products_extra_fields`
|Status||Duration|
|starting||0.11 ms|
|checking permissions||0.02 ms|
|closing tables||0.01 ms|
|Opening tables||0.41 ms|
|After opening tables||0.02 ms|
|System lock||0.01 ms|
|Table lock||0.01 ms|
|After opening tables||0.01 ms|
|init||0.03 ms|
|optimizing||0.03 ms|
|statistics||0.03 ms|
|preparing||0.03 ms|
|executing||0.01 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.02 ms|
|After opening tables||0.01 ms|
|checking permissions||0.04 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|closing tables||0.02 ms|
|executing||0.02 ms|
|Sending data||0.07 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.01 ms|
|removing tmp table||0.19 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|
|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/productfield.php:14|
|16||jshopProductField->__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:475|
|13||JSFactory::getAllProductExtraField()||JROOT/components/com_jshopping/lib/functions.php:1098|
|12||getQueryListProductsExtraFields()||JROOT/components/com_jshopping/lib/jtableauto.php:37|
|11||JTableAvto->getBuildQueryListProduct()||JROOT/components/com_jshopping/tables/category.php:178|
|10||jshopCategory->getCountProducts()||JROOT/components/com_jshopping/models/productlist.php:172|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
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.ordering
|id||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.05 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.01 ms|
|checking permissions||0.01 ms|
|sending cached result to clien||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/components/com_jshopping/tables/productfield.php:48|
|14||jshopProductField->getList()||JROOT/components/com_jshopping/lib/factory.php:476|
|13||JSFactory::getAllProductExtraField()||JROOT/components/com_jshopping/lib/functions.php:1098|
|12||getQueryListProductsExtraFields()||JROOT/components/com_jshopping/lib/jtableauto.php:37|
|11||JTableAvto->getBuildQueryListProduct()||JROOT/components/com_jshopping/tables/category.php:178|
|10||jshopCategory->getCountProducts()||JROOT/components/com_jshopping/models/productlist.php:172|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_taxes`
|Status||Duration|
|starting||0.08 ms|
|checking permissions||0.02 ms|
|closing tables||0.01 ms|
|Opening tables||0.16 ms|
|After opening tables||0.02 ms|
|System lock||0.01 ms|
|Table lock||0.01 ms|
|After opening tables||0.01 ms|
|init||0.02 ms|
|optimizing||0.02 ms|
|statistics||0.02 ms|
|preparing||0.02 ms|
|executing||0.02 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.02 ms|
|After opening tables||0.01 ms|
|checking permissions||0.12 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|closing tables||0.03 ms|
|executing||0.02 ms|
|Sending data||0.04 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.01 ms|
|removing tmp table||0.17 ms|
|closing tables||0.02 ms|
|freeing items||0.07 ms|
|updating status||0.03 ms|
|cleaning up||0.02 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/tax.php:14|
|17||jshopTax->__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:342|
|14||JSFactory::getAllTaxes()||JROOT/components/com_jshopping/lib/functions.php:955|
|13||getCorrectedPriceForQueryFilter()||JROOT/components/com_jshopping/lib/jtableauto.php:101|
|12||JTableAvto->getBuildQueryListProductFilterPrice()||JROOT/components/com_jshopping/lib/jtableauto.php:88|
|11||JTableAvto->getBuildQueryListProduct()||JROOT/components/com_jshopping/tables/category.php:178|
|10||jshopCategory->getCountProducts()||JROOT/components/com_jshopping/models/productlist.php:172|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
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.08 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.09 ms|
|updating status||0.02 ms|
|cleaning up||0.01 ms|
|#||Caller||File and line number|
|18||JDatabaseDriverMysqli->execute()||JROOT/libraries/joomla/database/driver.php:1689|
|17||JDatabaseDriver->loadObjectList()||JROOT/components/com_jshopping/tables/tax.php:21|
|16||jshopTax->getAllTaxes()||JROOT/components/com_jshopping/lib/factory.php:328|
|15||JSFactory::getAllTaxesOriginal()||JROOT/components/com_jshopping/lib/factory.php:343|
|14||JSFactory::getAllTaxes()||JROOT/components/com_jshopping/lib/functions.php:955|
|13||getCorrectedPriceForQueryFilter()||JROOT/components/com_jshopping/lib/jtableauto.php:101|
|12||JTableAvto->getBuildQueryListProductFilterPrice()||JROOT/components/com_jshopping/lib/jtableauto.php:88|
|11||JTableAvto->getBuildQueryListProduct()||JROOT/components/com_jshopping/tables/category.php:178|
|10||jshopCategory->getCountProducts()||JROOT/components/com_jshopping/models/productlist.php:172|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
SELECT count(
*)
FROM `veneno_jshopping_products_to_categories` AS pr_cat
INNER JOIN `veneno_jshopping_products` AS prod
ON pr_cat.product_id
=prod.product_id
WHERE pr_cat.category_id
='1'
AND prod.product_publish
='1'
AND prod.access IN (1,1)
|id||select_type||table||type||possible_keys||key||key_len||ref||rows||filtered||Extra|
|1||SIMPLE||pr_cat||ref||PRIMARY,category_id,product_id,product_id_2|category_id |4||const||1||100.00||Using index|
|1||SIMPLE||prod||eq_ref||PRIMARY,product_publish,access|PRIMARY |4||grlnwmxyhosting_thaibinh.pr_cat.product_id||1||100.00||Using where|
|Status||Duration|
|starting||0.05 ms|
|Waiting for query cache lock||0.03 ms|
|init||0.02 ms|
|checking query cache for query||0.13 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|Opening tables||0.04 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.03 ms|
|After opening tables||0.02 ms|
|Waiting for query cache lock||0.02 ms|
|After opening tables||0.05 ms|
|init||0.06 ms|
|optimizing||0.04 ms|
|statistics||0.12 ms|
|preparing||0.04 ms|
|executing||0.03 ms|
|Sending data||0.08 ms|
|end||0.02 ms|
|query end||0.02 ms|
|closing tables||0.02 ms|
|freeing items||0.07 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.02 ms|
|updating status||0.05 ms|
|Waiting for query cache lock||0.02 ms|
|updating status||0.02 ms|
|storing result in query cache||0.02 ms|
|cleaning up||0.02 ms|
|#||Caller||File and line number|
|12||JDatabaseDriverMysqli->execute()||JROOT/libraries/joomla/database/driver.php:1728|
|11||JDatabaseDriver->loadResult()||JROOT/components/com_jshopping/tables/category.php:188|
|10||jshopCategory->getCountProducts()||JROOT/components/com_jshopping/models/productlist.php:172|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
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` AS prod
LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat USING (product_id)
WHERE pr_cat.category_id
='1'
AND prod.product_publish
='1'
AND prod.access IN (1,1)
ORDER BY pr_cat.product_ordering ASC
LIMIT 0, 12
|id||select_type||table||type||possible_keys||key||key_len||ref||rows||filtered||Extra|
|1||SIMPLE||pr_cat||ref||PRIMARY,category_id,product_id,product_id_2|category_id |4||const||1||100.00||Using where; Using filesort|
|1||SIMPLE||prod||eq_ref||PRIMARY,product_publish,access|PRIMARY |4||grlnwmxyhosting_thaibinh.pr_cat.product_id||1||100.00||Using where|
|Status||Duration|
|starting||0.07 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.12 ms|
|checking permissions||0.02 ms|
|checking permissions||0.01 ms|
|Opening tables||0.02 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.02 ms|
|After opening tables||0.02 ms|
|Waiting for query cache lock||0.02 ms|
|After opening tables||0.05 ms|
|init||0.09 ms|
|optimizing||0.05 ms|
|statistics||0.14 ms|
|preparing||0.06 ms|
|executing||0.02 ms|
|Sorting result||0.09 ms|
|Sending data||0.10 ms|
|end||0.02 ms|
|query end||0.02 ms|
|closing tables||0.02 ms|
|freeing items||0.08 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.03 ms|
|Waiting for query cache lock||0.02 ms|
|updating status||0.02 ms|
|storing result in query cache||0.02 ms|
|cleaning up||0.02 ms|
|#||Caller||File and line number|
|12||JDatabaseDriverMysqli->execute()||JROOT/libraries/joomla/database/driver.php:1689|
|11||JDatabaseDriver->loadObjectList()||JROOT/components/com_jshopping/tables/category.php:170|
|10||jshopCategory->getProducts()||JROOT/components/com_jshopping/models/productlist.php:185|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_products_extra_field_values`
|Status||Duration|
|starting||0.11 ms|
|checking permissions||0.02 ms|
|closing tables||0.01 ms|
|Opening tables||0.24 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.01 ms|
|After opening tables||0.01 ms|
|init||0.02 ms|
|optimizing||0.02 ms|
|statistics||0.02 ms|
|preparing||0.02 ms|
|executing||0.01 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.03 ms|
|After opening tables||0.02 ms|
|checking permissions||0.15 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|closing tables||0.03 ms|
|executing||0.02 ms|
|Sending data||0.04 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.01 ms|
|removing tmp table||0.19 ms|
|closing tables||0.02 ms|
|freeing items||0.05 ms|
|updating status||0.03 ms|
|cleaning up||0.02 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/productfieldvalue.php:15|
|16||jshopProductFieldValue->__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:484|
|13||JSFactory::getAllProductExtraFieldValue()||JROOT/components/com_jshopping/lib/functions.php:787|
|12||getProductExtraFieldForProduct()||JROOT/components/com_jshopping/lib/functions.php:712|
|11||listProductUpdateData()||JROOT/components/com_jshopping/tables/category.php:171|
|10||jshopCategory->getProducts()||JROOT/components/com_jshopping/models/productlist.php:185|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
SELECT id, `name_vi-VN` as name, field_id
FROM `veneno_jshopping_products_extra_field_values`
order by ordering
|id||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.05 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||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/components/com_jshopping/tables/productfieldvalue.php:26|
|14||jshopProductFieldValue->getAllList()||JROOT/components/com_jshopping/lib/factory.php:485|
|13||JSFactory::getAllProductExtraFieldValue()||JROOT/components/com_jshopping/lib/functions.php:787|
|12||getProductExtraFieldForProduct()||JROOT/components/com_jshopping/lib/functions.php:712|
|11||listProductUpdateData()||JROOT/components/com_jshopping/tables/category.php:171|
|10||jshopCategory->getProducts()||JROOT/components/com_jshopping/models/productlist.php:185|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_product_labels`
|Status||Duration|
|starting||0.08 ms|
|checking permissions||0.02 ms|
|closing tables||0.01 ms|
|Opening tables||0.27 ms|
|After opening tables||0.03 ms|
|System lock||0.02 ms|
|Table lock||0.02 ms|
|After opening tables||0.02 ms|
|init||0.02 ms|
|optimizing||0.02 ms|
|statistics||0.02 ms|
|preparing||0.02 ms|
|executing||0.01 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.02 ms|
|After opening tables||0.02 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|closing tables||0.02 ms|
|executing||0.01 ms|
|Sending data||0.04 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.01 ms|
|removing tmp table||0.17 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|
|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/productlabel.php:14|
|15||jshopProductLabel->__construct()||JROOT/libraries/joomla/table/table.php:308|
|14||JTable::getInstance()||JROOT/components/com_jshopping/lib/factory.php:600|
|13||JSFactory::getTable()||JROOT/components/com_jshopping/lib/functions.php:616|
|12||getNameImageLabel()||JROOT/components/com_jshopping/lib/functions.php:751|
|11||listProductUpdateData()||JROOT/components/com_jshopping/tables/category.php:171|
|10||jshopCategory->getProducts()||JROOT/components/com_jshopping/models/productlist.php:185|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
SELECT id, image, `name_vi-VN` as name
FROM `veneno_jshopping_product_labels`
ORDER BY name
|id||select_type||table||type||possible_keys||key||key_len||ref||rows||filtered||Extra|
|1||SIMPLE||veneno_jshopping_product_labels||ALL||NULL|NO INDEX KEY COULD BE USED |NULL||NULL||3||100.00||Using filesort|
|Status||Duration|
|starting||0.05 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.01 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.01 ms|
|sending cached result to clien||0.04 ms|
|updating status||0.02 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/components/com_jshopping/tables/productlabel.php:22|
|13||jshopProductLabel->getListLabels()||JROOT/components/com_jshopping/lib/functions.php:617|
|12||getNameImageLabel()||JROOT/components/com_jshopping/lib/functions.php:751|
|11||listProductUpdateData()||JROOT/components/com_jshopping/tables/category.php:171|
|10||jshopCategory->getProducts()||JROOT/components/com_jshopping/models/productlist.php:185|
|9||jshopProductList->load()||JROOT/components/com_jshopping/controllers/category.php:73|
|8||JshoppingControllerCategory->view()||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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_products_reviews`
|Status||Duration|
|starting||0.11 ms|
|checking permissions||0.02 ms|
|closing tables||0.01 ms|
|Opening tables||0.30 ms|
|After opening tables||0.02 ms|
|System lock||0.01 ms|
|Table lock||0.01 ms|
|After opening tables||0.02 ms|
|init||0.02 ms|
|optimizing||0.02 ms|
|statistics||0.02 ms|
|preparing||0.03 ms|
|executing||0.02 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.02 ms|
|After opening tables||0.02 ms|
|checking permissions||0.11 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|closing tables||0.02 ms|
|executing||0.02 ms|
|Sending data||0.06 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.01 ms|
|removing tmp table||0.11 ms|
|closing tables||0.02 ms|
|freeing items||0.07 ms|
|updating status||0.03 ms|
|cleaning up||0.03 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/productlist.php:252|
|9||jshopProductList->getAllowReview()||JROOT/components/com_jshopping/controllers/category.php:87|
|8||JshoppingControllerCategory->view()||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|
SHOW FULL COLUMNS
FROM `veneno_jshopping_products`
|Status||Duration|
|starting||0.20 ms|
|checking permissions||0.02 ms|
|closing tables||0.01 ms|
|Opening tables||0.37 ms|
|After opening tables||0.03 ms|
|System lock||0.02 ms|
|Table lock||0.02 ms|
|After opening tables||0.02 ms|
|init||0.03 ms|
|optimizing||0.02 ms|
|statistics||0.03 ms|
|preparing||0.03 ms|
|executing||0.01 ms|
|Filling schema table||0.02 ms|
|Opening tables||0.04 ms|
|After opening tables||0.02 ms|
|checking permissions||0.10 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.04 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.03 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|checking permissions||0.02 ms|
|closing tables||0.03 ms|
|executing||0.02 ms|
|Sending data||0.10 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.01 ms|
|removing tmp table||0.21 ms|
|closing tables||0.02 ms|
|freeing items||0.08 ms|
|updating status||0.04 ms|
|cleaning up||0.02 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/product.php:15|
|17||jshopProduct->__construct()||JROOT/libraries/joomla/table/table.php:308|
|16||JTable::getInstance()||JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:10|
|15||include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php||JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18|
|14||include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php||JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16|
|13||include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php||JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47|
|12||include JROOT/templates/vina_veneno/html/com_jshopping/category/category_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/category/view.html.php:13|
|9||JshoppingViewCategory->display()||JROOT/components/com_jshopping/controllers/category.php:121|
|8||JshoppingControllerCategory->view()||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|
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
='357'
ORDER BY sort, I.ordering
|id||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.06 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.02 ms|
|checking permissions||0.01 ms|
|sending cached result to clien||0.04 ms|
|updating status||0.02 ms|
|cleaning up||0.01 ms|
|#||Caller||File and line number|
|18||JDatabaseDriverMysqli->execute()||JROOT/libraries/joomla/database/driver.php:1689|
|17||JDatabaseDriver->loadObjectList()||JROOT/components/com_jshopping/tables/product.php:333|
|16||jshopProduct->getImages()||JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12|
|15||include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php||JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18|
|14||include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php||JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16|
|13||include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php||JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47|
|12||include JROOT/templates/vina_veneno/html/com_jshopping/category/category_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/category/view.html.php:13|
|9||JshoppingViewCategory->display()||JROOT/components/com_jshopping/controllers/category.php:121|
|8||JshoppingControllerCategory->view()||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|
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-08-16 17:11:40')
AND (m.publish_down
='0000-00-00 00:00:00' OR m.publish_down > ='2018-08-16 17:11:40')
AND m.access IN (1,1)
AND m.client_id
=0
ORDER BY position, ordering
|id||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.15 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.19 ms|
|checking permissions||0.03 ms|
|Opening tables||0.04 ms|
|After opening tables||0.02 ms|
|System lock||0.02 ms|
|Table lock||0.02 ms|
|After opening tables||0.02 ms|
|Waiting for query cache lock||0.02 ms|
|After opening tables||0.06 ms|
|init||0.06 ms|
|optimizing||0.05 ms|
|statistics||0.09 ms|
|preparing||0.04 ms|
|executing||0.02 ms|
|Sending data||0.03 ms|
|end||0.02 ms|
|query end||0.01 ms|
|closing tables||0.02 ms|
|freeing items||0.06 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.02 ms|
|Waiting for query cache lock||0.01 ms|
|updating status||0.01 ms|
|storing result in query cache||0.02 ms|
|cleaning up||0.01 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|
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 asc
|id||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.08 ms|
|Waiting for query cache lock||0.03 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.07 ms|
|updating status||0.02 ms|
|cleaning up||0.02 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|
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 asc
|id||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.09 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.07 ms|
|updating status||0.02 ms|
|cleaning up||0.02 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|
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 asc
|id||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.07 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.06 ms|
|updating status||0.02 ms|
|cleaning up||0.03 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|
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 asc
|id||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.07 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.03 ms|
|sending cached result to clien||0.06 ms|
|updating status||0.03 ms|
|cleaning up||0.02 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|
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 asc
|id||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.06 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.06 ms|
|updating status||0.02 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|
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
='113'
AND category_publish
='1'
AND access IN (1,1)
ORDER BY category_id asc
|id||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.07 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.01 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.01 ms|
|sending cached result to clien||0.04 ms|
|updating status||0.02 ms|
|cleaning up||0.01 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|
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
='113'
AND access IN (1,1)
ORDER BY category_id asc
|id||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.05 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.06 ms|
|updating status||0.02 ms|
|cleaning up||0.02 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|
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
='134'
AND category_publish
='1'
AND access IN (1,1)
ORDER BY category_id asc
|id||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.07 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.01 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.06 ms|
|updating status||0.02 ms|
|cleaning up||0.02 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|
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
='134'
AND access IN (1,1)
ORDER BY category_id asc
|id||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.06 ms|
|Waiting for query cache lock||0.03 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.05 ms|
|updating status||0.02 ms|
|cleaning up||0.02 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|
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
='135'
AND category_publish
='1'
AND access IN (1,1)
ORDER BY category_id asc
|id||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.02 ms|
|init||0.01 ms|
|checking query cache for query||0.01 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.01 ms|
|sending cached result to clien||0.04 ms|
|updating status||0.02 ms|
|cleaning up||0.01 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|
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
='135'
AND access IN (1,1)
ORDER BY category_id asc
|id||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.01 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.01 ms|
|checking permissions||0.01 ms|
|sending cached result to clien||0.04 ms|
|updating status||0.02 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|
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
='136'
AND category_publish
='1'
AND access IN (1,1)
ORDER BY category_id asc
|id||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.06 ms|
|Waiting for query cache lock||0.02 ms|
|init||0.02 ms|
|checking query cache for query||0.02 ms|
|checking privileges on cached||0.02 ms|
|checking permissions||0.02 ms|
|sending cached result to clien||0.06 ms|
|updating status||0.03 ms|
|cleaning up||0.02 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|

Set-Cookie: cip_vvisitcounter=NTQuMTk4LjI3LjI0Mw%3D%3D; expires=Thu, 16-Aug-2018 17:26:40 GMT; Max-Age=900

P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"

Cache-Control: max-age=0, private, no-store, no-cache, must-revalidate

Accept-Ranges: bytes

Server: LiteSpeed