Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1765960385,
                "last": 1765960385,
                "now": 1765960385
            }
        },
        "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"
        ]
    }
}

Profile Information

Time

Memory

Time: 0.00 ms / 0.00 ms Memory: 0.410 MB / 0.41 MB Application: afterLoad

Time: 34.64 ms / 34.64 ms Memory: 2.454 MB / 2.86 MB Application: afterInitialise

Time: 20.70 ms / 55.34 ms Memory: 1.762 MB / 4.63 MB Application: afterRoute

Time: 1.71 ms / 57.05 ms Memory: 0.052 MB / 4.68 MB Application: beforeRenderComponent com_jshopping

Time: 13.75 ms / 70.80 ms Memory: 0.382 MB / 5.06 MB Application: afterRenderComponent com_jshopping

Time: 0.67 ms / 71.47 ms Memory: 0.010 MB / 5.07 MB Application: afterDispatch

Time: 5.36 ms / 76.83 ms Memory: 0.396 MB / 5.47 MB Application: beforeRenderModule mod_vina_cmenu_jshopping (Danh Mục Sản Phẩm)

Time: 62.59 ms / 139.41 ms Memory: 3.389 MB / 8.85 MB Application: afterRenderModule mod_vina_cmenu_jshopping (Danh Mục Sản Phẩm)

Time: 12.69 ms / 152.10 ms Memory: 0.099 MB / 8.95 MB Application: beforeRenderModule mod_custom (Payment Footer)

Time: 1.34 ms / 153.44 ms Memory: 0.010 MB / 8.96 MB Application: afterRenderModule mod_custom (Payment Footer)

Time: 0.16 ms / 153.60 ms Memory: 0.000 MB / 8.96 MB Application: beforeRenderModule mod_custom (Bản Đồ)

Time: 0.14 ms / 153.74 ms Memory: 0.007 MB / 8.97 MB Application: afterRenderModule mod_custom (Bản Đồ)

Time: 0.09 ms / 153.83 ms Memory: 0.000 MB / 8.97 MB Application: beforeRenderModule mod_menu (Hỗ trợ)

Time: 2.32 ms / 156.15 ms Memory: 0.070 MB / 9.04 MB Application: afterRenderModule mod_menu (Hỗ trợ)

Time: 0.10 ms / 156.24 ms Memory: 0.000 MB / 9.03 MB Application: beforeRenderModule mod_menu (Về Chúng Tôi)

Time: 0.71 ms / 156.96 ms Memory: 0.035 MB / 9.07 MB Application: afterRenderModule mod_menu (Về Chúng Tôi)

Time: 0.09 ms / 157.04 ms Memory: 0.000 MB / 9.06 MB Application: beforeRenderModule mod_custom (CÔNG TY TNHH ĐỒ CHƠI SAO VIỆT)

Time: 0.13 ms / 157.17 ms Memory: 0.007 MB / 9.07 MB Application: afterRenderModule mod_custom (CÔNG TY TNHH ĐỒ CHƠI SAO VIỆT)

Time: 0.08 ms / 157.25 ms Memory: 0.000 MB / 9.07 MB Application: beforeRenderModule mod_custom (text link toàn site)

Time: 0.11 ms / 157.36 ms Memory: 0.007 MB / 9.07 MB Application: afterRenderModule mod_custom (text link toàn site)

Time: 0.09 ms / 157.45 ms Memory: 0.003 MB / 9.08 MB Application: beforeRenderModule mod_vina_cmenu_jshopping (BỐ MẸ MUỐN MUA GÌ ?)

Time: 52.19 ms / 209.64 ms Memory: 2.244 MB / 11.32 MB Application: afterRenderModule mod_vina_cmenu_jshopping (BỐ MẸ MUỐN MUA GÌ ?)

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

Time: 42.31 ms / 252.19 ms Memory: 2.254 MB / 13.55 MB Application: afterRenderModule mod_vina_cmenu_jshopping (Danh Mục Sản Phẩm -MOBILE)

Time: 0.17 ms / 252.36 ms Memory: 0.000 MB / 13.53 MB Application: beforeRenderModule mod_jshopping_cart_ext (Mini Cart)

