Thuốc an thần

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1614491098,
                "last": 1614491098,
                "now": 1614491098
            },
            "client": {
                "forwarded": "3.238.7.202"
            },
            "token": "i3a6ryU1eaHfA2g9SDGduanRZd25VFvQ"
        },
        "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": "\/thuc-pham-bao-ve-suc-khoe\/thuoc-an-than.html&Itemid=Danh%20m%E1%BB%A5c%20s%E1%BA%A3n%20ph%E1%BA%A9m",
        "jshop_end_page_list_product": "\/thuc-pham-bao-ve-suc-khoe\/thuoc-an-than.html&Itemid=Danh%20m%E1%BB%A5c%20s%E1%BA%A3n%20ph%E1%BA%A9m"
    }
}

Profile Information

Time

Memory

Time: 46.93 ms / 46.93 ms Memory: 0.788 MB / 1.01 MB Application: afterLoad

Time: 220.18 ms / 267.11 ms Memory: 2.532 MB / 3.55 MB Application: afterInitialise

Time: 103.08 ms / 370.19 ms Memory: 1.664 MB / 5.21 MB Application: afterRoute

Time: 1.91 ms / 372.10 ms Memory: 0.049 MB / 5.26 MB Application: beforeRenderComponent com_jshopping

Time: 117.14 ms / 489.24 ms Memory: 1.277 MB / 6.54 MB Application: afterRenderComponent com_jshopping

Time: 7.15 ms / 496.39 ms Memory: 0.142 MB / 6.68 MB Application: afterDispatch

Time: 85.20 ms / 581.59 ms Memory: 0.973 MB / 7.65 MB Application: beforeRenderModule mod_vvisit_counter (Thống kê truy cập)

Time: 44.15 ms / 625.74 ms Memory: 0.495 MB / 8.15 MB Application: afterRenderModule mod_vvisit_counter (Thống kê truy cập)

Time: 0.24 ms / 625.99 ms Memory: 0.000 MB / 8.09 MB Application: beforeRenderModule mod_menu (Hỗ trợ mua hàng)

Time: 5.81 ms / 631.80 ms Memory: 0.065 MB / 8.15 MB Application: afterRenderModule mod_menu (Hỗ trợ mua hàng)

Time: 0.21 ms / 632.01 ms Memory: 0.000 MB / 8.14 MB Application: beforeRenderModule mod_menu (THÔNG TIN Y DƯỢC)

Time: 3.68 ms / 635.69 ms Memory: 0.043 MB / 8.19 MB Application: afterRenderModule mod_menu (THÔNG TIN Y DƯỢC)

Time: 0.18 ms / 635.87 ms Memory: 0.000 MB / 8.18 MB Application: beforeRenderModule mod_custom (Liên hệ mua hàng)

Time: 1.93 ms / 637.80 ms Memory: 0.012 MB / 8.19 MB Application: afterRenderModule mod_custom (Liên hệ mua hàng)

Time: 0.13 ms / 637.93 ms Memory: 0.000 MB / 8.19 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 3.17 ms / 641.10 ms Memory: 0.022 MB / 8.21 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.11 ms / 641.21 ms Memory: 0.000 MB / 8.21 MB Application: beforeRenderModule mod_vina_cmenu_jshopping (Danh Mục Sản Phẩm -MOBILE)

Time: 30.21 ms / 671.42 ms Memory: 1.403 MB / 9.61 MB Application: afterRenderModule mod_vina_cmenu_jshopping (Danh Mục Sản Phẩm -MOBILE)

Time: 0.21 ms / 671.63 ms Memory: 0.000 MB / 9.57 MB Application: beforeRenderModule mod_jshopping_cart_ext (Mini Cart)

Time: 8.24 ms / 679.87 ms Memory: 0.060 MB / 9.63 MB Application: afterRenderModule mod_jshopping_cart_ext (Mini Cart)

Time: 0.13 ms / 680.00 ms Memory: 0.000 MB / 9.62 MB Application: beforeRenderModule mod_jshopping_ajaxsearch (JoomShopping Search plus)

Time: 3.79 ms / 683.79 ms Memory: 0.078 MB / 9.70 MB Application: afterRenderModule mod_jshopping_ajaxsearch (JoomShopping Search plus)

Time: 0.18 ms / 683.97 ms Memory: 0.000 MB / 9.68 MB Application: beforeRenderModule mod_menu (Menu trên đầu trang chủ)

Time: 2.50 ms / 686.47 ms Memory: 0.037 MB / 9.71 MB Application: afterRenderModule mod_menu (Menu trên đầu trang chủ)

