Cahaya Musik

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1696367081,
                "last": 1696367081,
                "now": 1696367081
            },
            "token": "pYDQ2EPSPYW5XwXO1LM1tUMXusM99bBY"
        },
        "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": "IDR",
        "old_sessionid": "0e8fe16c3d2fca6c4b0f8cb6268ba7e4",
        "cart_id": {
            "wishlist": 383040
        }
    }
}

Profile Information

Time

Memory

Time: 9.06 ms / 9.06 ms Memory: 2.027 MB / 2.40 MB Application: afterLoad

Time: 52.21 ms / 61.28 ms Memory: 7.578 MB / 9.98 MB Application: afterInitialise

Time: 13.23 ms / 74.50 ms Memory: 1.622 MB / 11.60 MB Application: afterRoute

Time: 0.44 ms / 74.95 ms Memory: 0.026 MB / 11.63 MB Application: beforeRenderComponent com_quix

Time: 4.76 ms / 79.70 ms Memory: 0.527 MB / 12.16 MB Application: Before Access::preloadComponents (all components)

Time: 0.59 ms / 80.29 ms Memory: 0.061 MB / 12.22 MB Application: After Access::preloadComponents (all components)

Time: 0.01 ms / 80.31 ms Memory: -0.005 MB / 12.21 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.24 ms / 80.54 ms Memory: 0.026 MB / 12.24 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 2.16 ms / 82.70 ms Memory: 0.004 MB / 12.24 MB Application: Before QuixRenderItem

Time: 4.02 ms / 86.72 ms Memory: 0.878 MB / 13.12 MB Application: Before Access::getAssetRules (id:55 name:com_quix)

Time: 0.01 ms / 86.73 ms Memory: 0.002 MB / 13.12 MB Application: After Access::getAssetRules (id:55 name:com_quix)

Time: 0.83 ms / 87.56 ms Memory: 0.075 MB / 13.20 MB Application: Before loading assets (classic)

Time: 18.32 ms / 105.88 ms Memory: 7.404 MB / 20.60 MB Application: After loading assets (classic)

Time: 0.01 ms / 105.89 ms Memory: 0.001 MB / 20.60 MB Application: Before making view (classic)

Time: 1.79 ms / 107.69 ms Memory: 0.257 MB / 20.86 MB Application: beforeRenderModule mod_slideshowck (Slideshow CK)

Time: 3.35 ms / 111.04 ms Memory: 0.620 MB / 21.48 MB Application: afterRenderModule mod_slideshowck (Slideshow CK)

Time: 77.26 ms / 188.30 ms Memory: 6.621 MB / 28.10 MB Application: After making view (classic)

Time: 0.05 ms / 188.35 ms Memory: -0.001 MB / 28.10 MB Application: After QuixRenderItem

Time: 0.73 ms / 189.08 ms Memory: 0.178 MB / 28.28 MB Application: afterRenderComponent com_quix

Time: 0.20 ms / 189.28 ms Memory: 0.006 MB / 28.28 MB Application: afterDispatch

Time: 2.92 ms / 192.20 ms Memory: 0.349 MB / 28.63 MB Application: beforeRenderModule mod_custom (Footer)

Time: 6.84 ms / 199.04 ms Memory: 1.286 MB / 29.92 MB Application: Before QuixRenderItem

Time: 0.47 ms / 199.51 ms Memory: 0.102 MB / 30.02 MB Application: Before loading assets (classic)

Time: 1.58 ms / 201.09 ms Memory: 0.015 MB / 30.04 MB Application: After loading assets (classic)

Time: 0.01 ms / 201.10 ms Memory: 0.001 MB / 30.04 MB Application: Before making view (classic)

Time: 1.10 ms / 202.20 ms Memory: 0.007 MB / 30.04 MB Application: After making view (classic)

Time: 0.04 ms / 202.24 ms Memory: -0.007 MB / 30.04 MB Application: After QuixRenderItem

Time: 0.66 ms / 202.90 ms Memory: 0.023 MB / 30.06 MB Application: Before QuixRenderItem

Time: 0.49 ms / 203.39 ms Memory: 0.161 MB / 30.22 MB Application: Before loading assets (classic)

Time: 2.12 ms / 205.51 ms Memory: 0.016 MB / 30.24 MB Application: After loading assets (classic)

Time: 0.01 ms / 205.52 ms Memory: 0.001 MB / 30.24 MB Application: Before making view (classic)

Time: 1.46 ms / 206.98 ms Memory: 0.004 MB / 30.24 MB Application: After making view (classic)

Time: 0.04 ms / 207.02 ms Memory: -0.005 MB / 30.24 MB Application: After QuixRenderItem

Time: 0.53 ms / 207.55 ms Memory: -0.340 MB / 29.90 MB Application: afterRenderModule mod_custom (Footer)

Time: 2.32 ms / 209.86 ms Memory: 0.268 MB / 30.16 MB Application: Quix Loading Assets onBeforeCompileHeadLoadQuixAssets

Time: 1.69 ms / 211.56 ms Memory: 0.316 MB / 30.48 MB Application: afterRender

Database queries total: 51.56 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fkumx_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	fkumx_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 `fkumx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3065386665313663336432666361366334623066386362363236386261376534', 1, 1696367081, 0, '', 0)

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
update	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	7.32 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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.32 ms After last query: 1.32 ms Query memory: 0.025 MB Memory before query: 4.462 MB Rows returned: 43

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

  FROM `fkumx_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fkumx_extensions	NULL	ref	extension	extension	82	const	43	1.00	Using where

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.11 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.16 ms After last query: 1.34 ms Query memory: 0.021 MB Memory before query: 4.718 MB Rows returned: 5

SELECT id, rules

  FROM `fkumx_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.20 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.730 MB Rows returned: 2

SELECT b.id

  FROM fkumx_usergroups AS a

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

  WHERE a.id = 9

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	2	100.00	Using where; Using index

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.60 ms After last query: 0.34 ms Query memory: 0.035 MB Memory before query: 4.798 MB Rows returned: 131

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

  FROM fkumx_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fkumx_extensions	NULL	ref	extension	extension	82	const	226	0.60	Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.38 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php: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.61 ms After last query: 18.37 ms Query memory: 0.028 MB Memory before query: 8.470 MB Rows returned: 18

Duplicate queries: #65

SHOW FULL COLUMNS 
  FROM `fkumx_extensions`

Explain

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

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.51 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.35 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.04 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
13	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:181
11	qxGetComponentInfo()	JROOT/libraries/quix/app/bootstrap.php:44
10	include_once JROOT/libraries/quix/app/bootstrap.php	JROOT/libraries/loader.php:226
9	JLoader::import()	JROOT/libraries/loader.php:845
8	jimport()	JROOT/plugins/system/quix/quix.php:15
7	require_once JROOT/plugins/system/quix/quix.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
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: 0.18 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 8.516 MB Rows returned: 1

SELECT `extension_id`

  FROM `fkumx_extensions`

  WHERE element = 'com_quix'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fkumx_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
12	Joomla\CMS\Table\Extension->find()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:182
11	qxGetComponentInfo()	JROOT/libraries/quix/app/bootstrap.php:44
10	include_once JROOT/libraries/quix/app/bootstrap.php	JROOT/libraries/loader.php:226
9	JLoader::import()	JROOT/libraries/loader.php:845
8	jimport()	JROOT/plugins/system/quix/quix.php:15
7	require_once JROOT/plugins/system/quix/quix.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
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: 0.14 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 8.525 MB Rows returned: 1

SELECT *

  FROM fkumx_extensions

  WHERE `extension_id` = '10006'

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
12	Joomla\CMS\Table\Table->load()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:183
11	qxGetComponentInfo()	JROOT/libraries/quix/app/bootstrap.php:44
10	include_once JROOT/libraries/quix/app/bootstrap.php	JROOT/libraries/loader.php:226
9	JLoader::import()	JROOT/libraries/loader.php:845
8	jimport()	JROOT/plugins/system/quix/quix.php:15
7	require_once JROOT/plugins/system/quix/quix.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
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: 0.16 ms After last query: 0.35 ms Query memory: 0.022 MB Memory before query: 8.571 MB Rows returned: 1

SELECT template 
  FROM fkumx_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	fkumx_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	16.67	Using where

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:139
11	quix_default_template()	JROOT/libraries/quix/app/bootstrap.php:63
10	include_once JROOT/libraries/quix/app/bootstrap.php	JROOT/libraries/loader.php:226
9	JLoader::import()	JROOT/libraries/loader.php:845
8	jimport()	JROOT/plugins/system/quix/quix.php:15
7	require_once JROOT/plugins/system/quix/quix.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
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: 0.20 ms After last query: 6.21 ms Query memory: 0.031 MB Memory before query: 9.721 MB Rows returned: 102

Duplicate queries: #26 #54 #60

SELECT *

  FROM fkumx_j2store_configurations

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_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:165
9	plgSystemJ2Store->onJ2StoreCronTask()	JROOT/plugins/system/j2store/j2store.php:145
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: 0.62 ms After last query: 2.55 ms Query memory: 0.103 MB Memory before query: 10.231 MB Rows returned: 49

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

  LEFT JOIN fkumx_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	188	7.93	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	cahayamu_j308182020.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.33 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php: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: 0.27 ms After last query: 5.28 ms Query memory: 0.024 MB Memory before query: 11.174 MB Rows returned: 1

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

  FROM `fkumx_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fkumx_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

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: 2.00 ms After last query: 0.09 ms Query memory: 0.006 MB Memory before query: 11.167 MB

