{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1763551806,
                "last": 1763551806,
                "now": 1763551806
            }
        },
        "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.html",
        "jshop_end_page_list_product": "\/san-pham.html"
    }
}

Time

Memory

400 Queries Logged 113.66 ms

1. Query Time: 0.88 ms

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

   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.67 ms After last query: 1.23 ms

   SELECT `session_id`
   
     FROM `veneno_session`
   
     WHERE `session_id` = 'mmiqout7i4f4raq7ctojlicqk5' 
     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.84 ms After last query: 0.27 ms

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

   Explain

   EXPLAIN not possible on query: INSERT INTO `veneno_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES ('mmiqout7i4f4raq7ctojlicqk5', 1, '1763551806', 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.28 ms After last query: 1.96 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: 3.31 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.16 ms After last query: 0.39 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: 2.42 ms After last query: 0.22 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: 0.89 ms After last query: 13.21 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.53 ms After last query: 0.28 ms

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

   Explain

   EXPLAIN not possible on query: UPDATE `veneno_extensions` SET `params` = '{\"mediaversion\":\"d7fd7defa2ace6fbd927dbec005d9971\"}' 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: 1.36 ms After last query: 11.45 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: 0.63 ms After last query: 1.28 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: 0.21 ms After last query: 45.53 ms

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	veneno_languages	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]

    ---

13. Query Time: 1.37 ms After last query: 5.15 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
    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/config.php:14
    12	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
    11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:14
    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]

    ---

14. Query Time: 0.23 ms After last query: 2.79 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
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1445
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    12	JTable->load()	JROOT/components/com_jshopping/lib/factory.php:30
    11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:14
    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]

    ---

15. Query Time: 0.82 ms After last query: 1.07 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
    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/currency.php:14
    16	jshopCurrency->__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:548
    13	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
    12	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
    11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:14
    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]

    ---

16. Query Time: 0.16 ms After last query: 0.16 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
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
    14	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:549
    13	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
    12	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
    11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:14
    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]

    ---

17. Query Time: 0.92 ms After last query: 0.40 ms
    Duplicate queries: #18

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_users`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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/usershopbase.php:14
    16	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/tables/usershop.php:15
    15	jshopUserShop->__construct()	JROOT/components/com_jshopping/lib/factory.php:47
    14	JSFactory::getUserShop()	JROOT/components/com_jshopping/tables/config.php:67
    13	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
    12	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:14
    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]

    ---

18. Query Time: 0.88 ms After last query: 0.87 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
    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/usershopbase.php:14
    16	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/models/userguest.php:16
    15	jshopUserGust->__construct()	JROOT/components/com_jshopping/lib/factory.php:66
    14	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:71
    13	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
    12	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:14
    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]

    ---

19. Query Time: 0.76 ms After last query: 1.00 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
    23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    19	JTable->__construct()	JROOT/components/com_jshopping/tables/usergroup.php:14
    18	jshopUserGroup->__construct()	JROOT/libraries/joomla/table/table.php:311
    17	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    16	JSFactory::getTable()	JROOT/components/com_jshopping/models/userguest.php:30
    15	jshopUserGust->load()	JROOT/components/com_jshopping/lib/factory.php:67
    14	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:71
    13	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
    12	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:14
    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]

    ---

20. Query Time: 0.71 ms After last query: 0.93 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
    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/configdisplayprice.php:19
    16	jshopConfigDisplayPrice->__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/tables/config.php:79
    13	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
    12	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:14
    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]

    ---

21. Query Time: 0.16 ms After last query: 0.16 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
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/configdisplayprice.php:38
    14	jshopConfigDisplayPrice->getList()	JROOT/components/com_jshopping/tables/config.php:80
    13	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
    12	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    11	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    10	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    9	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    8	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/loadparams.php:14
    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]

    ---

22. Query Time: 0.20 ms After last query: 16.33 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]

    ---

23. Query Time: 1.15 ms After last query: 19.19 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
    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/product.php:15
    11	jshopProduct->__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/products.php:25
    8	JshoppingControllerProducts->display()	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]

    ---

24. Query Time: 0.92 ms After last query: 1.49 ms

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_config_seo`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    14	JTable->__construct()	JROOT/components/com_jshopping/tables/seo.php:14
    13	jshopSeo->__construct()	JROOT/libraries/joomla/table/table.php:311
    12	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    11	JSFactory::getTable()	JROOT/components/com_jshopping/helpers/metadata.php:25
    10	JshopHelpersMetadata::metaData()	JROOT/components/com_jshopping/helpers/metadata.php:272
    9	JshopHelpersMetadata::allProducts()	JROOT/components/com_jshopping/controllers/products.php:31
    8	JshoppingControllerProducts->display()	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.16 ms After last query: 0.29 ms

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1642
    12	JDatabaseDriver->loadObject()	JROOT/components/com_jshopping/tables/seo.php:22
    11	jshopSeo->loadData()	JROOT/components/com_jshopping/helpers/metadata.php:26
    10	JshopHelpersMetadata::metaData()	JROOT/components/com_jshopping/helpers/metadata.php:272
    9	JshopHelpersMetadata::allProducts()	JROOT/components/com_jshopping/controllers/products.php:31
    8	JshoppingControllerProducts->display()	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.89 ms After last query: 1.72 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/product.php:1252
    10	jshopProduct->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.31 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/product.php:1252
    10	jshopProduct->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.17 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/product.php:1252
    10	jshopProduct->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.73 ms After last query: 0.72 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
    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/productfield.php:14
    17	jshopProductField->__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:475
    14	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1098
    13	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:37
    12	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/product.php:1005
    11	jshopProduct->getCountAllProducts()	JROOT/components/com_jshopping/tables/product.php:1021
    10	jshopProduct->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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: 0.17 ms After last query: 0.24 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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfield.php:48
    15	jshopProductField->getList()	JROOT/components/com_jshopping/lib/factory.php:476
    14	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1098
    13	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:37
    12	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/product.php:1005
    11	jshopProduct->getCountAllProducts()	JROOT/components/com_jshopping/tables/product.php:1021
    10	jshopProduct->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.73 ms After last query: 0.80 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
    23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    19	JTable->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
    18	jshopTax->__construct()	JROOT/libraries/joomla/table/table.php:311
    17	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    16	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:342
    15	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:955
    14	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
    13	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
    12	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/product.php:1005
    11	jshopProduct->getCountAllProducts()	JROOT/components/com_jshopping/tables/product.php:1021
    10	jshopProduct->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.18 ms After last query: 0.21 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
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:21
    17	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:328
    16	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:343
    15	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:955
    14	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
    13	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
    12	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/product.php:1005
    11	jshopProduct->getCountAllProducts()	JROOT/components/com_jshopping/tables/product.php:1021
    10	jshopProduct->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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: 6.11 ms After last query: 0.15 ms

    SELECT COUNT(distinct prod.product_id) 
      FROM `veneno_jshopping_products` as prod
                      
      LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `veneno_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cat	ref	PRIMARY,category_publish,access,category_publish_2	category_publish_2	1	const	44	Using where; Using index
    1	SIMPLE	pr_cat	ref	PRIMARY,category_id,product_id,product_id_2	category_id	4	shopguitar_home.cat.category_id	7
    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
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    12	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/product.php:1017
    11	jshopProduct->getCountAllProducts()	JROOT/components/com_jshopping/tables/product.php:1021
    10	jshopProduct->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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: 1.87 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
    23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:130
    21	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:41
    20	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:35
    19	shopItemMenu::getInstance()	JROOT/components/com_jshopping/router.php:15
    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/libraries/cms/pagination/pagination.php:778
    11	JPagination->_buildDataObject()	JROOT/libraries/cms/pagination/pagination.php:319
    10	JPagination->getPagesLinks()	JROOT/components/com_jshopping/models/productlist.php:180
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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: 6.91 ms After last query: 3.88 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)
                      
      LEFT JOIN `veneno_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1)
                      
      GROUP BY prod.product_id  
      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	cat	ref	PRIMARY,category_publish,access,category_publish_2	category_publish_2	1	const	44	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	pr_cat	ref	PRIMARY,category_id,product_id,product_id_2	category_id	4	shopguitar_home.cat.category_id	7
    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
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:997
    11	jshopProduct->getAllProducts()	JROOT/components/com_jshopping/tables/product.php:1025
    10	jshopProduct->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.78 ms After last query: 0.91 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
    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/productfieldvalue.php:15
    17	jshopProductFieldValue->__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:484
    14	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/lib/functions.php:787
    13	getProductExtraFieldForProduct()	JROOT/components/com_jshopping/lib/functions.php:712
    12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:998
    11	jshopProduct->getAllProducts()	JROOT/components/com_jshopping/tables/product.php:1025
    10	jshopProduct->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.15 ms After last query: 0.18 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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:26
    15	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/lib/factory.php:485
    14	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/lib/functions.php:787
    13	getProductExtraFieldForProduct()	JROOT/components/com_jshopping/lib/functions.php:712
    12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:998
    11	jshopProduct->getAllProducts()	JROOT/components/com_jshopping/tables/product.php:1025
    10	jshopProduct->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.71 ms After last query: 0.76 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
    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/productlabel.php:14
    16	jshopProductLabel->__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/functions.php:616
    13	getNameImageLabel()	JROOT/components/com_jshopping/lib/functions.php:751
    12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:998
    11	jshopProduct->getAllProducts()	JROOT/components/com_jshopping/tables/product.php:1025
    10	jshopProduct->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.16 ms After last query: 0.18 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
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productlabel.php:22
    14	jshopProductLabel->getListLabels()	JROOT/components/com_jshopping/lib/functions.php:617
    13	getNameImageLabel()	JROOT/components/com_jshopping/lib/functions.php:751
    12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:998
    11	jshopProduct->getAllProducts()	JROOT/components/com_jshopping/tables/product.php:1025
    10	jshopProduct->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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: 2.03 ms After last query: 0.87 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
    24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:276
    22	JSFactory::getAliasProduct()	JROOT/components/com_jshopping/router.php:69
    21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
    19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    17	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    15	JRoute::_()	JROOT/components/com_jshopping/lib/functions.php:479
    14	SEFLink()	JROOT/components/com_jshopping/lib/functions.php:429
    13	addLinkToProducts()	JROOT/components/com_jshopping/lib/functions.php:763
    12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:998
    11	jshopProduct->getAllProducts()	JROOT/components/com_jshopping/tables/product.php:1025
    10	jshopProduct->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.11 ms After last query: 0.28 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
    24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:242
    22	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:70
    21	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
    19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    17	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    15	JRoute::_()	JROOT/components/com_jshopping/lib/functions.php:479
    14	SEFLink()	JROOT/components/com_jshopping/lib/functions.php:429
    13	addLinkToProducts()	JROOT/components/com_jshopping/lib/functions.php:763
    12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:998
    11	jshopProduct->getAllProducts()	JROOT/components/com_jshopping/tables/product.php:1025
    10	jshopProduct->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/products.php:35
    8	JshoppingControllerProducts->display()	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.87 ms After last query: 7.38 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/products.php:50
    8	JshoppingControllerProducts->display()	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.99 ms After last query: 5.65 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 = '599' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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.81 ms After last query: 0.77 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 = '387' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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.54 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 = '600' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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: 0.51 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 = '601' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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: 0.51 ms After last query: 0.76 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 = '602' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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.60 ms After last query: 0.73 ms

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `veneno_jshopping_products_images` as I 
      left join `veneno_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '603' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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.83 ms After last query: 1.08 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 = '439' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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.55 ms After last query: 1.03 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 = '604' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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.56 ms After last query: 1.03 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 = '605' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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.51 ms After last query: 1.06 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 = '606' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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.58 ms After last query: 1.08 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 = '607' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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.57 ms After last query: 1.04 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 = '629' 
      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
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    15	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    14	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
    13	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/products/products.php:21
    12	include JROOT/templates/vina_veneno/html/com_jshopping/products/products.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/products/view.html.php:13
    9	JshoppingViewProducts->display()	JROOT/components/com_jshopping/controllers/products.php:82
    8	JshoppingControllerProducts->display()	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.68 ms After last query: 23.51 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:30:06') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-11-19 11:30:06') 
      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]

    ---

