Store - JustHope

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1674875357,
                "last": 1674875357,
                "now": 1674875357
            },
            "token": "oXkyyUW21YNeqACw3aH1Zc8p6q4MgsId"
        },
        "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": {
        "manufacturer_ids": null,
        "vendor_ids": null,
        "productfilter_ids": null,
        "list_product_filter_search_logic_rel": null,
        "currency": "USD"
    }
}

Profile Information

Time

Memory

Time: 14.42 ms / 14.42 ms Memory: 2.024 MB / 2.39 MB Application: afterLoad

Time: 69.86 ms / 84.28 ms Memory: 6.605 MB / 9.00 MB Application: afterInitialise

Time: 20.20 ms / 104.48 ms Memory: 1.783 MB / 10.78 MB Application: afterRoute

Time: 0.56 ms / 105.03 ms Memory: 0.034 MB / 10.81 MB Application: beforeRenderComponent com_j2store

Time: 50.46 ms / 155.49 ms Memory: 5.275 MB / 16.09 MB Application: Before Access::preloadComponents (all components)

Time: 1.25 ms / 156.74 ms Memory: 0.068 MB / 16.16 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 156.77 ms Memory: -0.005 MB / 16.15 MB Application: Before Access::getAssetRules (id:419 name:com_j2store)

Time: 0.31 ms / 157.07 ms Memory: 0.026 MB / 16.18 MB Application: After Access::getAssetRules (id:419 name:com_j2store)

Time: 66.29 ms / 223.36 ms Memory: 2.094 MB / 18.27 MB Application: beforeRenderModule mod_custom (Store Sharing Buttons)

Time: 0.63 ms / 224.00 ms Memory: 0.005 MB / 18.28 MB Application: afterRenderRawModule mod_custom (Store Sharing Buttons)

Time: 0.01 ms / 224.01 ms Memory: -0.001 MB / 18.28 MB Application: beforeRenderModule mod_custom (Store Sharing Buttons)

Time: 1.41 ms / 225.41 ms Memory: 0.126 MB / 18.40 MB Application: afterRenderModule mod_custom (Store Sharing Buttons)

Time: 1.45 ms / 226.86 ms Memory: 0.016 MB / 18.42 MB Application: beforeRenderModule mod_custom (Stole Sizing)

Time: 0.17 ms / 227.03 ms Memory: 0.001 MB / 18.42 MB Application: afterRenderRawModule mod_custom (Stole Sizing)

Time: 0.01 ms / 227.04 ms Memory: 0.001 MB / 18.42 MB Application: beforeRenderModule mod_custom (Stole Sizing)

Time: 0.19 ms / 227.23 ms Memory: 0.003 MB / 18.42 MB Application: afterRenderModule mod_custom (Stole Sizing)

Time: 3.22 ms / 230.45 ms Memory: 0.102 MB / 18.52 MB Application: beforeRenderModule mod_custom (Stitching Hope Info)

Time: 0.16 ms / 230.60 ms Memory: 0.002 MB / 18.53 MB Application: afterRenderRawModule mod_custom (Stitching Hope Info)

Time: 0.01 ms / 230.61 ms Memory: 0.001 MB / 18.53 MB Application: beforeRenderModule mod_custom (Stitching Hope Info)

Time: 0.17 ms / 230.79 ms Memory: 0.002 MB / 18.53 MB Application: afterRenderModule mod_custom (Stitching Hope Info)

Time: 2.56 ms / 233.35 ms Memory: 0.047 MB / 18.58 MB Application: beforeRenderModule mod_custom (Stitching Hope Info)

Time: 0.18 ms / 233.53 ms Memory: 0.002 MB / 18.58 MB Application: afterRenderModule mod_custom (Stitching Hope Info)

Time: 2.03 ms / 235.55 ms Memory: 0.027 MB / 18.61 MB Application: beforeRenderModule mod_custom (Stitching Hope Info)

Time: 0.18 ms / 235.74 ms Memory: 0.002 MB / 18.61 MB Application: afterRenderModule mod_custom (Stitching Hope Info)

Time: 1.77 ms / 237.50 ms Memory: 0.025 MB / 18.63 MB Application: beforeRenderModule mod_custom (Stitching Hope Info)

Time: 0.20 ms / 237.70 ms Memory: 0.002 MB / 18.63 MB Application: afterRenderModule mod_custom (Stitching Hope Info)

Time: 1.98 ms / 239.69 ms Memory: 0.026 MB / 18.66 MB Application: beforeRenderModule mod_custom (Stitching Hope Info)

Time: 0.19 ms / 239.87 ms Memory: 0.002 MB / 18.66 MB Application: afterRenderModule mod_custom (Stitching Hope Info)

Time: 1.90 ms / 241.77 ms Memory: 0.026 MB / 18.69 MB Application: beforeRenderModule mod_custom (Stitching Hope Info)

Time: 0.16 ms / 241.93 ms Memory: 0.002 MB / 18.69 MB Application: afterRenderModule mod_custom (Stitching Hope Info)

Time: 1.78 ms / 243.71 ms Memory: 0.026 MB / 18.72 MB Application: beforeRenderModule mod_custom (Stitching Hope Info)

Time: 0.20 ms / 243.91 ms Memory: 0.002 MB / 18.72 MB Application: afterRenderModule mod_custom (Stitching Hope Info)

