Coperate

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714176870,
                "last": 1714176870,
                "now": 1714176870
            },
            "client": {
                "forwarded": "18.221.165.246"
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Memory Usage

Database Queries

30 Queries Logged 30.77 ms

2 duplicate found!

2 duplicates: #12 #13

Query Time: 1.10 ms Query memory: 0.024 MB Memory before query: 0.734 MB Rows returned: 0

SELECT `data`

  FROM `edmyp_session`

  WHERE `session_id` = '71c7d8ca8d7b62a28e2786c332d301ed'

Explain

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

Profile

Status	Duration
starting	0.16 ms
Waiting for query cache lock	0.09 ms
starting	0.02 ms
checking query cache for query	0.13 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.09 ms
statistics	0.13 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 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.71 ms After last query: 0.93 ms Query memory: 0.021 MB Memory before query: 0.753 MB Rows returned: 0

SELECT `session_id`

  FROM `edmyp_session`

  WHERE `session_id` = '71c7d8ca8d7b62a28e2786c332d301ed' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.03 ms
starting	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.08 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 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: 0.63 ms After last query: 0.13 ms Query memory: 0.003 MB Memory before query: 0.758 MB

INSERT INTO `edmyp_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('71c7d8ca8d7b62a28e2786c332d301ed', 0, 1, '1714176870', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `edmyp_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('71c7d8ca8d7b62a28e2786c332d301ed', 0, 1, '1714176870', 0, '')

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
update	0.20 ms
Waiting for query cache lock	0.03 ms
update	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.05 ms
cleaning up	0.02 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.97 ms After last query: 1.35 ms Query memory: 0.022 MB Memory before query: 0.877 MB Rows returned: 2

SELECT b.id

  FROM edmyp_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 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.67 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 0.882 MB Rows returned: 5

SELECT id, rules

  FROM `edmyp_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	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.84 ms After last query: 6.62 ms Query memory: 0.022 MB Memory before query: 1.328 MB Rows returned: 2

SELECT element

  FROM edmyp_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	edmyp_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.15 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: 0.63 ms After last query: 1.76 ms Query memory: 0.022 MB Memory before query: 1.443 MB Rows returned: 1

SELECT count(*)

  FROM `edmyp_cwgears_schedule`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Select tables optimized away

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
executing	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.10 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 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/plugins/system/cwgears/cwgears.php:74
8	plgSystemCwgears->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.60 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 1.449 MB Rows returned: 1

SELECT count(*)

  FROM `edmyp_cwgears_schedule`

  WHERE time + '86400'<'1714176870'

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 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/plugins/system/cwgears/cwgears.php:96
8	plgSystemCwgears->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: 1.26 ms After last query: 0.56 ms Query memory: 0.034 MB Memory before query: 1.466 MB Rows returned: 8

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

  LEFT JOIN edmyp_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	8	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	u512947.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.08 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
Waiting for query cache lock	0.03 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.27 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.07 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.04 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: 2.03 ms After last query: 12.95 ms Query memory: 0.029 MB Memory before query: 1.936 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `edmyp_assets`

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.59 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.04 ms
Opening tables	0.31 ms
checking permissions	0.12 ms
checking permissions	0.03 ms
checking permissions	0.09 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
Sending data	0.12 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.04 ms
removing tmp table	0.06 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
14	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
12	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:73
9	PlgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:95
8	PlgSystemSourcerer->onAfterRoute()	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:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
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.69 ms After last query: 1.02 ms Query memory: 0.026 MB Memory before query: 1.964 MB Rows returned: 1

SELECT *

  FROM edmyp_assets

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.07 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
13	JTable->load()	JROOT/libraries/joomla/access/access.php:697
12	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:73
9	PlgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:95
8	PlgSystemSourcerer->onAfterRoute()	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:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
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.98 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 1.969 MB Rows returned: 1

Duplicate queries: #13

SELECT a.rules

  FROM edmyp_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
Waiting for query cache lock	0.04 ms
starting	0.02 ms
checking query cache for query	0.09 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.14 ms
end	0.02 ms
query end	0.08 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:73
9	PlgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:95
8	PlgSystemSourcerer->onAfterRoute()	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:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
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.26 ms After last query: 0.80 ms Query memory: 0.023 MB Memory before query: 1.978 MB Rows returned: 1

Duplicate queries: #12

SELECT a.rules

  FROM edmyp_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
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
12	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
11	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:73
9	PlgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:95
8	PlgSystemSourcerer->onAfterRoute()	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:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
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.92 ms After last query: 2.65 ms Query memory: 0.026 MB Memory before query: 2.031 MB Rows returned: 1

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

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

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.04 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
14	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84
8	plgSystemSL_ScrollToTop->onAfterRoute()	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:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
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.70 ms After last query: 0.35 ms Query memory: 0.006 MB Memory before query: 2.024 MB

UPDATE `edmyp_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.17 ms
updating	0.08 ms
end	0.02 ms
Waiting for query cache lock	0.02 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84
8	plgSystemSL_ScrollToTop->onAfterRoute()	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:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
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.20 ms After last query: 3.09 ms Query memory: 0.027 MB Memory before query: 2.054 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM edmyp_template_styles as s

  LEFT JOIN edmyp_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	4	25.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	u512947.s.template,const	1	5.00	Using index condition; Using where

Profile

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.19 ms
init	0.05 ms
System lock	0.02 ms
Waiting for query cache lock	0.03 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.19 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
17	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
16	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
15	JHtml::script()	JROOT/libraries/cms/html/html.php:237
14	JHtml::call()	JROOT/libraries/cms/html/html.php:139
13	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
12	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:61
11	JHtmlBehavior::framework()	JROOT/libraries/cms/html/html.php:237
10	JHtml::call()	JROOT/libraries/cms/html/html.php:139
9	JHtml::_()	JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:130
8	plgSystemSL_ScrollToTop->onAfterRoute()	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:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
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.72 ms After last query: 5.69 ms Query memory: 0.023 MB Memory before query: 2.177 MB Rows returned: 1

SELECT count(*)

  FROM `edmyp_extensions`

  WHERE `element` = 'cwgears' 
  AND `extension_id` = ''

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
executing	0.03 ms
end	0.06 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:830
9	plgSystemCwgears->updateDownloadKeySub()	JROOT/plugins/system/cwgears/cwgears.php:130
8	plgSystemCwgears->onAfterRoute()	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:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
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: 5.53 ms Query memory: 0.028 MB Memory before query: 2.323 MB Rows returned: 34

SELECT element

  FROM edmyp_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	edmyp_extensions	NULL	ref	extension	extension	82	const	34	10.00	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.06 ms
starting	0.02 ms
checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.21 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.16 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
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_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.33 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 2.338 MB Rows returned: 34

SELECT a.name, a.rules

  FROM edmyp_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_coalawebcontact','com_config','com_contact','com_contactus','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nexevocontact','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_users','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	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	111	31.53	Using where

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.51 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
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_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.84 ms After last query: 0.93 ms Query memory: 0.038 MB Memory before query: 2.525 MB Rows returned: 1

SELECT a.*,l.title AS language_title,ua.name AS author_name

  FROM edmyp_sppagebuilder as a

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

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

  WHERE a.id = 4 
  AND a.published = 1 
  AND a.language in ('en-GB','*')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL
1	SIMPLE	l	NULL	system	idx_langcode	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.48 ms
init	0.07 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.47 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.04 ms
closing tables	0.04 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.09 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.03 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 2.18 ms After last query: 0.50 ms Query memory: 0.033 MB Memory before query: 2.553 MB Rows returned: 24

SHOW FULL COLUMNS 
  FROM `edmyp_sppagebuilder`

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.61 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
Opening tables	0.08 ms
checking permissions	0.09 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.08 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.14 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.07 ms
closing tables	0.02 ms
freeing items	0.05 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/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
14	JTable->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
13	SppagebuilderTablePage->__construct()	JROOT/libraries/joomla/table/table.php:308
12	JTable::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:176
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.80 ms After last query: 0.19 ms Query memory: 0.031 MB Memory before query: 2.607 MB Rows returned: 1

SELECT *

  FROM edmyp_sppagebuilder

  WHERE `id` = '4'

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.07 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/components/com_sppagebuilder/models/page.php:177
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.78 ms After last query: 0.25 ms Query memory: 0.006 MB Memory before query: 2.621 MB

UPDATE edmyp_sppagebuilder

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

  WHERE `id` = '4'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	edmyp_sppagebuilder	NULL	range	PRIMARY	PRIMARY	8	const	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.09 ms
updating	0.08 ms
end	0.02 ms
Waiting for query cache lock	0.02 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.22 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
12	JTable->hit()	JROOT/components/com_sppagebuilder/models/page.php:178
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.85 ms After last query: 5.88 ms Query memory: 0.027 MB Memory before query: 2.936 MB Rows returned: 1

SELECT `template`

  FROM `edmyp_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

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

Profile

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.07 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:609
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:154
15	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:682
14	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:14
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.73 ms After last query: 7.56 ms Query memory: 0.026 MB Memory before query: 2.995 MB Rows returned: 1

SELECT `template`

  FROM `edmyp_template_styles`

  WHERE `client_id` = '0' 
  AND `home` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	edmyp_template_styles	NULL	ref	idx_home	idx_home	28	const	2	25.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
16	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:192
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.04 ms After last query: 30.02 ms Query memory: 0.022 MB Memory before query: 3.277 MB Rows returned: 1

SELECT language,id

  FROM `edmyp_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	edmyp_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	9	3.03	Using where

Profile

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.09 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 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:121
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
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.47 ms After last query: 1.24 ms Query memory: 0.023 MB Memory before query: 3.288 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `edmyp_menu` AS `c`

  INNER JOIN `edmyp_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

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

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

  WHERE c.id = 122

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.08 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.64 ms
init	0.05 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.09 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:714
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
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: 2.25 ms After last query: 3.08 ms Query memory: 0.047 MB Memory before query: 3.339 MB Rows returned: 10

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

  FROM edmyp_modules AS m

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

  LEFT JOIN edmyp_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 <= '2024-04-27 00:14:30') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-27 00:14:30') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 122 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	18	1.85	Using index condition; Using where; Using filesort
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	u512947.m.id	1	40.00	Using where; Using index
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	u512947.m.module,const	1	10.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.10 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.30 ms
init	0.08 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.04 ms
statistics	0.20 ms
preparing	0.12 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.71 ms
Waiting for query cache lock	0.03 ms
Creating sort index	0.11 ms
end	0.05 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
Waiting for query cache lock	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.03 ms
cleaning up	0.07 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
8	JDocumentHtml->countModules()	JROOT/templates/protostar/index.php:94
7	require JROOT/templates/protostar/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.06 ms After last query: 8.52 ms Query memory: 0.024 MB Memory before query: 3.402 MB Rows returned: 0

SELECT uikit

  FROM `edmyp_cwgears`

  WHERE url = 'https://xn--80aabegdaxnusoia3a3be7n.xn--p1ai/en/articles'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.12 ms
checking permissions	0.03 ms
Opening tables	0.26 ms
init	0.05 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.03 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:48
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:347
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:58
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
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.10 ms Query memory: 0.024 MB Memory before query: 3.409 MB Rows returned: 0

SELECT uikit_plus

  FROM `edmyp_cwgears`

  WHERE url = 'https://xn--80aabegdaxnusoia3a3be7n.xn--p1ai/en/articles'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
executing	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.02 ms
freeing items	0.04 ms
Waiting for query cache lock	0.02 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:48
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:356
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:58
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
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.]

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT element 
  FROM edmyp_extensions

2 × SELECT `template` 
  FROM `edmyp_template_styles`

2 × SELECT a.rules 
  FROM edmyp_assets AS a

1 × SELECT `data` 
  FROM `edmyp_session`

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

1 × SELECT uikit 
  FROM `edmyp_cwgears`

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

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `edmyp_menu` AS `c` 
  INNER JOIN `edmyp_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `edmyp_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `edmyp_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT language,id 
  FROM `edmyp_menu`

1 × SELECT * 
  FROM edmyp_sppagebuilder

1 × SELECT a.*,l.title AS language_title,ua.name AS author_name 
  FROM edmyp_sppagebuilder as a 
  LEFT JOIN `edmyp_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN edmyp_users AS ua 
  ON ua.id = a.created_by

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

1 × SELECT count(*) 
  FROM `edmyp_extensions`

1 × SELECT `session_id` 
  FROM `edmyp_session`

1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `edmyp_extensions`

```
1 × SELECT * 
  FROM edmyp_assets
```

1 × 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 edmyp_menu AS m 
  LEFT JOIN edmyp_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT count(*) 
  FROM `edmyp_cwgears_schedule`

1 × SELECT count(*) 
  FROM `edmyp_cwgears_schedule

1 × SELECT id, rules 
  FROM `edmyp_viewlevels

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

1 × SELECT uikit_plus 
  FROM `edmyp_cwgears`

OTHER Tables:

1 × INSERT INTO `edmyp_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('71c7d8ca8d7b62a28e2786c332d301ed', 0, 1, '1714176870', 0, ''

1 × SHOW FULL COLUMNS 
  FROM `edmyp_assets

1 × UPDATE `edmyp_extensions` 
  SET `params` = '{\"mediaversion\":\"a033ab6cd73fa4b11e23d7eb0d8845e9\"}'

1 × SHOW FULL COLUMNS 
  FROM `edmyp_sppagebuilder

1 × UPDATE edmyp_sppagebuilder 
  SET `hits` = (`hits` + 1)