Media Integration Products

Search Our Site

Media Integration Products

Products inclue Media Integrator, Media Integrator for Virtuemart, Image Map Designer, Image Mapper for VM

Title
VM Image Map Designer
Web Site and Streaming Media on Single Server
Image Map Designer
Media Integrator VM
Media Integrator

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1571299320,
                "last": 1571299320,
                "now": 1571299320
            },
            "token": "kRKanrNrHQetTNV7dRNw6YHLRa97QMot"
        },
        "registry": {
            "base_url": "http:\/\/www.mediagration.com\/"
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 1.86 ms / 1.86 ms Memory: 0.061 MB / 0.39 MB Application: afterLoad

Time: 22.17 ms / 24.03 ms Memory: 1.112 MB / 1.50 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.59 ms / 24.62 ms Memory: 0.022 MB / 1.53 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.40 ms / 25.03 ms Memory: 0.006 MB / 1.53 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.48 ms / 25.51 ms Memory: 0.017 MB / 1.55 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.03 ms / 25.54 ms Memory: 0.000 MB / 1.55 MB Application: Start JAccess::preload(components)

Time: 2.29 ms / 27.83 ms Memory: 0.248 MB / 1.80 MB Application: Finish JAccess::preload(components)

Time: 4.63 ms / 32.45 ms Memory: 0.572 MB / 2.37 MB Application: afterInitialise

Time: 1.62 ms / 34.07 ms Memory: 0.029 MB / 2.40 MB Application: afterRoute

Time: 4.03 ms / 38.10 ms Memory: 0.127 MB / 2.53 MB Application: beforeRenderComponent com_content

Time: 1.14 ms / 39.24 ms Memory: 0.081 MB / 2.61 MB Application: New JAccess Preloading Process(com_content.category)

Time: 1.43 ms / 40.67 ms Memory: 0.142 MB / 2.75 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

Time: 1.55 ms / 42.21 ms Memory: 0.186 MB / 2.94 MB Application: After preloadPermissions (com_content.category)

Time: 0.01 ms / 42.23 ms Memory: 0.001 MB / 2.94 MB Application: End New JAccess Preloading Process(com_content.category)

Time: 0.01 ms / 42.24 ms Memory: 0.001 MB / 2.94 MB Application: Start JAccess::getAssetRules New (com_content.category.49)

Time: 0.07 ms / 42.30 ms Memory: 0.007 MB / 2.94 MB Application: Finish JAccess::getAssetRules New (com_content.category.49)

Time: 17.47 ms / 59.77 ms Memory: 0.491 MB / 3.44 MB Application: afterRenderComponent com_content

Time: 0.46 ms / 60.23 ms Memory: 0.006 MB / 3.44 MB Application: afterDispatch

Time: 20.43 ms / 80.66 ms Memory: 0.354 MB / 3.80 MB Application: beforeRenderModule mod_s5_box (S5 Box)

Time: 0.29 ms / 80.95 ms Memory: 0.025 MB / 3.82 MB Application: beforeRenderModule mod_login (Login)

Time: 1.68 ms / 82.64 ms Memory: 0.028 MB / 3.85 MB Application: afterRenderModule mod_login (Login)

Time: 0.03 ms / 82.66 ms Memory: 0.000 MB / 3.85 MB Application: beforeRenderModule mod_s5_register (Register)

Time: 3.79 ms / 86.45 ms Memory: 0.106 MB / 3.95 MB Application: afterRenderModule mod_s5_register (Register)

Time: 0.12 ms / 86.57 ms Memory: 0.000 MB / 3.94 MB Application: afterRenderModule mod_s5_box (S5 Box)

Time: 0.03 ms / 86.60 ms Memory: 0.005 MB / 3.95 MB Application: beforeRenderModule mod_menu (Bottom Menu)

Time: 0.57 ms / 87.18 ms Memory: 0.011 MB / 3.96 MB Application: afterRenderModule mod_menu (Bottom Menu)

Time: 0.09 ms / 87.27 ms Memory: 0.004 MB / 3.96 MB Application: beforeRenderModule mod_s5_live_search (Search Our Site)

Time: 0.54 ms / 87.81 ms Memory: 0.020 MB / 3.98 MB Application: afterRenderModule mod_s5_live_search (Search Our Site)

Time: 2.31 ms / 90.12 ms Memory: 0.284 MB / 4.26 MB Application: afterRender

Database queries total: 35.36 ms

Memory Usage

Database Queries

37 Queries Logged 35.36 ms

6 duplicate found!

2 duplicates: #14 #16

2 duplicates: #20 #37

2 duplicates: #34 #36

Query Time: 0.55 ms Query memory: 0.026 MB Memory before query: 0.719 MB Rows returned: 0

SELECT `data`

  FROM `efzhi_session`

  WHERE `session_id` = 'sja2l7iv7fl70n53b2gn3n5ch5'

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
executing	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.52 ms After last query: 0.65 ms Query memory: 0.023 MB Memory before query: 0.739 MB Rows returned: 0

SELECT `session_id`

  FROM `efzhi_session`

  WHERE `session_id` = 'sja2l7iv7fl70n53b2gn3n5ch5' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 2.12 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 0.745 MB

INSERT INTO `efzhi_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('sja2l7iv7fl70n53b2gn3n5ch5', 0, 1, '1571299320', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `efzhi_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('sja2l7iv7fl70n53b2gn3n5ch5', 0, 1, '1571299320', 0, '')

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
update	0.12 ms
end	0.02 ms
query end	1.70 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.90 ms After last query: 0.35 ms Query memory: 0.037 MB Memory before query: 0.773 MB Rows returned: 41

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

  FROM `efzhi_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_extensions	NULL	ref	extension	extension	82	const	41	100.00	NULL

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.30 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.35 ms Query memory: 0.024 MB Memory before query: 0.813 MB Rows returned: 1

SELECT b.id

  FROM efzhi_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 0.820 MB Rows returned: 3

SELECT id, rules

  FROM `efzhi_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 0.09 ms Query memory: 0.031 MB Memory before query: 0.830 MB Rows returned: 77

SELECT folder AS type, element AS name, params

  FROM efzhi_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_extensions	NULL	ref	extension	extension	82	const	109	0.40	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.40 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 0.887 MB Rows returned: 1

SELECT *

  FROM efzhi_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	efzhi_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
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/joomla/language/helper.php:85
4	JLanguageHelper::detectLanguage()	JROOT/libraries/cms/application/site.php:648
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 1.87 ms Query memory: 0.024 MB Memory before query: 1.179 MB Rows returned: 1

SELECT `enabled`

  FROM `efzhi_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:71
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.31 ms After last query: 0.89 ms Query memory: 0.026 MB Memory before query: 1.309 MB Rows returned: 1

SHOW TABLES LIKE "efzhi_virtuemart_configs"

Explain

EXPLAIN not possible on query: SHOW TABLES LIKE "efzhi_virtuemart_configs"

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
checking permissions	1.90 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:722
11	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:563
10	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:774
9	VmConfig::loadConfig()	JROOT/plugins/system/mmcartvmaddons/helper.php:19
8	require_once JROOT/plugins/system/mmcartvmaddons/helper.php	JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php:12
7	require_once JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 0.13 ms Query memory: 0.029 MB Memory before query: 1.319 MB Rows returned: 1

SELECT `config` 
  FROM `efzhi_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_virtuemart_configs	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:814
9	VmConfig::loadConfig()	JROOT/plugins/system/mmcartvmaddons/helper.php:19
8	require_once JROOT/plugins/system/mmcartvmaddons/helper.php	JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php:12
7	require_once JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.50 ms Query memory: 0.035 MB Memory before query: 1.462 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `efzhi_assets`

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 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
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
9	VmConfig::loadConfig()	JROOT/plugins/system/mmcartvmaddons/helper.php:19
8	require_once JROOT/plugins/system/mmcartvmaddons/helper.php	JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php:12
7	require_once JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.26 ms Query memory: 0.031 MB Memory before query: 1.496 MB Rows returned: 1

SELECT *

  FROM efzhi_assets

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
9	VmConfig::loadConfig()	JROOT/plugins/system/mmcartvmaddons/helper.php:19
8	require_once JROOT/plugins/system/mmcartvmaddons/helper.php	JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php:12
7	require_once JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 0.12 ms Query memory: 0.027 MB Memory before query: 1.506 MB Rows returned: 1

Duplicate queries: #16

SELECT a.rules

  FROM efzhi_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
9	VmConfig::loadConfig()	JROOT/plugins/system/mmcartvmaddons/helper.php:19
8	require_once JROOT/plugins/system/mmcartvmaddons/helper.php	JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php:12
7	require_once JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 0.21 ms Query memory: 0.028 MB Memory before query: 1.523 MB Rows returned: 1

SELECT id

  FROM efzhi_assets

  WHERE parent_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_assets	NULL	ref	idx_parent_id	idx_parent_id	4	const	1	100.00	Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
14	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
9	VmConfig::loadConfig()	JROOT/plugins/system/mmcartvmaddons/helper.php:19
8	require_once JROOT/plugins/system/mmcartvmaddons/helper.php	JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php:12
7	require_once JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.09 ms Query memory: 0.028 MB Memory before query: 1.534 MB Rows returned: 1

Duplicate queries: #14

SELECT a.rules

  FROM efzhi_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
9	VmConfig::loadConfig()	JROOT/plugins/system/mmcartvmaddons/helper.php:19
8	require_once JROOT/plugins/system/mmcartvmaddons/helper.php	JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php:12
7	require_once JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.14 ms Query memory: 0.033 MB Memory before query: 1.553 MB Rows returned: 41

SELECT element

  FROM efzhi_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_extensions	NULL	ref	extension	extension	82	const	41	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
9	VmConfig::loadConfig()	JROOT/plugins/system/mmcartvmaddons/helper.php:19
8	require_once JROOT/plugins/system/mmcartvmaddons/helper.php	JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php:12
7	require_once JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.94 ms After last query: 0.12 ms Query memory: 0.033 MB Memory before query: 1.572 MB Rows returned: 41

SELECT a.name, a.rules

  FROM efzhi_assets AS a

  WHERE (a.name IN ('com_acesql','com_admin','com_ajax','com_ajax_eshop','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_hwdmediashare','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_productcreator','com_redirect','com_search','com_spellcheck','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper') OR a.name = 'root.1')

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.17 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.44 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
11	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
10	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
9	VmConfig::loadConfig()	JROOT/plugins/system/mmcartvmaddons/helper.php:19
8	require_once JROOT/plugins/system/mmcartvmaddons/helper.php	JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php:12
7	require_once JROOT/plugins/system/mmcartvmaddons/mmcartvmaddons.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 1.33 ms Query memory: 0.024 MB Memory before query: 1.829 MB Rows returned: 1

SELECT element

  FROM efzhi_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_extensions	NULL	ref	extension	extension	82	const	2	2.50	Using index condition; Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.46 ms After last query: 1.09 ms Query memory: 0.078 MB Memory before query: 1.951 MB Rows returned: 52

Duplicate queries: #37

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

  LEFT JOIN efzhi_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	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	186	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	mediagratoin_db3.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.00 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 2.93 ms Query memory: 0.026 MB Memory before query: 2.481 MB Rows returned: 1

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

  FROM `efzhi_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	efzhi_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.82 ms After last query: 0.19 ms Query memory: 0.007 MB Memory before query: 2.474 MB

UPDATE `efzhi_extensions`

  SET `params` = '{\"mediaversion\":\"3697a60b344d0182883965420ae1b69c\"}'

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.06 ms
updating	0.07 ms
end	0.01 ms
query end	1.47 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 2.521 MB Rows returned: 7

SELECT id, home, template, s.params

  FROM efzhi_template_styles as s

  LEFT JOIN efzhi_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	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	10	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	mediagratoin_db3.s.template,const	1	4.61	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.09 ms After last query: 1.51 ms Query memory: 0.051 MB Memory before query: 2.609 MB Rows returned: 237

SELECT a.id, a.parent_id

  FROM efzhi_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	592	20.13	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.58 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.97 ms After last query: 0.42 ms Query memory: 0.075 MB Memory before query: 2.753 MB Rows returned: 237

SELECT a.id, a.name, a.rules

  FROM efzhi_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	592	20.13	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.61 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.54 ms After last query: 0.79 ms Query memory: 0.041 MB Memory before query: 3.016 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,COUNT(i.`id`) AS numitems

  FROM efzhi_categories as c

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

  LEFT JOIN efzhi_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  LEFT JOIN `efzhi_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1 
  AND (i.language = '*' OR i.language = 'en-GB')

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=49

  GROUP BY 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

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	41	11.06	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	mediagratoin_db3.c.id	6	100.00	Using where; Not exists; Using index
1	PRIMARY	i	NULL	ref	idx_state,idx_catid,idx_language	idx_catid	4	mediagratoin_db3.c.id	8	100.00	Using where
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	15	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	41	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.22 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
Opening tables	0.03 ms
init	0.16 ms
System lock	0.02 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
statistics	0.24 ms
preparing	0.06 ms
Creating tmp table	0.08 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
executing	0.01 ms
Sending data	0.25 ms
Creating sort index	1.72 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.11 ms
query end	0.02 ms
removing tmp table	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/models/category.php:354
13	ContentModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.60 ms After last query: 0.55 ms Query memory: 0.057 MB Memory before query: 3.054 MB Rows returned: 5

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

  FROM efzhi_content AS a

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

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 49 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-17 08:02:00') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-17 08:02:00') 
  AND a.language in ('en-GB','*')

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using filesort
1	PRIMARY	a	NULL	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	7	16.00	Using index condition; Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	mediagratoin_db3.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	mediagratoin_db3.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	mediagratoin_db3.a.id	1	100.00	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	6	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	15	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	41	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.20 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
Opening tables	0.03 ms
init	0.14 ms
System lock	0.02 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.22 ms
executing	0.01 ms
Sending data	0.19 ms
Creating sort index	0.17 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.13 ms After last query: 0.62 ms Query memory: 0.029 MB Memory before query: 3.240 MB Rows returned: 1

