**BChef2Me - Home**

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1532137502,
                "last": 1532137502,
                "now": 1532137502
            },
            "token": "lSTU45PwBqNf73b3GKdy9n3Eafcit34O"
        },
        "registry": {
            "com_hikashop": {
                "user_id": 0
            }
        },
        "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
        }
    }
}

Profile Information

Time

Memory

**Time**: 25.54 ms / 25.54 ms **Memory**: 1.523 MB / 1.85 MB Application: afterLoad

**Time**: 332.96 ms / 358.50 ms **Memory**: 9.943 MB / 11.80 MB Application: afterInitialise

**Time**: 190.56 ms / 549.06 ms **Memory**: 0.793 MB / 12.59 MB Application: afterRoute

**Time**: 4.31 ms / 553.37 ms **Memory**: 0.038 MB / 12.63 MB Application: beforeRenderComponent com_content

**Time**: 44.22 ms / 597.59 ms **Memory**: 0.257 MB / 12.88 MB Application: Before Access::preloadComponents (all components)

**Time**: 2.87 ms / 600.46 ms **Memory**: 0.070 MB / 12.95 MB Application: After Access::preloadComponents (all components)

**Time**: 0.06 ms / 600.51 ms **Memory**: 0.000 MB / 12.95 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**Time**: 0.86 ms / 601.37 ms **Memory**: 0.026 MB / 12.98 MB Application: After Access::getAssetRules (id:8 name:com_content)

**Time**: 227.75 ms / 829.12 ms **Memory**: 0.887 MB / 13.86 MB Application: afterRenderComponent com_content

**Time**: 115.28 ms / 944.40 ms **Memory**: 0.978 MB / 14.84 MB Application: Before Access::getAssetRules (id:1 name:root.1)

**Time**: 0.10 ms / 944.51 ms **Memory**: 0.007 MB / 14.85 MB Application: After Access::getAssetRules (id:1 name:root.1)

**Time**: 53.97 ms / 998.48 ms **Memory**: 0.349 MB / 15.20 MB Application: beforeRenderModule mod_acymailing (Notify Me)

**Time**: 74.22 ms / 1072.69 ms **Memory**: 1.190 MB / 16.39 MB Application: afterRenderModule mod_acymailing (Notify Me)

**Time**: 241.12 ms / 1313.81 ms **Memory**: 0.418 MB / 16.81 MB Application: afterDispatch

**Time**: 55.97 ms / 1369.78 ms **Memory**: 0.243 MB / 17.05 MB Application: Before Access::getAssetRules (id:94 name:com_jfbconnect)

**Time**: 0.05 ms / 1369.82 ms **Memory**: 0.002 MB / 17.05 MB Application: After Access::getAssetRules (id:94 name:com_jfbconnect)

**Time**: 0.82 ms / 1370.65 ms **Memory**: 0.017 MB / 17.07 MB Application: beforeRenderModule mod_custom (Copyright)

**Time**: 4.08 ms / 1374.73 ms **Memory**: 0.008 MB / 17.08 MB Application: afterRenderModule mod_custom (Copyright)

**Time**: 0.16 ms / 1374.89 ms **Memory**: 0.000 MB / 17.07 MB Application: beforeRenderModule mod_login (Login)

**Time**: 12.12 ms / 1387.01 ms **Memory**: 0.052 MB / 17.13 MB Application: afterRenderModule mod_login (Login)

**Time**: 0.13 ms / 1387.14 ms **Memory**: 0.000 MB / 17.12 MB Application: beforeRenderModule mod_custom (About)

**Time**: 0.38 ms / 1387.51 ms **Memory**: 0.003 MB / 17.13 MB Application: afterRenderModule mod_custom (About)

**Time**: 0.06 ms / 1387.57 ms **Memory**: 0.003 MB / 17.13 MB Application: beforeRenderModule mod_acymailing (Notify Me)

**Time**: 3.08 ms / 1390.65 ms **Memory**: 0.048 MB / 17.18 MB Application: afterRenderModule mod_acymailing (Notify Me)

**Time**: 0.10 ms / 1390.76 ms **Memory**: 0.000 MB / 17.16 MB Application: beforeRenderModule mod_hikashop_cart (My Basket)

**Time**: 259.10 ms / 1649.85 ms **Memory**: 5.828 MB / 22.98 MB Application: afterRenderModule mod_hikashop_cart (My Basket)