Time: 0.10 ms / 686.57 ms Memory: 0.000 MB / 9.71 MB Application: beforeRenderModule mod_custom (Số điện thoại menu top)

Time: 0.56 ms / 687.13 ms Memory: 0.007 MB / 9.71 MB Application: afterRenderModule mod_custom (Số điện thoại menu top)

Time: 10.73 ms / 697.85 ms Memory: 0.128 MB / 9.84 MB Application: afterRender

Database queries total: 72.39 ms

Memory Usage

Database Queries

115 Queries Logged 72.39 ms

22 duplicate found!

2 duplicates: #16 #17

2 duplicates: #59 #64

2 duplicates: #60 #66

2 duplicates: #61 #68

2 duplicates: #62 #70

2 duplicates: #73 #76

2 duplicates: #74 #78

2 duplicates: #81 #84

2 duplicates: #82 #86

2 duplicates: #93 #96

2 duplicates: #94 #98

Query Time: 0.47 ms

SELECT `data`

  FROM `veneno_session`

  WHERE `session_id` = 'e0ulh745nmrcqasr3mifck1t31'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_session	const	PRIMARY	PRIMARY	766	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.40 ms After last query: 3.88 ms

SELECT `session_id`

  FROM `veneno_session`

  WHERE `session_id` = 'e0ulh745nmrcqasr3mifck1t31' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_session	const	PRIMARY	PRIMARY	766	const	1	Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.49 ms After last query: 0.18 ms

INSERT INTO `veneno_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('e0ulh745nmrcqasr3mifck1t31', 1, '1614491098', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `veneno_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('e0ulh745nmrcqasr3mifck1t31', 1, '1614491098', 0, '', 0)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.89 ms After last query: 7.40 ms

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `veneno_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_extensions	ref	extension	extension	82	const	36	Using index condition

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:431
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.15 ms After last query: 6.93 ms

SELECT id, rules

  FROM `veneno_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1496
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.12 ms After last query: 0.16 ms

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 2.44 ms After last query: 1.45 ms

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM veneno_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_extensions	ref	extension	extension	82	const	111	Using index condition; Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.73 ms After last query: 24.24 ms

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `veneno_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/backup/backup.php:4
7	require_once JROOT/plugins/system/backup/backup.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.60 ms After last query: 0.30 ms

UPDATE `veneno_extensions`

  SET `params` = '{\"mediaversion\":\"fc8a5c2b0dfb0a76ff2025eeec8cb9d9\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN not possible on query: UPDATE `veneno_extensions` SET `params` = '{\"mediaversion\":\"fc8a5c2b0dfb0a76ff2025eeec8cb9d9\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/backup/backup.php:4
7	require_once JROOT/plugins/system/backup/backup.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 4.11 ms After last query: 82.74 ms

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	172	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	duocphaph_1.m.component_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
24	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
22	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
21	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
20	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
19	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
18	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
17	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
16	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:436
15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
14	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
13	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
12	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
11	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
10	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
9	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.18 ms After last query: 2.70 ms

SELECT id, home, template, s.params

  FROM veneno_template_styles as s

  LEFT JOIN veneno_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
14	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
13	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
12	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
11	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
10	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
9	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 2.89 ms After last query: 92.80 ms

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_config`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.29 ms After last query: 9.64 ms

SELECT *

  FROM veneno_jshopping_config

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_config	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
15	Joomla\CMS\Table\Table->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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.98 ms After last query: 1.89 ms

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_currencies`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_currencies`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
19	jshopCurrency->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.11 ms After last query: 0.17 ms

SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `veneno_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_currencies	system	currency_publish	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.68 ms After last query: 2.88 ms

Duplicate queries: #17

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_users`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.27 ms After last query: 0.97 ms

Duplicate queries: #16

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_users`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.77 ms After last query: 1.18 ms

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_usergroups`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_usergroups`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
22	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/usergroup.php:14
21	jshopUserGroup->__construct()	JROOT/libraries/src/Table/Table.php:312
20	Joomla\CMS\Table\Table::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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.77 ms After last query: 1.10 ms

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config_display_prices`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_config_display_prices`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/configdisplayprice.php:19
19	jshopConfigDisplayPrice->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.11 ms After last query: 0.18 ms

SELECT * 
  FROM `veneno_jshopping_config_display_prices`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_config_display_prices	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.60 ms After last query: 5.48 ms

select product_id as id, `alias_vi-VN` as alias 
  from veneno_jshopping_products 
  where `alias_vi-VN`!=''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_products	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	65	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/router.php:216
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.12 ms After last query: 0.23 ms

select category_id as id, `alias_vi-VN` as alias 
  from veneno_jshopping_categories 
  where `alias_vi-VN`!=''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_categories	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	24	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.13 ms After last query: 7.53 ms

SELECT *

  FROM veneno_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_languages	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.19 ms After last query: 29.01 ms

select * 
  from veneno_jshopping_languages

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.27 ms After last query: 30.37 ms

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_categories`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_categories`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/category.php:15
11	jshopCategory->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.39 ms After last query: 0.40 ms

SELECT *

  FROM veneno_jshopping_categories

  WHERE `category_id` = '152'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_categories	const	PRIMARY	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/controllers/category.php:57
8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.55 ms After last query: 0.23 ms

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 = '152'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY ordering asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_categories	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.12 ms After last query: 1.53 ms

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)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	173	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.98 ms After last query: 7.60 ms

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_vendors`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_vendors`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/vendor.php:15
15	jshopVendor->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.35 ms After last query: 0.40 ms

SELECT id 
  FROM veneno_jshopping_vendors 
  WHERE `main`=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_vendors	system	main	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.35 ms After last query: 0.32 ms

SELECT *

  FROM veneno_jshopping_vendors

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_vendors	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.06 ms After last query: 0.99 ms

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_taxes`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_taxes`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
18	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
17	jshopTax->__construct()	JROOT/libraries/src/Table/Table.php:312
16	Joomla\CMS\Table\Table::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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.36 ms After last query: 0.23 ms

SELECT tax_id, tax_name, tax_value 
  FROM `veneno_jshopping_taxes`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_taxes	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.13 ms After last query: 0.17 ms

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 = '152' 
  AND prod.product_publish = '1'  
  AND prod.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pr_cat	ref	PRIMARY,category_id,product_id,product_id_2	category_id	4	const	7
1	SIMPLE	prod	eq_ref	PRIMARY,product_publish,access	PRIMARY	4	duocphaph_1.pr_cat.product_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.39 ms After last query: 6.12 ms

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 = '152' 
  AND prod.product_publish = '1'  
  AND prod.access IN (1,1)  
  ORDER BY prod.product_price ASC 
  LIMIT 0, 12

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pr_cat	ref	PRIMARY,category_id,product_id,product_id_2	category_id	4	const	7	Using temporary; Using filesort
1	SIMPLE	prod	eq_ref	PRIMARY,product_publish,access	PRIMARY	4	duocphaph_1.pr_cat.product_id	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.47 ms After last query: 8.86 ms

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products_reviews`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products_reviews`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/review.php:14
12	jshopReview->__construct()	JROOT/libraries/src/Table/Table.php:312
11	Joomla\CMS\Table\Table::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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.41 ms After last query: 10.75 ms

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
18	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/product.php:15
17	jshopProduct->__construct()	JROOT/libraries/src/Table/Table.php:312
16	Joomla\CMS\Table\Table::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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.28 ms After last query: 0.40 ms

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 = '491' 
  ORDER BY sort, I.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	I	ref	product_id	product_id	4	const	1	Using temporary; Using filesort
1	SIMPLE	P	eq_ref	PRIMARY	PRIMARY	4	duocphaph_1.I.product_id	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.45 ms After last query: 0.90 ms

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 = '499' 
  ORDER BY sort, I.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	I	ref	product_id	product_id	4	const	1	Using temporary; Using filesort
1	SIMPLE	P	eq_ref	PRIMARY	PRIMARY	4	duocphaph_1.I.product_id	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.47 ms After last query: 0.73 ms

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 = '462' 
  ORDER BY sort, I.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	I	ref	product_id	product_id	4	const	1	Using temporary; Using filesort
1	SIMPLE	P	eq_ref	PRIMARY	PRIMARY	4	duocphaph_1.I.product_id	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.46 ms After last query: 0.71 ms

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 = '507' 
  ORDER BY sort, I.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	I	ref	product_id	product_id	4	const	1	Using temporary; Using filesort
1	SIMPLE	P	eq_ref	PRIMARY	PRIMARY	4	duocphaph_1.I.product_id	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.66 ms After last query: 0.69 ms

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 = '492' 
  ORDER BY sort, I.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	I	ref	product_id	product_id	4	const	3	Using temporary; Using filesort
1	SIMPLE	P	eq_ref	PRIMARY	PRIMARY	4	duocphaph_1.I.product_id	1

Profile</

	Hôm nay	44
	Hôm qua	59
	Tuần	394
	Tháng	1704
	Tổng	223387

Hỗ trợ an thần & Bồi bổ sức khỏe

Liên hệ mua hàng

THÔNG TIN Y DƯỢC

Hỗ trợ mua hàng

Thống kê truy cập

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

115 Queries Logged 72.39 ms

22 duplicate found!