Máy trị liệu chườm nóng - 2 dải bó (650.000đ)

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713855703,
                "last": 1713855703,
                "now": 1713855703
            },
            "token": "mh8fLStvopvOH8RIBVFiIErFVXp59Jyp"
        },
        "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\/may-bo-thuoc-dong-y-2-dai-bo",
        "jshop_end_page_list_product": "\/san-pham\/may-bo-thuoc-dong-y-2-dai-bo"
    }
}

Time

Memory

84 Queries Logged 306.39 ms

1. Query Time: 0.69 ms Query memory: 0.007 MB Memory before query: 4.094 MB Rows returned: 0

   SELECT `data`
   
     FROM `veneno_session`
   
     WHERE `session_id` = X'3736653436376563363662656530336138313138653533653036656132643334'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	veneno_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.17 ms
   checking permissions	0.02 ms
   Opening tables	0.13 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.06 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.01 ms

   Call Stack

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

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

   ---

2. Query Time: 0.43 ms After last query: 1.44 ms Query memory: 0.004 MB Memory before query: 4.189 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `veneno_session`
   
     WHERE `session_id` = X'3736653436376563363662656530336138313138653533653036656132643334' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	veneno_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Profile

   Status	Duration
   starting	0.10 ms
   checking permissions	0.03 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   Call Stack

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

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

   ---

3. Query Time: 1.17 ms After last query: 0.12 ms Query memory: 0.004 MB Memory before query: 4.194 MB

   INSERT INTO `veneno_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3736653436376563363662656530336138313138653533653036656132643334', 1, 1713855703, 0, '', 0)

   Explain

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

   Profile

   Status	Duration
   starting	0.09 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.10 ms
   Waiting for query cache lock	0.01 ms
   update	0.01 ms
   end	0.01 ms
   query end	0.76 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.01 ms

   Call Stack

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

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

   ---

4. Query Time: 0.64 ms After last query: 6.79 ms Query memory: 0.005 MB Memory before query: 4.767 MB Rows returned: 5

   SELECT id, rules
   
     FROM `veneno_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.15 ms
   checking permissions	0.02 ms
   Opening tables	0.09 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.06 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   Call Stack

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

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

   ---

5. Query Time: 0.58 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 4.779 MB Rows returned: 1

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	100.00	Using where; Using index

   Profile

   Status	Duration
   starting	0.11 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.10 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   Call Stack

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

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

   ---

6. Query Time: 1.32 ms After last query: 11.81 ms Query memory: 0.006 MB Memory before query: 5.474 MB

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	UPDATE	veneno_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.16 ms
   checking permissions	0.02 ms
   Opening tables	0.10 ms
   init	0.05 ms
   System lock	0.12 ms
   updating	0.13 ms
   end	0.02 ms
   Waiting for query cache lock	0.02 ms
   end	0.03 ms
   query end	0.49 ms
   closing tables	0.03 ms
   freeing items	0.08 ms
   cleaning up	0.02 ms

   Call Stack

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

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

   ---