SELECT COUNT(*)

  FROM efzhi_content AS a

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

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 49 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-17 08:02:00') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-17 08:02:00') 
  AND a.language in ('en-GB','*')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	a	NULL	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	7	16.00	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	mediagratoin_db3.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	mediagratoin_db3.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	mediagratoin_db3.a.id	1	100.00	Using where; Using index
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	6	100.00	Using where; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	15	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	41	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.10 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
Opening tables	0.02 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.06 ms
executing	0.01 ms
Sending data	0.17 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.33 ms Query memory: 0.037 MB Memory before query: 3.251 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `efzhi_contentitem_tag_map` AS m 

  INNER JOIN `efzhi_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 49 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:217
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.68 ms After last query: 6.35 ms Query memory: 0.046 MB Memory before query: 3.461 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 efzhi_categories as c

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

  LEFT JOIN efzhi_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=49

  GROUP BY 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

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	41	11.06	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	mediagratoin_db3.c.id	6	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	15	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	41	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
statistics	0.15 ms
preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.18 ms
Creating sort index	0.33 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
21	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
20	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/category/tmpl/default_articles.php:135
19	include JROOT/components/com_content/views/category/tmpl/default_articles.php	JROOT/libraries/legacy/view/legacy.php:677
18	JViewLegacy->loadTemplate()	JROOT/layouts/joomla/content/category_default.php:60
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
14	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 2.04 ms Query memory: 0.027 MB Memory before query: 3.475 MB Rows returned: 1

SELECT * 
  FROM efzhi_template_styles 
  WHERE template = 'samba_spa';

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_template_styles	NULL	ref	idx_template	idx_template	202	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/templates/samba_spa/vertex/parameters.php:19
9	getTemplateName()	JROOT/templates/samba_spa/vertex/parameters.php:167
8	require_once JROOT/templates/samba_spa/vertex/parameters.php	JROOT/templates/samba_spa/index.php:21
7	require JROOT/templates/samba_spa/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 0.14 ms Query memory: 0.031 MB Memory before query: 3.485 MB Rows returned: 0

SELECT * 
  FROM efzhi_menu 
  WHERE template_style_id IN (38) 
  AND alias = 'media-integratorx'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_menu	NULL	ref	idx_alias	idx_alias	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/templates/samba_spa/vertex/parameters.php:40
9	getTemplateName()	JROOT/templates/samba_spa/vertex/parameters.php:167
8	require_once JROOT/templates/samba_spa/vertex/parameters.php	JROOT/templates/samba_spa/index.php:21
7	require JROOT/templates/samba_spa/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.22 ms After last query: 3.83 ms Query memory: 0.033 MB Memory before query: 3.592 MB Rows returned: 11

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM efzhi_modules AS m

  LEFT JOIN efzhi_modules_menu AS mm 
  ON mm.moduleid = m.id

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-10-17 08:02:00') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-10-17 08:02:00') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 559 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	39	1.60	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	mediagratoin_db3.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	mediagratoin_db3.m.id	7	40.00	Using where; Using index

Profile

Status	Duration
starting	0.19 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.19 ms
preparing	0.06 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.22 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
9	JDocumentHtml->countModules()	JROOT/templates/samba_spa/vertex/module_calcs.php:15
8	require_once JROOT/templates/samba_spa/vertex/module_calcs.php	JROOT/templates/samba_spa/index.php:23
7	require JROOT/templates/samba_spa/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 1.57 ms Query memory: 0.026 MB Memory before query: 3.599 MB Rows returned: 0

Duplicate queries: #36

SELECT menutype  
  FROM  efzhi_menu 
  WHERE language = 'en-GB' 
  AND home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_menu	NULL	ref	idx_language	idx_language	28	const	1	10.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/templates/samba_spa/vertex/responsive/responsive_mobile_menu.php:140
10	include JROOT/templates/samba_spa/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/samba_spa/vertex/responsive/responsive_mobile_sidebar.php:70
9	require JROOT/templates/samba_spa/vertex/responsive/responsive_mobile_sidebar.php	JROOT/templates/samba_spa/vertex/includes/vertex_includes_top.php:4
8	require_once JROOT/templates/samba_spa/vertex/includes/vertex_includes_top.php	JROOT/templates/samba_spa/index.php:150
7	require JROOT/templates/samba_spa/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.81 ms After last query: 2.10 ms Query memory: 0.040 MB Memory before query: 3.681 MB Rows returned: 2

SELECT * 
  FROM `efzhi_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "en-GB" ) 
  AND ( access="1" )  
  ORDER BY `language` DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	187	0.40	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
