MARVEY JUMP S/APPLE&STRAW GUMMY 40G

{
    "__default": {
        "session": {
            "counter": 3,
            "timer": {
                "start": 1786590871,
                "last": 1786590882,
                "now": 1786590904
            },
            "token": "FFLCcvzEm6CxzGsB7zBb081EDEL8dwpr"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "user_id": 0,
                "zone_id": "129"
            }
        },
        "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
        },
        "application": {
            "queue": []
        }
    },
    "__plg_sociallogin_facebook": {
        "loginUrl": "\/all-products\/product\/7800-marvey-jump-s-apple-straw-gummy-40g",
        "failureUrl": "\/"
    }
}

Time

Memory

76 Queries Logged 64.77 ms

1. Query Time: 0.58 ms Query memory: 0.023 MB Memory before query: 1.032 MB Rows returned: 1

   SELECT `data`
   
     FROM `jq470_session`
   
     WHERE `session_id` = X'33366f36366266686274336162366431657664306b6769726262'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jq470_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.00 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

2. Query Time: 0.63 ms After last query: 3.18 ms Query memory: 0.025 MB Memory before query: 1.078 MB Rows returned: 43

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jq470_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jq470_extensions	ref	extension	extension	82	const	44	Using index condition; Using where

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.21 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   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:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   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:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

3. Query Time: 0.29 ms After last query: 2.31 ms Query memory: 0.021 MB Memory before query: 1.108 MB Rows returned: 5

   SELECT id, rules
   
     FROM `jq470_viewlevels`

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.03 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

4. Query Time: 0.28 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 1.120 MB Rows returned: 2

   SELECT b.id
   
     FROM jq470_usergroups AS a
   
     LEFT JOIN jq470_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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.04 ms
   Preparing	0.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

5. Query Time: 1.52 ms After last query: 0.32 ms Query memory: 0.051 MB Memory before query: 1.142 MB Rows returned: 144

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM jq470_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	jq470_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	395	Using where; Using filesort

   Profile

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	1.21 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.02 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   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:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 0.57 ms After last query: 16.99 ms Query memory: 0.022 MB Memory before query: 1.795 MB Rows returned: 0

   select email 
     from jq470_users 
     where id=0 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Profile

   Status	Duration
   Starting	0.13 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.06 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/plugins/system/bfstop/helpers/db.php:246
   12	BFStopDBHelper->getUserEmailWhere()	JROOT/plugins/system/bfstop/helpers/db.php:253
   11	BFStopDBHelper->getUserEmailByID()	JROOT/plugins/system/bfstop/helpers/notify.php:23
   10	BFStopNotifier->__construct()	JROOT/plugins/system/bfstop/bfstop.php:197
   9	plgSystembfstop->init()	JROOT/plugins/system/bfstop/bfstop.php:367
   8	plgSystembfstop->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:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 0.39 ms After last query: 3.96 ms Query memory: 0.025 MB Memory before query: 1.928 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.03 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   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:3048
   10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:184
   9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:63
   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:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.89 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 1.921 MB

   UPDATE `jq470_extensions`
   
     SET `params` = '{\"mediaversion\":\"0259f3f0da8f0622021f5c730081ab07\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init for update	0.04 ms
   Updating	0.10 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.50 ms
   Query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.07 ms
   Reset for next command	0.00 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:3048
   10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:184
   9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:63
   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:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 2.31 ms After last query: 5.17 ms Query memory: 0.062 MB Memory before query: 2.516 MB Rows returned: 323

   SELECT * 
     FROM jq470_hikashop_config

   Explain

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

   Profile

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.61 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
   12	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1253
   11	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3067
   10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:184
   9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:63
   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:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 3.20 ms After last query: 3.90 ms Query memory: 0.072 MB Memory before query: 2.804 MB Rows returned: 44

    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 jq470_menu AS m
    
      LEFT JOIN jq470_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	216	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	econma06_db.m.component_id	1	Using where

    Profile

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.05 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.37 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 5.93 ms After last query: 5.75 ms Query memory: 0.021 MB Memory before query: 2.997 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.09 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.20 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	5.04 ms
    Query end	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    9	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    8	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_live_tracks/router.php:30
    7	Live_tracksRouter->__construct()	JROOT/libraries/src/Router/SiteRouter.php:789
    6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 1.16 ms After last query: 5.35 ms Query memory: 0.088 MB Memory before query: 3.054 MB Rows returned: 5

    SELECT id, home, template, s.params
    
      FROM jq470_template_styles as s
    
      LEFT JOIN jq470_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	4	Using index condition; Using where
    1	SIMPLE	s	ref|filter	idx_template,idx_client_id,idx_client_id_home	idx_template|idx_client_id	202|1	econma06_db.e.element	1 (71%)	Using index condition; Using where; Using rowid filter

    Profile

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.22 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
    18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
    17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:91
    13	JHtmlBehavior::core()	JROOT/libraries/cms/html/behavior.php:722
    12	JHtmlBehavior::keepalive()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/loginregister/loginregister.php:33
    8	plgsystemloginregister->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:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 1.30 ms After last query: 17.46 ms Query memory: 0.024 MB Memory before query: 3.270 MB Rows returned: 1

    SELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering  
      FROM jq470_hikashop_product AS product  
      LEFT JOIN jq470_hikashop_product_category AS product_category 
      ON product.product_id = product_category.product_id  
      WHERE (product.product_id = 7800) 
      AND ((product.product_access = 'all' OR product.product_access LIKE '%,9,%')) 
      LIMIT 0, 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	product	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	product_category	ref	product_id	product_id	4	const	1

    Profile

    Status	Duration
    Starting	0.22 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.16 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_hikashop/views/product/view.html.php:1185
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.66 ms After last query: 2.24 ms Query memory: 0.024 MB Memory before query: 3.374 MB Rows returned: 0
    Duplicate queries: #71  #73

    SELECT cart.cart_id 
      FROM jq470_hikashop_cart AS cart  
      WHERE (cart.cart_type = 'cart') 
      AND (cart.session_id = '36o66bfhbt3ab6d1evd0kgirbb')  
      ORDER BY cart.cart_current DESC, cart.cart_modified DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cart	ref	session_id	session_id	767	const	1	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.17 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
    16	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:132
    15	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:502
    14	hikashop_getZone()	JROOT/components/com_hikashop/views/product/view.html.php:1231
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.34 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 3.383 MB Rows returned: 1

    SELECT * 
      FROM jq470_hikashop_currency 
      WHERE currency_id IN (96)

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.02 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1864
    14	hikashopCurrencyClass->getCurrencies()	JROOT/components/com_hikashop/views/product/view.html.php:1234
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.54 ms After last query: 5.11 ms Query memory: 0.007 MB Memory before query: 3.644 MB

    UPDATE jq470_hikashop_product 
      SET product_hit = product_hit + 1, product_last_seen_date = 1786590904 
      WHERE product_id = 7800

    Explain

    EXPLAIN not possible on query: UPDATE jq470_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1786590904 WHERE product_id = 7800

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.06 ms
    Updating	0.10 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.03 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_hikashop/classes/product.php:4010
    14	hikashopProductClass->hit()	JROOT/components/com_hikashop/views/product/view.html.php:1274
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.41 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 3.653 MB Rows returned: 0

    SELECT p.*  
      FROM jq470_hikashop_product_related AS pr  
      LEFT JOIN jq470_hikashop_product AS p 
      ON pr.product_related_id = p.product_id  
      WHERE (pr.product_id = 7800) 
      AND (pr.product_related_type = 'options') 
      AND (p.product_published = 1) 
      AND ((p.product_sale_start = '' OR p.product_sale_start <= 1786590904)) 
      AND ((p.product_sale_end = '' OR p.product_sale_end > 1786590904)) 
      AND ((p.product_access = 'all' OR p.product_access LIKE '%,9,%'))  
      ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Executing	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1296
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.27 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 3.661 MB Rows returned: 0

    SELECT p.*, pr.product_related_quantity  
      FROM jq470_hikashop_product_related AS pr  
      INNER JOIN jq470_hikashop_product AS p 
      ON pr.product_related_id = p.product_id  
      WHERE pr.product_id = 7800 
      AND pr.product_related_type = 'bundle' 
      ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1305
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.28 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 3.668 MB Rows returned: 1

    SELECT * 
      FROM jq470_hikashop_product 
      WHERE (product_parent_id IN (7800)) 
      AND (product_published = 1) 
      AND ((product_access = 'all' OR product_access LIKE '%,9,%'))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_hikashop_product	ref	product_parent_id	product_parent_id	4	const	1	Using where

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1333
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.78 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 3.679 MB Rows returned: 3

    SELECT v.*, c.*  
      FROM jq470_hikashop_variant AS v  
      INNER JOIN jq470_hikashop_characteristic AS c 
      ON v.variant_characteristic_id = c.characteristic_id  
      WHERE v.variant_product_id IN (7800,7801)  
      ORDER BY v.ordering ASC, c.characteristic_ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v	range	PRIMARY,variant_product_id	variant_product_id	4	NULL	3	Using index condition; Using temporary; Using filesort
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	econma06_db.v.variant_characteristic_id	1

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.37 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.08 ms
    Creating sort index	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1374
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.80 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 3.691 MB Rows returned: 1

    SELECT * 
      FROM jq470_hikashop_file 
      WHERE file_ref_id IN (7800,7801) 
      AND file_type IN ('product','file')  
      ORDER BY file_ordering ASC, file_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_hikashop_file	range	file_type,idx_file_ref_type_order​	idx_file_ref_type_order​	771	NULL	11	Using index condition; Using filesort

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.42 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.10 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1417
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.23 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 3.701 MB Rows returned: 1

    SELECT currency_id 
      FROM jq470_hikashop_currency 
      WHERE currency_published=1 OR currency_id = 96

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/currency.php:469
    16	hikashopCurrencyClass->publishedCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:1547
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.49 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 3.712 MB Rows returned: 2

    SELECT p.* 
      FROM jq470_hikashop_price as p 
      WHERE (p.price_currency_id IN (96)) 
      AND (p.price_start_date < 1786590904) 
      AND ((p.price_end_date < 1 OR p.price_end_date > 1786590904)) 
      AND (p.price_product_id IN (7800,7801)) 
      AND ((p.price_access = 'all' OR p.price_access LIKE '%,9,%')) 
      AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) 
      ORDER BY p.price_site_id ASC, p.price_value DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	p	range	price_product_id	price_product_id	4	NULL	2	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.12 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    Creating sort index	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1591
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 1.15 ms After last query: 0.67 ms Query memory: 0.026 MB Memory before query: 3.728 MB Rows returned: 0
    Duplicate queries: #31

    SELECT b.*,c.* 
      FROM jq470_hikashop_category AS a 
      LEFT JOIN jq470_hikashop_taxation AS b 
      ON a.category_namekey=b.category_namekey 
      LEFT JOIN jq470_hikashop_tax AS c 
      ON b.tax_namekey=c.tax_namekey 
      WHERE a.category_id = 11 
      AND b.taxation_published=1 
      AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) 
      AND b.taxation_date_start <= 1786590904 
      AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1786590904) 
      AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%') 
      ORDER BY b.taxation_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:195
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1683
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.19 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 3.738 MB Rows returned: 1
    Duplicate queries: #32

    SELECT category_parent_id 
      FROM jq470_hikashop_category 
      WHERE category_id = 11

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/currency.php:199
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1683
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.32 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 3.748 MB Rows returned: 0
    Duplicate queries: #33

    SELECT b.*,c.* 
      FROM jq470_hikashop_category AS a 
      LEFT JOIN jq470_hikashop_taxation AS b 
      ON a.category_namekey=b.category_namekey 
      LEFT JOIN jq470_hikashop_tax AS c 
      ON b.tax_namekey=c.tax_namekey 
      WHERE a.category_id = 3 
      AND b.taxation_published=1 
      AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) 
      AND b.taxation_date_start <= 1786590904 
      AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1786590904) 
      AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%') 
      ORDER BY b.taxation_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:195
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1683
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.17 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 3.757 MB Rows returned: 1
    Duplicate queries: #34

    SELECT category_parent_id 
      FROM jq470_hikashop_category 
      WHERE category_id = 3

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/currency.php:199
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1683
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.42 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 3.768 MB Rows returned: 0

    SELECT b.*,c.* 
      FROM jq470_hikashop_category AS a 
      LEFT JOIN jq470_hikashop_taxation AS b 
      ON a.category_namekey=b.category_namekey 
      LEFT JOIN jq470_hikashop_tax AS c 
      ON b.tax_namekey=c.tax_namekey 
      WHERE a.category_id = 1 
      AND b.taxation_published=1 
      AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) 
      AND b.taxation_date_start <= 1786590904 
      AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1786590904) 
      AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%') 
      ORDER BY b.taxation_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Executing	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:195
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1683
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.16 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 3.777 MB Rows returned: 1

    SELECT category_parent_id 
      FROM jq470_hikashop_category 
      WHERE category_id = 1

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/currency.php:199
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1683
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.20 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 3.787 MB Rows returned: 1

    SELECT * 
      FROM jq470_hikashop_zone 
      WHERE zone_id = 129

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.17 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/currency.php:216
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1683
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.26 ms After last query: 0.20 ms Query memory: 0.026 MB Memory before query: 3.800 MB Rows returned: 0
    Duplicate queries: #24

    SELECT b.*,c.* 
      FROM jq470_hikashop_category AS a 
      LEFT JOIN jq470_hikashop_taxation AS b 
      ON a.category_namekey=b.category_namekey 
      LEFT JOIN jq470_hikashop_tax AS c 
      ON b.tax_namekey=c.tax_namekey 
      WHERE a.category_id = 11 
      AND b.taxation_published=1 
      AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) 
      AND b.taxation_date_start <= 1786590904 
      AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1786590904) 
      AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%') 
      ORDER BY b.taxation_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:195
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1688
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.23 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 3.809 MB Rows returned: 1
    Duplicate queries: #25

    SELECT category_parent_id 
      FROM jq470_hikashop_category 
      WHERE category_id = 11

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/currency.php:199
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1688
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.31 ms After last query: 0.06 ms Query memory: 0.027 MB Memory before query: 3.826 MB Rows returned: 0
    Duplicate queries: #26

    SELECT b.*,c.* 
      FROM jq470_hikashop_category AS a 
      LEFT JOIN jq470_hikashop_taxation AS b 
      ON a.category_namekey=b.category_namekey 
      LEFT JOIN jq470_hikashop_tax AS c 
      ON b.tax_namekey=c.tax_namekey 
      WHERE a.category_id = 3 
      AND b.taxation_published=1 
      AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) 
      AND b.taxation_date_start <= 1786590904 
      AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1786590904) 
      AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%') 
      ORDER BY b.taxation_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:195
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1688
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.17 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 3.836 MB Rows returned: 1
    Duplicate queries: #27

    SELECT category_parent_id 
      FROM jq470_hikashop_category 
      WHERE category_id = 3

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/currency.php:199
    19	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
    18	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2603
    17	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1688
    16	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1601
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.30 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 3.847 MB Rows returned: 0

    SELECT * 
      FROM jq470_hikashop_discount 
      WHERE (discount_type = 'discount') 
      AND (discount_published = 1) 
      AND (discount_quota > discount_used_times OR discount_quota = 0) 
      AND (discount_start < 1786590904) 
      AND (discount_end > 1786590904 OR discount_end = 0) 
      AND (discount_product_id IN ('','0','7800','7801') OR discount_product_id LIKE '%,7800,%' OR discount_product_id LIKE '%,7801,%') 
      AND (discount_flat_amount != 0 OR discount_percent_amount != 0) 
      AND ((discount_flat_amount = 0 OR discount_currency_id =96)) 
      AND ((discount_access = 'all' OR discount_access LIKE '%,9,%')) 
      AND ((discount_user_id = '' OR discount_user_id LIKE '%,0,%'))

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1651
    15	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1509
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1423
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.38 ms After last query: 0.62 ms Query memory: 0.024 MB Memory before query: 3.923 MB Rows returned: 2

    SELECT category_id 
      FROM jq470_hikashop_product_category 
      WHERE product_id IN (7800) 
      ORDER BY ordering ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/product.php:1074
    16	hikashopProductClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:275
    15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:160
    14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1426
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 1.21 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 3.934 MB Rows returned: 4

    SELECT hk_parent.* 
      FROM jq470_hikashop_category AS hk_cat  
      LEFT JOIN jq470_hikashop_category AS hk_parent 
      ON (hk_parent.category_left <= hk_cat.category_left 
      AND hk_parent.category_right >= hk_cat.category_right)  
      WHERE  hk_cat.category_id IN (61,64)  
      GROUP BY hk_parent.category_id  
      ORDER BY hk_parent.category_left

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	hk_cat	range	PRIMARY	PRIMARY	4	NULL	2	Using index condition; Using temporary; Using filesort
    1	SIMPLE	hk_parent	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	167	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Creating tmp table	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.49 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.10 ms
    Creating sort index	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:749
    16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/field.php:280
    15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:160
    14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1426
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.55 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 3.951 MB Rows returned: 0

    SELECT * 
      FROM jq470_hikashop_field as a 
      WHERE a.`field_published` = 1 
      AND a.`field_frontcomp` = 1 
      AND a.field_table='product' 
      AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%')  
      AND ((((field_with_sub_categories = 0 
      AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,61,%' OR field_categories LIKE '%,64,%'))OR (field_with_sub_categories = 1 
      AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,61,%' OR field_categories LIKE '%,64,%'))) 
      AND field_products="") OR (field_products LIKE '%,7800,%')) 
      ORDER BY a.`field_ordering` ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.03 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Sorting result	0.08 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:141
    15	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:161
    14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1426
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.33 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 3.961 MB Rows returned: 0

    SELECT * 
      FROM jq470_hikashop_field as a 
      WHERE a.`field_published` = 1 
      AND a.`field_frontcomp` = 1 
      AND a.field_table='item' 
      AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%')  
      AND ((((field_with_sub_categories = 0 
      AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,61,%' OR field_categories LIKE '%,64,%'))OR (field_with_sub_categories = 1 
      AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,61,%' OR field_categories LIKE '%,64,%'))) 
      AND field_products="") OR (field_products LIKE '%,7800,%')) 
      ORDER BY a.`field_ordering` ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.01 ms
    Preparing	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:141
    15	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:161
    14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1430
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.56 ms After last query: 2.71 ms Query memory: 0.023 MB Memory before query: 3.991 MB Rows returned: 1

    SELECT a.* 
      FROM jq470_hikashop_badge AS a 
      WHERE a.badge_start <= 1786590904 
      AND (a.badge_end >= 1786590904 OR a.badge_end = 0) 
      AND a.badge_published = 1 
      AND (a.badge_quantity = '' OR a.badge_quantity = 0) 
      AND (a.badge_new_period = 0 OR a.badge_new_period >= 22879480) 
      AND (badge_discount_id = '0' OR badge_discount_id = '') 
      AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') 
      AND ((badge_category_childs = 0 
      AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '61' OR badge_category_id LIKE '%,61,%' OR badge_category_id = '64' OR badge_category_id LIKE '%,64,%')) OR (badge_category_childs = 1 
      AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '61' OR badge_category_id LIKE '%,61,%' OR badge_category_id = '64' OR badge_category_id LIKE '%,64,%'))) 
      ORDER BY a.badge_ordering ASC,a.badge_id ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.06 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
    14	hikashopBadgeClass->loadBadges()	JROOT/components/com_hikashop/views/product/view.html.php:1558
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.40 ms After last query: 1.05 ms Query memory: 0.023 MB Memory before query: 3.997 MB Rows returned: 2

    SELECT b.*  
      FROM jq470_hikashop_product_category AS a  
      LEFT JOIN jq470_hikashop_category AS b 
      ON a.category_id = b.category_id  
      WHERE a.product_id = 7800 
      ORDER BY a.product_category_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	product_id	product_id	4	const	1	Using where; Using filesort
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	econma06_db.a.category_id	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1702
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.76 ms After last query: 1.45 ms Query memory: 0.024 MB Memory before query: 4.013 MB Rows returned: 1

    SELECT a.id 
      FROM jq470_menu AS a 
      INNER JOIN `jq470_menu_types` as b 
      on a.menutype = b.menutype 
      WHERE a.type='component' 
      AND a.published=1 
      AND b.title IS NOT NULL 
      AND a.access IN (1,1,5) 
      AND a.client_id=0 
      AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' 
      AND a.language IN ('*', '', 'en-GB')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where
    1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	econma06_db.b.menutype	10	Using where

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.17 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.32 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
    16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:197
    15	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
    14	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:1737
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.63 ms After last query: 0.24 ms Query memory: 0.025 MB Memory before query: 4.020 MB Rows returned: 0

    SELECT b.*, a.*, c.currency_symbol 
      FROM jq470_hikashop_shipping AS a  
      LEFT JOIN jq470_hikashop_shipping_price AS b 
      ON a.shipping_id = b.shipping_id 
      AND b.shipping_price_ref_id = 7801 
      INNER JOIN jq470_hikashop_currency AS c 
      ON c.currency_id = a.shipping_currency_id  
      WHERE (a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' OR a.shipping_params LIKE '%s:20:\"shipping_per_product\";i:1%')  
      AND (b.shipping_price_ref_id IS NULL OR (b.shipping_price_ref_id = 7801 
      AND b.shipping_price_ref_type = 'product')) 
      ORDER BY a.shipping_id, b.shipping_price_min_quantity

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
    1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	11	Using where; Using filesort
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	econma06_db.a.shipping_currency_id	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.24 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:38
    18	plgHikashopShippingmanual_prices->_getShippings()	JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:260
    17	plgHikashopShippingmanual_prices->onHikaShopBeforeDisplayView()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2426
    13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 0.33 ms After last query: 0.43 ms Query memory: 0.025 MB Memory before query: 4.031 MB Rows returned: 1

    SELECT * 
      FROM jq470_extensions 
      WHERE folder='hikashop' 
      AND element='shippingmanual_prices' 
      AND type='plugin'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.04 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/plugins.php:113
    18	hikashopPluginsClass->getByName()	JROOT/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:264
    17	plgHikashopShippingmanual_prices->onHikaShopBeforeDisplayView()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2426
    13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 0.51 ms After last query: 8.13 ms Query memory: 0.028 MB Memory before query: 4.144 MB Rows returned: 1

    SELECT product_average_score, product_total_vote 
      FROM jq470_hikashop_product 
      WHERE product_id = 7800

    Explain

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

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    24	JDatabaseDriver->loadObject()	JROOT/components/com_hikashop/views/vote/view.html.php:243
    23	VoteViewvote->form()	JROOT/components/com_hikashop/views/vote/view.html.php:16
    22	VoteViewvote->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
    21	hikashop_getLayout()	JROOT/templates/shaper_spectrum/html/com_hikashop/product/show_tabular.php:25
    20	include JROOT/templates/shaper_spectrum/html/com_hikashop/product/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
    17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2462
    13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Query Time: 0.28 ms After last query: 0.12 ms Query memory: 0.028 MB Memory before query: 4.159 MB Rows returned: 0

    SELECT * 
      FROM jq470_hikashop_vote 
      WHERE (vote_type = 'product') 
      AND (vote_rating != 0) 
      AND (vote_ref_id = 7800) 
      AND (vote_ip = '216.73.216.77') 
      AND (vote_user_id = '')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/vote.php:690
    24	hikashopVoteClass->getUserRating()	JROOT/components/com_hikashop/views/vote/view.html.php:290
    23	VoteViewvote->form()	JROOT/components/com_hikashop/views/vote/view.html.php:16
    22	VoteViewvote->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
    21	hikashop_getLayout()	JROOT/templates/shaper_spectrum/html/com_hikashop/product/show_tabular.php:25
    20	include JROOT/templates/shaper_spectrum/html/com_hikashop/product/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
    17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2462
    13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 0.84 ms After last query: 7.91 ms Query memory: 0.029 MB Memory before query: 4.286 MB Rows returned: 1
    Duplicate queries: #74

    SELECT * 
      FROM jq470_extensions 
      WHERE folder='system' 
      AND element='hikashopsocial' 
      AND type='plugin'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.17 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.10 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.07 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/plugins.php:113
    24	hikashopPluginsClass->getByName()	JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php:12
    23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_social.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    21	hikashopView->loadTemplate()	JROOT/templates/shaper_spectrum/html/com_hikashop/product/show_tabular.php:71
    20	include JROOT/templates/shaper_spectrum/html/com_hikashop/product/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
    17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2462
    13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 1.38 ms After last query: 5.91 ms Query memory: 0.028 MB Memory before query: 4.323 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jq470_contentitem_tag_map` AS m 
    
      INNER JOIN `jq470_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_hikashop.product' 
      AND `m`.`content_item_id` = 7800 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	econma06_db.m.tag_id	1	Using where

    Profile

    Status	Duration
    Starting	0.56 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.13 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.03 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    24	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_hikashop/views/product/tmpl/show_block_tags.php:29
    23	include JROOT/components/com_hikashop/views/product/tmpl/show_block_tags.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    21	hikashopView->loadTemplate()	JROOT/templates/shaper_spectrum/html/com_hikashop/product/show_tabular.php:218
    20	include JROOT/templates/shaper_spectrum/html/com_hikashop/product/show_tabular.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    19	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    18	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/product/tmpl/show.php:80
    17	include JROOT/components/com_hikashop/views/product/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2462
    13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
    12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2200
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1941
    9	hikashopController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2178
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Query Time: 2.05 ms After last query: 37.36 ms Query memory: 0.245 MB Memory before query: 4.536 MB Rows returned: 119

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jq470_modules AS m
    
      LEFT JOIN jq470_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jq470_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-08-13 03:15:04') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-13 03:15:04') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 712 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	54	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	econma06_db.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	econma06_db.m.module,const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.14 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.09 ms
    Preparing	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	1.28 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
    8	Helix3::generatelayout()	JROOT/templates/shaper_spectrum/index.php:193
    7	require JROOT/templates/shaper_spectrum/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 1.06 ms After last query: 30.79 ms Query memory: 0.023 MB Memory before query: 4.635 MB Rows returned: 1

    SELECT *
    
      FROM `jq470_sppagebuilder`
    
      WHERE `extension` = 'mod_sppagebuilder' 
      AND `extension_view` = 'module' 
      AND `view_id` = '182'

    Explain

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

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.54 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/modules/mod_sppagebuilder/helper.php:38
    12	ModSPagebuilderHelper::pageBuilderData()	JROOT/modules/mod_sppagebuilder/helper.php:14
    11	ModSPagebuilderHelper::getData()	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:13
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 0.43 ms After last query: 1.05 ms Query memory: 0.024 MB Memory before query: 4.651 MB Rows returned: 1
    Duplicate queries: #52  #59  #67

    SELECT `template`
    
      FROM `jq470_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	Using where

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:643
    14	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:154
    13	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:739
    12	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/modules/mod_sppagebuilder/tmpl/default.php:11
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Query Time: 0.63 ms After last query: 23.32 ms Query memory: 0.023 MB Memory before query: 4.799 MB Rows returned: 1
    Duplicate queries: #51  #59  #67

    SELECT `template`
    
      FROM `jq470_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	Using where

    Profile

    Status	Duration
    Starting	0.14 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
    14	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

53. Query Time: 2.38 ms After last query: 10.21 ms Query memory: 0.026 MB Memory before query: 4.929 MB Rows returned: 9

    SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
    
      FROM (
    SELECT id,title,level,published,parent_id,lft,rgt
    
      FROM jq470_tags
    
      WHERE `published` = '1') AS a
    
      LEFT JOIN `jq470_tags` AS b 
      ON a.lft > b.lft 
      AND a.rgt < b.rgt
    
      WHERE `a`.`level` != '0'
    
      ORDER BY a.lft ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_tags	ALL	tag_idx	NO INDEX KEY COULD BE USED	NULL	NULL	10	Using where; Using temporary; Using filesort
    1	SIMPLE	b	ALL	idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	10	Range checked for each record (index map: 0x10); Distinct

    Profile

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.17 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.26 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:194
    15	SpPgaeBuilderBase::getArticleTags()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:163
    14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

54. Query Time: 0.90 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 4.936 MB Rows returned: 0
    Duplicate queries: #55  #56

    SELECT a.enabled
    
      FROM `jq470_extensions` AS `a`
    
      WHERE `a`.`name` = 'com_k2'

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.38 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.24 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
    15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:172
    14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

55. Query Time: 0.44 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 4.950 MB Rows returned: 0
    Duplicate queries: #54  #56

    SELECT a.enabled
    
      FROM `jq470_extensions` AS `a`
    
      WHERE `a`.`name` = 'com_k2'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.25 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
    15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:279
    14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

56. Query Time: 0.42 ms After last query: 0.52 ms Query memory: 0.025 MB Memory before query: 4.985 MB Rows returned: 0
    Duplicate queries: #54  #55

    SELECT a.enabled
    
      FROM `jq470_extensions` AS `a`
    
      WHERE `a`.`name` = 'com_k2'

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.19 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
    15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138
    14	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

57. Query Time: 0.97 ms After last query: 9.63 ms Query memory: 0.025 MB Memory before query: 5.721 MB Rows returned: 0

    SELECT a.enabled
    
      FROM `jq470_extensions` AS `a`
    
      WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	Using index condition

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.15 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.02 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:470
    15	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
    14	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

58. Query Time: 1.05 ms After last query: 13.00 ms Query memory: 0.023 MB Memory before query: 6.163 MB Rows returned: 1

    SELECT *
    
      FROM `jq470_sppagebuilder`
    
      WHERE `extension` = 'mod_sppagebuilder' 
      AND `extension_view` = 'module' 
      AND `view_id` = '171'

    Explain

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

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.48 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/modules/mod_sppagebuilder/helper.php:38
    12	ModSPagebuilderHelper::pageBuilderData()	JROOT/modules/mod_sppagebuilder/helper.php:14
    11	ModSPagebuilderHelper::getData()	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:13
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

59. Query Time: 0.52 ms After last query: 0.45 ms Query memory: 0.023 MB Memory before query: 6.218 MB Rows returned: 1
    Duplicate queries: #51  #52  #67

    SELECT `template`
    
      FROM `jq470_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	Using where

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
    14	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

60. Query Time: 5.66 ms After last query: 26.47 ms Query memory: 0.125 MB Memory before query: 6.323 MB Rows returned: 118
    Duplicate queries: #61

    SELECT *, jq470_hikashop_category.category_id as id, jq470_hikashop_category.category_depth-1 as level, jq470_hikashop_category.category_parent_id as parent, jq470_hikashop_category.category_ordering as ordering 
      FROM jq470_hikashop_category 
      LEFT 
      OUTER JOIN jq470_hikashop_file 
      ON jq470_hikashop_file.file_ref_id = jq470_hikashop_category.category_id 
      WHERE jq470_hikashop_category.category_type = 'product' 
      AND jq470_hikashop_category.category_published = 1 
      AND jq470_hikashop_category.category_depth > 1 
      ORDER BY level DESC, ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_hikashop_category	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	167	Using where; Using filesort
    1	SIMPLE	jq470_hikashop_file	ref	idx_file_ref_type_order​	idx_file_ref_type_order​	4	econma06_db.jq470_hikashop_category.category_id	1243

    Profile

    Status	Duration
    Starting	0.24 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    Creating sort index	4.82 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/modules/mod_accordeonck/helper_hikashop.php:49
    11	modAccordeonckhikashopHelper::getItems()	JROOT/modules/mod_accordeonck/mod_accordeonck.php:49
    10	include JROOT/modules/mod_accordeonck/mod_accordeonck.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

61. Query Time: 4.05 ms After last query: 0.03 ms Query memory: 0.125 MB Memory before query: 6.329 MB Rows returned: 118
    Duplicate queries: #60

    SELECT *, jq470_hikashop_category.category_id as id, jq470_hikashop_category.category_depth-1 as level, jq470_hikashop_category.category_parent_id as parent, jq470_hikashop_category.category_ordering as ordering 
      FROM jq470_hikashop_category 
      LEFT 
      OUTER JOIN jq470_hikashop_file 
      ON jq470_hikashop_file.file_ref_id = jq470_hikashop_category.category_id 
      WHERE jq470_hikashop_category.category_type = 'product' 
      AND jq470_hikashop_category.category_published = 1 
      AND jq470_hikashop_category.category_depth > 1 
      ORDER BY level DESC, ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_hikashop_category	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	167	Using where; Using filesort
    1	SIMPLE	jq470_hikashop_file	ref	idx_file_ref_type_order​	idx_file_ref_type_order​	4	econma06_db.jq470_hikashop_category.category_id	1243

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	3.60 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_accordeonck/helper_hikashop.php:50
    11	modAccordeonckhikashopHelper::getItems()	JROOT/modules/mod_accordeonck/mod_accordeonck.php:49
    10	include JROOT/modules/mod_accordeonck/mod_accordeonck.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

62. Query Time: 0.24 ms After last query: 0.30 ms Query memory: 0.022 MB Memory before query: 6.694 MB Rows returned: 1
    Duplicate queries: #63

    SELECT jq470_hikashop_category.category_depth 
      FROM jq470_hikashop_category 
      WHERE jq470_hikashop_category.category_id = 2

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    13	JDatabase->query()	JROOT/modules/mod_accordeonck/helper_hikashop.php:335
    12	modAccordeonckhikashopHelper::getParentLevel()	JROOT/modules/mod_accordeonck/helper_hikashop.php:58
    11	modAccordeonckhikashopHelper::getItems()	JROOT/modules/mod_accordeonck/mod_accordeonck.php:49
    10	include JROOT/modules/mod_accordeonck/mod_accordeonck.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

63. Query Time: 0.22 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 6.700 MB Rows returned: 1
    Duplicate queries: #62

    SELECT jq470_hikashop_category.category_depth 
      FROM jq470_hikashop_category 
      WHERE jq470_hikashop_category.category_id = 2

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/modules/mod_accordeonck/helper_hikashop.php:336
    12	modAccordeonckhikashopHelper::getParentLevel()	JROOT/modules/mod_accordeonck/helper_hikashop.php:58
    11	modAccordeonckhikashopHelper::getItems()	JROOT/modules/mod_accordeonck/mod_accordeonck.php:49
    10	include JROOT/modules/mod_accordeonck/mod_accordeonck.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

64. Query Time: 0.20 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 6.707 MB Rows returned: 2
    Duplicate queries: #65

    SELECT category_id 
      FROM jq470_hikashop_product_category 
      WHERE product_id = 7800;

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_hikashop_product_category	ref	product_id	product_id	4	const	1

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    13	JDatabase->query()	JROOT/modules/mod_accordeonck/helper_hikashop.php:350
    12	modAccordeonckhikashopHelper::getActiveCategory()	JROOT/modules/mod_accordeonck/helper_hikashop.php:63
    11	modAccordeonckhikashopHelper::getItems()	JROOT/modules/mod_accordeonck/mod_accordeonck.php:49
    10	include JROOT/modules/mod_accordeonck/mod_accordeonck.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

65. Query Time: 0.17 ms After last query: 0.02 ms Query memory: 0.028 MB Memory before query: 6.723 MB Rows returned: 2
    Duplicate queries: #64

    SELECT category_id 
      FROM jq470_hikashop_product_category 
      WHERE product_id = 7800;

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_hikashop_product_category	ref	product_id	product_id	4	const	1

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_accordeonck/helper_hikashop.php:351
    12	modAccordeonckhikashopHelper::getActiveCategory()	JROOT/modules/mod_accordeonck/helper_hikashop.php:63
    11	modAccordeonckhikashopHelper::getItems()	JROOT/modules/mod_accordeonck/mod_accordeonck.php:49
    10	include JROOT/modules/mod_accordeonck/mod_accordeonck.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

66. Query Time: 0.90 ms After last query: 10.88 ms Query memory: 0.023 MB Memory before query: 6.544 MB Rows returned: 1

    SELECT *
    
      FROM `jq470_sppagebuilder`
    
      WHERE `extension` = 'mod_sppagebuilder' 
      AND `extension_view` = 'module' 
      AND `view_id` = '194'

    Explain

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

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.38 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.05 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/modules/mod_sppagebuilder/helper.php:38
    12	ModSPagebuilderHelper::pageBuilderData()	JROOT/modules/mod_sppagebuilder/helper.php:14
    11	ModSPagebuilderHelper::getData()	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:13
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

67. Query Time: 0.31 ms After last query: 0.53 ms Query memory: 0.023 MB Memory before query: 6.602 MB Rows returned: 1
    Duplicate queries: #51  #52  #59

    SELECT `template`
    
      FROM `jq470_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
    14	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

68. Query Time: 0.74 ms After last query: 22.52 ms Query memory: 0.024 MB Memory before query: 6.609 MB Rows returned: 4

    SELECT * 
      FROM jq470_hikashop_filter 
      WHERE filter_published = 1 
      AND (filter_access = 'all' OR filter_access LIKE '%,9,%') 
      ORDER BY filter_ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.12 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.04 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/filter.php:295
    14	hikashopFilterClass->getFilters()	JROOT/components/com_hikashop/views/product/view.html.php:185
    13	ProductViewProduct->filter()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
    11	hikashop_getLayout()	JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php:30
    10	include JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

69. Query Time: 0.94 ms After last query: 0.64 ms Query memory: 0.025 MB Memory before query: 6.661 MB Rows returned: 2

    SELECT a.id 
      FROM jq470_menu AS a 
      INNER JOIN `jq470_menu_types` as b 
      on a.menutype = b.menutype 
      WHERE a.type='component' 
      AND a.published=1 
      AND b.title IS NOT NULL 
      AND a.access IN (1,1,5) 
      AND a.client_id=0 
      AND a.link='index.php?option=com_hikashop&view=category&layout=listing' 
      AND a.language IN ('*', '', 'en-GB')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where
    1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	econma06_db.b.menutype	10	Using where

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.36 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.03 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
    18	hikashopMenusClass->loadAMenuItemId()	JROOT/templates/shaper_spectrum/html/com_hikashop/product/filter.php:30
    17	include JROOT/templates/shaper_spectrum/html/com_hikashop/product/filter.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2462
    13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
    12	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
    11	hikashop_getLayout()	JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php:30
    10	include JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

70. Query Time: 0.55 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 6.672 MB Rows returned: 2

    SELECT a.id 
      FROM jq470_menu AS a 
      INNER JOIN `jq470_menu_types` as b 
      on a.menutype = b.menutype 
      WHERE a.type='component' 
      AND a.published=1 
      AND b.title IS NOT NULL 
      AND a.access IN (1,1,5) 
      AND a.client_id=0 
      AND a.link='index.php?option=com_hikashop&view=product&layout=listing' 
      AND a.language IN ('*', '', 'en-GB')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where
    1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	econma06_db.b.menutype	10	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.27 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
    18	hikashopMenusClass->loadAMenuItemId()	JROOT/templates/shaper_spectrum/html/com_hikashop/product/filter.php:33
    17	include JROOT/templates/shaper_spectrum/html/com_hikashop/product/filter.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2479
    15	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    14	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2462
    13	hikashopView->display()	JROOT/components/com_hikashop/views/product/view.html.php:29
    12	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
    11	hikashop_getLayout()	JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php:30
    10	include JROOT/modules/mod_hikashop_filter/mod_hikashop_filter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

71. Query Time: 0.32 ms After last query: 1.75 ms Query memory: 0.023 MB Memory before query: 6.682 MB Rows returned: 0
    Duplicate queries: #14  #73

    SELECT cart.cart_id 
      FROM jq470_hikashop_cart AS cart  
      WHERE (cart.cart_type = 'cart') 
      AND (cart.session_id = '36o66bfhbt3ab6d1evd0kgirbb')  
      ORDER BY cart.cart_current DESC, cart.cart_modified DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cart	ref	session_id	session_id	767	const	1	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
    14	hikashopCartClass->getCurrentCartId()	JROOT/components/com_hikashop/views/product/view.html.php:2142
    13	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
    11	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
    10	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

72. Query Time: 0.60 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 6.692 MB Rows returned: 7

    SELECT a.id 
      FROM jq470_menu AS a 
      INNER JOIN `jq470_menu_types` as b 
      on a.menutype = b.menutype 
      WHERE a.type='component' 
      AND a.published=1 
      AND b.title IS NOT NULL 
      AND a.access IN (1,1,5) 
      AND a.client_id=0 
      AND a.link LIKE 'index.php?option=com_hikashop&view=%' 
      AND a.language IN ('*', '', 'en-GB')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ALL	idx_menutype	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where
    1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	econma06_db.b.menutype	10	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.35 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
    15	hikashopMenusClass->loadAMenuItemId()	JROOT/components/com_hikashop/views/product/view.html.php:2333
    14	ProductViewProduct->legacyCartInit()	JROOT/components/com_hikashop/views/product/view.html.php:2248
    13	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
    11	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
    10	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

73. Query Time: 0.30 ms After last query: 4.14 ms Query memory: 0.023 MB Memory before query: 6.736 MB Rows returned: 0
    Duplicate queries: #14  #71

    SELECT cart.cart_id 
      FROM jq470_hikashop_cart AS cart  
      WHERE (cart.cart_type = 'cart') 
      AND (cart.session_id = '36o66bfhbt3ab6d1evd0kgirbb')  
      ORDER BY cart.cart_current DESC, cart.cart_modified DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cart	ref	session_id	session_id	767	const	1	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
    14	hikashopCartClass->getCurrentCartId()	JROOT/components/com_hikashop/views/product/view.html.php:2142
    13	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
    12	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:844
    11	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
    10	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

74. Query Time: 1.87 ms After last query: 4.40 ms Query memory: 0.021 MB Memory before query: 6.801 MB Rows returned: 1
    Duplicate queries: #47

    SELECT * 
      FROM jq470_extensions 
      WHERE folder='system' 
      AND element='hikashopsocial' 
      AND type='plugin'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/plugins.php:113
    8	hikashopPluginsClass->getByName()	JROOT/plugins/system/hikashopsocial/hikashopsocial.php:55
    7	plgSystemHikashopsocial->onAfterRender()	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/CMSApplication.php:1050
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

75. Query Time: 0.36 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 6.814 MB Rows returned: 1

    SELECT * 
      FROM jq470_hikashop_product 
      WHERE product_id = '7800' 
      LIMIT 0, 1

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2362
    12	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/product.php:30
    11	hikashopProductClass->get()	JROOT/plugins/system/hikashopsocial/hikashopsocial.php:503
    10	plgSystemHikashopsocial->_getProductInfo()	JROOT/plugins/system/hikashopsocial/hikashopsocial.php:471
    9	plgSystemHikashopsocial->_getElementInfo()	JROOT/plugins/system/hikashopsocial/hikashopsocial.php:288
    8	plgSystemHikashopsocial->_addFacebookButton()	JROOT/plugins/system/hikashopsocial/hikashopsocial.php:89
    7	plgSystemHikashopsocial->onAfterRender()	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/CMSApplication.php:1050
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

76. Query Time: 0.59 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 6.829 MB Rows returned: 1

    SELECT * 
      FROM jq470_hikashop_file 
      WHERE file_ref_id=7800  
      AND file_type='product' 
      ORDER BY file_ordering ASC, file_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jq470_hikashop_file	ref	file_type,idx_file_ref_type_order​	idx_file_ref_type_order​	771	const,const	8	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.26 ms
    Preparing	0.07 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/plugins/system/hikashopsocial/hikashopsocial.php:554
    9	plgSystemHikashopsocial->_getImageURL()	JROOT/plugins/system/hikashopsocial/hikashopsocial.php:427
    8	plgSystemHikashopsocial->_addFacebookButton()	JROOT/plugins/system/hikashopsocial/hikashopsocial.php:89
    7	plgSystemHikashopsocial->onAfterRender()	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/CMSApplication.php:1050
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---