Time: 162.21 ms / 406.12 ms Memory: 3.883 MB / 22.60 MB Application: afterRenderComponent com_j2store

Time: 0.48 ms / 406.61 ms Memory: 0.008 MB / 22.61 MB Application: afterDispatch

Time: 7.94 ms / 414.55 ms Memory: 1.593 MB / 24.20 MB Application: beforeRenderModule mod_custom (Social and Guidestar Badge)

Time: 0.25 ms / 414.80 ms Memory: 0.001 MB / 24.20 MB Application: afterRenderRawModule mod_custom (Social and Guidestar Badge)

Time: 0.01 ms / 414.81 ms Memory: 0.001 MB / 24.20 MB Application: beforeRenderModule mod_custom (Social and Guidestar Badge)

Time: 0.28 ms / 415.09 ms Memory: 0.002 MB / 24.21 MB Application: afterRenderModule mod_custom (Social and Guidestar Badge)

Time: 7.56 ms / 422.65 ms Memory: 0.035 MB / 24.24 MB Application: beforeRenderModule mod_custom (Footer Address)

Time: 0.24 ms / 422.89 ms Memory: 0.001 MB / 24.24 MB Application: afterRenderRawModule mod_custom (Footer Address)

Time: 0.01 ms / 422.90 ms Memory: 0.001 MB / 24.24 MB Application: beforeRenderModule mod_custom (Footer Address)

Time: 0.26 ms / 423.16 ms Memory: 0.002 MB / 24.24 MB Application: afterRenderModule mod_custom (Footer Address)

Time: 6.56 ms / 429.72 ms Memory: 0.034 MB / 24.28 MB Application: beforeRenderModule mod_custom (Footer donate)

Time: 0.25 ms / 429.97 ms Memory: 0.001 MB / 24.28 MB Application: afterRenderRawModule mod_custom (Footer donate)

Time: 0.01 ms / 429.98 ms Memory: 0.001 MB / 24.28 MB Application: beforeRenderModule mod_custom (Footer donate)

Time: 0.36 ms / 430.34 ms Memory: 0.002 MB / 24.28 MB Application: afterRenderModule mod_custom (Footer donate)

Time: 6.50 ms / 436.84 ms Memory: 0.039 MB / 24.32 MB Application: beforeRenderModule mod_custom (Upper Footer Text)

Time: 0.25 ms / 437.09 ms Memory: 0.001 MB / 24.32 MB Application: afterRenderRawModule mod_custom (Upper Footer Text)

Time: 0.01 ms / 437.10 ms Memory: 0.001 MB / 24.32 MB Application: beforeRenderModule mod_custom (Upper Footer Text)

Time: 0.28 ms / 437.38 ms Memory: 0.002 MB / 24.33 MB Application: afterRenderModule mod_custom (Upper Footer Text)

Time: 6.89 ms / 444.26 ms Memory: 0.035 MB / 24.36 MB Application: beforeRenderModule mod_custom (JustHope to Suspend Operations)

Time: 0.26 ms / 444.52 ms Memory: 0.001 MB / 24.36 MB Application: afterRenderRawModule mod_custom (JustHope to Suspend Operations)

Time: 0.01 ms / 444.53 ms Memory: 0.001 MB / 24.36 MB Application: beforeRenderModule mod_custom (JustHope to Suspend Operations)

Time: 0.25 ms / 444.78 ms Memory: 0.002 MB / 24.36 MB Application: afterRenderModule mod_custom (JustHope to Suspend Operations)

Time: 6.95 ms / 451.73 ms Memory: 0.040 MB / 24.40 MB Application: beforeRenderModule mod_menu (Navigation)

Time: 13.09 ms / 464.82 ms Memory: 0.355 MB / 24.76 MB Application: afterRenderRawModule mod_menu (Navigation)

Time: 0.02 ms / 464.85 ms Memory: -0.005 MB / 24.75 MB Application: beforeRenderModule mod_menu (Navigation)

Time: 0.30 ms / 465.15 ms Memory: 0.002 MB / 24.76 MB Application: afterRenderModule mod_menu (Navigation)

Time: 8.81 ms / 473.95 ms Memory: 0.042 MB / 24.80 MB Application: beforeRenderModule mod_menu (User Menu)

Time: 2.40 ms / 476.35 ms Memory: 0.021 MB / 24.82 MB Application: afterRenderRawModule mod_menu (User Menu)

Time: 0.01 ms / 476.37 ms Memory: -0.000 MB / 24.82 MB Application: beforeRenderModule mod_menu (User Menu)

Time: 0.28 ms / 476.65 ms Memory: 0.002 MB / 24.82 MB Application: afterRenderModule mod_menu (User Menu)

Time: 7.47 ms / 484.12 ms Memory: 0.033 MB / 24.85 MB Application: beforeRenderModule mod_custom (Social Buttons)

Time: 0.28 ms / 484.40 ms Memory: 0.001 MB / 24.85 MB Application: afterRenderRawModule mod_custom (Social Buttons)

Time: 0.01 ms / 484.42 ms Memory: 0.001 MB / 24.85 MB Application: beforeRenderModule mod_custom (Social Buttons)

Time: 0.33 ms / 484.75 ms Memory: 0.013 MB / 24.87 MB Application: afterRenderModule mod_custom (Social Buttons)

Time: 72.37 ms / 557.11 ms Memory: 0.001 MB / 24.87 MB Application: afterRender

Database queries total: 129.85 ms

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

#	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

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

#	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

EXPLAIN not possible on query: INSERT INTO `nkhd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6166356332376564383761323563643865356232353934303832643963656665', 1, 1674875357, 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: 0.44 ms After last query: 4.58 ms Query memory: 0.021 MB Memory before query: 4.812 MB Rows returned: 3

SELECT id, rules

  FROM `nkhd_viewlevels`

Explain

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

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: 0.44 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 4.823 MB Rows returned: 1

SELECT b.id

  FROM nkhd_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

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: 0.87 ms After last query: 32.71 ms Query memory: 0.031 MB Memory before query: 8.836 MB Rows returned: 94

Duplicate queries: #9 #13 #15 #19 #21 #129

SELECT *

  FROM nkhd_j2store_configurations

Explain

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

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: 6.21 ms After last query: 13.52 ms Query memory: 0.006 MB Memory before query: 10.546 MB

UPDATE `nkhd_extensions`

  SET `params` = '{\"mediaversion\":\"044a59ce23d1a824e581118d61dda218\"}'

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

Explain

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

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: 0.83 ms After last query: 22.44 ms Query memory: 0.021 MB Memory before query: 13.275 MB Rows returned: 1

SELECT template 
  FROM nkhd_template_styles 
  WHERE client_id = 0 
  AND home=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nkhd_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	16.67	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: 0.47 ms After last query: 26.16 ms Query memory: 0.031 MB Memory before query: 15.941 MB Rows returned: 94

Duplicate queries: #6 #13 #15 #19 #21 #129

SELECT *

  FROM nkhd_j2store_configurations

Explain

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

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/administrator/components/com_j2store/models/products.php:1034
10	J2StoreModelProducts->getMergedParams()	JROOT/components/com_j2store/controllers/products.php:38
9	J2StoreControllerProducts->browse()	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.08 ms After last query: 2.94 ms Query memory: 0.029 MB Memory before query: 16.095 MB Rows returned: 44

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

  FROM `nkhd_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_civicrm','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_easyfrontendseo','com_fields','com_finder','com_installer','com_j2store','com_jce','com_jch_optimize','com_joomlaupdate','com_jucontact','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nkhd_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	44	100.00	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:42
9	J2StoreControllerProducts->browse()	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: 6.53 ms After last query: 0.74 ms Query memory: 0.070 MB Memory before query: 16.197 MB Rows returned: 837

Duplicate queries: #22

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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
14	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
13	F0FDatabaseDriverJoomla->getTableList()	JROOT/administrator/components/com_j2store/models/products.php:2091
12	J2StoreModelProducts->checkTable()	JROOT/administrator/components/com_j2store/models/products.php:1291
11	J2StoreModelProducts->getSFQuery()	JROOT/administrator/components/com_j2store/models/products.php:1124
10	J2StoreModelProducts->getSFProducts()	JROOT/components/com_j2store/controllers/products.php:146
9	J2StoreControllerProducts->browse()	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: 0.88 ms After last query: 1.09 ms Query memory: 0.023 MB Memory before query: 16.257 MB Rows returned: 4

Duplicate queries: #14 #18

SELECT sub.id

  FROM nkhd_categories as sub

  INNER JOIN nkhd_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id IN ( 78 ) 
  AND sub.level <= (this.level + 3)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	sub	NULL	ALL	idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	69	5.96	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/f0f/database/driver/joomla.php:301
13	F0FDatabaseDriverJoomla->loadAssocList()	JROOT/administrator/components/com_j2store/models/products.php:1497
12	J2StoreModelProducts->_sfBuildWhereQuery()	JROOT/administrator/components/com_j2store/models/products.php:1331
11	J2StoreModelProducts->getSFQuery()	JROOT/administrator/components/com_j2store/models/products.php:1124
10	J2StoreModelProducts->getSFProducts()	JROOT/components/com_j2store/controllers/products.php:146
9	J2StoreControllerProducts->browse()	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: 0.28 ms After last query: 0.33 ms Query memory: 0.032 MB Memory before query: 16.285 MB Rows returned: 94

Duplicate queries: #6 #9 #15 #19 #21 #129

SELECT *

  FROM nkhd_j2store_configurations

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/models/products.php:1034
13	J2StoreModelProducts->getMergedParams()	JROOT/administrator/components/com_j2store/models/products.php:1713
12	J2StoreModelProducts->_sfBuildQueryOrderBy()	JROOT/administrator/components/com_j2store/models/products.php:1332
11	J2StoreModelProducts->getSFQuery()	JROOT/administrator/components/com_j2store/models/products.php:1124
10	J2StoreModelProducts->getSFProducts()	JROOT/components/com_j2store/controllers/products.php:146
9	J2StoreControllerProducts->browse()	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: 0.23 ms After last query: 0.32 ms Query memory: 0.024 MB Memory before query: 16.294 MB Rows returned: 4

Duplicate queries: #12 #18

SELECT sub.id

  FROM nkhd_categories as sub

  INNER JOIN nkhd_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id IN ( 78 ) 
  AND sub.level <= (this.level + 3)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	sub	NULL	ALL	idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	69	5.96	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/f0f/database/driver/joomla.php:301
15	F0FDatabaseDriverJoomla->loadAssocList()	JROOT/administrator/components/com_j2store/models/products.php:1497
14	J2StoreModelProducts->_sfBuildWhereQuery()	JROOT/administrator/components/com_j2store/models/products.php:1331
13	J2StoreModelProducts->getSFQuery()	JROOT/administrator/components/com_j2store/models/products.php:1188
12	J2StoreModelProducts->getSFPageTotal()	JROOT/administrator/components/com_j2store/models/products.php:1219
11	J2StoreModelProducts->getStart()	JROOT/administrator/components/com_j2store/models/products.php:1126
10	J2StoreModelProducts->getSFProducts()	JROOT/components/com_j2store/controllers/products.php:146
9	J2StoreControllerProducts->browse()	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: 0.20 ms After last query: 0.22 ms Query memory: 0.033 MB Memory before query: 16.322 MB Rows returned: 94

Duplicate queries: #6 #9 #13 #19 #21 #129

SELECT *

  FROM nkhd_j2store_configurations

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/models/products.php:1034
15	J2StoreModelProducts->getMergedParams()	JROOT/administrator/components/com_j2store/models/products.php:1713
14	J2StoreModelProducts->_sfBuildQueryOrderBy()	JROOT/administrator/components/com_j2store/models/products.php:1332
13	J2StoreModelProducts->getSFQuery()	JROOT/administrator/components/com_j2store/models/products.php:1188
12	J2StoreModelProducts->getSFPageTotal()	JROOT/administrator/components/com_j2store/models/products.php:1219
11	J2StoreModelProducts->getStart()	JROOT/administrator/components/com_j2store/models/products.php:1126
10	J2StoreModelProducts->getSFProducts()	JROOT/components/com_j2store/controllers/products.php:146
9	J2StoreControllerProducts->browse()	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: 13.88 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 16.316 MB Rows returned: 8

SELECT COUNT(*)

  FROM nkhd_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nkhd_categories AS cat JOIN nkhd_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  INNER JOIN nkhd_j2store_products 
  ON nkhd_j2store_products.product_source='com_content' 
  AND nkhd_j2store_products.product_source_id = a.id

  INNER JOIN nkhd_j2store_variants 
  ON nkhd_j2store_products.j2store_product_id=nkhd_j2store_variants.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_productimages 
  ON nkhd_j2store_products.j2store_product_id=nkhd_j2store_productimages.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_productquantities 
  ON nkhd_j2store_productquantities.variant_id = nkhd_j2store_variants.j2store_variant_id

  LEFT 
  OUTER JOIN nkhd_j2store_productprice_index 
  ON  nkhd_j2store_products.j2store_product_id=nkhd_j2store_productprice_index.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_product_filters 
  ON nkhd_j2store_products.j2store_product_id=nkhd_j2store_product_filters.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_manufacturers 
  ON nkhd_j2store_products.manufacturer_id=nkhd_j2store_manufacturers.j2store_manufacturer_id

  LEFT 
  OUTER JOIN nkhd_j2store_addresses 
  ON nkhd_j2store_manufacturers.address_id=nkhd_j2store_addresses.j2store_address_id

  WHERE 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = '1' 
  AND (a.catid  REGEXP BINARY '[[:<:]]78[[:>:]]' OR a.catid  REGEXP BINARY '[[:<:]]48[[:>:]]|[[:<:]]49[[:>:]]|[[:<:]]110[[:>:]]|[[:<:]]111[[:>:]]' ) 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-01-28 03:09:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-01-28 03:09:17') 
  AND `nkhd_j2store_variants`.`is_master` = '1' 
  AND `nkhd_j2store_products`.`visibility`='1' 
  AND `nkhd_j2store_products`.`enabled` IN (1)

  GROUP BY a.id,nkhd_j2store_products.j2store_product_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	nkhd_j2store_products	NULL	ALL	PRIMARY,catalogsource	NO INDEX KEY COULD BE USED	NULL	NULL	43	2.33	Using where; Using temporary; Using filesort
1	PRIMARY	nkhd_j2store_variants	NULL	ref	variant_product_id	variant_product_id	5	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	10.00	Using where
1	PRIMARY	nkhd_j2store_productimages	NULL	ref	productimage_product_id	productimage_product_id	5	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	100.00	Using index
1	PRIMARY	nkhd_j2store_productquantities	NULL	eq_ref	stock_variant_id	stock_variant_id	4	justhope_joomla.nkhd_j2store_variants.j2store_variant_id	1	100.00	Using index
1	PRIMARY	nkhd_j2store_productprice_index	NULL	eq_ref	PRIMARY,product_id	PRIMARY	4	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	100.00	Using index
1	PRIMARY	nkhd_j2store_product_filters	NULL	ref	PRIMARY	PRIMARY	4	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	100.00	Using index
1	PRIMARY	nkhd_j2store_manufacturers	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.nkhd_j2store_products.manufacturer_id	1	100.00	NULL
1	PRIMARY	nkhd_j2store_addresses	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.nkhd_j2store_manufacturers.address_id	1	100.00	Using index
1	PRIMARY	a	NULL	eq_ref	PRIMARY,idx_access,idx_catid	PRIMARY	4	justhope_joomla.nkhd_j2store_products.product_source_id	1	16.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	justhope_joomla.a.catid	1	98.55	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.c.parent_id	1	100.00	Using where; Using index
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.a.id	1	100.00	Using where; Using index
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	justhope_joomla.c.id	5	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	7	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	69	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/f0f/database/driver/joomla.php:129
13	F0FDatabaseDriverJoomla->execute()	JROOT/administrator/components/com_j2store/models/products.php:1204
12	J2StoreModelProducts->getSFPageTotal()	JROOT/administrator/components/com_j2store/models/products.php:1219
11	J2StoreModelProducts->getStart()	JROOT/administrator/components/com_j2store/models/products.php:1126
10	J2StoreModelProducts->getSFProducts()	JROOT/components/com_j2store/controllers/products.php:146
9	J2StoreControllerProducts->browse()	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.60 ms After last query: 0.12 ms Query memory: 0.067 MB Memory before query: 16.312 MB Rows returned: 8