**Time**: 0.18 ms / 1650.03 ms **Memory**: 0.000 MB / 22.97 MB Application: beforeRenderModule mod_custom (Search a Chef)

**Time**: 0.38 ms / 1650.41 ms **Memory**: 0.003 MB / 22.97 MB Application: afterRenderModule mod_custom (Search a Chef)

**Time**: 0.10 ms / 1650.52 ms **Memory**: 0.004 MB / 22.97 MB Application: beforeRenderModule mod_sclogin (Login or Register)

**Time**: 100.06 ms / 1750.58 ms **Memory**: 0.311 MB / 23.28 MB Application: afterRenderModule mod_sclogin (Login or Register)

**Time**: 1975.68 ms / 3726.26 ms **Memory**: 1.559 MB / 24.84 MB Application: afterRender

**Database queries total: 179.52 ms**

Memory Usage

Database Queries

64 Queries Logged 179.52 ms

6 duplicate found!

**4 duplicates**: #22 #29 #36 #43

**2 duplicates**: #57 #59

**Query Time: 1.70 ms** **Query memory: 0.025 MB Memory before query: 3.374 MB** **Rows returned: 0**

SELECT `data`

  FROM `josixih_session`

  WHERE `session_id` = '8dd51696636a2eff0aea8132cbcb8777'

**Explain**

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

**Profile**

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.07 ms
checking permissions	0.02 ms
Opening tables	0.19 ms
After opening tables	0.05 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.04 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.68 ms
preparing	0.02 ms
executing	0.13 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.09 ms
cleaning up	0.02 ms

**Call Stack**

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

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

**Query Time: 15.22 ms** **After last query: 2.19 ms** **Query memory: 0.022 MB Memory before query: 3.476 MB** **Rows returned: 0**

SELECT `session_id`

  FROM `josixih_session`

  WHERE `session_id` = '8dd51696636a2eff0aea8132cbcb8777' 
  LIMIT 1

**Explain**

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

**Profile**

Status	Duration
starting	0.04 ms
Waiting for query cache lock	14.30 ms
init	0.06 ms
checking query cache for query	0.07 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.14 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.07 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

**Call Stack**

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

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

**Query Time: 5.12 ms** **After last query: 0.23 ms** **Query memory: 0.004 MB Memory before query: 3.481 MB**

INSERT INTO `josixih_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('8dd51696636a2eff0aea8132cbcb8777', 1, '1532137502', 0, '', 0)

**Explain**

**EXPLAIN not possible on query: INSERT INTO `josixih_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('8dd51696636a2eff0aea8132cbcb8777', 1, '1532137502', 0, '', 0)**

**Profile**

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
update	0.25 ms
Waiting for query cache lock	0.02 ms
update	0.02 ms
end	0.01 ms
query end	4.49 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.04 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:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

**Query Time: 2.29 ms** **After last query: 5.47 ms** **Query memory: 0.032 MB Memory before query: 3.748 MB** **Rows returned: 49**

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

  FROM `josixih_extensions`

  WHERE `type` = 'component'

**Explain**

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

**Profile**

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.85 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.22 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.44 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

**Call Stack**

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

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

**Query Time: 0.24 ms** **After last query: 4.03 ms** **Query memory: 0.023 MB Memory before query: 3.953 MB** **Rows returned: 6**

SELECT id, rules

  FROM `josixih_viewlevels`

**Explain**

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

**Profile**

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

**Call Stack**

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

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

**Query Time: 0.18 ms** **After last query: 0.13 ms** **Query memory: 0.022 MB Memory before query: 3.965 MB** **Rows returned: 2**

SELECT b.id

  FROM josixih_usergroups AS a

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

  WHERE a.id = 9

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	Using where; Using index

**Profile**

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

**Call Stack**

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

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

**Query Time: 2.30 ms** **After last query: 1.13 ms** **Query memory: 0.041 MB Memory before query: 4.039 MB** **Rows returned: 185**

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

  FROM josixih_extensions

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

  ORDER BY ordering

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	1.39 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

**Call Stack**

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

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

**Query Time: 2.14 ms** **After last query: 48.50 ms** **Query memory: 0.022 MB Memory before query: 6.362 MB** **Rows returned: 1**

SELECT config_value 
  FROM josixih_hikashop_config 
  WHERE config_namekey = 'version'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josixih_hikashop_config	const	PRIMARY	PRIMARY	602	const	1