56. Query Time: 0.94 ms After last query: 2.79 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
    25	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    21	JTable->__construct()	JROOT/components/com_jshopping/tables/category.php:15
    20	jshopCategory->__construct()	JROOT/libraries/joomla/table/table.php:311
    19	JTable::getInstance()	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:65
    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]

    ---

57. Query Time: 0.20 ms After last query: 0.52 ms
    Duplicate queries: #172  #286

    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]

    ---

58. Query Time: 0.23 ms After last query: 8.61 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 = '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]

    ---

59. Query Time: 0.13 ms After last query: 1.92 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 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]

    ---

60. Query Time: 0.13 ms After last query: 0.71 ms
    Duplicate queries: #65  #175  #180  #289  #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 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]

    ---

61. Query Time: 0.12 ms After last query: 0.31 ms
    Duplicate queries: #67  #176  #182  #290  #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 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.15 ms After last query: 0.34 ms
    Duplicate queries: #69  #177  #184  #291  #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 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.12 ms After last query: 0.31 ms
    Duplicate queries: #71  #178  #186  #292  #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 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.12 ms After last query: 0.49 ms
    Duplicate queries: #179  #293

    SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
      FROM `veneno_jshopping_categories`
                       
      WHERE category_parent_id = '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]

    ---

65. Query Time: 0.13 ms After last query: 0.31 ms
    Duplicate queries: #60  #175  #180  #289  #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 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]

    ---

66. Query Time: 0.13 ms After last query: 0.23 ms
    Duplicate queries: #181  #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 = '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]

    ---

67. Query Time: 0.14 ms After last query: 0.31 ms
    Duplicate queries: #61  #176  #182  #290  #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 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]

    ---

68. Query Time: 0.11 ms After last query: 0.24 ms
    Duplicate queries: #183  #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 = '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]

    ---

69. Query Time: 0.11 ms After last query: 0.35 ms
    Duplicate queries: #62  #177  #184  #291  #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 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]

    ---

70. Query Time: 0.11 ms After last query: 0.26 ms
    Duplicate queries: #185  #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 = '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]

    ---

71. Query Time: 0.11 ms After last query: 0.28 ms
    Duplicate queries: #63  #178  #186  #292  #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 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]

    ---

72. Query Time: 0.10 ms After last query: 0.19 ms
    Duplicate queries: #187  #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 = '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]

    ---

73. Query Time: 0.89 ms After last query: 1.98 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 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]

    ---

74. Query Time: 0.33 ms After last query: 0.58 ms
    Duplicate queries: #83  #189  #198  #303  #312

    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]

    ---

75. Query Time: 0.77 ms After last query: 0.20 ms
    Duplicate queries: #85  #190  #200  #304  #314

    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]

    ---

76. Query Time: 0.22 ms After last query: 0.18 ms
    Duplicate queries: #87  #191  #202  #305  #316

    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]

    ---

77. Query Time: 0.20 ms After last query: 0.21 ms