SELECT a.id, a.title, a.title as product_name, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published,nkhd_j2store_products.*,nkhd_j2store_variants.price,nkhd_j2store_variants.sku,nkhd_j2store_variants.upc,nkhd_j2store_variants.manage_stock,nkhd_j2store_variants.availability,nkhd_j2store_productimages.thumb_image, nkhd_j2store_productimages.main_image, nkhd_j2store_productimages.additional_images,nkhd_j2store_productimages.thumb_image_alt,nkhd_j2store_productimages.main_image_alt,nkhd_j2store_productimages.additional_images_alt,`nkhd_j2store_productquantities`.j2store_productquantity_id ,`nkhd_j2store_productquantities`.quantity,
  CASE 
							WHEN nkhd_j2store_products.product_type IN ("variable","flexivariable","advancedvariable","variablesubscriptionproduct") THEN
							  nkhd_j2store_productprice_index.min_price
							ELSE
								nkhd_j2store_variants.price
							END as min_price
				,
  CASE 
							WHEN nkhd_j2store_products.product_type IN ("variable","flexivariable","advancedvariable","variablesubscriptionproduct") THEN
							  nkhd_j2store_productprice_index.max_price
							ELSE
								nkhd_j2store_variants.price
							END as max_price
				,nkhd_j2store_product_filters.filter_id,nkhd_j2store_addresses.company as brand_name

  FROM nkhd_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nkhd_categories AS cat JOIN nkhd_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  INNER JOIN nkhd_j2store_products 
  ON nkhd_j2store_products.product_source='com_content' 
  AND nkhd_j2store_products.product_source_id = a.id

  INNER JOIN nkhd_j2store_variants 
  ON nkhd_j2store_products.j2store_product_id=nkhd_j2store_variants.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_productimages 
  ON nkhd_j2store_products.j2store_product_id=nkhd_j2store_productimages.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_productquantities 
  ON nkhd_j2store_productquantities.variant_id = nkhd_j2store_variants.j2store_variant_id

  LEFT 
  OUTER JOIN nkhd_j2store_productprice_index 
  ON  nkhd_j2store_products.j2store_product_id=nkhd_j2store_productprice_index.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_product_filters 
  ON nkhd_j2store_products.j2store_product_id=nkhd_j2store_product_filters.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_manufacturers 
  ON nkhd_j2store_products.manufacturer_id=nkhd_j2store_manufacturers.j2store_manufacturer_id

  LEFT 
  OUTER JOIN nkhd_j2store_addresses 
  ON nkhd_j2store_manufacturers.address_id=nkhd_j2store_addresses.j2store_address_id

  WHERE 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = '1' 
  AND (a.catid  REGEXP BINARY '[[:<:]]78[[:>:]]' OR a.catid  REGEXP BINARY '[[:<:]]48[[:>:]]|[[:<:]]49[[:>:]]|[[:<:]]110[[:>:]]|[[:<:]]111[[:>:]]' ) 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-01-28 03:09:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-01-28 03:09:17') 
  AND `nkhd_j2store_variants`.`is_master` = '1' 
  AND `nkhd_j2store_products`.`visibility`='1' 
  AND `nkhd_j2store_products`.`enabled` IN (1)

  GROUP BY a.id,nkhd_j2store_products.j2store_product_id

  ORDER BY  a.created  DESC 
  LIMIT 0, 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	nkhd_j2store_products	NULL	ALL	PRIMARY,catalogsource	NO INDEX KEY COULD BE USED	NULL	NULL	43	2.33	Using where; Using temporary; Using filesort
1	PRIMARY	nkhd_j2store_variants	NULL	ref	variant_product_id	variant_product_id	5	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	10.00	Using where
1	PRIMARY	nkhd_j2store_productimages	NULL	ref	productimage_product_id	productimage_product_id	5	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	100.00	NULL
1	PRIMARY	nkhd_j2store_productquantities	NULL	eq_ref	stock_variant_id	stock_variant_id	4	justhope_joomla.nkhd_j2store_variants.j2store_variant_id	1	100.00	NULL
1	PRIMARY	nkhd_j2store_productprice_index	NULL	eq_ref	PRIMARY,product_id	PRIMARY	4	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	100.00	NULL
1	PRIMARY	nkhd_j2store_product_filters	NULL	ref	PRIMARY	PRIMARY	4	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	100.00	Using index
1	PRIMARY	nkhd_j2store_manufacturers	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.nkhd_j2store_products.manufacturer_id	1	100.00	NULL
1	PRIMARY	nkhd_j2store_addresses	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.nkhd_j2store_manufacturers.address_id	1	100.00	NULL
1	PRIMARY	a	NULL	eq_ref	PRIMARY,idx_access,idx_catid	PRIMARY	4	justhope_joomla.nkhd_j2store_products.product_source_id	1	16.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	justhope_joomla.a.catid	1	98.55	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.c.parent_id	1	100.00	Using where
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.a.id	1	100.00	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	justhope_joomla.c.id	5	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	7	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	69	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

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/libraries/f0f/database/driver/joomla.php:321
12	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/administrator/components/com_j2store/models/products.php:1153
11	J2StoreModelProducts->_getSFList()	JROOT/administrator/components/com_j2store/models/products.php:1126
10	J2StoreModelProducts->getSFProducts()	JROOT/components/com_j2store/controllers/products.php:146
9	J2StoreControllerProducts->browse()	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: 0.28 ms After last query: 0.33 ms Query memory: 0.023 MB Memory before query: 16.407 MB Rows returned: 4

Duplicate queries: #12 #14

SELECT sub.id

  FROM nkhd_categories as sub

  INNER JOIN nkhd_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id IN ( 78 ) 
  AND sub.level <= (this.level + 3)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	sub	NULL	ALL	idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	69	5.96	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/f0f/database/driver/joomla.php:301
13	F0FDatabaseDriverJoomla->loadAssocList()	JROOT/administrator/components/com_j2store/models/products.php:1497
12	J2StoreModelProducts->_sfBuildWhereQuery()	JROOT/administrator/components/com_j2store/models/products.php:1331
11	J2StoreModelProducts->getSFQuery()	JROOT/administrator/components/com_j2store/models/products.php:1133
10	J2StoreModelProducts->getSFAllProducts()	JROOT/components/com_j2store/controllers/products.php:148
9	J2StoreControllerProducts->browse()	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: 0.23 ms After last query: 0.29 ms Query memory: 0.032 MB Memory before query: 16.434 MB Rows returned: 94

Duplicate queries: #6 #9 #13 #15 #21 #129

SELECT *

  FROM nkhd_j2store_configurations

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/models/products.php:1034
13	J2StoreModelProducts->getMergedParams()	JROOT/administrator/components/com_j2store/models/products.php:1713
12	J2StoreModelProducts->_sfBuildQueryOrderBy()	JROOT/administrator/components/com_j2store/models/products.php:1332
11	J2StoreModelProducts->getSFQuery()	JROOT/administrator/components/com_j2store/models/products.php:1133
10	J2StoreModelProducts->getSFAllProducts()	JROOT/components/com_j2store/controllers/products.php:148
9	J2StoreControllerProducts->browse()	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.67 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 16.420 MB Rows returned: 8

SELECT nkhd_j2store_products.j2store_product_id

  FROM nkhd_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nkhd_categories AS cat JOIN nkhd_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  INNER JOIN nkhd_j2store_products 
  ON nkhd_j2store_products.product_source='com_content' 
  AND nkhd_j2store_products.product_source_id = a.id

  INNER JOIN nkhd_j2store_variants 
  ON nkhd_j2store_products.j2store_product_id=nkhd_j2store_variants.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_productimages 
  ON nkhd_j2store_products.j2store_product_id=nkhd_j2store_productimages.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_productquantities 
  ON nkhd_j2store_productquantities.variant_id = nkhd_j2store_variants.j2store_variant_id

  LEFT 
  OUTER JOIN nkhd_j2store_productprice_index 
  ON  nkhd_j2store_products.j2store_product_id=nkhd_j2store_productprice_index.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_product_filters 
  ON nkhd_j2store_products.j2store_product_id=nkhd_j2store_product_filters.product_id

  LEFT 
  OUTER JOIN nkhd_j2store_manufacturers 
  ON nkhd_j2store_products.manufacturer_id=nkhd_j2store_manufacturers.j2store_manufacturer_id

  LEFT 
  OUTER JOIN nkhd_j2store_addresses 
  ON nkhd_j2store_manufacturers.address_id=nkhd_j2store_addresses.j2store_address_id

  WHERE 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = '1' 
  AND (a.catid  REGEXP BINARY '[[:<:]]78[[:>:]]' OR a.catid  REGEXP BINARY '[[:<:]]48[[:>:]]|[[:<:]]49[[:>:]]|[[:<:]]110[[:>:]]|[[:<:]]111[[:>:]]' ) 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-01-28 03:09:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-01-28 03:09:17') 
  AND `nkhd_j2store_variants`.`is_master` = '1' 
  AND `nkhd_j2store_products`.`visibility`='1' 
  AND `nkhd_j2store_products`.`enabled` IN (1)

  GROUP BY a.id,nkhd_j2store_products.j2store_product_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	nkhd_j2store_products	NULL	ALL	PRIMARY,catalogsource	NO INDEX KEY COULD BE USED	NULL	NULL	43	2.33	Using where; Using temporary; Using filesort