Time: 1.94 ms / 254.30 ms Memory: 0.013 MB / 13.54 MB Application: afterRenderModule mod_jshopping_cart_ext (Mini Cart)

Time: 0.07 ms / 254.37 ms Memory: 0.000 MB / 13.54 MB Application: beforeRenderModule mod_jshopping_search (Tìm kiếm sản phẩm banner)

Time: 1.33 ms / 255.69 ms Memory: 0.012 MB / 13.55 MB Application: afterRenderModule mod_jshopping_search (Tìm kiếm sản phẩm banner)

Time: 0.17 ms / 255.86 ms Memory: 0.000 MB / 13.55 MB Application: beforeRenderModule mod_custom (Banner slogan 3)

Time: 0.14 ms / 256.00 ms Memory: 0.007 MB / 13.55 MB Application: afterRenderModule mod_custom (Banner slogan 3)

Time: 8.49 ms / 264.50 ms Memory: 0.123 MB / 13.68 MB Application: afterRender

Database queries total: 117.92 ms

Memory Usage

Database Queries

320 Queries Logged 117.92 ms

290 duplicate found!

2 duplicates: #18 #19

3 duplicates: #31 #129 #225

3 duplicates: #33 #130 #226

3 duplicates: #34 #131 #227

6 duplicates: #35 #42 #132 #139 #228 #235

6 duplicates: #36 #44 #133 #141 #229 #237

6 duplicates: #37 #46 #134 #143 #230 #239

6 duplicates: #38 #48 #135 #145 #231 #241

6 duplicates: #39 #50 #136 #147 #232 #243

6 duplicates: #40 #52 #137 #149 #233 #245

3 duplicates: #41 #138 #234

3 duplicates: #43 #140 #236

3 duplicates: #45 #142 #238

3 duplicates: #47 #144 #240

3 duplicates: #49 #146 #242

3 duplicates: #51 #148 #244

3 duplicates: #53 #150 #246

3 duplicates: #54 #151 #247

6 duplicates: #55 #59 #152 #156 #248 #252

6 duplicates: #56 #61 #153 #158 #249 #254

6 duplicates: #57 #63 #154 #160 #250 #256

3 duplicates: #58 #155 #251

3 duplicates: #60 #157 #253

3 duplicates: #62 #159 #255

3 duplicates: #64 #161 #257

3 duplicates: #65 #162 #258

6 duplicates: #66 #74 #163 #171 #259 #267

6 duplicates: #67 #76 #164 #173 #260 #269

6 duplicates: #68 #78 #165 #175 #261 #271

6 duplicates: #69 #80 #166 #177 #262 #273

6 duplicates: #70 #82 #167 #179 #263 #275

6 duplicates: #71 #84 #168 #181 #264 #277

6 duplicates: #72 #86 #169 #183 #265 #279

3 duplicates: #73 #170 #266

3 duplicates: #75 #172 #268

3 duplicates: #77 #174 #270

3 duplicates: #79 #176 #272

3 duplicates: #81 #178 #274

3 duplicates: #83 #180 #276

3 duplicates: #85 #182 #278

3 duplicates: #87 #184 #280

3 duplicates: #88 #185 #281

6 duplicates: #89 #98 #186 #195 #282 #291

6 duplicates: #90 #100 #187 #197 #283 #293

6 duplicates: #91 #102 #188 #199 #284 #295

6 duplicates: #92 #104 #189 #201 #285 #297

6 duplicates: #93 #106 #190 #203 #286 #299

6 duplicates: #94 #108 #191 #205 #287 #301

6 duplicates: #95 #110 #192 #207 #288 #303

6 duplicates: #96 #112 #193 #209 #289 #305

3 duplicates: #97 #194 #290

3 duplicates: #99 #196 #292

3 duplicates: #101 #198 #294

3 duplicates: #103 #200 #296

3 duplicates: #105 #202 #298

3 duplicates: #107 #204 #300

3 duplicates: #109 #206 #302

3 duplicates: #111 #208 #304

3 duplicates: #113 #210 #306

3 duplicates: #114 #211 #307

6 duplicates: #115 #119 #212 #216 #308 #312

6 duplicates: #116 #121 #213 #218 #309 #314

6 duplicates: #117 #123 #214 #220 #310 #316

3 duplicates: #118 #215 #311

3 duplicates: #120 #217 #313

3 duplicates: #122 #219 #315

3 duplicates: #124 #221 #317

3 duplicates: #125 #222 #318

3 duplicates: #126 #223 #319

3 duplicates: #127 #224 #320

Query Time: 0.42 ms Query memory: 0.008 MB Memory before query: 0.903 MB

DELETE 

  FROM `veneno_session`

  WHERE `time` < '1765956785'

Explain

EXPLAIN not possible on query: DELETE FROM `veneno_session` WHERE `time` < '1765956785'

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:42

[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.28 ms Query memory: 0.021 MB Memory before query: 0.926 MB Rows returned: 0

SELECT `data`

  FROM `veneno_session`

  WHERE `session_id` = 'qu8jb3bb3uo5ebl9b6ladr27b2'

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:42

[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.49 ms Query memory: 0.012 MB Memory before query: 0.979 MB Rows returned: 0

SELECT `session_id`

  FROM `veneno_session`

  WHERE `session_id` = 'qu8jb3bb3uo5ebl9b6ladr27b2' 
  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
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:42

[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.17 ms Query memory: 0.009 MB Memory before query: 0.994 MB

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:42

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

Query Time: 0.72 ms After last query: 0.56 ms Query memory: 0.019 MB Memory before query: 1.048 MB Rows returned: 38

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	38	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
9	JComponentHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.50 ms After last query: 0.76 ms Query memory: 0.015 MB Memory before query: 1.138 MB Rows returned: 1

SELECT b.id

  FROM veneno_usergroups AS a

  LEFT JOIN veneno_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 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	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.40 ms After last query: 0.12 ms Query memory: 0.015 MB Memory before query: 1.158 MB Rows returned: 5

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 1.16 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 1.198 MB Rows returned: 98

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

  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	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	260	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
9	JPluginHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.62 ms After last query: 10.33 ms Query memory: 0.014 MB Memory before query: 2.005 MB Rows returned: 1

SELECT `enabled`

  FROM `veneno_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

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	element_clientid	402	const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.40 ms After last query: 0.42 ms Query memory: 0.024 MB Memory before query: 2.046 MB Rows returned: 1

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
16	JLibraryHelper::{closure}()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
13	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/backup/backup.php:4
7	require_once JROOT/plugins/system/backup/backup.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.61 ms After last query: 0.18 ms Query memory: 0.016 MB Memory before query: 2.052 MB

UPDATE `veneno_extensions`

  SET `params` = '{\"mediaversion\":\"6617f76744fd499e058386a82cb7aba8\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `veneno_extensions` SET `params` = '{\"mediaversion\":\"6617f76744fd499e058386a82cb7aba8\"}' 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	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/backup/backup.php:4
7	require_once JROOT/plugins/system/backup/backup.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 1.01 ms After last query: 4.46 ms Query memory: 0.040 MB Memory before query: 2.463 MB Rows returned: 23

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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	194	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	dwdohemwhosting_dochoimaugiao.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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
24	JMenuSite->{closure}()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
22	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
21	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
20	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
19	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
18	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
17	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
16	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:433
15	JApplicationSite->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
14	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
13	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
12	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
11	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
10	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
9	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.62 ms After last query: 0.87 ms Query memory: 0.039 MB Memory before query: 2.609 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM veneno_template_styles as s

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

  WHERE s.client_id = 0 
  AND e.enabled = 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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
15	JApplicationSite->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
14	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
13	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
12	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
11	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
10	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
9	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 1.52 ms After last query: 7.33 ms Query memory: 0.038 MB Memory before query: 3.353 MB Rows returned: 140

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
16	JTable->__construct()	JROOT/components/com_jshopping/tables/config.php:14
15	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1550
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.69 ms After last query: 2.20 ms Query memory: 0.064 MB Memory before query: 3.807 MB Rows returned: 1

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	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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
15	JTable->load()	JROOT/components/com_jshopping/lib/factory.php:30
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1550
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.81 ms After last query: 0.66 ms Query memory: 0.033 MB Memory before query: 3.818 MB Rows returned: 8

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
20	JTable->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
19	jshopCurrency->__construct()	JROOT/libraries/joomla/table/table.php:311
18	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
17	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:548
16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1550
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

[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.20 ms Query memory: 0.026 MB Memory before query: 3.864 MB Rows returned: 1

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_currencies	ref	currency_publish	currency_publish	1	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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
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:1550
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.99 ms After last query: 0.26 ms Query memory: 0.036 MB Memory before query: 3.938 MB Rows returned: 53

Duplicate queries: #19

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
20	JTable->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
19	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/tables/usershop.php:15
18	jshopUserShop->__construct()	JROOT/components/com_jshopping/lib/factory.php:47
17	JSFactory::getUserShop()	JROOT/components/com_jshopping/tables/config.php:67
16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1550
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.94 ms After last query: 0.73 ms Query memory: 0.036 MB Memory before query: 4.103 MB Rows returned: 53

Duplicate queries: #18

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
20	JTable->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
19	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/models/userguest.php:16
18	jshopUserGust->__construct()	JROOT/components/com_jshopping/lib/factory.php:66
17	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:71
16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1550
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.77 ms After last query: 0.84 ms Query memory: 0.035 MB Memory before query: 4.270 MB Rows returned: 10

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
22	JTable->__construct()	JROOT/components/com_jshopping/tables/usergroup.php:14
21	jshopUserGroup->__construct()	JROOT/libraries/joomla/table/table.php:311
20	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
19	JSFactory::getTable()	JROOT/components/com_jshopping/models/userguest.php:30
18	jshopUserGust->load()	JROOT/components/com_jshopping/lib/factory.php:67
17	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:71
16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1550
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.72 ms After last query: 0.41 ms Query memory: 0.032 MB Memory before query: 4.345 MB Rows returned: 4

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
20	JTable->__construct()	JROOT/components/com_jshopping/tables/configdisplayprice.php:19
19	jshopConfigDisplayPrice->__construct()	JROOT/libraries/joomla/table/table.php:311
18	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
17	JSFactory::getTable()	JROOT/components/com_jshopping/tables/config.php:79
16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1550
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.34 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 4.380 MB Rows returned: 1

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	ALL	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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
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:1550
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.99 ms After last query: 0.70 ms Query memory: 0.032 MB Memory before query: 4.429 MB Rows returned: 449

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	414	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
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/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 2.79 ms Query memory: 0.014 MB Memory before query: 4.636 MB Rows returned: 1

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	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.39 ms After last query: 3.85 ms Query memory: 0.016 MB Memory before query: 4.718 MB Rows returned: 2

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/functions.php:281
8	installNewLanguages()	JROOT/components/com_jshopping/loadparams.php:32
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.90 ms After last query: 5.17 ms Query memory: 0.025 MB Memory before query: 4.933 MB Rows returned: 9

SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config_seo`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
14	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
13	JTable->__construct()	JROOT/components/com_jshopping/tables/seo.php:14
12	jshopSeo->__construct()	JROOT/libraries/joomla/table/table.php:311
11	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
10	JSFactory::getTable()	JROOT/components/com_jshopping/helpers/metadata.php:249
9	JshopHelpersMetadata::wishlist()	JROOT/components/com_jshopping/controllers/wishlist.php:31
8	JshoppingControllerWishlist->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.48 ms After last query: 0.21 ms Query memory: 0.018 MB Memory before query: 4.974 MB Rows returned: 1

SELECT id, alias, `title_vi-VN` as title, `keyword_vi-VN` as keyword, `description_vi-VN` as description 
  FROM `veneno_jshopping_config_seo` 
  where alias='wishlist'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	veneno_jshopping_config_seo	ref	alias	alias	194	const	1	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
11	JDatabaseDriver->loadObject()	JROOT/components/com_jshopping/tables/seo.php:22
10	jshopSeo->loadData()	JROOT/components/com_jshopping/helpers/metadata.php:250
9	JshopHelpersMetadata::wishlist()	JROOT/components/com_jshopping/controllers/wishlist.php:31
8	JshoppingControllerWishlist->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.57 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 4.992 MB Rows returned: 5

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	ALL	idx_client_id_parent_id_alias_language,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	194	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:130
14	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:41
13	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:35
12	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:387
11	getShopMainPageItemid()	JROOT/components/com_jshopping/lib/functions.php:379
10	getThisURLMainPageShop()	JROOT/components/com_jshopping/helpers/metadata.php:251
9	JshopHelpersMetadata::wishlist()	JROOT/components/com_jshopping/controllers/wishlist.php:31
8	JshoppingControllerWishlist->view()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.57 ms After last query: 8.51 ms Query memory: 0.025 MB Memory before query: 5.424 MB Rows returned: 1

SELECT id, title, module, position, content, showtitle, params

  FROM veneno_modules AS m

  WHERE m.published = 1 
  AND m.id = 201 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-12-17 08:33:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-17 08:33:05') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY position, ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix/core/classes/menu.php:649
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.92 ms After last query: 1.96 ms Query memory: 0.037 MB Memory before query: 5.548 MB Rows returned: 25

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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
21	JTable->__construct()	JROOT/components/com_jshopping/tables/category.php:15
20	jshopCategory->__construct()	JROOT/libraries/joomla/table/table.php:311
19	JTable::getInstance()	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:129
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.59 ms After last query: 0.39 ms Query memory: 0.030 MB Memory before query: 5.633 MB Rows returned: 7

Duplicate queries: #129 #225

SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '0'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc

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	7	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
19	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:131
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.40 ms After last query: 0.40 ms Query memory: 0.039 MB Memory before query: 5.679 MB Rows returned: 34

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	34	Using where

Profile

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

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
29	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:242
28	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:58
27	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
26	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
25	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
24	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
23	JRouter->build()	JROOT/libraries/cms/router/site.php:149
22	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
21	JRoute::_()	JROOT/components/com_jshopping/lib/functions.php:479
20	SEFLink()	JROOT/components/com_jshopping/tables/category.php:36
19	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:131
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.72 ms After last query: 1.49 ms Query memory: 0.033 MB Memory before query: 5.732 MB Rows returned: 6

Duplicate queries: #130 #226

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 = '148'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id 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	6	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
21	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.65 ms After last query: 1.21 ms Query memory: 0.035 MB Memory before query: 5.797 MB Rows returned: 6

Duplicate queries: #131 #227

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
23	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.34 ms Query memory: 0.036 MB Memory before query: 5.858 MB Rows returned: 0

Duplicate queries: #42 #132 #139 #228 #235

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.12 ms Query memory: 0.036 MB Memory before query: 5.891 MB Rows returned: 0

Duplicate queries: #44 #133 #141 #229 #237

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.24 ms Query memory: 0.036 MB Memory before query: 5.925 MB Rows returned: 0

Duplicate queries: #46 #134 #143 #230 #239

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.48 ms After last query: 0.20 ms Query memory: 0.036 MB Memory before query: 5.958 MB Rows returned: 0

Duplicate queries: #48 #135 #145 #231 #241

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.44 ms After last query: 0.24 ms Query memory: 0.036 MB Memory before query: 5.992 MB Rows returned: 0

Duplicate queries: #50 #136 #147 #232 #243

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.21 ms Query memory: 0.036 MB Memory before query: 6.026 MB Rows returned: 0

Duplicate queries: #52 #137 #149 #233 #245

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.20 ms Query memory: 0.034 MB Memory before query: 6.026 MB Rows returned: 0

Duplicate queries: #138 #234

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.20 ms Query memory: 0.036 MB Memory before query: 6.064 MB Rows returned: 0

Duplicate queries: #35 #132 #139 #228 #235

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.14 ms Query memory: 0.034 MB Memory before query: 6.091 MB Rows returned: 0

Duplicate queries: #140 #236

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.13 ms Query memory: 0.036 MB Memory before query: 6.129 MB Rows returned: 0

Duplicate queries: #36 #133 #141 #229 #237

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.42 ms After last query: 0.10 ms Query memory: 0.034 MB Memory before query: 6.156 MB Rows returned: 0

Duplicate queries: #142 #238

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.10 ms After last query: 0.13 ms Query memory: 0.036 MB Memory before query: 6.194 MB Rows returned: 0

Duplicate queries: #37 #134 #143 #230 #239

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.41 ms After last query: 0.09 ms Query memory: 0.034 MB Memory before query: 6.221 MB Rows returned: 0

Duplicate queries: #144 #240

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.10 ms After last query: 0.12 ms Query memory: 0.036 MB Memory before query: 6.259 MB Rows returned: 0

Duplicate queries: #38 #135 #145 #231 #241

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.41 ms After last query: 0.11 ms Query memory: 0.034 MB Memory before query: 6.286 MB Rows returned: 0

Duplicate queries: #146 #242

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.13 ms Query memory: 0.036 MB Memory before query: 6.324 MB Rows returned: 0

Duplicate queries: #39 #136 #147 #232 #243

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.09 ms Query memory: 0.034 MB Memory before query: 6.351 MB Rows returned: 0

Duplicate queries: #148 #244

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.12 ms Query memory: 0.036 MB Memory before query: 6.389 MB Rows returned: 0

Duplicate queries: #40 #137 #149 #233 #245

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.54 ms After last query: 0.08 ms Query memory: 0.033 MB Memory before query: 6.393 MB Rows returned: 3

Duplicate queries: #150 #246

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 category_id 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	3	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
21	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.54 ms After last query: 0.59 ms Query memory: 0.035 MB Memory before query: 6.443 MB Rows returned: 3

Duplicate queries: #151 #247

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 access IN (1,1)
                   
  ORDER BY category_id asc

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
23	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.24 ms Query memory: 0.036 MB Memory before query: 6.493 MB Rows returned: 0

Duplicate queries: #59 #152 #156 #248 #252

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.42 ms After last query: 0.14 ms Query memory: 0.036 MB Memory before query: 6.526 MB Rows returned: 0

Duplicate queries: #61 #153 #158 #249 #254

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.44 ms After last query: 0.24 ms Query memory: 0.036 MB Memory before query: 6.560 MB Rows returned: 0

Duplicate queries: #63 #154 #160 #250 #256

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.41 ms After last query: 0.15 ms Query memory: 0.034 MB Memory before query: 6.571 MB Rows returned: 0

Duplicate queries: #155 #251

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.14 ms Query memory: 0.036 MB Memory before query: 6.609 MB Rows returned: 0

Duplicate queries: #55 #152 #156 #248 #252

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.40 ms After last query: 0.10 ms Query memory: 0.034 MB Memory before query: 6.636 MB Rows returned: 0

Duplicate queries: #157 #253

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.10 ms After last query: 0.13 ms Query memory: 0.036 MB Memory before query: 6.674 MB Rows returned: 0

Duplicate queries: #56 #153 #158 #249 #254

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.42 ms After last query: 0.09 ms Query memory: 0.034 MB Memory before query: 6.701 MB Rows returned: 0

Duplicate queries: #159 #255

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.10 ms After last query: 0.12 ms Query memory: 0.036 MB Memory before query: 6.739 MB Rows returned: 0

Duplicate queries: #57 #154 #160 #250 #256

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.09 ms Query memory: 0.033 MB Memory before query: 6.755 MB Rows returned: 7

Duplicate queries: #161 #257

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 = '193'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id 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	7	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
21	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.63 ms After last query: 0.96 ms Query memory: 0.036 MB Memory before query: 6.823 MB Rows returned: 7

Duplicate queries: #162 #258

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
23	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.37 ms Query memory: 0.036 MB Memory before query: 6.885 MB Rows returned: 0

Duplicate queries: #74 #163 #171 #259 #267

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.12 ms Query memory: 0.036 MB Memory before query: 6.918 MB Rows returned: 0

Duplicate queries: #76 #164 #173 #260 #269

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.42 ms After last query: 0.12 ms Query memory: 0.036 MB Memory before query: 6.952 MB Rows returned: 0

Duplicate queries: #78 #165 #175 #261 #271

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.20 ms Query memory: 0.036 MB Memory before query: 6.985 MB Rows returned: 0

Duplicate queries: #80 #166 #177 #262 #273

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.42 ms After last query: 0.20 ms Query memory: 0.036 MB Memory before query: 7.019 MB Rows returned: 0

Duplicate queries: #82 #167 #179 #263 #275

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.20 ms Query memory: 0.036 MB Memory before query: 7.053 MB Rows returned: 0

Duplicate queries: #84 #168 #181 #264 #277

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.19 ms Query memory: 0.036 MB Memory before query: 7.086 MB Rows returned: 0

Duplicate queries: #86 #169 #183 #265 #279

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.42 ms After last query: 0.19 ms Query memory: 0.034 MB Memory before query: 7.085 MB Rows returned: 0

Duplicate queries: #170 #266

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.21 ms Query memory: 0.036 MB Memory before query: 7.123 MB Rows returned: 0

Duplicate queries: #66 #163 #171 #259 #267

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.15 ms Query memory: 0.034 MB Memory before query: 7.150 MB Rows returned: 0

Duplicate queries: #172 #268

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.20 ms Query memory: 0.036 MB Memory before query: 7.188 MB Rows returned: 0

Duplicate queries: #67 #164 #173 #260 #269

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.42 ms After last query: 0.15 ms Query memory: 0.034 MB Memory before query: 7.215 MB Rows returned: 0

Duplicate queries: #174 #270

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.17 ms Query memory: 0.036 MB Memory before query: 7.253 MB Rows returned: 0

Duplicate queries: #68 #165 #175 #261 #271

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.14 ms Query memory: 0.034 MB Memory before query: 7.280 MB Rows returned: 0

Duplicate queries: #176 #272

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.19 ms Query memory: 0.036 MB Memory before query: 7.318 MB Rows returned: 0

Duplicate queries: #69 #166 #177 #262 #273

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.15 ms Query memory: 0.034 MB Memory before query: 7.345 MB Rows returned: 0

Duplicate queries: #178 #274

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.13 ms After last query: 0.22 ms Query memory: 0.036 MB Memory before query: 7.383 MB Rows returned: 0

Duplicate queries: #70 #167 #179 #263 #275

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.37 ms After last query: 0.16 ms Query memory: 0.034 MB Memory before query: 7.410 MB Rows returned: 0

Duplicate queries: #180 #276

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.40 ms After last query: 0.21 ms Query memory: 0.036 MB Memory before query: 7.448 MB Rows returned: 0

Duplicate queries: #71 #168 #181 #264 #277

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.15 ms Query memory: 0.034 MB Memory before query: 7.476 MB Rows returned: 0

Duplicate queries: #182 #278

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
22	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.20 ms Query memory: 0.036 MB Memory before query: 7.513 MB Rows returned: 0

Duplicate queries: #72 #169 #183 #265 #279

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
22	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
21	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:35
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.65 ms After last query: 0.15 ms Query memory: 0.033 MB Memory before query: 7.516 MB Rows returned: 8

Duplicate queries: #184 #280

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 = '194'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id 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	8	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
21	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.53 ms After last query: 1.52 ms Query memory: 0.035 MB Memory before query: 7.590 MB Rows returned: 8

Duplicate queries: #185 #281

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
23	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

[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.61 ms Query memory: 0.036 MB Memory before query: 7.658 MB Rows returned: 0

Duplicate queries: #98 #186 #195 #282 #291

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.41 ms After last query: 0.20 ms Query memory: 0.036 MB Memory before query: 7.691 MB Rows returned: 0

Duplicate queries: #100 #187 #197 #283 #293

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.41 ms After last query: 0.19 ms Query memory: 0.036 MB Memory before query: 7.725 MB Rows returned: 0

Duplicate queries: #102 #188 #199 #284 #295

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.34 ms After last query: 0.19 ms Query memory: 0.036 MB Memory before query: 7.758 MB Rows returned: 0

Duplicate queries: #104 #189 #201 #285 #297

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
24	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:83
22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
21	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
20	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
19	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
8	Helix::Header()	JROOT/templates/vina_veneno/index.php:33
7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.19 ms Query memory: 0.036 MB Memory before query: 7.792 MB Rows returned: 0

My Wishlist

CÔNG TY TNHH ĐỒ CHƠI SAO VIỆT

Về Chúng Tôi

Hỗ trợ

Bản Đồ

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

320 Queries Logged 117.92 ms

290 duplicate found!