Sorting result	0.06 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	1.05 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1274
21	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:860
20	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:889
19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
18	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/templates/samba_spa/vertex/responsive/responsive_mobile_menu.php:103
11	s5_responsive_menu::getList()	JROOT/templates/samba_spa/vertex/responsive/responsive_mobile_menu.php:145
10	include JROOT/templates/samba_spa/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/samba_spa/vertex/responsive/responsive_mobile_sidebar.php:70
9	require JROOT/templates/samba_spa/vertex/responsive/responsive_mobile_sidebar.php	JROOT/templates/samba_spa/vertex/includes/vertex_includes_top.php:4
8	require_once JROOT/templates/samba_spa/vertex/includes/vertex_includes_top.php	JROOT/templates/samba_spa/index.php:150
7	require JROOT/templates/samba_spa/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 0.83 ms Query memory: 0.025 MB Memory before query: 3.713 MB Rows returned: 0

Duplicate queries: #34

SELECT menutype  
  FROM  efzhi_menu 
  WHERE language = 'en-GB' 
  AND home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efzhi_menu	NULL	ref	idx_language	idx_language	28	const	1	10.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/templates/samba_spa/vertex/s5flex_menu/default.php:45
8	include JROOT/templates/samba_spa/vertex/s5flex_menu/default.php	JROOT/templates/samba_spa/index.php:197
7	require JROOT/templates/samba_spa/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.91 ms After last query: 0.26 ms Query memory: 0.076 MB Memory before query: 3.727 MB Rows returned: 52