1	PRIMARY	nkhd_j2store_variants	NULL	ref	variant_product_id	variant_product_id	5	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	10.00	Using where
1	PRIMARY	nkhd_j2store_productimages	NULL	ref	productimage_product_id	productimage_product_id	5	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	100.00	Using index
1	PRIMARY	nkhd_j2store_productquantities	NULL	eq_ref	stock_variant_id	stock_variant_id	4	justhope_joomla.nkhd_j2store_variants.j2store_variant_id	1	100.00	Using index
1	PRIMARY	nkhd_j2store_productprice_index	NULL	eq_ref	PRIMARY,product_id	PRIMARY	4	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	100.00	Using index
1	PRIMARY	nkhd_j2store_product_filters	NULL	ref	PRIMARY	PRIMARY	4	justhope_joomla.nkhd_j2store_products.j2store_product_id	1	100.00	Using index
1	PRIMARY	nkhd_j2store_manufacturers	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.nkhd_j2store_products.manufacturer_id	1	100.00	NULL
1	PRIMARY	nkhd_j2store_addresses	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.nkhd_j2store_manufacturers.address_id	1	100.00	Using index
1	PRIMARY	a	NULL	eq_ref	PRIMARY,idx_access,idx_catid	PRIMARY	4	justhope_joomla.nkhd_j2store_products.product_source_id	1	16.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	justhope_joomla.a.catid	1	98.55	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.c.parent_id	1	100.00	Using where; Using index
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.a.id	1	100.00	Using where; Using index
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	justhope_joomla.c.id	5	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	7	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	69	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

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/libraries/f0f/database/driver/joomla.php:321
12	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/administrator/components/com_j2store/models/products.php:1153
11	J2StoreModelProducts->_getSFList()	JROOT/administrator/components/com_j2store/models/products.php:1135
10	J2StoreModelProducts->getSFAllProducts()	JROOT/components/com_j2store/controllers/products.php:148
9	J2StoreControllerProducts->browse()	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: 0.23 ms After last query: 0.46 ms Query memory: 0.031 MB Memory before query: 16.455 MB Rows returned: 94

Duplicate queries: #6 #9 #13 #15 #19 #129

SELECT *

  FROM nkhd_j2store_configurations

Explain

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

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:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/models/products.php:1034
11	J2StoreModelProducts->getMergedParams()	JROOT/components/com_j2store/controllers/products.php:494
10	J2StoreControllerProducts->getFilters()	JROOT/components/com_j2store/controllers/products.php:151
9	J2StoreControllerProducts->browse()	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: 6.40 ms After last query: 1.63 ms Query memory: 0.071 MB Memory before query: 16.528 MB Rows returned: 837

Duplicate queries: #11

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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
17	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
16	F0FDatabaseDriverJoomla->getTableList()	JROOT/libraries/f0f/table/table.php:2082
15	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
14	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/productfilter.php:16
13	J2StoreTableProductFilter->__construct()	JROOT/libraries/f0f/table/table.php:433
12	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/models/products.php:1099
11	J2StoreModelProducts->getProductFilters()	JROOT/components/com_j2store/controllers/products.php:520
10	J2StoreControllerProducts->getFilters()	JROOT/components/com_j2store/controllers/products.php:151
9	J2StoreControllerProducts->browse()	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: 0.69 ms After last query: 0.25 ms Query memory: 0.025 MB Memory before query: 16.616 MB Rows returned: 2

SHOW FULL COLUMNS 
  FROM `nkhd_j2store_product_filters`

Explain

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

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:536
14	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/productfilter.php:16
13	J2StoreTableProductFilter->__construct()	JROOT/libraries/f0f/table/table.php:433
12	F0FTable::getAnInstance()	JROOT/administrator/components/com_j2store/models/products.php:1099
11	J2StoreModelProducts->getProductFilters()	JROOT/components/com_j2store/controllers/products.php:520
10	J2StoreControllerProducts->getFilters()	JROOT/components/com_j2store/controllers/products.php:151
9	J2StoreControllerProducts->browse()	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.26 ms After last query: 0.77 ms Query memory: 0.023 MB Memory before query: 16.678 MB Rows returned: 0

SELECT pf.*,f.filter_name, f.group_id,fg.group_name

  FROM nkhd_j2store_product_filters AS pf

  LEFT JOIN nkhd_j2store_filters as f 
  ON f.j2store_filter_id = pf.filter_id

  LEFT JOIN nkhd_j2store_filtergroups as fg 
  ON fg.j2store_filtergroup_id=f.group_id

  WHERE product_id IN (1,2,3,4,5,6,7,39) 
  AND fg.enabled = 1

  GROUP BY pf.filter_id

  ORDER BY fg.ordering ASC,f.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pf	NULL	index	PRIMARY	PRIMARY	8	NULL	1	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	f	NULL	eq_ref	PRIMARY,group_id	PRIMARY	4	justhope_joomla.pf.filter_id	1	100.00	NULL
1	SIMPLE	fg	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.f.group_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
13	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/administrator/components/com_j2store/tables/productfilter.php:130
12	J2StoreTableProductFilter->getFiltersByProduct()	JROOT/administrator/components/com_j2store/models/products.php:1099
11	J2StoreModelProducts->getProductFilters()	JROOT/components/com_j2store/controllers/products.php:520
10	J2StoreControllerProducts->getFilters()	JROOT/components/com_j2store/controllers/products.php:151
9	J2StoreControllerProducts->browse()	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.05 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 16.686 MB Rows returned: 2

SELECT p.*,m.*,a.*

  FROM nkhd_j2store_products AS p

  LEFT JOIN nkhd_j2store_manufacturers as m 
  ON m.j2store_manufacturer_id =p.manufacturer_id

  LEFT JOIN nkhd_j2store_addresses as a 
  ON a.j2store_address_id=m.address_id

  WHERE p.j2store_product_id IN (1,2,3,4,5,6,7,39) 
  AND p.manufacturer_id=m.j2store_manufacturer_id

  GROUP BY p.manufacturer_id

  ORDER BY m.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	NULL	range	PRIMARY	PRIMARY	4	NULL	8	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	m	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	3	33.33	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.m.address_id	1	100.00	NULL

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/libraries/f0f/database/driver/joomla.php:321
12	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/administrator/components/com_j2store/models/products.php:2026
11	J2StoreModelProducts->getManfucaturersByProduct()	JROOT/components/com_j2store/controllers/products.php:529
10	J2StoreControllerProducts->getFilters()	JROOT/components/com_j2store/controllers/products.php:151
9	J2StoreControllerProducts->browse()	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.73 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 16.699 MB Rows returned: 0

SELECT p.*,v.*,a.*

  FROM nkhd_j2store_products AS p

  LEFT JOIN nkhd_j2store_vendors as v 
  ON v.j2store_vendor_id =p.vendor_id

  LEFT JOIN nkhd_j2store_addresses as a 
  ON a.j2store_address_id=v.address_id

  WHERE p.j2store_product_id IN (1,2,3,4,5,6,7,39) 
  AND p.vendor_id=v.j2store_vendor_id

  GROUP BY p.vendor_id

  ORDER BY v.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using temporary; Using filesort
1	SIMPLE	p	NULL	range	PRIMARY	PRIMARY	4	NULL	8	10.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	justhope_joomla.v.address_id	1	100.00	NULL

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/libraries/f0f/database/driver/joomla.php:321
12	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/administrator/components/com_j2store/models/products.php:2071
11	J2StoreModelProducts->getVendorsByProduct()	JROOT/components/com_j2store/controllers/products.php:537
10	J2StoreControllerProducts->getFilters()	JROOT/components/com_j2store/controllers/products.php:151
9	J2StoreControllerProducts->browse()	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: 0.60 ms After last query: 7.67 ms Query memory: 0.029 MB Memory before query: 17.488 MB Rows returned: 6

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 `nkhd_categories` AS `s`

  INNER JOIN `nkhd_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) 
  AND c.published = 1 
  AND s.id = 78

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:1917
10	J2StoreModelProducts->executePlugins()	JROOT/components/com_j2store/controllers/products.php:155
9	J2StoreControllerProducts->browse()	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.61 ms After last query: 0.41 ms Query memory: 0.025 MB Memory before query: 17.550 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM nkhd_fields AS a

  LEFT JOIN `nkhd_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN nkhd_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN nkhd_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN nkhd_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN nkhd_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `nkhd_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.category.productlist' 
  AND (fc.category_id IS NULL OR fc.category_id IN (78,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

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/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:1917
10	J2StoreModelProducts->executePlugins()	JROOT/components/com_j2store/controllers/products.php:155
9	J2StoreControllerProducts->browse()	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: 0.93 ms After last query: 4.32 ms Query memory: 0.025 MB Memory before query: 17.956 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM nkhd_fields AS a

  LEFT JOIN `nkhd_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN nkhd_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN nkhd_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN nkhd_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN nkhd_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `nkhd_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.category.productlist' 
  AND (fc.category_id IS NULL OR fc.category_id IN (111,0,110,78)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

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/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:1917
10	J2StoreModelProducts->executePlugins()	JROOT/components/com_j2store/controllers/products.php:155
9	J2StoreControllerProducts->browse()	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: 0.71 ms After last query: 1.39 ms Query memory: 0.027 MB Memory before query: 18.062 MB Rows returned: 1

Duplicate queries: #33 #35 #37 #39 #41 #43

SELECT m.*

  FROM nkhd_modules AS m

  LEFT JOIN nkhd_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.client_id = 0 
  AND m.title = 'Store Sharing Buttons' 
  AND m.access IN (1,1) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	146	0.68	Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	justhope_joomla.m.module,const	1	10.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:290
23	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:492
22	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:444
21	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:628
20	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:610
19	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:67
18	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:78
17	PlgSystemModulesAnywhere->processArticle()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:331
15	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:290
14	RegularLabs\Library\Article::process()	JROOT/libraries/regularlabs/src/SystemPlugin.php:230
13	RegularLabs\Library\SystemPlugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:1917
10	J2StoreModelProducts->executePlugins()	JROOT/components/com_j2store/controllers/products.php:155
9	J2StoreControllerProducts->browse()	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

Sidebar

Navigation

JustHope to Suspend Operations

Amalgama: In Concert (CD)

Stole: Stubborn Hope

Stole: Dreaming a Whole World

Stole: Kin-dom of God

Stole: Advent Stardust

Stole: Acompañamiento

Stole: Gift of Life

Stole: The Spirit's Anointing

Filter by Brands

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

166 Queries Logged 129.85 ms

82 duplicate found!