Vol. 30, No. 3: Autumn 2020

Name: Vol. 30, No. 3: Autumn 2020
SKU: J303
Price: 5.95 USD
Availability: InStock

$5.95

**SKU**: J303

Features in the Autumn 2020 issue include: "Understanding the Hips and the Waist (Part 2 & 3)" by Sam Masich; "Wading the Stream" by Sara & Michael Stenson; "Fengshui Healing" by Master Zhongxian Wu; and "Tai Chi Principles: The Correct Internal Principles of Tai Chi" by GrandMaster Kellen Chia.

Departments include "Five Common Mistakes in Tai Chi Push Hands" by Sara Kim Hjortborg; "China's Giant Panda" by Steven Luo; "Teaching Qigong Online: Zooming in on the Virtual Classroom" by Kenneth S. Cohen; "Quarantine Life: Wellness Hacks from an Acupuncturist" by Snow Xia, L.Ac.; a poem entitled "I Call These Words On My Dying Bed" by William M. Russell; as well as our usual news and tidbits.

Related products

Vol. 30, No. 3: Autumn 2020 Qi Journal (online Digital edition)

$5.95

**Add to cart**

You may also be interested in these products

Qi Journal Domestic Subscription: 1 year (starts with next issue)

$23.95

**Add to cart**

Qi Journal Domestic Subscription: 1 year (starts with current issue)

$25.95

**Add to cart**

**No Images**

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728302942,
                "last": 1728302942,
                "now": 1728302942
            },
            "token": "9KLK002rRuzveGap0dRy2tuTjRPQaKBR"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__j2store": {
        "currency": "USD"
    }
}

Profile Information

Time

Memory

**Time**: 5.34 ms / 5.34 ms **Memory**: 0.406 MB / 0.75 MB Application: afterLoad

**Time**: 90.63 ms / 95.97 ms **Memory**: 1.618 MB / 2.37 MB Application: afterInitialise

**Time**: 73.30 ms / 169.27 ms **Memory**: 1.712 MB / 4.08 MB Application: afterRoute

**Time**: 2.64 ms / 171.91 ms **Memory**: 0.021 MB / 4.10 MB Application: beforeRenderComponent com_j2store

**Time**: 49.32 ms / 221.23 ms **Memory**: 0.924 MB / 5.03 MB Application: Before Access::preloadComponents (all components)

**Time**: 2.76 ms / 223.99 ms **Memory**: 0.066 MB / 5.09 MB Application: After Access::preloadComponents (all components)

**Time**: 0.07 ms / 224.06 ms **Memory**: -0.004 MB / 5.09 MB Application: Before Access::getAssetRules (id:181 name:com_j2store)

**Time**: 0.40 ms / 224.46 ms **Memory**: 0.007 MB / 5.09 MB Application: After Access::getAssetRules (id:181 name:com_j2store)

**Time**: 13.26 ms / 237.72 ms **Memory**: 0.175 MB / 5.27 MB Application: Before Access::preloadPermissions (com_content)

**Time**: 11.11 ms / 248.83 ms **Memory**: 2.583 MB / 7.85 MB Application: After Access::preloadPermissions (com_content)

**Time**: 0.14 ms / 248.97 ms **Memory**: -0.128 MB / 7.72 MB Application: Before Access::getAssetRules (id:3360 name:com_content.article.2924)

**Time**: 0.06 ms / 249.03 ms **Memory**: 0.007 MB / 7.73 MB Application: After Access::getAssetRules (id:3360 name:com_content.article.2924)

**Time**: 43.37 ms / 292.40 ms **Memory**: 0.443 MB / 8.17 MB Application: Before Access::getAssetRules (id:1 name:root.1)

**Time**: 0.03 ms / 292.43 ms **Memory**: 0.002 MB / 8.17 MB Application: After Access::getAssetRules (id:1 name:root.1)

**Time**: 24.92 ms / 317.35 ms **Memory**: 0.170 MB / 8.35 MB Application: Before Access::getAssetRules (id:3361 name:com_content.article.2925)

**Time**: 0.05 ms / 317.40 ms **Memory**: 0.002 MB / 8.35 MB Application: After Access::getAssetRules (id:3361 name:com_content.article.2925)

**Time**: 46.29 ms / 363.69 ms **Memory**: 0.188 MB / 8.53 MB Application: Before Access::getAssetRules (id:1037 name:com_content.article.1659)

**Time**: 0.05 ms / 363.74 ms **Memory**: 0.003 MB / 8.54 MB Application: After Access::getAssetRules (id:1037 name:com_content.article.1659)

**Time**: 37.01 ms / 400.75 ms **Memory**: 0.355 MB / 8.89 MB Application: Before Access::getAssetRules (id:1030 name:com_content.article.2072)