UPDATE `fkumx_extensions`

  SET `params` = '{\"mediaversion\":\"6327b39d3c6e7333b073fda927c63be3\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `fkumx_extensions` SET `params` = '{\"mediaversion\":\"6327b39d3c6e7333b073fda927c63be3\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.03 ms
updating	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	1.78 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

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.31 ms After last query: 1.37 ms Query memory: 0.021 MB Memory before query: 11.404 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM fkumx_template_styles as s

  LEFT JOIN fkumx_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	cahayamu_j308182020.e.element	1	83.33	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
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: 0.33 ms After last query: 1.79 ms Query memory: 0.021 MB Memory before query: 11.598 MB Rows returned: 0

SELECT *

  FROM fkumx_quix_conditions

  WHERE item_type = "article" 
  AND component = "com_content" 
  AND condition_type = "article"

Explain

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

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/components/com_quix/helpers/theme.php:167
9	QuixHelperTheme::getAllTypesMatch()	JROOT/plugins/system/quix/quix.php:67
8	plgSystemQuix->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.18 ms After last query: 0.13 ms Query memory: 0.019 MB Memory before query: 11.607 MB Rows returned: 1

SELECT *

  FROM fkumx_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

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: 1.54 ms After last query: 2.92 ms Query memory: 0.029 MB Memory before query: 12.084 MB Rows returned: 22

SHOW FULL COLUMNS 
  FROM `fkumx_quix`

Explain

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

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.50 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.31 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.06 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.03 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_quix/tables/page.php:28
15	QuixTablePage->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_quix/models/page.php:128
13	QuixModelPage->getTable()	JROOT/components/com_quix/models/page.php:66
12	QuixModelPage->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:44
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.10 ms Query memory: 0.078 MB Memory before query: 12.121 MB Rows returned: 1

SELECT *

  FROM fkumx_quix

  WHERE `id` = '86'

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_quix/models/page.php:69
12	QuixModelPage->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:44
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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: 0.17 ms Query memory: 0.028 MB Memory before query: 12.161 MB Rows returned: 43

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

  FROM `fkumx_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_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_hikashop','com_installer','com_j2store','com_jce','com_jmedia','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_quix','com_redirect','com_search','com_slideshowck','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fkumx_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	44	100.00	Using index condition

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.22 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/components/com_quix/models/page.php:75
12	QuixModelPage->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:44
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.06 ms After last query: 0.39 ms Query memory: 0.006 MB Memory before query: 12.240 MB

UPDATE fkumx_quix

  SET `hits` = (`hits` + 1)

  WHERE `id` = '86'

Explain

EXPLAIN not possible on query: UPDATE fkumx_quix SET `hits` = (`hits` + 1) WHERE `id` = '86'

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.02 ms
updating	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	1.87 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_quix/models/page.php:292
12	QuixModelPage->getHit()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:68
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.39 ms After last query: 4.09 ms Query memory: 0.022 MB Memory before query: 13.125 MB Rows returned: 0

Duplicate queries: #88 #91

SELECT c.id AS id, a.name AS asset_name

  FROM (
SELECT id,asset_id

  FROM fkumx_categories

  WHERE extension = 'com_quix' 
  AND published = 1) AS c

  INNER JOIN fkumx_assets AS a 
  ON c.asset_id = a.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fkumx_categories	NULL	ref	cat_idx	cat_idx	203	const,const	1	100.00	NULL
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	cahayamu_j308182020.fkumx_categories.asset_id	1	100.00	NULL

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/User/User.php:428
12	Joomla\CMS\User\User->getAuthorisedCategories()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:86
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.36 ms After last query: 19.62 ms Query memory: 0.037 MB Memory before query: 20.728 MB Rows returned: 1

SELECT *

  FROM fkumx_modules

  WHERE published = 1 
  AND id = 146

Explain

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

Profile

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
46	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
45	JDatabaseDriver->loadObject()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:20
44	qxModuleById()	JROOT/libraries/quix/app/elements/joomla-module/view.php:16
43	include JROOT/libraries/quix/app/elements/joomla-module/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.32 ms After last query: 15.22 ms Query memory: 0.038 MB Memory before query: 23.721 MB Rows returned: 1

SELECT template 
  FROM fkumx_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	fkumx_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	16.67	Using where

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
47	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_j2store/helpers/strapper.php:169
46	J2StoreStrapper::getDefaultTemplate()	JROOT/administrator/components/com_j2store/helpers/strapper.php:137
45	J2StoreStrapper::addCSS()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:21
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.30 ms After last query: 6.80 ms Query memory: 0.047 MB Memory before query: 24.709 MB Rows returned: 102

Duplicate queries: #12 #54 #60

SELECT *

  FROM fkumx_j2store_configurations

Explain

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

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.08 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
47	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/models/products.php:1034
46	J2StoreModelProducts->getMergedParams()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:38
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.65 ms After last query: 0.50 ms Query memory: 0.043 MB Memory before query: 24.782 MB Rows returned: 6

SELECT fkumx_j2store_products.*,fkumx_j2store_variants.sku,fkumx_j2store_variants.upc,fkumx_j2store_variants.price,fkumx_j2store_variants.shipping,fkumx_j2store_variants.manage_stock,fkumx_j2store_variants.availability,fkumx_j2store_productimages.thumb_image, fkumx_j2store_productimages.main_image, fkumx_j2store_productimages.additional_images,fkumx_j2store_productimages.thumb_image_alt,fkumx_j2store_productimages.main_image_alt,fkumx_j2store_productimages.additional_images_alt,fkumx_j2store_taxprofiles.taxprofile_name,`fkumx_j2store_productquantities`.j2store_productquantity_id ,`fkumx_j2store_productquantities`.quantity,fkumx_j2store_productprice_index.min_price,fkumx_j2store_productprice_index.max_price,fkumx_content.title as product_name,fkumx_content.catid

  FROM fkumx_j2store_products

  INNER JOIN fkumx_j2store_variants 
  ON fkumx_j2store_products.j2store_product_id=fkumx_j2store_variants.product_id

  LEFT 
  OUTER JOIN fkumx_j2store_productimages 
  ON fkumx_j2store_products.j2store_product_id=fkumx_j2store_productimages.product_id

  LEFT 
  OUTER JOIN fkumx_j2store_taxprofiles 
  ON fkumx_j2store_products.taxprofile_id=fkumx_j2store_taxprofiles.j2store_taxprofile_id

  LEFT 
  OUTER JOIN fkumx_j2store_productquantities 
  ON fkumx_j2store_productquantities.variant_id = fkumx_j2store_variants.j2store_variant_id

  LEFT 
  OUTER JOIN fkumx_j2store_productprice_index 
  ON  fkumx_j2store_products.j2store_product_id=fkumx_j2store_productprice_index.product_id

  LEFT 
  OUTER JOIN fkumx_content AS fkumx_content 
  ON fkumx_j2store_products.product_source_id=fkumx_content.id 
  AND fkumx_j2store_products.product_source='com_content'

  WHERE `fkumx_j2store_products`.`visibility`='1' 
  AND `fkumx_j2store_products`.`enabled` IN ('1') 
  AND fkumx_content.catid IN (0,28,30,29,31,37,32) 
  AND 
  CASE WHEN fkumx_j2store_products.product_source = 'com_content' THEN
						fkumx_content.state !='-2'
  					ELSE
						fkumx_j2store_products.enabled = '1'
					END
				 	

  GROUP BY fkumx_j2store_products.j2store_product_id

  ORDER BY `fkumx_j2store_products`.`j2store_product_id` ASC 
  LIMIT 0, 6

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fkumx_j2store_products	NULL	ALL	PRIMARY,catalogsource	NO INDEX KEY COULD BE USED	NULL	NULL	293	1.00	Using where; Using temporary; Using filesort
1	SIMPLE	fkumx_j2store_variants	NULL	ref	variant_product_id	variant_product_id	5	cahayamu_j308182020.fkumx_j2store_products.j2store_product_id	1	100.00	NULL
1	SIMPLE	fkumx_j2store_productimages	NULL	ref	productimage_product_id	productimage_product_id	5	cahayamu_j308182020.fkumx_j2store_products.j2store_product_id	1	100.00	NULL
1	SIMPLE	fkumx_content	NULL	eq_ref	PRIMARY,idx_catid	PRIMARY	4	cahayamu_j308182020.fkumx_j2store_products.product_source_id	1	56.92	Using where
1	SIMPLE	fkumx_j2store_taxprofiles	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	fkumx_j2store_productquantities	NULL	eq_ref	stock_variant_id	stock_variant_id	4	cahayamu_j308182020.fkumx_j2store_variants.j2store_variant_id	1	100.00	NULL
1	SIMPLE	fkumx_j2store_productprice_index	NULL	eq_ref	PRIMARY,product_id	PRIMARY	4	cahayamu_j308182020.fkumx_j2store_products.j2store_product_id	1	100.00	NULL

Profile

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
Creating tmp table	0.13 ms
executing	3.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
49	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
48	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
47	F0FModel->_getList()	JROOT/administrator/components/com_j2store/models/products.php:665
46	J2StoreModelProducts->getProductList()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:139
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.22 ms After last query: 0.09 ms Query memory: 0.041 MB Memory before query: 24.830 MB Rows returned: 1

SELECT a.*,c.title AS category_title, c.alias AS category_alias, c.access AS category_access

  FROM fkumx_content as a

  LEFT JOIN fkumx_categories AS c 
  on c.id = a.catid

  WHERE a.id='43'

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	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
54	JDatabaseDriver->loadObject()	JROOT/plugins/content/j2store/j2store.php:681
53	plgContentJ2Store->getArticle()	JROOT/plugins/content/j2store/j2store.php:571
52	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
51	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
50	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
49	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/products.php:125
48	J2StoreModelProducts->onProcessList()	JROOT/libraries/f0f/model/model.php:1955
47	F0FModel->_getList()	JROOT/administrator/components/com_j2store/models/products.php:665
46	J2StoreModelProducts->getProductList()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:139
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.38 ms After last query: 0.57 ms Query memory: 0.051 MB Memory before query: 24.971 MB Rows returned: 3

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

  INNER JOIN `fkumx_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 = 31

  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	45	37.48	Using where

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.09 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
66	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
65	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
64	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
63	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
62	ContentRouter->getCategorySegment()	Same as call in the line below.
61	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
60	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
59	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
58	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
57	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
56	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
55	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
54	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
53	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/j2store/j2store.php:592
52	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
51	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
50	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
49	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/products.php:125
48	J2StoreModelProducts->onProcessList()	JROOT/libraries/f0f/model/model.php:1955
47	F0FModel->_getList()	JROOT/administrator/components/com_j2store/models/products.php:665
46	J2StoreModelProducts->getProductList()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:139
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.19 ms After last query: 0.33 ms Query memory: 0.041 MB Memory before query: 25.044 MB Rows returned: 1

SELECT a.*,c.title AS category_title, c.alias AS category_alias, c.access AS category_access

  FROM fkumx_content as a

  LEFT JOIN fkumx_categories AS c 
  on c.id = a.catid

  WHERE a.id='40'

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	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
54	JDatabaseDriver->loadObject()	JROOT/plugins/content/j2store/j2store.php:681
53	plgContentJ2Store->getArticle()	JROOT/plugins/content/j2store/j2store.php:571
52	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
51	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
50	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
49	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/products.php:125
48	J2StoreModelProducts->onProcessList()	JROOT/libraries/f0f/model/model.php:1955
47	F0FModel->_getList()	JROOT/administrator/components/com_j2store/models/products.php:665
46	J2StoreModelProducts->getProductList()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:139
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.35 ms After last query: 0.11 ms Query memory: 0.051 MB Memory before query: 25.079 MB Rows returned: 3

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

  INNER JOIN `fkumx_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 = 28

  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	45	35.21	Using where

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.09 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
66	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
65	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
64	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
63	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
62	ContentRouter->getCategorySegment()	Same as call in the line below.
61	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
60	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
59	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
58	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
57	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
56	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
55	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
54	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
53	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/j2store/j2store.php:592
52	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
51	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
50	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
49	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/products.php:125
48	J2StoreModelProducts->onProcessList()	JROOT/libraries/f0f/model/model.php:1955
47	F0FModel->_getList()	JROOT/administrator/components/com_j2store/models/products.php:665
46	J2StoreModelProducts->getProductList()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:139
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.18 ms After last query: 0.10 ms Query memory: 0.041 MB Memory before query: 25.114 MB Rows returned: 1

SELECT a.*,c.title AS category_title, c.alias AS category_alias, c.access AS category_access

  FROM fkumx_content as a

  LEFT JOIN fkumx_categories AS c 
  on c.id = a.catid

  WHERE a.id='44'

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	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
54	JDatabaseDriver->loadObject()	JROOT/plugins/content/j2store/j2store.php:681
53	plgContentJ2Store->getArticle()	JROOT/plugins/content/j2store/j2store.php:571
52	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
51	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
50	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
49	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/products.php:125
48	J2StoreModelProducts->onProcessList()	JROOT/libraries/f0f/model/model.php:1955
47	F0FModel->_getList()	JROOT/administrator/components/com_j2store/models/products.php:665
46	J2StoreModelProducts->getProductList()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:139
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.17 ms After last query: 0.13 ms Query memory: 0.042 MB Memory before query: 25.153 MB Rows returned: 1

SELECT a.*,c.title AS category_title, c.alias AS category_alias, c.access AS category_access

  FROM fkumx_content as a

  LEFT JOIN fkumx_categories AS c 
  on c.id = a.catid

  WHERE a.id='45'

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	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
54	JDatabaseDriver->loadObject()	JROOT/plugins/content/j2store/j2store.php:681
53	plgContentJ2Store->getArticle()	JROOT/plugins/content/j2store/j2store.php:571
52	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
51	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
50	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
49	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/products.php:125
48	J2StoreModelProducts->onProcessList()	JROOT/libraries/f0f/model/model.php:1955
47	F0FModel->_getList()	JROOT/administrator/components/com_j2store/models/products.php:665
46	J2StoreModelProducts->getProductList()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:139
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.17 ms After last query: 0.12 ms Query memory: 0.041 MB Memory before query: 25.186 MB Rows returned: 1

SELECT a.*,c.title AS category_title, c.alias AS category_alias, c.access AS category_access

  FROM fkumx_content as a

  LEFT JOIN fkumx_categories AS c 
  on c.id = a.catid

  WHERE a.id='48'

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	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
54	JDatabaseDriver->loadObject()	JROOT/plugins/content/j2store/j2store.php:681
53	plgContentJ2Store->getArticle()	JROOT/plugins/content/j2store/j2store.php:571
52	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
51	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
50	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
49	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/products.php:125
48	J2StoreModelProducts->onProcessList()	JROOT/libraries/f0f/model/model.php:1955
47	F0FModel->_getList()	JROOT/administrator/components/com_j2store/models/products.php:665
46	J2StoreModelProducts->getProductList()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:139
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.17 ms After last query: 0.12 ms Query memory: 0.041 MB Memory before query: 25.218 MB Rows returned: 1

SELECT a.*,c.title AS category_title, c.alias AS category_alias, c.access AS category_access

  FROM fkumx_content as a

  LEFT JOIN fkumx_categories AS c 
  on c.id = a.catid

  WHERE a.id='49'

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	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
54	JDatabaseDriver->loadObject()	JROOT/plugins/content/j2store/j2store.php:681
53	plgContentJ2Store->getArticle()	JROOT/plugins/content/j2store/j2store.php:571
52	plgContentJ2Store->onJ2StoreAfterGetProduct()	JROOT/libraries/joomla/event/event.php:70
51	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
50	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
49	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_j2store/models/products.php:125
48	J2StoreModelProducts->onProcessList()	JROOT/libraries/f0f/model/model.php:1955
47	F0FModel->_getList()	JROOT/administrator/components/com_j2store/models/products.php:665
46	J2StoreModelProducts->getProductList()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:139
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.74 ms After last query: 1.15 ms Query memory: 0.051 MB Memory before query: 25.360 MB Rows returned: 199

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
63	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
62	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
61	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
60	F0FDatabaseDriverJoomla->getTableList()	JROOT/libraries/f0f/table/table.php:2082
59	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
58	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/variant.php:35
57	J2StoreTableVariant->__construct()	JROOT/libraries/f0f/table/table.php:433
56	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
55	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
54	F0FModel->getTable()	JROOT/libraries/f0f/model/model.php:2061
53	F0FModel->buildQuery()	JROOT/administrator/components/com_j2store/models/variants.php:28
52	J2StoreModelVariants->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
51	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
50	F0FModel->getList()	JROOT/administrator/components/com_j2store/models/behavior/simple.php:197
49	J2StoreModelProductsBehaviorSimple->onAfterGetProduct()	JROOT/libraries/f0f/utils/observable/event.php:63
48	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
47	F0FUtilsObservableDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:208
46	J2StoreModelProducts->getProduct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:142
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.40 ms After last query: 0.07 ms Query memory: 0.051 MB Memory before query: 25.408 MB Rows returned: 33

Duplicate queries: #41

SHOW FULL COLUMNS 
  FROM `fkumx_j2store_variants`

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.44 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.26 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
executing	0.04 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
63	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
62	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
61	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
60	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
59	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
58	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/variant.php:35
57	J2StoreTableVariant->__construct()	JROOT/libraries/f0f/table/table.php:433
56	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
55	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
54	F0FModel->getTable()	JROOT/libraries/f0f/model/model.php:2061
53	F0FModel->buildQuery()	JROOT/administrator/components/com_j2store/models/variants.php:28
52	J2StoreModelVariants->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
51	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
50	F0FModel->getList()	JROOT/administrator/components/com_j2store/models/behavior/simple.php:197
49	J2StoreModelProductsBehaviorSimple->onAfterGetProduct()	JROOT/libraries/f0f/utils/observable/event.php:63
48	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
47	F0FUtilsObservableDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:208
46	J2StoreModelProducts->getProduct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:142
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.80 ms After last query: 0.15 ms Query memory: 0.044 MB Memory before query: 25.477 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `fkumx_j2store_productquantities`

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.22 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
executing	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
64	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
63	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
62	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
61	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
60	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2365
59	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
58	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/variant.php:35
57	J2StoreTableVariant->__construct()	JROOT/libraries/f0f/table/table.php:433
56	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
55	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
54	F0FModel->getTable()	JROOT/libraries/f0f/model/model.php:2061
53	F0FModel->buildQuery()	JROOT/administrator/components/com_j2store/models/variants.php:28
52	J2StoreModelVariants->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
51	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
50	F0FModel->getList()	JROOT/administrator/components/com_j2store/models/behavior/simple.php:197
49	J2StoreModelProductsBehaviorSimple->onAfterGetProduct()	JROOT/libraries/f0f/utils/observable/event.php:63
48	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
47	F0FUtilsObservableDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:208
46	J2StoreModelProducts->getProduct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:142
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:76
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:161
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/partials/quix-render-item.php:162
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:71
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:79
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:74
6	require_once JROOT/components/com_quix/quix.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.78 ms After last query: 0.05 ms Query memory: 0.044 MB Memory before query: 25.511 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `fkumx_j2store_lengths`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.20 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
executing	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
64	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
63	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
62	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
61	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2167
60	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2365
59	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
58	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/variant.php:35
57	J2StoreTableVariant->__construct()	JROOT/libraries/f0f/table/table.php:433
56	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
55	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
54	F0FModel->getTable()	JROOT/libraries/f0f/model/model.php:2061
53	F0FModel->buildQuery()	JROOT/administrator/components/com_j2store/models/variants.php:28
52	J2StoreModelVariants->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
51	F0FModel->getItemList()	JROOT/libraries/f0f/model/model.php:1204
50	F0FModel->getList()	JROOT/administrator/components/com_j2store/models/behavior/simple.php:197
49	J2StoreModelProductsBehaviorSimple->onAfterGetProduct()	JROOT/libraries/f0f/utils/observable/event.php:63
48	F0FUtilsObservableEvent->update()	JROOT/libraries/f0f/utils/observable/dispatcher.php:146
47	F0FUtilsObservableDispatcher->trigger()	JROOT/administrator/components/com_j2store/models/products.php:208
46	J2StoreModelProducts->getProduct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/helper.php:142
45	ModJ2StoreRelatedProductsHelper::getAllProducts()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:48
44	templateJ2StoreElement->__construct()	JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php:80
43	include JROOT/templates/tx_shopx/quix/elements/j2store-gallery/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:82
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:145
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Same as call in the line below.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:268
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:249
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:30
35	include JROOT/libraries/quix/app/nodes/column/view.php

Subwoofer Pasif Audio Seven Turbo 18in

Power Amplifier AudioSeven FP 14000 X

Subwoofer Pasif Audio Seven WLX 18in

Power Amplifier AudioSeven H-5

Power Amplifier AudioSeven H-3

Power Amplifier AudioSeven H-15

Penawaran Special

Penawaran Special

Fast Delivery

SPECIAL DISCOUNT

SECURE CHECKOUT

MONEY RETURNS

Shipping Service

Quick Links

Social Media

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

93 Queries Logged 51.56 ms

27 duplicate found!