Duplicate queries: #20

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

  LEFT JOIN efzhi_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	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	186	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	mediagratoin_db3.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.27 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
13	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
12	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
11	JMenuSite->__construct()	JROOT/templates/samba_spa/vertex/s5flex_menu/helpers.php:41
10	S5modMainMenuHelper::getList()	JROOT/templates/samba_spa/vertex/s5flex_menu/helpers.php:141
9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/samba_spa/vertex/s5flex_menu/default.php:54
8	include JROOT/templates/samba_spa/vertex/s5flex_menu/default.php	JROOT/templates/samba_spa/index.php:197
7	require JROOT/templates/samba_spa/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × 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 efzhi_menu AS m 
  LEFT JOIN efzhi_extensions AS e 
  ON m.component_id = e.extension_id

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `efzhi_extensions`

2 × SELECT menutype  
  FROM  efzhi_menu

2 × SELECT a.rules 
  FROM efzhi_assets AS a

2 × SELECT element 
  FROM efzhi_extensions

1 × SELECT a.id, a.parent_id 
  FROM efzhi_assets AS a

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM efzhi_modules AS m 
  LEFT JOIN efzhi_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN efzhi_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

```
1 × SELECT * 
  FROM efzhi_menu
```

1 × SELECT * 
  FROM efzhi_template_styles