**Profile**

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.34 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.06 ms
Opening tables	1.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.04 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.02 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	1.15 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/hikamarketoverrides/hikamarketoverrides.php:33
8	plgSystemHikamarketoverrides->init()	JROOT/plugins/system/hikamarketoverrides/hikamarketoverrides.php:17
7	plgSystemHikamarketoverrides->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.62 ms** **After last query: 24.07 ms** **Query memory: 0.054 MB Memory before query: 7.443 MB** **Rows returned: 139**

SELECT setting,value 
  FROM josixih_jfbconnect_config

**Explain**

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

**Profile**

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.27 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
updating status	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_jfbconnect/models/config.php:306
14	JFBConnectModelConfig->getSettings()	JROOT/administrator/components/com_jfbconnect/models/config.php:344
13	JFBConnectModelConfig->get()	JROOT/administrator/components/com_jfbconnect/models/config.php:391
12	JFBConnectModelConfig->getSetting()	JROOT/components/com_jfbconnect/libraries/provider.php:33
11	JFBConnectProvider->__construct()	JROOT/components/com_jfbconnect/libraries/provider/github.php:20
10	JFBConnectProviderGithub->__construct()	JROOT/components/com_jfbconnect/libraries/factory.php:55
9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:76
8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
7	plgSystemJFBCSystem->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.92 ms** **After last query: 12.82 ms** **Query memory: 0.026 MB Memory before query: 8.142 MB** **Rows returned: 1**

SELECT value

  FROM josixih_jfbconnect_config

  WHERE setting="profile_hikashop"

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josixih_jfbconnect_config	const	setting	setting	152	const	1

**Profile**

Status	Duration
starting	0.07 ms
Waiting for query cache lock	1.65 ms
init	0.03 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.02 ms
updating status	0.02 ms
cleaning up	0.03 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
17	JDatabaseDriver->loadResult()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:616
16	SocialProfilePlugin->loadSettings()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:170
15	SocialProfilePlugin->socialProfilesGetRequiredScope()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jfbconnect/libraries/profile/amazon.php:55
11	JFBConnectProfileAmazon->getRequiredScope()	JROOT/components/com_jfbconnect/libraries/provider/amazon.php:34
10	JFBConnectProviderAmazon->setupAuthentication()	JROOT/components/com_jfbconnect/libraries/factory.php:56
9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:76
8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
7	plgSystemJFBCSystem->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.40 ms** **After last query: 36.14 ms** **Query memory: 0.028 MB Memory before query: 10.113 MB** **Rows returned: 1**

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

  FROM `josixih_extensions`

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

**Explain**

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

**Profile**

Status	Duration
starting	0.06 ms
Waiting for query cache lock	1.60 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.33 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.29 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
20	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
19	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	*Same as call in the line below.*
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
16	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
15	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
14	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3941
10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:180
9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:62
8	plgSystemHikashopgeolocation->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 9.66 ms** **After last query: 0.25 ms** **Query memory: 0.007 MB Memory before query: 10.107 MB**

UPDATE `josixih_extensions`

  SET `params` = '{\"mediaversion\":\"34dcab10b49d379f8c65b74c11e082cf\"}'

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

**Explain**

**EXPLAIN not possible on query: UPDATE `josixih_extensions` SET `params` = '{\"mediaversion\":\"34dcab10b49d379f8c65b74c11e082cf\"}' WHERE `type` = 'library' AND `element` = 'joomla'**

**Profile**

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.12 ms
updating	0.12 ms
end	0.02 ms
Waiting for query cache lock	0.01 ms
end	2.17 ms
query end	6.55 ms
closing tables	0.05 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	19.59 ms
cleaning up	0.05 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3941
10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:180
9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:62
8	plgSystemHikashopgeolocation->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.58 ms** **After last query: 19.50 ms** **Query memory: 0.080 MB Memory before query: 10.919 MB** **Rows returned: 534**

SELECT * 
  FROM josixih_hikashop_config

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.47 ms
Waiting for query cache lock	0.02 ms
Sending data	0.40 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.05 ms
updating status	3.58 ms
Waiting for query cache lock	0.03 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
12	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1120
11	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3958
10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:180
9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:62
8	plgSystemHikashopgeolocation->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 24.75 ms** **After last query: 5.96 ms** **Query memory: 0.066 MB Memory before query: 11.424 MB** **Rows returned: 43**

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM josixih_menu AS m

  LEFT JOIN josixih_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

**Explain**

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

**Profile**

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	17.00 ms
After opening tables	0.06 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	4.93 ms
init	0.09 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.06 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.46 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.32 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.14 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	3.81 ms
Waiting for query cache lock	0.04 ms
updating status	0.01 ms
storing result in query cache	1.96 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	*Same as call in the line below.*
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:488
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/dropfiles/dropfiles.php:32
8	plgSystemDropfiles->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.28 ms** **After last query: 88.81 ms** **Query memory: 0.024 MB Memory before query: 12.434 MB** **Rows returned: 5**

SELECT id, home, template, s.params

  FROM josixih_template_styles as s

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

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

**Explain**

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

**Profile**

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.11 ms
preparing	0.09 ms
executing	0.01 ms
Sending data	0.20 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.54 ms** **After last query: 105.60 ms** **Query memory: 0.025 MB Memory before query: 12.604 MB** **Rows returned: 1**

SELECT *

  FROM josixih_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

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

**Profile**

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.77 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.02 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
storing result in query cache	0.17 ms
cleaning up	0.02 ms

**Call Stack**

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

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

**Query Time: 2.44 ms** **After last query: 46.94 ms** **Query memory: 0.034 MB Memory before query: 12.891 MB** **Rows returned: 49**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `josixih_assets`

  WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dropeditor','com_dropfiles','com_droppics','com_edition','com_eemail','com_fields','com_finder','com_hikamarket','com_hikashop','com_installer','com_islands','com_jce','com_jfbconnect','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mymaplocations','com_newsfeeds','com_phocacommander','com_plugins','com_postinstall','com_redirect','com_rstbox','com_search','com_tags','com_templates','com_users','com_vendor','com_wrapper','com_xcloner-backupandrestore')

**Explain**

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

**Profile**

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.02 ms
Opening tables	0.76 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.04 ms
init	0.13 ms
optimizing	0.03 ms
statistics	0.34 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	0.56 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.05 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:113
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:54
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 5.93 ms** **After last query: 3.08 ms** **Query memory: 0.038 MB Memory before query: 13.045 MB** **Rows returned: 0**

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM josixih_content AS a

  INNER JOIN josixih_content_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN josixih_categories AS c 
  ON c.id = a.catid

  LEFT JOIN josixih_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN josixih_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN josixih_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN josixih_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-07-21 01:45:02') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-07-21 01:45:02')

  ORDER BY c.lft, a.featured DESC, fp.ordering,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 4

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fp	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	pokche5_joom564.fp.content_id	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	pokche5_joom564.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	pokche5_joom564.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	pokche5_joom564.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	pokche5_joom564.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	pokche5_joom564.a.id	1	Using where

**Profile**

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.32 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.02 ms
Opening tables	2.99 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.06 ms
init	0.14 ms
optimizing	0.08 ms
statistics	0.65 ms
preparing	0.07 ms
Creating tmp table	0.11 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.64 ms
Creating sort index	0.07 ms
removing tmp table	0.17 ms
Creating sort index	0.04 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.36 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.03 ms
cleaning up	0.03 ms

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.16 ms** **After last query: 2.22 ms** **Query memory: 0.025 MB Memory before query: 13.132 MB** **Rows returned: 1**

SELECT COUNT(*)

  FROM josixih_content AS a

  INNER JOIN josixih_content_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN josixih_categories AS c 
  ON c.id = a.catid

  LEFT JOIN josixih_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN josixih_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN josixih_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN josixih_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-07-21 01:45:02') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-07-21 01:45:02')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fp	index	PRIMARY	PRIMARY	4	NULL	1	Using index
1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	pokche5_joom564.fp.content_id	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	pokche5_joom564.a.catid	1	Using where

**Profile**

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.15 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.03 ms
Table lock	0.02 ms
Waiting for query cache lock	0.04 ms
init	0.06 ms
optimizing	0.06 ms
statistics	0.16 ms
preparing	0.02 ms
Unlocking tables	0.06 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.27 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.46 ms
cleaning up	0.03 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 4.18 ms** **After last query: 216.61 ms** **Query memory: 0.022 MB Memory before query: 13.857 MB** **Rows returned: 4**

SELECT DISTINCT shipping_name 
  FROM josixih_hikashop_shipping

**Explain**

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

**Profile**

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	1.90 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.01 ms
Sending data	0.45 ms
removing tmp table	0.06 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.09 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:20
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.75 ms** **After last query: 0.12 ms** **Query memory: 0.029 MB Memory before query: 13.863 MB** **Rows returned: 9**

SELECT * 
  FROM josixih_hikashop_shipping  
  WHERE shipping_name = 'Delivery 3'

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.95 ms
init	0.03 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.30 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.06 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:30
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 4.67 ms** **After last query: 0.19 ms** **Query memory: 0.038 MB Memory before query: 13.886 MB** **Rows returned: 5**

**Duplicate queries**: #29 #36 #43

SELECT * 
  FROM josixih_hikamarket_vendor 
  WHERE vendor_id != 1 
  ORDER BY vendor_id asc

**Explain**

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

**Profile**

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	3.51 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.08 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.08 ms
Creating sort index	0.21 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.39 ms
Waiting for query cache lock	0.02 ms
updating status	0.03 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:57
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.01 ms** **After last query: 0.23 ms** **Query memory: 0.027 MB Memory before query: 13.921 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 3'  
  AND shipping_vendor_id = 77

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.18 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.21 ms
Waiting for query cache lock	0.03 ms
updating status	0.02 ms
storing result in query cache	0.15 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.06 ms** **After last query: 0.11 ms** **Query memory: 0.027 MB Memory before query: 13.928 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 3'  
  AND shipping_vendor_id = 78

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.17 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.19 ms
Waiting for query cache lock	0.02 ms
updating status	0.03 ms
storing result in query cache	0.11 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.98 ms** **After last query: 0.11 ms** **Query memory: 0.027 MB Memory before query: 13.933 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 3'  
  AND shipping_vendor_id = 87

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.18 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.17 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.07 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.94 ms** **After last query: 0.09 ms** **Query memory: 0.027 MB Memory before query: 13.937 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 3'  
  AND shipping_vendor_id = 92

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.18 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.18 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.87 ms** **After last query: 0.09 ms** **Query memory: 0.027 MB Memory before query: 13.941 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 3'  
  AND shipping_vendor_id = 93

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.18 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.20 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.11 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.02 ms** **After last query: 0.10 ms** **Query memory: 0.029 MB Memory before query: 13.898 MB** **Rows returned: 9**

SELECT * 
  FROM josixih_hikashop_shipping  
  WHERE shipping_name = 'Delivery 1'

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.21 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.24 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.03 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:30
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.33 ms** **After last query: 0.15 ms** **Query memory: 0.038 MB Memory before query: 13.915 MB** **Rows returned: 5**

**Duplicate queries**: #22 #36 #43

SELECT * 
  FROM josixih_hikamarket_vendor 
  WHERE vendor_id != 1 
  ORDER BY vendor_id asc

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.28 ms
updating status	0.02 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:57
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.90 ms** **After last query: 0.16 ms** **Query memory: 0.027 MB Memory before query: 13.951 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 1'  
  AND shipping_vendor_id = 77

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.05 ms
Waiting for query cache lock	0.05 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.17 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.17 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.87 ms** **After last query: 0.08 ms** **Query memory: 0.027 MB Memory before query: 13.958 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 1'  
  AND shipping_vendor_id = 78

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.16 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.20 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.04 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.86 ms** **After last query: 0.10 ms** **Query memory: 0.027 MB Memory before query: 13.963 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 1'  
  AND shipping_vendor_id = 87

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.03 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.16 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.07 ms
Waiting for query cache lock	0.82 ms
updating status	0.18 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.03 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.87 ms** **After last query: 0.08 ms** **Query memory: 0.028 MB Memory before query: 13.974 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 1'  
  AND shipping_vendor_id = 92

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.17 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.17 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.89 ms** **After last query: 0.08 ms** **Query memory: 0.027 MB Memory before query: 13.979 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 1'  
  AND shipping_vendor_id = 93

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.16 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.03 ms
updating status	0.20 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.91 ms** **After last query: 0.11 ms** **Query memory: 0.029 MB Memory before query: 13.935 MB** **Rows returned: 9**

SELECT * 
  FROM josixih_hikashop_shipping  
  WHERE shipping_name = 'Delivery 2'

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.20 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.03 ms
Waiting for query cache lock	0.02 ms
updating status	0.25 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.04 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:30
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.36 ms** **After last query: 0.15 ms** **Query memory: 0.038 MB Memory before query: 13.955 MB** **Rows returned: 5**

**Duplicate queries**: #22 #29 #43

SELECT * 
  FROM josixih_hikamarket_vendor 
  WHERE vendor_id != 1 
  ORDER BY vendor_id asc

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.28 ms
updating status	0.02 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:57
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.87 ms** **After last query: 0.16 ms** **Query memory: 0.027 MB Memory before query: 13.989 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 2'  
  AND shipping_vendor_id = 77

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.18 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.16 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.30 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.16 ms** **After last query: 0.08 ms** **Query memory: 0.027 MB Memory before query: 13.997 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 2'  
  AND shipping_vendor_id = 78

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.17 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.17 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.10 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.01 ms** **After last query: 0.08 ms** **Query memory: 0.027 MB Memory before query: 14.001 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 2'  
  AND shipping_vendor_id = 87

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.06 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.16 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.17 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.09 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.93 ms** **After last query: 0.08 ms** **Query memory: 0.027 MB Memory before query: 14.006 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 2'  
  AND shipping_vendor_id = 92

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.16 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.17 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.07 ms
cleaning up	0.03 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.06 ms** **After last query: 0.09 ms** **Query memory: 0.027 MB Memory before query: 14.010 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Delivery 2'  
  AND shipping_vendor_id = 93

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.75 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.18 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.38 ms
updating status	0.26 ms
Waiting for query cache lock	0.04 ms
updating status	0.02 ms
storing result in query cache	0.20 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.21 ms** **After last query: 0.10 ms** **Query memory: 0.029 MB Memory before query: 13.966 MB** **Rows returned: 9**

SELECT * 
  FROM josixih_hikashop_shipping  
  WHERE shipping_name = 'Pickup'

**Explain**

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

**Profile**

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.20 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
Waiting for query cache lock	0.02 ms
updating status	0.25 ms
Waiting for query cache lock	0.06 ms
updating status	0.02 ms
storing result in query cache	0.04 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:30
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.41 ms** **After last query: 0.15 ms** **Query memory: 0.038 MB Memory before query: 13.984 MB** **Rows returned: 5**

**Duplicate queries**: #22 #29 #36

SELECT * 
  FROM josixih_hikamarket_vendor 
  WHERE vendor_id != 1 
  ORDER BY vendor_id asc

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.28 ms
updating status	0.02 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:57
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.06 ms** **After last query: 0.16 ms** **Query memory: 0.027 MB Memory before query: 14.020 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Pickup'  
  AND shipping_vendor_id = 77

**Explain**

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

**Profile**

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.05 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.15 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
Sending data	0.17 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.16 ms
Waiting for query cache lock	0.03 ms
updating status	0.02 ms
storing result in query cache	0.05 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.14 ms** **After last query: 0.08 ms** **Query memory: 0.027 MB Memory before query: 14.027 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Pickup'  
  AND shipping_vendor_id = 78

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.26 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.16 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.16 ms
Waiting for query cache lock	5.94 ms
updating status	0.04 ms
storing result in query cache	0.06 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 7.18 ms** **After last query: 0.08 ms** **Query memory: 0.027 MB Memory before query: 14.032 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Pickup'  
  AND shipping_vendor_id = 87

**Explain**

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

**Profile**

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.10 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.08 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.04 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.19 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
Waiting for query cache lock	0.02 ms
updating status	0.27 ms
Waiting for query cache lock	0.86 ms
updating status	0.02 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.50 ms** **After last query: 0.15 ms** **Query memory: 0.027 MB Memory before query: 14.036 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Pickup'  
  AND shipping_vendor_id = 92

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.67 ms** **After last query: 0.08 ms** **Query memory: 0.027 MB Memory before query: 14.040 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_shipping 
  WHERE shipping_name = 'Pickup'  
  AND shipping_vendor_id = 93

**Explain**

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

**Profile**

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shipping/shipping.php:69
7	PlgSystemShipping->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 6.66 ms** **After last query: 40.32 ms** **Query memory: 0.024 MB Memory before query: 14.695 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_edition_usernew 
  WHERE orderid=0 
  ORDER BY id asc

**Explain**

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

**Profile**

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	4.99 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.98 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.91 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/edition/edition.php:37
7	PlgSystemEdition->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 6.75 ms** **After last query: 0.14 ms** **Query memory: 0.027 MB Memory before query: 14.701 MB** **Rows returned: 1**

SELECT * 
  FROM josixih_hikashop_cart 
  WHERE cart_id = 213

**Explain**

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

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	4.19 ms
After opening tables	0.05 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.60 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.63 ms
preparing	0.03 ms
Unlocking tables	0.02 ms
executing	0.02 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.03 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.64 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/edition/edition.php:49
7	PlgSystemEdition->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 5.38 ms** **After last query: 0.48 ms** **Query memory: 0.022 MB Memory before query: 14.723 MB** **Rows returned: 1**

SELECT user_id 
  FROM josixih_hikashop_user 
  WHERE user_cms_id = '0'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josixih_hikashop_user	ref	user_cms_id	user_cms_id	4	const	1

**Profile**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	4.14 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.46 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.10 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.06 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/edition/edition.php:101
7	PlgSystemEdition->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.64 ms** **After last query: 0.09 ms** **Query memory: 0.022 MB Memory before query: 14.724 MB** **Rows returned: 0**

SELECT cart_id 
  FROM josixih_hikashop_cart 
  WHERE user_id = '143' 
  ORDER BY cart_id ASC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josixih_hikashop_cart	ref	user_id	user_id	4	const	1	Using where; Using filesort

**Profile**

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.04 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.02 ms
storing result in query cache	0.04 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/edition/edition.php:111
7	PlgSystemEdition->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.50 ms** **After last query: 8.95 ms** **Query memory: 0.025 MB Memory before query: 14.849 MB** **Rows returned: 1**

select b.* 
  from josixih_rstbox b 
  where b.published = 1  
  AND b.testmode=0

**Explain**

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

**Profile**

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
checking query cache for query	0.07 ms
checking permissions	0.02 ms
Opening tables	0.63 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/helper.php:238
8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
7	PlgSystemRstBox->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.47 ms** **After last query: 8.42 ms** **Query memory: 0.023 MB Memory before query: 14.925 MB** **Rows returned: 1**

SELECT COUNT(id)

  FROM `josixih_rstbox_logs`

  WHERE `event` = 1 
  AND `box` = 2 
  AND `visitorid` = '643d54caae549d1a' 
  AND DATE(date) = '2018-07-21'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josixih_rstbox_logs	ref	visitorid,box	visitorid	194	const	1	Using index condition; Using where

**Profile**

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.06 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.70 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.04 ms
optimizing	0.03 ms
statistics	1.03 ms
preparing	0.06 ms
executing	0.03 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.45 ms
Waiting for query cache lock	0.03 ms
updating status	0.02 ms
storing result in query cache	0.25 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rstbox/helpers/assignments.php:203
11	ebAssignments->passImpressions()	JROOT/administrator/components/com_rstbox/helpers/assignments.php:99
10	ebAssignments->passAll()	JROOT/administrator/components/com_rstbox/helpers/helper.php:199
9	EBHelper::checkPublishingAssignments()	JROOT/administrator/components/com_rstbox/helpers/helper.php:241
8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
7	PlgSystemRstBox->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.97 ms** **After last query: 37.91 ms** **Query memory: 0.031 MB Memory before query: 15.122 MB** **Rows returned: 1**

SELECT *

  FROM josixih_modules

  WHERE id='120'

**Explain**

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

**Profile**

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.55 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.74 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.37 ms
cleaning up	0.02 ms

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:366
15	NRFramework\Functions::loadModule()	JROOT/plugins/engagebox/module/layout/module.php:18
14	include JROOT/plugins/engagebox/module/layout/module.php	JROOT/plugins/system/t3/includes/joomla4/FileLayout.php:125
13	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_rstbox/helpers/type.php:70
12	EngageBoxType->onEngageBoxTypeRender()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_rstbox/helpers/helper.php:257
8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
7	PlgSystemRstBox->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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 4.45 ms** **After last query: 21.64 ms** **Query memory: 0.042 MB Memory before query: 15.821 MB** **Rows returned: 161**

Use your location

OR

Enter street, town or country

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

64 Queries Logged 179.52 ms

6 duplicate found!

**Use your location**

**OR**

**Enter street, town or country**

**Joomla! Debug Console**

**Session**

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**64 Queries Logged** 179.52 ms

**6 duplicate found!**

Use your location

OR

Enter street, town or country

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

64 Queries Logged 179.52 ms

6 duplicate found!