**Time**: 0.04 ms / 400.79 ms **Memory**: 0.002 MB / 8.89 MB Application: After Access::getAssetRules (id:1030 name:com_content.article.2072)

**Time**: 125.01 ms / 525.80 ms **Memory**: 1.296 MB / 10.19 MB Application: afterRenderComponent com_j2store

**Time**: 2.34 ms / 528.14 ms **Memory**: 0.009 MB / 10.20 MB Application: afterDispatch

**Time**: 1.49 ms / 529.63 ms **Memory**: 0.028 MB / 10.23 MB Application: beforeRenderModule mod_custom (Footer information)

**Time**: 1.00 ms / 530.64 ms **Memory**: 0.006 MB / 10.23 MB Application: afterRenderModule mod_custom (Footer information)

**Time**: 0.06 ms / 530.69 ms **Memory**: -0.001 MB / 10.23 MB Application: beforeRenderModule mod_search (Site Search)

**Time**: 0.95 ms / 531.65 ms **Memory**: 0.020 MB / 10.25 MB Application: afterRenderModule mod_search (Site Search)

**Time**: 0.02 ms / 531.67 ms **Memory**: -0.006 MB / 10.25 MB Application: beforeRenderModule mod_random_image (Monk Photos)

**Time**: 0.45 ms / 532.11 ms **Memory**: 0.008 MB / 10.25 MB Application: afterRenderModule mod_random_image (Monk Photos)

**Time**: 0.07 ms / 532.19 ms **Memory**: -0.001 MB / 10.25 MB Application: beforeRenderModule mod_custom (Left Navigation Panel)

**Time**: 0.09 ms / 532.27 ms **Memory**: 0.003 MB / 10.26 MB Application: afterRenderModule mod_custom (Left Navigation Panel)

**Time**: 0.04 ms / 532.32 ms **Memory**: 0.000 MB / 10.26 MB Application: beforeRenderModule mod_menu (Top)

**Time**: 14.18 ms / 546.49 ms **Memory**: 1.439 MB / 11.69 MB Application: afterRenderModule mod_menu (Top)

**Time**: 0.07 ms / 546.56 ms **Memory**: -0.015 MB / 11.68 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

**Time**: 1.39 ms / 547.96 ms **Memory**: 0.016 MB / 11.70 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

**Time**: 0.10 ms / 548.05 ms **Memory**: 0.011 MB / 11.71 MB Application: beforeRenderModule mod_custom (Image Module)

**Time**: 7.73 ms / 555.78 ms **Memory**: 0.023 MB / 11.73 MB Application: afterRenderModule mod_custom (Image Module)

**Time**: 19.15 ms / 574.92 ms **Memory**: 0.311 MB / 12.04 MB Application: beforeRenderModule mod_menu (Calendar Menu module)

**Time**: 1.10 ms / 576.02 ms **Memory**: 0.017 MB / 12.06 MB Application: afterRenderModule mod_menu (Calendar Menu module)

**Time**: 3.52 ms / 579.54 ms **Memory**: 0.005 MB / 12.06 MB Application: beforeRenderModule mod_menu (Library Menu module)

**Time**: 0.80 ms / 580.34 ms **Memory**: 0.046 MB / 12.11 MB Application: afterRenderModule mod_menu (Library Menu module)

**Time**: 28.25 ms / 608.59 ms **Memory**: 0.031 MB / 12.14 MB Application: afterRender

**Database queries total: 309.01 ms**

Memory Usage

Database Queries

126 Queries Logged 309.01 ms

48 duplicate found!

**2 duplicates**: #10 #28

**3 duplicates**: #29 #33 #36

**2 duplicates**: #37 #41

**3 duplicates**: #48 #51 #54

**14 duplicates**: #57 #60 #63 #64 #65 #66 #67 #68 #69 #70 #71 #72 #73 #74

**14 duplicates**: #77 #79 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91 #92 #93

**2 duplicates**: #96 #97

**2 duplicates**: #101 #102

**2 duplicates**: #103 #104

**2 duplicates**: #105 #106

**2 duplicates**: #107 #108

**Query Time: 1.62 ms** **Query memory: 0.023 MB Memory before query: 1.029 MB** **Rows returned: 0**

SELECT `data`

  FROM `hubip_session`

  WHERE `session_id` = X'3734663030313963356439316533353336626538656462663830346636656638'

**Explain**

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

**Profile**

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

**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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

**Query Time: 0.77 ms** **After last query: 0.51 ms** **Query memory: 0.020 MB Memory before query: 1.043 MB** **Rows returned: 0**

SELECT `session_id`

  FROM `hubip_session`

  WHERE `session_id` = X'3734663030313963356439316533353336626538656462663830346636656638' 
  LIMIT 1

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

**Query Time: 5.80 ms** **After last query: 0.12 ms** **Query memory: 0.004 MB Memory before query: 1.048 MB**

INSERT INTO `hubip_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3734663030313963356439316533353336626538656462663830346636656638', 1, 1728302942, 0, '', 0)

**Explain**

**EXPLAIN not possible on query: INSERT INTO `hubip_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3734663030313963356439316533353336626538656462663830346636656638', 1, 1728302942, 0, '', 0)**

**Profile**

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

**Call Stack**

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

**Query Time: 4.12 ms** **After last query: 0.84 ms** **Query memory: 0.025 MB Memory before query: 1.079 MB** **Rows returned: 45**

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

  FROM `hubip_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	hubip_extensions	ref	extension	extension	82	const	46	Using index condition; Using where

**Profile**

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

**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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.81 ms** **After last query: 1.03 ms** **Query memory: 0.021 MB Memory before query: 1.113 MB** **Rows returned: 6**

SELECT id, rules

  FROM `hubip_viewlevels`

**Explain**

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

**Profile**

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

**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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.87 ms** **After last query: 0.17 ms** **Query memory: 0.021 MB Memory before query: 1.125 MB** **Rows returned: 2**

SELECT b.id

  FROM hubip_usergroups AS a

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

  WHERE a.id = 13

**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**

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

**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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 7.48 ms** **After last query: 0.26 ms** **Query memory: 0.051 MB Memory before query: 1.146 MB** **Rows returned: 147**

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

  FROM hubip_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	hubip_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	375	Using where; Using filesort

**Profile**

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

**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:351
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:356
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.79 ms** **After last query: 38.99 ms** **Query memory: 0.005 MB Memory before query: 2.269 MB**

DELETE 

  FROM `hubip_jhackguard_ip_filters`

  WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) 
  AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)

**Explain**

**EXPLAIN not possible on query: DELETE FROM `hubip_jhackguard_ip_filters` WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)**

**Profile**

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

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/jhackguard/jhackguard.php:156
8	PlgSystemJhackguard->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:668
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 3.09 ms** **After last query: 0.17 ms** **Query memory: 0.021 MB Memory before query: 2.277 MB** **Rows returned: 0**

SELECT `state`,`rule_type`

  FROM `hubip_jhackguard_ip_filters`

  WHERE `ip` = '44.220.184.63' 
  AND `state` = 1

  ORDER BY ordering ASC

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/jhackguard/jhackguard.php:358
9	PlgSystemJhackguard->ip_is()	JROOT/plugins/system/jhackguard/jhackguard.php:174
8	PlgSystemJhackguard->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:668
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.93 ms** **After last query: 1.62 ms** **Query memory: 0.031 MB Memory before query: 2.297 MB** **Rows returned: 106**

**Duplicate queries**: #28

SELECT *

  FROM hubip_j2store_configurations

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/helpers/config.php:20
12	J2Config->__construct()	JROOT/administrator/components/com_j2store/helpers/config.php:28
11	J2Config::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:72
10	J2Store::config()	JROOT/plugins/system/j2store/j2store.php:187
9	plgSystemJ2Store->onJ2StoreCronTask()	JROOT/plugins/system/j2store/j2store.php:167
8	plgSystemJ2Store->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:668
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 4.20 ms** **After last query: 1.30 ms** **Query memory: 0.398 MB Memory before query: 2.397 MB** **Rows returned: 138**

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 hubip_menu AS m

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

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

  ORDER BY m.lft

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
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:78
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:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:533
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:1141
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.63 ms** **After last query: 6.34 ms** **Query memory: 0.022 MB Memory before query: 3.332 MB** **Rows returned: 1**

SELECT *

  FROM hubip_content

  WHERE `alias` = 'j303' 
  AND `language` IN ('en-GB','*' )

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hubip_content	ref	idx_language,idx_alias	idx_alias	766	const	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_j2store/helpers/article.php:189
11	J2Article->getArticleByAlias()	JROOT/administrator/components/com_j2store/helpers/router.php:472
10	J2StoreRouterHelper::getArticleByAlias()	JROOT/components/com_j2store/router.php:486
9	J2StoreRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.54 ms** **After last query: 4.95 ms** **Query memory: 0.032 MB Memory before query: 3.476 MB** **Rows returned: 239**

SHOW TABLES

**Explain**

**EXPLAIN not possible on query: SHOW TABLES**

**Profile**

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

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
16	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
15	F0FDatabaseDriverJoomla->getTableList()	JROOT/libraries/f0f/table/table.php:2082
14	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
13	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
12	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
11	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/helpers/router.php:475
10	J2StoreRouterHelper::getArticleByAlias()	JROOT/components/com_j2store/router.php:486
9	J2StoreRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.09 ms** **After last query: 0.43 ms** **Query memory: 0.027 MB Memory before query: 3.507 MB** **Rows returned: 21**

SHOW FULL COLUMNS 
  FROM `hubip_j2store_products`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hubip_j2store_products`**

**Profile**

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

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
15	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
14	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
13	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
12	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
11	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/helpers/router.php:475
10	J2StoreRouterHelper::getArticleByAlias()	JROOT/components/com_j2store/router.php:486
9	J2StoreRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.79 ms** **After last query: 0.45 ms** **Query memory: 0.026 MB Memory before query: 3.548 MB** **Rows returned: 8**

SHOW FULL COLUMNS 
  FROM `hubip_j2store_productimages`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hubip_j2store_productimages`**

**Profile**

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

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
16	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
15	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2360
14	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
13	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
12	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
11	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/helpers/router.php:475
10	J2StoreRouterHelper::getArticleByAlias()	JROOT/components/com_j2store/router.php:486
9	J2StoreRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.42 ms** **After last query: 0.09 ms** **Query memory: 0.025 MB Memory before query: 3.564 MB** **Rows returned: 5**

SHOW FULL COLUMNS 
  FROM `hubip_j2store_manufacturers`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hubip_j2store_manufacturers`**

**Profile**

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

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
16	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
15	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2360
14	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
13	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
12	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
11	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/helpers/router.php:475
10	J2StoreRouterHelper::getArticleByAlias()	JROOT/components/com_j2store/router.php:486
9	J2StoreRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 4.30 ms** **After last query: 0.15 ms** **Query memory: 0.026 MB Memory before query: 3.580 MB** **Rows returned: 5**

SHOW FULL COLUMNS 
  FROM `hubip_j2store_vendors`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hubip_j2store_vendors`**

**Profile**

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

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
16	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
15	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2360
14	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
13	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
12	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
11	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/helpers/router.php:475
10	J2StoreRouterHelper::getArticleByAlias()	JROOT/components/com_j2store/router.php:486
9	J2StoreRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 3.10 ms** **After last query: 0.36 ms** **Query memory: 0.029 MB Memory before query: 3.595 MB** **Rows returned: 22**

SHOW FULL COLUMNS 
  FROM `hubip_j2store_addresses`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hubip_j2store_addresses`**

**Profile**

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

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
16	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2162
15	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2360
14	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
13	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:66
12	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
11	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/helpers/router.php:475
10	J2StoreRouterHelper::getArticleByAlias()	JROOT/components/com_j2store/router.php:486
9	J2StoreRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 6.55 ms** **After last query: 1.62 ms** **Query memory: 0.023 MB Memory before query: 3.661 MB** **Rows returned: 1**

SELECT hubip_j2store_products.*,`hubip_j2store_productimages`.`j2store_productimage_id`,`hubip_j2store_productimages`.`main_image`,`hubip_j2store_productimages`.`main_image_alt`,`hubip_j2store_productimages`.`thumb_image`,`hubip_j2store_productimages`.`thumb_image_alt`,`hubip_j2store_productimages`.`additional_images`,`hubip_j2store_productimages`.`additional_images_alt`,`hubip_j2store_manufacturers`.`brand_desc_id`,`hubip_j2store_addresses`.`first_name` AS manufacturer_first_name,`hubip_j2store_addresses`.`last_name` AS manufacturer_last_name,`hubip_j2store_addresses`.`company` AS manufacturer

  FROM hubip_j2store_products

  LEFT JOIN `hubip_j2store_productimages` 
  ON `hubip_j2store_products`.`j2store_product_id` = `hubip_j2store_productimages`.`product_id`

  LEFT JOIN `hubip_j2store_manufacturers` 
  ON `hubip_j2store_products`.`manufacturer_id` = `hubip_j2store_manufacturers`.`j2store_manufacturer_id`

  LEFT JOIN `hubip_j2store_vendors` 
  ON `hubip_j2store_products`.`vendor_id` = `hubip_j2store_vendors`.`j2store_vendor_id`

  LEFT JOIN `hubip_j2store_addresses` 
  ON `hubip_j2store_manufacturers`.`address_id` = `hubip_j2store_addresses`.`j2store_address_id`

  WHERE `hubip_j2store_products`.`product_source` = 'com_content' 
  AND `hubip_j2store_products`.`product_source_id` = '2924' 
  AND `hubip_j2store_products`.`enabled` = '1' 
  AND `hubip_j2store_products`.`visibility` = '1'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hubip_j2store_products	const	catalogsource	catalogsource	773	const,const	1
1	SIMPLE	hubip_j2store_productimages	ref	productimage_product_id	productimage_product_id	5	const	1
1	SIMPLE	hubip_j2store_manufacturers	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	hubip_j2store_addresses	eq_ref	PRIMARY	PRIMARY	4	joomla.hubip_j2store_manufacturers.address_id	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
14	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
13	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:94
12	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/tables/product.php:197
11	J2StoreTableProduct->get_product_by_source()	JROOT/administrator/components/com_j2store/helpers/router.php:476
10	J2StoreRouterHelper::getArticleByAlias()	JROOT/components/com_j2store/router.php:486
9	J2StoreRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 3.21 ms** **After last query: 2.20 ms** **Query memory: 0.021 MB Memory before query: 3.681 MB** **Rows returned: 2**

SELECT id, home, template, s.params

  FROM hubip_template_styles as s

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	joomla.s.template,const	1	Using index condition; Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:353
9	T3::detect()	JROOT/plugins/system/t3/t3.php:87
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.00 ms** **After last query: 1.10 ms** **Query memory: 0.024 MB Memory before query: 3.713 MB** **Rows returned: 1**

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

  FROM `hubip_extensions`

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

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/j2store/j2store.php:80
8	plgSystemJ2Store->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:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.48 ms** **After last query: 0.25 ms** **Query memory: 0.006 MB Memory before query: 3.706 MB**

UPDATE `hubip_extensions`

  SET `params` = '{\"mediaversion\":\"a6a623aa4f3ebbbc38d12f946e5bd113\"}'

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

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/j2store/j2store.php:80
8	plgSystemJ2Store->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:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.10 ms** **After last query: 1.73 ms** **Query memory: 0.021 MB Memory before query: 3.760 MB** **Rows returned: 1**

SELECT hubip_j2store_products.*

  FROM hubip_j2store_products

  WHERE `hubip_j2store_products`.`j2store_product_id` = '2755'

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
10	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
9	F0FTable->load()	JROOT/plugins/system/j2canonical/j2canonical.php:101
8	plgSystemJ2Canonical->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:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 14.23 ms** **After last query: 0.21 ms** **Query memory: 0.177 MB Memory before query: 3.766 MB** **Rows returned: 2583**

SELECT jp.j2store_product_id,c.catid

  FROM hubip_j2store_products jp

  LEFT JOIN hubip_content c 
  ON c.id=jp.product_source_id

  WHERE jp.product_source='com_content'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jp	ref	catalogsource	catalogsource	768	const	2583	Using where; Using index
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	joomla.jp.product_source_id	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/j2canonical/j2canonical.php:189
9	plgSystemJ2Canonical->getProductCatId()	JROOT/plugins/system/j2canonical/j2canonical.php:107
8	plgSystemJ2Canonical->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:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.58 ms** **After last query: 4.35 ms** **Query memory: 0.019 MB Memory before query: 4.083 MB** **Rows returned: 1**

SELECT *

  FROM hubip_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

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

**Profile**

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

**Call Stack**

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

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

**Query Time: 6.84 ms** **After last query: 20.84 ms** **Query memory: 0.021 MB Memory before query: 4.785 MB** **Rows returned: 1**

SELECT template 
  FROM hubip_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	hubip_template_styles	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_j2store/helpers/strapper.php:169
8	J2StoreStrapper::getDefaultTemplate()	JROOT/administrator/components/com_j2store/helpers/strapper.php:137
7	J2StoreStrapper::addCSS()	JROOT/components/com_j2store/j2store.php:24
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.31 ms** **After last query: 22.67 ms** **Query memory: 0.029 MB Memory before query: 5.032 MB** **Rows returned: 45**

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

  FROM `hubip_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforms6','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyfrontendseo','com_fields','com_finder','com_focontentuploader','com_geoprotection','com_gsd','com_installer','com_j2store','com_jce','com_jhackguard','com_joomlaquiz','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hubip_assets	range	idx_asset_name	idx_asset_name	202	NULL	46	Using index condition

**Profile**

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

**Call Stack**

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/libraries/f0f/integration/joomla/platform.php:584
15	F0FIntegrationJoomlaPlatform->authorise()	JROOT/libraries/f0f/view/raw.php:80
14	F0FViewRaw->__construct()	JROOT/libraries/f0f/view/html.php:53
13	F0FViewHtml->__construct()	JROOT/libraries/f0f/controller/controller.php:2806
12	F0FController->createView()	JROOT/libraries/f0f/controller/controller.php:2501
11	F0FController->getView()	JROOT/libraries/f0f/controller/controller.php:2403
10	F0FController->getThisView()	JROOT/components/com_j2store/controllers/products.php:576
9	J2StoreControllerProducts->view()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 4.69 ms** **After last query: 2.60 ms** **Query memory: 0.031 MB Memory before query: 5.166 MB** **Rows returned: 106**

**Duplicate queries**: #10

SELECT *

  FROM hubip_j2store_configurations

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/models/products.php:1034
10	J2StoreModelProducts->getMergedParams()	JROOT/components/com_j2store/controllers/products.php:585
9	J2StoreControllerProducts->view()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 3.94 ms** **After last query: 1.08 ms** **Query memory: 0.024 MB Memory before query: 5.190 MB** **Rows returned: 1**

**Duplicate queries**: #33 #36

SELECT hubip_j2store_products.*,`hubip_j2store_productimages`.`j2store_productimage_id`,`hubip_j2store_productimages`.`main_image`,`hubip_j2store_productimages`.`main_image_alt`,`hubip_j2store_productimages`.`thumb_image`,`hubip_j2store_productimages`.`thumb_image_alt`,`hubip_j2store_productimages`.`additional_images`,`hubip_j2store_productimages`.`additional_images_alt`,`hubip_j2store_manufacturers`.`brand_desc_id`,`hubip_j2store_addresses`.`first_name` AS manufacturer_first_name,`hubip_j2store_addresses`.`last_name` AS manufacturer_last_name,`hubip_j2store_addresses`.`company` AS manufacturer

  FROM hubip_j2store_products

  LEFT JOIN `hubip_j2store_productimages` 
  ON `hubip_j2store_products`.`j2store_product_id` = `hubip_j2store_productimages`.`product_id`

  LEFT JOIN `hubip_j2store_manufacturers` 
  ON `hubip_j2store_products`.`manufacturer_id` = `hubip_j2store_manufacturers`.`j2store_manufacturer_id`

  LEFT JOIN `hubip_j2store_vendors` 
  ON `hubip_j2store_products`.`vendor_id` = `hubip_j2store_vendors`.`j2store_vendor_id`

  LEFT JOIN `hubip_j2store_addresses` 
  ON `hubip_j2store_manufacturers`.`address_id` = `hubip_j2store_addresses`.`j2store_address_id`

  WHERE `hubip_j2store_products`.`j2store_product_id` = '2755'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hubip_j2store_products	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	hubip_j2store_productimages	ref	productimage_product_id	productimage_product_id	5	const	1
1	SIMPLE	hubip_j2store_manufacturers	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	hubip_j2store_addresses	eq_ref	PRIMARY	PRIMARY	4	joomla.hubip_j2store_manufacturers.address_id	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
14	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
13	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:94
12	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/helpers/product.php:149
11	J2Product->loadProduct()	JROOT/administrator/components/com_j2store/helpers/product.php:131
10	J2Product->getProduct()	JROOT/components/com_j2store/controllers/products.php:593
9	J2StoreControllerProducts->view()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 5.10 ms** **After last query: 1.76 ms** **Query memory: 0.405 MB Memory before query: 5.267 MB** **Rows returned: 3299**

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

  FROM `hubip_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hubip_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	4082	Using where

**Profile**

Status	Duration
Starting	0.28 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.03 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	2.94 ms
End of update loop	0.07 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.22 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
22	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
21	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:128
17	ContentModelArticle->getItem()	JROOT/plugins/content/j2store/j2store.php:684
16	plgContentJ2Store->getArticle()	JROOT/plugins/content/j2store/j2store.php:581
15	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/helpers/product.php:150
11	J2Product->loadProduct()	JROOT/administrator/components/com_j2store/helpers/product.php:131
10	J2Product->getProduct()	JROOT/components/com_j2store/controllers/products.php:593
9	J2StoreControllerProducts->view()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 3.12 ms** **After last query: 6.49 ms** **Query memory: 0.025 MB Memory before query: 7.732 MB** **Rows returned: 1**

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM hubip_content AS a

  INNER JOIN hubip_categories AS c 
  on c.id = a.catid

  LEFT JOIN hubip_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 2924 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-07 12:09:02') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-07 12:09:02') 
  AND (a.state = 1 OR a.state =0)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

**Profile**

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

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
17	ContentModelArticle->getItem()	JROOT/plugins/content/j2store/j2store.php:684
16	plgContentJ2Store->getArticle()	JROOT/plugins/content/j2store/j2store.php:581
15	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/helpers/product.php:150
11	J2Product->loadProduct()	JROOT/administrator/components/com_j2store/helpers/product.php:131
10	J2Product->getProduct()	JROOT/components/com_j2store/controllers/products.php:593
9	J2StoreControllerProducts->view()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.64 ms** **After last query: 1.48 ms** **Query memory: 0.029 MB Memory before query: 7.763 MB** **Rows returned: 2**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `hubip_categories` AS `s`

  INNER JOIN `hubip_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 187

  ORDER BY c.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	208	Using where; Using filesort

**Profile**

Status	Duration
Starting	0.37 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.08 ms
Optimizing	0.03 ms
Statistics	0.20 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.29 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
25	ContentRouter->getCategorySegment()	*Same as call in the line below.*
24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/j2store/j2store.php:602
15	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/helpers/product.php:150
11	J2Product->loadProduct()	JROOT/administrator/components/com_j2store/helpers/product.php:131
10	J2Product->getProduct()	JROOT/components/com_j2store/controllers/products.php:593
9	J2StoreControllerProducts->view()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.16 ms** **After last query: 1.96 ms** **Query memory: 0.030 MB Memory before query: 7.835 MB** **Rows returned: 1**

**Duplicate queries**: #29 #36

SELECT hubip_j2store_products.*,`hubip_j2store_productimages`.`j2store_productimage_id`,`hubip_j2store_productimages`.`main_image`,`hubip_j2store_productimages`.`main_image_alt`,`hubip_j2store_productimages`.`thumb_image`,`hubip_j2store_productimages`.`thumb_image_alt`,`hubip_j2store_productimages`.`additional_images`,`hubip_j2store_productimages`.`additional_images_alt`,`hubip_j2store_manufacturers`.`brand_desc_id`,`hubip_j2store_addresses`.`first_name` AS manufacturer_first_name,`hubip_j2store_addresses`.`last_name` AS manufacturer_last_name,`hubip_j2store_addresses`.`company` AS manufacturer

  FROM hubip_j2store_products

  LEFT JOIN `hubip_j2store_productimages` 
  ON `hubip_j2store_products`.`j2store_product_id` = `hubip_j2store_productimages`.`product_id`

  LEFT JOIN `hubip_j2store_manufacturers` 
  ON `hubip_j2store_products`.`manufacturer_id` = `hubip_j2store_manufacturers`.`j2store_manufacturer_id`

  LEFT JOIN `hubip_j2store_vendors` 
  ON `hubip_j2store_products`.`vendor_id` = `hubip_j2store_vendors`.`j2store_vendor_id`

  LEFT JOIN `hubip_j2store_addresses` 
  ON `hubip_j2store_manufacturers`.`address_id` = `hubip_j2store_addresses`.`j2store_address_id`

  WHERE `hubip_j2store_products`.`j2store_product_id` = '2755'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hubip_j2store_products	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	hubip_j2store_productimages	ref	productimage_product_id	productimage_product_id	5	const	1
1	SIMPLE	hubip_j2store_manufacturers	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	hubip_j2store_addresses	eq_ref	PRIMARY	PRIMARY	4	joomla.hubip_j2store_manufacturers.address_id	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
28	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
27	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
26	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:94
25	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/helpers/router.php:393
24	J2StoreRouterHelper::getProductCategory()	JROOT/administrator/components/com_j2store/helpers/router.php:301
23	J2StoreRouterHelper::checkMenuProducts()	JROOT/administrator/components/com_j2store/helpers/router.php:248
22	J2StoreRouterHelper::findProductMenu()	JROOT/components/com_j2store/router.php:224
21	J2StoreRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_j2store/helpers/product.php:1036
14	J2Product->getProductLink()	JROOT/administrator/components/com_j2store/models/behavior/simple.php:194
13	J2StoreModelProductsBehaviorSimple->onAfterGetProduct()	JROOT/libraries/f0f/utils/observable/event.php:63
12	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
11	F0FUtilsObservableDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:208
10	J2StoreModelProducts->getProduct()	JROOT/components/com_j2store/controllers/products.php:602
9	J2StoreControllerProducts->view()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.32 ms** **After last query: 0.42 ms** **Query memory: 0.028 MB Memory before query: 7.842 MB** **Rows returned: 0**

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `hubip_content` AS `c`

  INNER JOIN `hubip_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `hubip_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `hubip_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `hubip_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 2924

**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.20 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
27	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_j2store/helpers/article.php:274
26	J2Article->getAssociations()	JROOT/administrator/components/com_j2store/helpers/article.php:245
25	J2Article->getAssociatedArticle()	JROOT/administrator/components/com_j2store/helpers/router.php:395
24	J2StoreRouterHelper::getProductCategory()	JROOT/administrator/components/com_j2store/helpers/router.php:301
23	J2StoreRouterHelper::checkMenuProducts()	JROOT/administrator/components/com_j2store/helpers/router.php:248
22	J2StoreRouterHelper::findProductMenu()	JROOT/components/com_j2store/router.php:224
21	J2StoreRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_j2store/helpers/product.php:1036
14	J2Product->getProductLink()	JROOT/administrator/components/com_j2store/models/behavior/simple.php:194
13	J2StoreModelProductsBehaviorSimple->onAfterGetProduct()	JROOT/libraries/f0f/utils/observable/event.php:63
12	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
11	F0FUtilsObservableDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:208
10	J2StoreModelProducts->getProduct()	JROOT/components/com_j2store/controllers/products.php:602
9	J2StoreControllerProducts->view()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 4.40 ms** **After last query: 0.10 ms** **Query memory: 0.028 MB Memory before query: 7.852 MB** **Rows returned: 1**

SELECT *

  FROM hubip_content

  WHERE id='2924'

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_j2store/helpers/article.php:86
25	J2Article->getArticle()	JROOT/administrator/components/com_j2store/helpers/router.php:396
24	J2StoreRouterHelper::getProductCategory()	JROOT/administrator/components/com_j2store/helpers/router.php:301
23	J2StoreRouterHelper::checkMenuProducts()	JROOT/administrator/components/com_j2store/helpers/router.php:248
22	J2StoreRouterHelper::findProductMenu()	JROOT/components/com_j2store/router.php:224
21	J2StoreRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_j2store/helpers/product.php:1036
14	J2Product->getProductLink()	JROOT/administrator/components/com_j2store/models/behavior/simple.php:194
13	J2StoreModelProductsBehaviorSimple->onAfterGetProduct()	JROOT/libraries/f0f/utils/observable/event.php:63
12	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
11	F0FUtilsObservableDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:208
10	J2StoreModelProducts->getProduct()	JROOT/components/com_j2store/controllers/products.php:602
9	J2StoreControllerProducts->view()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.22 ms** **After last query: 0.96 ms** **Query memory: 0.028 MB Memory before query: 7.879 MB** **Rows returned: 1**

**Duplicate queries**: #29 #33

SELECT hubip_j2store_products.*,`hubip_j2store_productimages`.`j2store_productimage_id`,`hubip_j2store_productimages`.`main_image`,`hubip_j2store_productimages`.`main_image_alt`,`hubip_j2store_productimages`.`thumb_image`,`hubip_j2store_productimages`.`thumb_image_alt`,`hubip_j2store_productimages`.`additional_images`,`hubip_j2store_productimages`.`additional_images_alt`,`hubip_j2store_manufacturers`.`brand_desc_id`,`hubip_j2store_addresses`.`first_name` AS manufacturer_first_name,`hubip_j2store_addresses`.`last_name` AS manufacturer_last_name,`hubip_j2store_addresses`.`company` AS manufacturer

  FROM hubip_j2store_products

  LEFT JOIN `hubip_j2store_productimages` 
  ON `hubip_j2store_products`.`j2store_product_id` = `hubip_j2store_productimages`.`product_id`

  LEFT JOIN `hubip_j2store_manufacturers` 
  ON `hubip_j2store_products`.`manufacturer_id` = `hubip_j2store_manufacturers`.`j2store_manufacturer_id`

  LEFT JOIN `hubip_j2store_vendors` 
  ON `hubip_j2store_products`.`vendor_id` = `hubip_j2store_vendors`.`j2store_vendor_id`

  LEFT JOIN `hubip_j2store_addresses` 
  ON `hubip_j2store_manufacturers`.`address_id` = `hubip_j2store_addresses`.`j2store_address_id`

  WHERE `hubip_j2store_products`.`j2store_product_id` = '2755'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hubip_j2store_products	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	hubip_j2store_productimages	ref	productimage_product_id	productimage_product_id	5	const	1
1	SIMPLE	hubip_j2store_manufacturers	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	hubip_j2store_addresses	eq_ref	PRIMARY	PRIMARY	4	joomla.hubip_j2store_manufacturers.address_id	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
25	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
24	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:94
23	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/helpers/router.php:419
22	J2StoreRouterHelper::getItemAlias()	JROOT/components/com_j2store/router.php:263
21	J2StoreRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_j2store/helpers/product.php:1036
14	J2Product->getProductLink()	JROOT/administrator/components/com_j2store/models/behavior/simple.php:194
13	J2StoreModelProductsBehaviorSimple->onAfterGetProduct()	JROOT/libraries/f0f/utils/observable/event.php:63
12	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
11	F0FUtilsObservableDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:208
10	J2StoreModelProducts->getProduct()	JROOT/components/com_j2store/controllers/products.php:602
9	J2StoreControllerProducts->view()	JROOT/libraries/f0f/controller/controller.php:967
8	F0FController->execute()	JROOT/libraries/f0f/dispatcher/dispatcher.php:326
7	F0FDispatcher->dispatch()	JROOT/components/com_j2store/j2store.php:25
6	require_once JROOT/components/com_j2store/j2store.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.04 ms** **After last query: 1.61 ms** **Query memory: 0.036 MB Memory before query: 7.916 MB** **Rows returned: 33**

Vol. 30, No. 3: Autumn 2020

**Related products**

Vol. 30, No. 3: Autumn 2020 Qi Journal (online Digital edition)

**You may also be interested in these products**

Qi Journal Domestic Subscription: 1 year (starts with next issue)

Qi Journal Domestic Subscription: 1 year (starts with current issue)

**Joomla! Debug Console**

**Session**

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**126 Queries Logged** 309.01 ms

**48 duplicate found!**

Related products

You may also be interested in these products

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

126 Queries Logged 309.01 ms

48 duplicate found!