7. Query Time: 3.17 ms After last query: 43.07 ms Query memory: 0.009 MB Memory before query: 8.930 MB Rows returned: 140

   SHOW FULL COLUMNS 
     FROM `veneno_jshopping_config`

   Explain

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

   Profile

   Status	Duration
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.08 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.04 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   Sending data	0.29 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   removing tmp table	0.05 ms
   closing tables	0.01 ms
   freeing items	0.08 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
   18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/config.php:14
   15	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
   14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
   13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
   12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
   11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
   10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
   9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.75 ms After last query: 2.62 ms Query memory: 0.008 MB Memory before query: 9.288 MB Rows returned: 1

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	veneno_jshopping_config	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.12 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.09 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.10 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.12 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
   16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
   15	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/lib/factory.php:30
   14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
   13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
   12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
   11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
   10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
   9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.83 ms After last query: 0.65 ms Query memory: 0.011 MB Memory before query: 9.291 MB Rows returned: 8

   SHOW FULL COLUMNS 
     FROM `veneno_jshopping_currencies`

   Explain

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

   Profile

   Status	Duration
   starting	0.10 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.14 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.02 ms
   Opening tables	0.07 ms
   checking permissions	0.04 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   Sending data	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   removing tmp table	0.03 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
   22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   20	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
   19	jshopCurrency->__construct()	JROOT/libraries/src/Table/Table.php:312
   18	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
   17	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:548
   16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
   15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
   14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
   13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
   12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
   11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
   10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
   9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.57 ms After last query: 0.15 ms Query memory: 0.009 MB Memory before query: 9.313 MB Rows returned: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_currencies	NULL	ref	currency_publish	currency_publish	1	const	1	100.00	Using index condition; Using filesort

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
    17	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:549
    16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
    15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 1.50 ms After last query: 1.54 ms Query memory: 0.010 MB Memory before query: 9.402 MB Rows returned: 53
    Duplicate queries: #12

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_users`

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.13 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.04 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    20	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
    19	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/tables/usershop.php:15
    18	jshopUserShop->__construct()	JROOT/components/com_jshopping/lib/factory.php:47
    17	JSFactory::getUserShop()	JROOT/components/com_jshopping/tables/config.php:67
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
    15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 1.45 ms After last query: 0.61 ms Query memory: 0.010 MB Memory before query: 9.499 MB Rows returned: 53
    Duplicate queries: #11

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_users`

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    Opening tables	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.13 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.03 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    20	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
    19	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/models/userguest.php:16
    18	jshopUserGust->__construct()	JROOT/components/com_jshopping/lib/factory.php:66
    17	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:71
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
    15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.80 ms After last query: 0.64 ms Query memory: 0.011 MB Memory before query: 9.596 MB Rows returned: 10

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_usergroups`

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    Opening tables	0.07 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.05 ms
    end	0.02 ms
    query end	0.03 ms
    closing tables	0.01 ms
    removing tmp table	0.04 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    22	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/usergroup.php:14
    21	jshopUserGroup->__construct()	JROOT/libraries/src/Table/Table.php:312
    20	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    19	JSFactory::getTable()	JROOT/components/com_jshopping/models/userguest.php:30
    18	jshopUserGust->load()	JROOT/components/com_jshopping/lib/factory.php:67
    17	JSFactory::getUserShopGuest()	JROOT/components/com_jshopping/tables/config.php:71
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
    15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.64 ms After last query: 0.37 ms Query memory: 0.010 MB Memory before query: 9.628 MB Rows returned: 4

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_config_display_prices`

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.03 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    20	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/configdisplayprice.php:19
    19	jshopConfigDisplayPrice->__construct()	JROOT/libraries/src/Table/Table.php:312
    18	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    17	JSFactory::getTable()	JROOT/components/com_jshopping/tables/config.php:79
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
    15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.34 ms After last query: 0.11 ms Query memory: 0.009 MB Memory before query: 9.644 MB Rows returned: 1

    SELECT * 
      FROM `veneno_jshopping_config_display_prices`

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/configdisplayprice.php:38
    17	jshopConfigDisplayPrice->getList()	JROOT/components/com_jshopping/tables/config.php:80
    16	jshopConfig->getDisplayPriceFront()	JROOT/components/com_jshopping/tables/config.php:288
    15	jshopConfig->parseConfigVars()	JROOT/components/com_jshopping/lib/factory.php:35
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 1.67 ms After last query: 39.09 ms Query memory: 0.007 MB Memory before query: 9.728 MB Rows returned: 15

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

    Explain

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

    Profile

    Status	Duration
    starting	0.19 ms
    checking permissions	0.02 ms
    Opening tables	1.03 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:276
    14	JSFactory::getAliasProduct()	JROOT/plugins/jshoppingrouter/jshopping_product_seo/jshopping_product_seo.php:42
    13	plgJshoppingRouterJshopping_product_seo->onBeforeParseRoute()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/router.php:216
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 1.06 ms After last query: 0.13 ms Query memory: 0.006 MB Memory before query: 9.739 MB Rows returned: 9

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

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.67 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:242
    11	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:287
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 1.26 ms After last query: 41.38 ms Query memory: 0.006 MB Memory before query: 10.223 MB Rows returned: 2

    select * 
      from veneno_jshopping_languages

    Explain

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

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.02 ms
    Opening tables	0.68 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/functions.php:281
    8	installNewLanguages()	JROOT/components/com_jshopping/loadparams.php:32
    7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 2.30 ms After last query: 102.96 ms Query memory: 0.007 MB Memory before query: 10.852 MB Rows returned: 25

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_categories`

    Explain

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

    Profile

    Status	Duration
    starting	0.20 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.20 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.03 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.60 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Sending data	0.16 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.01 ms
    removing tmp table	0.06 ms
    closing tables	0.02 ms
    freeing items	0.10 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    12	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/category.php:15
    11	jshopCategory->__construct()	JROOT/libraries/src/Table/Table.php:312
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/category.php:56
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 1.10 ms After last query: 0.30 ms Query memory: 0.006 MB Memory before query: 10.898 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.14 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.04 ms
    executing	0.02 ms
    Sending data	0.50 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Call Stack

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

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

    ---

21. Query Time: 2.76 ms After last query: 530.23 ms Query memory: 0.009 MB Memory before query: 11.869 MB Rows returned: 0

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

    Explain

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

    Profile

    Status	Duration
    starting	0.24 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	1.59 ms
    init	0.08 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.15 ms
    preparing	0.04 ms
    Creating tmp table	0.05 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.17 ms
    Creating sort index	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.04 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.09 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:914
    11	changeDataUsePluginContent()	JROOT/components/com_jshopping/tables/category.php:251
    10	jshopCategory->preparePluginContent()	JROOT/components/com_jshopping/tables/category.php:66
    9	jshopCategory->getDescription()	JROOT/components/com_jshopping/controllers/category.php:58
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.49 ms After last query: 0.55 ms Query memory: 0.006 MB Memory before query: 11.877 MB Rows returned: 0

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

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    10	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:119
    9	jshopCategory->getChildCategories()	JROOT/components/com_jshopping/controllers/category.php:66
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 1.08 ms After last query: 9.68 ms Query memory: 0.007 MB Memory before query: 11.923 MB Rows returned: 1

    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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_menu	NULL	ALL	idx_client_id_parent_id_alias_language,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	197	0.51	Using where

    Profile

    Status	Duration
    starting	0.21 ms
    checking permissions	0.03 ms
    Opening tables	0.15 ms
    init	0.06 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	0.12 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.21 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:130
    13	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:41
    12	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:35
    11	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:387
    10	getShopMainPageItemid()	JROOT/components/com_jshopping/helpers/metadata.php:38
    9	JshopHelpersMetadata::category()	JROOT/components/com_jshopping/controllers/category.php:69
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 2.28 ms After last query: 143.88 ms Query memory: 0.009 MB Memory before query: 12.106 MB Rows returned: 31

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_vendors`

    Explain

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

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.17 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.04 ms
    executing	0.02 ms
    Opening tables	0.95 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.04 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/vendor.php:15
    15	jshopVendor->__construct()	JROOT/libraries/src/Table/Table.php:312
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    13	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:414
    12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1409
    11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:304
    10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 1.04 ms After last query: 0.21 ms Query memory: 0.007 MB Memory before query: 12.158 MB Rows returned: 1

    SELECT id 
      FROM veneno_jshopping_vendors 
      WHERE `main`=1

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.61 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.10 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/vendor.php:23
    13	jshopVendor->loadMain()	JROOT/components/com_jshopping/lib/factory.php:415
    12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1409
    11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:304
    10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.62 ms After last query: 0.15 ms Query memory: 0.007 MB Memory before query: 12.169 MB Rows returned: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_vendors	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.25 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    14	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/tables/vendor.php:24
    13	jshopVendor->loadMain()	JROOT/components/com_jshopping/lib/factory.php:415
    12	JSFactory::getMainVendor()	JROOT/components/com_jshopping/lib/functions.php:1409
    11	getBuildFilterListProduct()	JROOT/components/com_jshopping/tables/category.php:304
    10	jshopCategory->getFilterListProduct()	JROOT/components/com_jshopping/models/productlist.php:168
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 1.15 ms After last query: 0.61 ms Query memory: 0.010 MB Memory before query: 12.181 MB Rows returned: 3

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_taxes`

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    Opening tables	0.49 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.03 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    18	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
    17	jshopTax->__construct()	JROOT/libraries/src/Table/Table.php:312
    16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    15	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:342
    14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:955
    13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
    12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
    11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:178
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.41 ms After last query: 0.10 ms Query memory: 0.009 MB Memory before query: 12.197 MB Rows returned: 1

    SELECT tax_id, tax_name, tax_value 
      FROM `veneno_jshopping_taxes`

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:21
    16	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:328
    15	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:343
    14	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:955
    13	getCorrectedPriceForQueryFilter()	JROOT/components/com_jshopping/lib/jtableauto.php:101
    12	JTableAvto->getBuildQueryListProductFilterPrice()	JROOT/components/com_jshopping/lib/jtableauto.php:88
    11	JTableAvto->getBuildQueryListProduct()	JROOT/components/com_jshopping/tables/category.php:178
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 1.05 ms After last query: 0.09 ms Query memory: 0.006 MB Memory before query: 12.204 MB Rows returned: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	category_id	4	const	3	100.00	Using index
    1	SIMPLE	prod	NULL	eq_ref	PRIMARY,product_publish,access	PRIMARY	4	newpower_npl.pr_cat.product_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.48 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/category.php:188
    10	jshopCategory->getCountProducts()	JROOT/components/com_jshopping/models/productlist.php:172
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 1.24 ms After last query: 95.42 ms Query memory: 0.006 MB Memory before query: 12.341 MB Rows returned: 3

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	category_id	4	const	3	100.00	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	prod	NULL	eq_ref	PRIMARY,product_publish,access	PRIMARY	4	newpower_npl.pr_cat.product_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.22 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.11 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.23 ms
    Creating sort index	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.04 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:170
    10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 1.27 ms After last query: 2.36 ms Query memory: 0.009 MB Memory before query: 12.366 MB Rows returned: 6

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_product_labels`

    Explain

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

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    Opening tables	0.57 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.03 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/productlabel.php:14
    15	jshopProductLabel->__construct()	JROOT/libraries/src/Table/Table.php:312
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    13	JSFactory::getTable()	JROOT/components/com_jshopping/lib/functions.php:616
    12	getNameImageLabel()	JROOT/components/com_jshopping/lib/functions.php:751
    11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:171
    10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.36 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 12.384 MB Rows returned: 2

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

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productlabel.php:22
    13	jshopProductLabel->getListLabels()	JROOT/components/com_jshopping/lib/functions.php:617
    12	getNameImageLabel()	JROOT/components/com_jshopping/lib/functions.php:751
    11	listProductUpdateData()	JROOT/components/com_jshopping/tables/category.php:171
    10	jshopCategory->getProducts()	JROOT/components/com_jshopping/models/productlist.php:185
    9	jshopProductList->load()	JROOT/components/com_jshopping/controllers/category.php:73
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 2.72 ms After last query: 41.40 ms Query memory: 0.009 MB Memory before query: 12.518 MB Rows returned: 10

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_products_reviews`

    Explain

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

    Profile

    Status	Duration
    starting	0.22 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    Opening tables	0.23 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    preparing	0.05 ms
    executing	0.05 ms
    Opening tables	0.70 ms
    checking permissions	0.09 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.06 ms
    checking permissions	0.04 ms
    checking permissions	0.05 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    Sending data	0.11 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.03 ms
    removing tmp table	0.10 ms
    closing tables	0.05 ms
    freeing items	0.13 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/review.php:14
    12	jshopReview->__construct()	JROOT/libraries/src/Table/Table.php:312
    11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    10	JSFactory::getTable()	JROOT/components/com_jshopping/models/productlist.php:252
    9	jshopProductList->getAllowReview()	JROOT/components/com_jshopping/controllers/category.php:87
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 1.57 ms After last query: 106.55 ms Query memory: 0.011 MB Memory before query: 13.532 MB Rows returned: 46

    SHOW FULL COLUMNS 
      FROM `veneno_jshopping_products`

    Explain

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

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.18 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.02 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.15 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.04 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    18	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/product.php:15
    17	jshopProduct->__construct()	JROOT/libraries/src/Table/Table.php:312
    16	Joomla\CMS\Table\Table::getInstance()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:10
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 1.19 ms After last query: 0.27 ms Query memory: 0.010 MB Memory before query: 13.607 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.57 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.06 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.60 ms After last query: 1.18 ms Query memory: 0.010 MB Memory before query: 13.620 MB Rows returned: 2

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

    Explain

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

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.03 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.06 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.58 ms After last query: 0.92 ms Query memory: 0.010 MB Memory before query: 13.632 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.05 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:333
    16	jshopProduct->getImages()	JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
    15	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php	JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
    14	include JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
    13	include JROOT/templates/vina_veneno/html/com_jshopping/category/products.php	JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
    12	include JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_jshopping/views/category/view.html.php:13
    9	JshoppingViewCategory->display()	JROOT/components/com_jshopping/controllers/category.php:121
    8	JshoppingControllerCategory->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 1.13 ms After last query: 10.37 ms Query memory: 0.006 MB Memory before query: 13.647 MB Rows returned: 6

    SHOW FULL COLUMNS 
      FROM `veneno_template_styles`

    Explain

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

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.16 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.32 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.04 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    11	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    10	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    9	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
    8	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/helix/helix.php:83
    7	plgSystemHelix->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.46 ms After last query: 0.17 ms Query memory: 0.005 MB Memory before query: 13.665 MB Rows returned: 1

    SELECT *
    
      FROM veneno_template_styles
    
      WHERE `id` = '17'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_template_styles	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    9	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    8	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/helix/helix.php:84
    7	plgSystemHelix->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 2.15 ms After last query: 764.18 ms Query memory: 0.009 MB Memory before query: 14.610 MB Rows returned: 11

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM veneno_modules AS m
    
      LEFT JOIN veneno_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN veneno_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-23 07:01:45') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-23 07:01:45') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 397 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	14	1.60	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	newpower_npl.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	newpower_npl.m.id	4	40.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.21 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.98 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.45 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix/core/helix.php:735
    11	Helix::countModules()	JROOT/plugins/system/helix/core/helix.php:351
    10	Helix::showRow()	JROOT/plugins/system/helix/core/helix.php:448
    9	Helix::generatelayout()	JROOT/plugins/system/helix/core/helix.php:713
    8	Helix::layout()	JROOT/templates/vina_veneno/index.php:98
    7	require JROOT/templates/vina_veneno/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 1.23 ms After last query: 330.99 ms Query memory: 0.007 MB Memory before query: 14.993 MB Rows returned: 8
    Duplicate queries: #68

    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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_publish	1	const	8	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.65 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    14	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:131
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.52 ms After last query: 3.12 ms Query memory: 0.009 MB Memory before query: 15.096 MB Rows returned: 0
    Duplicate queries: #69

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.40 ms After last query: 0.13 ms Query memory: 0.010 MB Memory before query: 15.109 MB Rows returned: 0
    Duplicate queries: #70

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 0.42 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 15.116 MB Rows returned: 0
    Duplicate queries: #71

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 0.38 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 15.129 MB Rows returned: 0
    Duplicate queries: #72

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Query Time: 0.41 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 15.136 MB Rows returned: 0
    Duplicate queries: #73

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 0.38 ms After last query: 0.12 ms Query memory: 0.010 MB Memory before query: 15.149 MB Rows returned: 0
    Duplicate queries: #74

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 0.43 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 15.156 MB Rows returned: 0
    Duplicate queries: #75

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Query Time: 0.38 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 15.168 MB Rows returned: 0
    Duplicate queries: #76

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 0.45 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 15.175 MB Rows returned: 0
    Duplicate queries: #77

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 0.39 ms After last query: 0.12 ms Query memory: 0.010 MB Memory before query: 15.188 MB Rows returned: 0
    Duplicate queries: #78

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Query Time: 0.42 ms After last query: 0.11 ms Query memory: 0.009 MB Memory before query: 15.195 MB Rows returned: 0
    Duplicate queries: #79

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

53. Query Time: 0.38 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 15.208 MB Rows returned: 0
    Duplicate queries: #80

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

54. Query Time: 0.49 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 15.215 MB Rows returned: 0
    Duplicate queries: #81

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

55. Query Time: 0.41 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 15.228 MB Rows returned: 0
    Duplicate queries: #82

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.08 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

56. Query Time: 0.40 ms After last query: 0.10 ms Query memory: 0.009 MB Memory before query: 15.235 MB Rows returned: 0
    Duplicate queries: #83

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

57. Query Time: 0.41 ms After last query: 0.12 ms Query memory: 0.010 MB Memory before query: 15.247 MB Rows returned: 0
    Duplicate queries: #84

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:99
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

58. Query Time: 1.06 ms After last query: 14.37 ms Query memory: 0.009 MB Memory before query: 15.218 MB Rows returned: 10

    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
                      
      INNER JOIN `veneno_jshopping_products_to_categories` AS pr_cat 
      ON pr_cat.product_id = prod.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_id DESC 
      LIMIT 10

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	prod	NULL	ref	PRIMARY,product_manufacturer_id,parent_id,product_ean,unlimited,product_publish,product_tax_id,currency_id,product_price,min_price,add_price_unit_id,average_rating,reviews_count,delivery_times_id,hits,basic_price_unit_id,label_id,vendor_id,access	product_publish	1	const	17	100.00	Using where
    1	SIMPLE	pr_cat	NULL	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	newpower_npl.prod.product_id	1	100.00	Using index
    1	SIMPLE	cat	NULL	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	newpower_npl.pr_cat.category_id	1	72.73	Using where

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.07 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.29 ms
    end	0.01 ms
    query end	0.03 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:838
    16	jshopProduct->getLastProducts()	JROOT/modules/mod_vina_ticker_jshopping/helper.php:115
    15	modVinaTickerJShoppingHelper::getLatest()	JROOT/modules/mod_vina_ticker_jshopping/helper.php:37
    14	modVinaTickerJShoppingHelper::getItems()	JROOT/modules/mod_vina_ticker_jshopping/mod_vina_ticker_jshopping.php:31
    13	include JROOT/modules/mod_vina_ticker_jshopping/mod_vina_ticker_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

59. Query Time: 1.83 ms After last query: 308.15 ms Query memory: 0.007 MB Memory before query: 15.959 MB

    CREATE TABLE IF NOT EXISTS veneno_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1

    Explain

    EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS veneno_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    Opening tables	1.44 ms
    After create	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    14	JDatabase->query()	JROOT/modules/mod_vvisit_counter/helper.php:1404
    13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
    12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
    11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
    10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

60. Query Time: 36.41 ms After last query: 0.07 ms Query memory: 0.007 MB Memory before query: 15.966 MB Rows returned: 1

    SELECT count( * ) AS records, MAX( id ) AS max 
      FROM veneno_vvisitcounter

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Select tables optimized away

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	35.83 ms
    executing	0.05 ms
    end	0.03 ms
    query end	0.04 ms
    closing tables	0.04 ms
    freeing items	0.14 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
    14	JDatabaseDriver->loadRow()	JROOT/modules/mod_vvisit_counter/helper.php:1417
    13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
    12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
    11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
    10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

61. Query Time: 5.32 ms After last query: 0.15 ms Query memory: 0.007 MB Memory before query: 15.974 MB

    DELETE 
      FROM veneno_vvisitcounter 
      WHERE id<='168812'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	DELETE	veneno_vvisitcounter	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.04 ms
    Opening tables	0.04 ms
    init	0.05 ms
    System lock	0.37 ms
    updating	4.17 ms
    end	0.04 ms
    Waiting for query cache lock	0.06 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.18 ms
    freeing items	0.11 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    14	JDatabase->query()	JROOT/modules/mod_vvisit_counter/helper.php:1560
    13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
    12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
    11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
    10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

62. Query Time: 94.48 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 15.981 MB Rows returned: 1

    SELECT COUNT(*) 
      FROM veneno_vvisitcounter 
      WHERE ip=UNHEX(SHA1('3.142.250.114')) 
      AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_vvisitcounter	NULL	ref	ip,iptm	iptm	20	const	1	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	93.59 ms
    preparing	0.08 ms
    executing	0.03 ms
    Sending data	0.25 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.14 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1612
    13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
    12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
    11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
    10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

63. Query Time: 2.53 ms After last query: 0.15 ms Query memory: 0.007 MB Memory before query: 15.988 MB

    INSERT INTO veneno_vvisitcounter ( tm, ip, data ) 
      VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('3.142.250.114')) , NULL )

    Explain

    EXPLAIN not possible on query: INSERT INTO veneno_vvisitcounter ( tm, ip, data ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('3.142.250.114')) , NULL )

    Profile

    Status	Duration
    starting	0.20 ms
    checking permissions	0.04 ms
    Opening tables	0.06 ms
    init	0.06 ms
    System lock	0.04 ms
    update	1.49 ms
    Waiting for query cache lock	0.05 ms
    update	0.04 ms
    end	0.05 ms
    query end	0.03 ms
    closing tables	0.20 ms
    freeing items	0.13 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    14	JDatabase->query()	JROOT/modules/mod_vvisit_counter/helper.php:1651
    13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
    12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
    11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
    10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

64. Query Time: 1.25 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 15.996 MB Rows returned: 1

    SELECT COUNT(*) 
      FROM veneno_vvisitcounter 
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW())) 
      AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_vvisitcounter	NULL	range	tm	tm	4	NULL	44	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.06 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	0.24 ms
    preparing	0.05 ms
    executing	0.04 ms
    Sending data	0.26 ms
    end	0.04 ms
    query end	0.05 ms
    closing tables	0.05 ms
    freeing items	0.10 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1920
    13	modVisitCounterHelper->sql_today_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:763
    12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
    11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
    10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

65. Query Time: 1.08 ms After last query: 0.10 ms Query memory: 0.013 MB Memory before query: 16.013 MB Rows returned: 1

    SELECT COUNT(*) 
      FROM veneno_vvisitcounter 
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY)) 
      AND UNIX_TIMESTAMP(DATE(NOW()))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_vvisitcounter	NULL	range	tm	tm	4	NULL	77	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.26 ms
    preparing	0.03 ms
    executing	0.03 ms
    Sending data	0.30 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1935
    13	modVisitCounterHelper->sql_yesterday_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:774
    12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
    11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
    10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

66. Query Time: 0.88 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 16.027 MB Rows returned: 1

    SELECT COUNT(*) 
      FROM veneno_vvisitcounter 
      WHERE tm BETWEEN 1713744000 
      AND 1714348800

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_vvisitcounter	NULL	range	tm	tm	4	NULL	109	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.38 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1979
    13	modVisitCounterHelper->sql_week_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:784
    12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
    11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
    10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

67. Query Time: 99.19 ms After last query: 0.09 ms Query memory: 0.007 MB Memory before query: 16.035 MB Rows returned: 1

    SELECT COUNT(*) 
      FROM veneno_vvisitcounter 
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01")) 
      AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_vvisitcounter	NULL	range	tm	tm	4	NULL	1835	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	90.93 ms
    preparing	0.06 ms
    executing	0.03 ms
    Sending data	7.74 ms
    end	0.04 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.09 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1994
    13	modVisitCounterHelper->sql_month_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:808
    12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
    11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
    10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

68. Query Time: 1.24 ms After last query: 2.75 ms Query memory: 0.007 MB Memory before query: 16.142 MB Rows returned: 8
    Duplicate queries: #41

    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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_publish	1	const	8	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.68 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    14	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:131
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

69. Query Time: 0.63 ms After last query: 64.18 ms Query memory: 0.009 MB Memory before query: 16.240 MB Rows returned: 0
    Duplicate queries: #42

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.09 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

70. Query Time: 0.40 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 16.253 MB Rows returned: 0
    Duplicate queries: #43

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

71. Query Time: 0.45 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 16.260 MB Rows returned: 0
    Duplicate queries: #44

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

72. Query Time: 0.41 ms After last query: 0.09 ms Query memory: 0.010 MB Memory before query: 16.272 MB Rows returned: 0
    Duplicate queries: #45

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

73. Query Time: 0.43 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 16.279 MB Rows returned: 0
    Duplicate queries: #46

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

74. Query Time: 0.40 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 16.292 MB Rows returned: 0
    Duplicate queries: #47

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

75. Query Time: 0.45 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 16.299 MB Rows returned: 0
    Duplicate queries: #48

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

76. Query Time: 0.39 ms After last query: 0.10 ms Query memory: 0.010 MB Memory before query: 16.312 MB Rows returned: 0
    Duplicate queries: #49

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

77. Query Time: 0.44 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 16.319 MB Rows returned: 0
    Duplicate queries: #50

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

78. Query Time: 0.39 ms After last query: 0.10 ms Query memory: 0.010 MB Memory before query: 16.332 MB Rows returned: 0
    Duplicate queries: #51

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

79. Query Time: 0.41 ms After last query: 0.07 ms Query memory: 0.009 MB Memory before query: 16.339 MB Rows returned: 0
    Duplicate queries: #52

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

80. Query Time: 0.39 ms After last query: 0.09 ms Query memory: 0.010 MB Memory before query: 16.351 MB Rows returned: 0
    Duplicate queries: #53

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

81. Query Time: 0.42 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 16.358 MB Rows returned: 0
    Duplicate queries: #54

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

82. Query Time: 0.38 ms After last query: 0.09 ms Query memory: 0.010 MB Memory before query: 16.371 MB Rows returned: 0
    Duplicate queries: #55

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

83. Query Time: 0.42 ms After last query: 0.07 ms Query memory: 0.009 MB Memory before query: 16.378 MB Rows returned: 0
    Duplicate queries: #56

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,category_publish,access,category_publish_2	category_parent_id	4	const	1	72.73	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    16	jshopCategory->getSubCategories()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

84. Query Time: 0.40 ms After last query: 0.10 ms Query memory: 0.010 MB Memory before query: 16.391 MB Rows returned: 0
    Duplicate queries: #57

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	veneno_jshopping_categories	NULL	ref	category_parent_id,access	category_parent_id	4	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    18	jshopCategory->getSubCategories()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
    17	modVinaCMenuJShoppingHelper::getChildCategory()	JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
    16	modVinaCMenuJShoppingHelper::getActiveState()	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
    15	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php	JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
    14	require JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php	JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
    13	include JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    12	JModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:608
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---