1 × 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 efzhi_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM efzhi_categories AS cat JOIN efzhi_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `efzhi_contentitem_tag_map` AS m  
  INNER JOIN `efzhi_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT COUNT(*) 
  FROM efzhi_content AS a 
  LEFT JOIN efzhi_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN efzhi_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN efzhi_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN efzhi_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN efzhi_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM efzhi_categories AS cat JOIN efzhi_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM efzhi_content AS a 
  LEFT JOIN efzhi_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN efzhi_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN efzhi_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN efzhi_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN efzhi_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM efzhi_categories AS cat JOIN efzhi_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × 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,COUNT(i.`id`) AS numitems 
  FROM efzhi_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM efzhi_categories AS cat JOIN efzhi_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.name, a.rules 
  FROM efzhi_assets AS a

1 × SELECT `data` 
  FROM `efzhi_session`

1 × SELECT id, home, template, s.params 
  FROM efzhi_template_styles as s 
  LEFT JOIN efzhi_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `session_id` 
  FROM `efzhi_session`

1 × SELECT a.name, a.rules 
  FROM efzhi_assets AS a

```
1 × SELECT id 
  FROM efzhi_assets
```
```
1 × SELECT * 
  FROM efzhi_assets
```

1 × SELECT `config` 
  FROM `efzhi_virtuemart_configs`

1 × SELECT `enabled` 
  FROM `efzhi_extensions`

```
1 × SELECT * 
  FROM efzhi_languages
```

1 × SELECT folder AS type, element AS name, params 
  FROM efzhi_extensions

1 × SELECT id, rules 
  FROM `efzhi_viewlevels

1 × SELECT b.id 
  FROM efzhi_usergroups AS a 
  LEFT JOIN efzhi_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

```
1 × SELECT * 
  FROM `efzhi_menu`
```

OTHER Tables:

1 × INSERT INTO `efzhi_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('sja2l7iv7fl70n53b2gn3n5ch5', 0, 1, '1571299320', 0, ''

1 × SHOW TABLES LIKE "efzhi_virtuemart_configs

1 × SHOW FULL COLUMNS 
  FROM `efzhi_assets

1 × UPDATE `efzhi_extensions` 
  SET `params` = '{\"mediaversion\":\"3697a60b344d0182883965420ae1b69c\"}'

Home

About

Products

Services

Contact

OpenTok

Demo Shop

Try & Buy

Upload Video

Search Our Site

Login

Register

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

37 Queries Logged 35.36 ms

6 duplicate found!

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: