{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1763550908,
                "last": 1763550908,
                "now": 1763550908
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "js_id_currency_orig": "1",
        "js_id_currency": "1",
        "js_history_sel_lang": "vi-VN",
        "js_prev_user_id": 0,
        "jshop_checked_language": [
            "en-GB",
            "vi-VN"
        ],
        "jshop_end_page_buy_product": "\/san-pham\/category\/view\/168.html&Itemid=Danh%20m%E1%BB%A5c%20s%E1%BA%A3n%20ph%E1%BA%A9m",
        "jshop_end_page_list_product": "\/san-pham\/category\/view\/168.html&Itemid=Danh%20m%E1%BB%A5c%20s%E1%BA%A3n%20ph%E1%BA%A9m"
    }
}

Time

Memory

401 Queries Logged 106.46 ms

1. Query Time: 0.79 ms

   SELECT `data`
   
     FROM `veneno_session`
   
     WHERE `session_id` = 'ajf439fvisl52uqvna2nk3c4e4'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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]

   ---

2. Query Time: 0.51 ms After last query: 1.12 ms

   SELECT `session_id`
   
     FROM `veneno_session`
   
     WHERE `session_id` = 'ajf439fvisl52uqvna2nk3c4e4' 
     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	JDatabaseDriverMysql->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]

   ---

3. Query Time: 1.20 ms After last query: 0.24 ms

   INSERT INTO `veneno_session`
   (`session_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('ajf439fvisl52uqvna2nk3c4e4', 1, '1763550908', 0, '')

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysql->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]

   ---

4. Query Time: 1.02 ms After last query: 1.70 ms

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `veneno_extensions`
   
     WHERE `type` = 'component'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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]

   ---

5. Query Time: 0.18 ms After last query: 9.74 ms

   SELECT b.id
   
     FROM veneno_usergroups AS a
   
     LEFT JOIN veneno_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	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	JDatabaseDriverMysql->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]

   ---

6. Query Time: 0.14 ms After last query: 0.35 ms

   SELECT id, rules
   
     FROM `veneno_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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]

   ---

7. Query Time: 1.08 ms After last query: 0.24 ms

   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	ref	extension	extension	82	const	126	Using index condition; Using where; Using filesort

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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]

   ---

8. Query Time: 1.62 ms After last query: 75.26 ms

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `veneno_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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]

   ---

9. Query Time: 3.09 ms After last query: 0.39 ms

   UPDATE `veneno_extensions`
   
     SET `params` = '{\"mediaversion\":\"a6ceb1af69ae22229bea6a918d577433\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysql->execute()	JROOT/libraries/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]

   ---

10. Query Time: 3.01 ms After last query: 104.92 ms

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM veneno_menu AS m
    
      LEFT JOIN veneno_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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]

    ---

11. Query Time: 1.23 ms After last query: 1.45 ms

    SELECT id, home, template, s.params
    
      FROM veneno_template_styles as s
    
      LEFT JOIN veneno_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	shopguitar_home.s.template,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
    17	JDatabaseDriverMysql->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]

    ---

12. Query Time: 1.60 ms After last query: 63.67 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php: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]

    ---

13. Query Time: 0.23 ms After last query: 2.90 ms

    SELECT *
    
      FROM veneno_jshopping_config
    
      WHERE `id` = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	veneno_jshopping_config	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	JDatabaseDriverMysql->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:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php: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]

    ---

14. Query Time: 0.77 ms After last query: 1.12 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_currencies`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php: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]

    ---

15. Query Time: 0.15 ms After last query: 0.17 ms

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	veneno_jshopping_currencies	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	JDatabaseDriverMysql->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:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php: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]

    ---

16. Query Time: 0.94 ms After last query: 0.41 ms
    Duplicate queries: #17

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_users`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php: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]

    ---

17. Query Time: 0.88 ms After last query: 0.88 ms
    Duplicate queries: #16

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_users`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php: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]

    ---

18. Query Time: 0.77 ms After last query: 0.92 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_usergroups`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php: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]

    ---

19. Query Time: 0.70 ms After last query: 0.73 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_config_display_prices`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php: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]

    ---

20. Query Time: 0.14 ms After last query: 0.15 ms

    SELECT * 
      FROM `veneno_jshopping_config_display_prices`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	veneno_jshopping_config_display_prices	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	JDatabaseDriverMysql->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:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php: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]

    ---

21. Query Time: 2.98 ms After last query: 2.42 ms

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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]

    ---

22. Query Time: 0.20 ms After last query: 4.93 ms

    SELECT *
    
      FROM veneno_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	veneno_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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]

    ---

23. Query Time: 0.27 ms After last query: 22.07 ms

    select * 
      from veneno_jshopping_languages

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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]

    ---

24. Query Time: 1.19 ms After last query: 17.37 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_categories`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    12	JTable->__construct()	JROOT/components/com_jshopping/tables/category.php:15
    11	jshopCategory->__construct()	JROOT/libraries/joomla/table/table.php:311
    10	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/category.php:56
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

25. Query Time: 0.92 ms After last query: 0.46 ms

    SELECT *
    
      FROM veneno_jshopping_categories
    
      WHERE `category_id` = '168'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1445
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    9	JTable->load()	JROOT/components/com_jshopping/controllers/category.php:57
    8	JshoppingControllerCategory->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]

    ---

26. Query Time: 0.24 ms After last query: 16.08 ms

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM veneno_fields AS a
    
      LEFT JOIN `veneno_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN veneno_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN veneno_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN veneno_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN veneno_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_content.article' 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	shopguitar_home.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	shopguitar_home.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	shopguitar_home.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	shopguitar_home.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	shopguitar_home.a.group_id	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    19	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    18	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    17	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    15	PlgSystemFields->onContentPrepare()	Same as call in the line below.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:914
    11	changeDataUsePluginContent()	JROOT/components/com_jshopping/tables/category.php:251
    10	jshopCategory->preparePluginContent()	JROOT/components/com_jshopping/tables/category.php:66
    9	jshopCategory->getDescription()	JROOT/components/com_jshopping/controllers/category.php:58
    8	JshoppingControllerCategory->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]

    ---

27. Query Time: 0.18 ms After last query: 0.76 ms

    SELECT option_value 
      FROM veneno_imagerecycle_options 
      WHERE option_name ='queue_process_lastRun' 
      LIMIT 1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_imagerecycle/helpers/imagerecycle.php:185
    16	ImagerecycleHelper->getOption()	JROOT/plugins/content/imagerecycle/imagerecycle.php:61
    15	plgContentImagerecycle->onContentPrepare()	Same as call in the line below.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:914
    11	changeDataUsePluginContent()	JROOT/components/com_jshopping/tables/category.php:251
    10	jshopCategory->preparePluginContent()	JROOT/components/com_jshopping/tables/category.php:66
    9	jshopCategory->getDescription()	JROOT/components/com_jshopping/controllers/category.php:58
    8	JshoppingControllerCategory->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]

    ---

28. Query Time: 0.14 ms After last query: 0.10 ms

    SELECT option_value 
      FROM veneno_imagerecycle_options 
      WHERE option_name ='queue_process_status' 
      LIMIT 1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_imagerecycle/helpers/imagerecycle.php:185
    16	ImagerecycleHelper->getOption()	JROOT/plugins/content/imagerecycle/imagerecycle.php:62
    15	plgContentImagerecycle->onContentPrepare()	Same as call in the line below.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:914
    11	changeDataUsePluginContent()	JROOT/components/com_jshopping/tables/category.php:251
    10	jshopCategory->preparePluginContent()	JROOT/components/com_jshopping/tables/category.php:66
    9	jshopCategory->getDescription()	JROOT/components/com_jshopping/controllers/category.php:58
    8	JshoppingControllerCategory->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]

    ---

29. Query Time: 0.80 ms After last query: 0.53 ms

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    10	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:119
    9	jshopCategory->getChildCategories()	JROOT/components/com_jshopping/controllers/category.php:66
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

30. Query Time: 1.28 ms After last query: 0.93 ms

    select id,link 
      from veneno_menu 
      where `type`='component' 
      and published=1 
      and link like '%option=com_jshopping%' 
      and client_id=0 
      and (language='*' or language='vi-VN') 
      and access IN (1,1)

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:130
    13	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:41
    12	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:35
    11	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:387
    10	getShopMainPageItemid()	JROOT/components/com_jshopping/helpers/metadata.php:38
    9	JshopHelpersMetadata::category()	JROOT/components/com_jshopping/controllers/category.php:69
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

31. Query Time: 0.17 ms After last query: 9.99 ms

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:242
    19	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:58
    18	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
    16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	JROOT/components/com_jshopping/lib/functions.php:479
    11	SEFLink()	JROOT/components/com_jshopping/lib/functions.php:139
    10	appendExtendPathWay()	JROOT/components/com_jshopping/helpers/metadata.php:39
    9	JshopHelpersMetadata::category()	JROOT/components/com_jshopping/controllers/category.php:69
    8	JshoppingControllerCategory->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]

    ---

32. Query Time: 0.98 ms After last query: 5.10 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_vendors`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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/vendor.php:15
    15	jshopVendor->__construct()	JROOT/libraries/joomla/table/table.php:311
    14	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    13	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:414
    12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1409
    11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:304
    10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

33. Query Time: 0.17 ms After last query: 0.28 ms

    SELECT id 
      FROM veneno_jshopping_vendors 
      WHERE `main`=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	veneno_jshopping_vendors	ref	main	main	1	const	1	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    14	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/vendor.php:23
    13	jshopVendor->loadMain()	JROOT/components/com_jshopping/lib/factory.php:415
    12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1409
    11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:304
    10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

34. Query Time: 0.16 ms After last query: 0.24 ms

    SELECT *
    
      FROM veneno_jshopping_vendors
    
      WHERE `id` = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	veneno_jshopping_vendors	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
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1445
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    14	JTable->load()	JROOT/components/com_jshopping/tables/vendor.php:24
    13	jshopVendor->loadMain()	JROOT/components/com_jshopping/lib/factory.php:415
    12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1409
    11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:304
    10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

35. Query Time: 0.73 ms After last query: 0.76 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_products_extra_fields`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    17	JTable->__construct()	JROOT/components/com_jshopping/tables/productfield.php:14
    16	jshopProductField->__construct()	JROOT/libraries/joomla/table/table.php:311
    15	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:475
    13	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1098
    12	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:37
    11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:178
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

36. Query Time: 0.17 ms After last query: 0.17 ms

    SELECT F.id, F.`name_vi-VN` as name, F.`description_vi-VN` as description, F.allcats, F.type, F.cats, F.ordering, F.`
      group`, G.`name_vi-VN` as groupname, multilist 
      FROM `veneno_jshopping_products_extra_fields` as F 
      left join `veneno_jshopping_products_extra_field_groups` as G 
      on G.id=F.
      group 
      order by G.ordering, F.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	F	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using temporary; Using filesort
    1	SIMPLE	G	eq_ref	PRIMARY	PRIMARY	4	shopguitar_home.F.group	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfield.php:48
    14	jshopProductField->getList()	JROOT/components/com_jshopping/lib/factory.php:476
    13	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1098
    12	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:37
    11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:178
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

37. Query Time: 0.69 ms After last query: 0.71 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_taxes`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    18	JTable->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
    17	jshopTax->__construct()	JROOT/libraries/joomla/table/table.php:311
    16	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    15	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:342
    14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:955
    13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
    12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
    11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:178
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

38. Query Time: 0.14 ms After last query: 0.16 ms

    SELECT tax_id, tax_name, tax_value 
      FROM `veneno_jshopping_taxes`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	veneno_jshopping_taxes	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
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:21
    16	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:328
    15	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:343
    14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:955
    13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
    12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
    11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:178
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

39. Query Time: 0.69 ms After last query: 0.12 ms

    SELECT count(*) 
      FROM `veneno_jshopping_products_to_categories` AS pr_cat
                      
      INNER JOIN `veneno_jshopping_products` AS prod 
      ON pr_cat.product_id = prod.product_id
                       
                      
      WHERE pr_cat.category_id = '168' 
      AND prod.product_publish = '1'  
      AND prod.access IN (1,1)

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    11	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/category.php:188
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

40. Query Time: 1.75 ms After last query: 2.50 ms

    SELECT prod.product_id, pr_cat.category_id, prod.`name_vi-VN` as name, prod.`short_description_vi-VN` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices 
      FROM `veneno_jshopping_products` AS prod
                      
      LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
                      
      WHERE pr_cat.category_id = '168' 
      AND prod.product_publish = '1'  
      AND prod.access IN (1,1)  
      ORDER BY prod.product_price ASC 
      LIMIT 0, 12

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:170
    10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

41. Query Time: 0.69 ms After last query: 0.81 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_products_extra_field_values`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    17	JTable->__construct()	JROOT/components/com_jshopping/tables/productfieldvalue.php:15
    16	jshopProductFieldValue->__construct()	JROOT/libraries/joomla/table/table.php:311
    15	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:484
    13	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/lib/functions.php:787
    12	getProductExtraFieldForProduct()	JROOT/components/com_jshopping/lib/functions.php:712
    11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:171
    10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

42. Query Time: 0.15 ms After last query: 0.14 ms

    SELECT id, `name_vi-VN` as name, field_id 
      FROM `veneno_jshopping_products_extra_field_values` 
      order by ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:26
    14	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/lib/factory.php:485
    13	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/lib/functions.php:787
    12	getProductExtraFieldForProduct()	JROOT/components/com_jshopping/lib/functions.php:712
    11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:171
    10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

43. Query Time: 0.68 ms After last query: 0.88 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_product_labels`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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/productlabel.php:14
    15	jshopProductLabel->__construct()	JROOT/libraries/joomla/table/table.php:311
    14	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    13	JSFactory::getTable()	JROOT/components/com_jshopping/lib/functions.php:616
    12	getNameImageLabel()	JROOT/components/com_jshopping/lib/functions.php:751
    11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:171
    10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

44. Query Time: 0.15 ms After last query: 0.15 ms

    SELECT id, image, `name_vi-VN` as name 
      FROM `veneno_jshopping_product_labels` 
      ORDER BY name

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	veneno_jshopping_product_labels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productlabel.php:22
    13	jshopProductLabel->getListLabels()	JROOT/components/com_jshopping/lib/functions.php:617
    12	getNameImageLabel()	JROOT/components/com_jshopping/lib/functions.php:751
    11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:171
    10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

45. Query Time: 0.74 ms After last query: 6.36 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_products_reviews`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php: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/review.php:14
    12	jshopReview->__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/models/productlist.php:252
    9	jshopProductList->getAllowReview()	JROOT/components/com_jshopping/controllers/category.php:87
    8	JshoppingControllerCategory->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]

    ---

46. Query Time: 1.31 ms After last query: 4.88 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_products`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    18	JTable->__construct()	JROOT/components/com_jshopping/tables/product.php:15
    17	jshopProduct->__construct()	JROOT/libraries/joomla/table/table.php:311
    16	JTable::getInstance()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:10
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

47. Query Time: 1.14 ms After last query: 0.72 ms

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `veneno_jshopping_products_images` as I 
      left join `veneno_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '865' 
      ORDER BY sort, I.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

48. Query Time: 0.74 ms After last query: 1.18 ms

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `veneno_jshopping_products_images` as I 
      left join `veneno_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '928' 
      ORDER BY sort, I.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

49. Query Time: 0.54 ms After last query: 0.75 ms

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `veneno_jshopping_products_images` as I 
      left join `veneno_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '927' 
      ORDER BY sort, I.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

50. Query Time: 0.71 ms After last query: 0.70 ms

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `veneno_jshopping_products_images` as I 
      left join `veneno_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '929' 
      ORDER BY sort, I.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

51. Query Time: 0.83 ms After last query: 1.23 ms

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `veneno_jshopping_products_images` as I 
      left join `veneno_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '833' 
      ORDER BY sort, I.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

52. Query Time: 0.82 ms After last query: 1.00 ms

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `veneno_jshopping_products_images` as I 
      left join `veneno_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '926' 
      ORDER BY sort, I.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

53. Query Time: 0.65 ms After last query: 0.91 ms

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `veneno_jshopping_products_images` as I 
      left join `veneno_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '834' 
      ORDER BY sort, I.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

54. Query Time: 0.80 ms After last query: 0.85 ms

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `veneno_jshopping_products_images` as I 
      left join `veneno_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '822' 
      ORDER BY sort, I.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

55. Query Time: 0.58 ms After last query: 0.93 ms

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `veneno_jshopping_products_images` as I 
      left join `veneno_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '823' 
      ORDER BY sort, I.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/legacy/controller/legacy.php: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]

    ---

56. Query Time: 0.30 ms After last query: 21.95 ms

    SELECT *
    
      FROM veneno_rsform_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:51
    16	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:18
    15	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:98
    14	RSFormProConfig::getInstance()	JROOT/administrator/components/com_rsform/helpers/rsform.php:318
    13	RSFormProHelper::readConfig()	JROOT/administrator/components/com_rsform/helpers/legacy.php:36
    12	RSAdapter->RSAdapter()	JROOT/administrator/components/com_rsform/helpers/rsform.php:124
    11	RSFormProHelper::getLegacyAdapter()	JROOT/administrator/components/com_rsform/helpers/rsform.php:35
    10	require_once JROOT/administrator/components/com_rsform/helpers/rsform.php	JROOT/plugins/content/rsform/rsform.php:37
    9	plgContentRSForm->canRun()	JROOT/plugins/content/rsform/rsform.php:68
    8	plgContentRSForm->onAfterDispatch()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    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]

    ---

57. Query Time: 1.02 ms After last query: 32.88 ms

    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-11-19 11:15:09') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-11-19 11:15:09') 
      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	JDatabaseDriverMysql->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:32
    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]

    ---

58. Query Time: 0.22 ms After last query: 2.56 ms
    Duplicate queries: #173  #287

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysql->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:66
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

59. Query Time: 0.18 ms After last query: 4.86 ms
    Duplicate queries: #174  #288

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

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysql->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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

60. Query Time: 0.20 ms After last query: 1.10 ms
    Duplicate queries: #175  #289

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

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysql->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:36
    22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

61. Query Time: 0.16 ms After last query: 0.36 ms
    Duplicate queries: #66  #176  #181  #290  #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 = '135'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:42
    22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

62. Query Time: 0.16 ms After last query: 0.18 ms
    Duplicate queries: #68  #177  #183  #291  #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 = '136'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:42
    22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

63. Query Time: 0.19 ms After last query: 0.19 ms
    Duplicate queries: #70  #178  #185  #292  #299

    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 = '137'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:42
    22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

64. Query Time: 0.15 ms After last query: 0.17 ms
    Duplicate queries: #72  #179  #187  #293  #301

    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 = '138'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:42
    22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

65. Query Time: 0.19 ms After last query: 0.32 ms
    Duplicate queries: #180  #294

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

    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	JDatabaseDriverMysql->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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

66. Query Time: 0.16 ms After last query: 0.18 ms
    Duplicate queries: #61  #176  #181  #290  #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 = '135'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

67. Query Time: 0.16 ms After last query: 0.15 ms
    Duplicate queries: #182  #296

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

    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	JDatabaseDriverMysql->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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

68. Query Time: 0.15 ms After last query: 0.19 ms
    Duplicate queries: #62  #177  #183  #291  #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 = '136'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

69. Query Time: 0.17 ms After last query: 0.14 ms
    Duplicate queries: #184  #298

    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 = '137'  
      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	JDatabaseDriverMysql->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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

70. Query Time: 0.17 ms After last query: 0.19 ms
    Duplicate queries: #63  #178  #185  #292  #299

    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 = '137'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

71. Query Time: 0.19 ms After last query: 0.14 ms
    Duplicate queries: #186  #300

    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 = '138'  
      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	JDatabaseDriverMysql->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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

72. Query Time: 0.15 ms After last query: 0.17 ms
    Duplicate queries: #64  #179  #187  #293  #301

    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 = '138'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

73. Query Time: 0.15 ms After last query: 0.14 ms
    Duplicate queries: #188  #302

    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 = '109'  
      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	JDatabaseDriverMysql->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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

74. Query Time: 0.16 ms After last query: 1.92 ms
    Duplicate queries: #189  #303

    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 = '109'  
      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	JDatabaseDriverMysql->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:36
    22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

75. Query Time: 0.15 ms After last query: 0.51 ms
    Duplicate queries: #84  #190  #199  #304  #313

    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 = '139'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:42
    22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

76. Query Time: 0.14 ms After last query: 0.18 ms
    Duplicate queries: #86  #191  #201  #305  #315

    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 = '140'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:42
    22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

77. Query Time: 0.15 ms After last query: 0.19 ms
    Duplicate queries: #88  #192  #203  #306  #317

    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 = '141'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:42
    22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

78. Query Time: 0.15 ms After last query: 0.17 ms
    Duplicate queries: #90  #193  #205  #307  #319

    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 = '142'  
      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	JDatabaseDriverMysql->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:36
    23	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:42
    22	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:59
    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:68
    18	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    17	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:664
    16	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:259
    15	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:242
    14	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:580
    13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:501
    12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:532
    11	HelixMenu->showMenu()	JROOT/templates/vina_veneno/features/menu.php:65
    10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:225
    9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1173
    8	Helix::Header()	JROOT/templates/vina_veneno/index.php:32
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/joomla/document/html.php: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]

    ---

79. Query Time: 0.16 ms After last query: 0.17 ms