Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1765104643,
                "last": 1765104643,
                "now": 1765104643
            },
            "token": "alKEODOluysmgoyljhUccc8gdLPFin0Y"
        },
        "registry": {
            "users": {
                "login": {
                    "form": {
                        "data": {
                            "return": "index.php?option=com_users&view=profile"
                        }
                    }
                }
            }
        },
        "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: 17.09 ms / 17.09 ms Memory: 0.125 MB / 0.51 MB Application: afterLoad

Time: 96.32 ms / 113.41 ms Memory: 1.148 MB / 1.66 MB Application: afterInitialise

Time: 42.61 ms / 156.02 ms Memory: 0.783 MB / 2.44 MB Application: afterRoute

Time: 0.37 ms / 156.39 ms Memory: 0.009 MB / 2.45 MB Application: beforeRenderComponent com_users

Time: 43.09 ms / 199.48 ms Memory: 0.410 MB / 2.86 MB Application: afterRenderComponent com_users

Time: 6.37 ms / 205.85 ms Memory: 0.076 MB / 2.93 MB Application: afterDispatch

Time: 42.52 ms / 248.38 ms Memory: 0.365 MB / 3.30 MB Application: beforeRenderModule mod_custom (Snowventures Ski & Snowboard Vacations)

Time: 2.67 ms / 251.05 ms Memory: 0.007 MB / 3.30 MB Application: afterRenderModule mod_custom (Snowventures Ski & Snowboard Vacations)

Time: 0.05 ms / 251.10 ms Memory: 0.000 MB / 3.30 MB Application: beforeRenderModule mod_menu (Bottom menu class=hide_mobile)

Time: 2.03 ms / 253.13 ms Memory: 0.035 MB / 3.34 MB Application: afterRenderModule mod_menu (Bottom menu class=hide_mobile)

Time: 0.04 ms / 253.17 ms Memory: 0.000 MB / 3.34 MB Application: beforeRenderModule mod_custom (Find us on Facebook )

Time: 0.39 ms / 253.56 ms Memory: 0.003 MB / 3.34 MB Application: afterRenderModule mod_custom (Find us on Facebook )

Time: 0.02 ms / 253.58 ms Memory: 0.000 MB / 3.34 MB Application: beforeRenderModule mod_custom (Pinterest (right side))

Time: 0.34 ms / 253.92 ms Memory: 0.003 MB / 3.34 MB Application: afterRenderModule mod_custom (Pinterest (right side))

Time: 0.02 ms / 253.94 ms Memory: 0.000 MB / 3.34 MB Application: beforeRenderModule mod_custom (Twitter widget)

Time: 1.65 ms / 255.58 ms Memory: 0.003 MB / 3.34 MB Application: afterRenderModule mod_custom (Twitter widget)

Time: 0.06 ms / 255.64 ms Memory: 0.000 MB / 3.34 MB Application: beforeRenderModule mod_custom (Banner for mobile layout class=hide_all show_mobile)

Time: 0.19 ms / 255.84 ms Memory: 0.004 MB / 3.35 MB Application: afterRenderModule mod_custom (Banner for mobile layout class=hide_all show_mobile)

Time: 0.04 ms / 255.88 ms Memory: 0.004 MB / 3.35 MB Application: beforeRenderModule mod_s5_live_search (Shape 5 Live Search)

Time: 0.95 ms / 256.83 ms Memory: 0.016 MB / 3.37 MB Application: afterRenderModule mod_s5_live_search (Shape 5 Live Search)

Time: 0.04 ms / 256.87 ms Memory: 0.000 MB / 3.36 MB Application: beforeRenderModule mod_custom (Phone number)

Time: 0.09 ms / 256.96 ms Memory: 0.003 MB / 3.36 MB Application: afterRenderModule mod_custom (Phone number)

Time: 0.03 ms / 256.99 ms Memory: 0.000 MB / 3.36 MB Application: beforeRenderModule mod_custom (Aspen Ski Trips - top right class=hide_mobile)

Time: 0.08 ms / 257.06 ms Memory: 0.003 MB / 3.36 MB Application: afterRenderModule mod_custom (Aspen Ski Trips - top right class=hide_mobile)

Time: 11.30 ms / 268.37 ms Memory: 0.139 MB / 3.50 MB Application: afterRender

Database queries total: 25.05 ms

Memory Usage

Database Queries

19 Queries Logged 25.05 ms

4 duplicate found!

2 duplicates: #9 #19

2 duplicates: #17 #18

Query Time: 1.29 ms Query memory: 0.003 MB Memory before query: 1.007 MB

DELETE 

  FROM `lz7a0_session`

  WHERE `time` < '1765103743'

Explain

EXPLAIN not possible on query: DELETE FROM `lz7a0_session` WHERE `time` < '1765103743'

Profile

Status	Duration
Starting	0.53 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init for update	0.16 ms
Updating	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
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.60 ms After last query: 0.07 ms Query memory: 0.019 MB Memory before query: 1.012 MB Rows returned: 0

SELECT `session_id`

  FROM `lz7a0_session`

  WHERE `session_id` = '532fb2acf26dca268831037dfcaa91d6' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.09 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.26 ms
Reset for next command	0.01 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: 6.98 ms After last query: 0.09 ms Query memory: 0.003 MB Memory before query: 1.017 MB

INSERT INTO `lz7a0_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('532fb2acf26dca268831037dfcaa91d6', 0, 1, '1765104643', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `lz7a0_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('532fb2acf26dca268831037dfcaa91d6', 0, 1, '1765104643', 0, '')

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.13 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	6.04 ms
Query end	0.05 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.18 ms
Updating status	0.03 ms
Reset for next command	0.01 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: 1.24 ms After last query: 5.19 ms Query memory: 0.023 MB Memory before query: 1.042 MB Rows returned: 36

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

  FROM `lz7a0_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lz7a0_extensions	ref	extension	extension	82	const	36	Using index condition

Profile

Status	Duration
Starting	0.19 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.23 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 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: 1.03 ms After last query: 2.83 ms Query memory: 0.021 MB Memory before query: 1.131 MB Rows returned: 2

SELECT b.id

  FROM lz7a0_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
Starting	0.16 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.09 ms
Updating status	0.01 ms
Reset for next command	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.31 ms After last query: 1.36 ms Query memory: 0.021 MB Memory before query: 1.136 MB Rows returned: 5

SELECT id, rules

  FROM `lz7a0_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.11 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.12 ms
Updating status	0.01 ms
Reset for next command	0.01 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: 1.19 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 1.144 MB Rows returned: 71

SELECT folder AS type, element AS name, params

  FROM lz7a0_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.09 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.38 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.04 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 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.93 ms After last query: 14.80 ms Query memory: 0.020 MB Memory before query: 1.495 MB Rows returned: 1

SELECT `enabled`

  FROM `lz7a0_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lz7a0_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.19 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.06 ms
Reset for next command	0.01 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:80
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: 0.67 ms After last query: 24.95 ms Query memory: 0.106 MB Memory before query: 1.731 MB Rows returned: 63

Duplicate queries: #19

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

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

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

  ORDER BY m.lft

Explain

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

Profile

Status	Duration
Starting	0.33 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
Sending cached result to clien	0.17 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
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.24 ms After last query: 22.59 ms Query memory: 0.024 MB Memory before query: 2.298 MB Rows returned: 1

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

  FROM `lz7a0_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.30 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.15 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.17 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.18 ms
Reset for next command	0.01 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/k2/k2.php:388
8	plgSystemK2->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: 2.18 ms After last query: 0.20 ms Query memory: 0.006 MB Memory before query: 2.290 MB

UPDATE `lz7a0_extensions`

  SET `params` = '{\"mediaversion\":\"939954e51dc685b67d54e904d65a40a9\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `lz7a0_extensions` SET `params` = '{\"mediaversion\":\"939954e51dc685b67d54e904d65a40a9\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.05 ms
Updating	0.10 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.09 ms
Query end	0.01 ms
Commit	1.41 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.13 ms
Updating status	0.02 ms
Reset for next command	0.01 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/k2/k2.php:388
8	plgSystemK2->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.35 ms After last query: 6.69 ms Query memory: 0.022 MB Memory before query: 2.412 MB Rows returned: 1

SELECT *

  FROM lz7a0_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.19 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.09 ms
Updating status	0.01 ms
Reset for next command	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/joomla/language/helper.php:164
12	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
11	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:53
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
8	plgSystemK2->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.07 ms After last query: 3.04 ms Query memory: 0.025 MB Memory before query: 2.428 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM lz7a0_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.20 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.11 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.17 ms
Reset for next command	0.01 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/jquery.php:53
12	JHtmlJquery::framework()	JROOT/libraries/cms/html/html.php:237
11	JHtml::call()	JROOT/libraries/cms/html/html.php:139
10	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:71
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
8	plgSystemK2->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.40 ms After last query: 54.32 ms Query memory: 0.022 MB Memory before query: 2.961 MB Rows returned: 4

SELECT * 
  FROM lz7a0_template_styles 
  WHERE template = 'corpway';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lz7a0_template_styles	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where

Profile

Status	Duration
Starting	0.20 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
Sending cached result to clien	0.10 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/templates/corpway/vertex/parameters.php:19
9	getTemplateName()	JROOT/templates/corpway/vertex/parameters.php:167
8	require_once JROOT/templates/corpway/vertex/parameters.php	JROOT/templates/corpway/index.php:47
7	require JROOT/templates/corpway/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.20 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 2.970 MB Rows returned: 0

SELECT * 
  FROM lz7a0_menu 
  WHERE template_style_id IN (9,10,13,14) 
  AND alias = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lz7a0_menu	ref	idx_alias	idx_alias	402	const	1	Using where

Profile

Status	Duration
Starting	0.09 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.08 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/templates/corpway/vertex/parameters.php:40
9	getTemplateName()	JROOT/templates/corpway/vertex/parameters.php:167
8	require_once JROOT/templates/corpway/vertex/parameters.php	JROOT/templates/corpway/index.php:47
7	require JROOT/templates/corpway/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.84 ms After last query: 10.62 ms Query memory: 0.123 MB Memory before query: 3.083 MB Rows returned: 129

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

  FROM lz7a0_modules AS m

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

  LEFT JOIN lz7a0_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 <= '2025-12-07 10:50:43') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-07 10:50:43') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	107	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	snowventures.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	snowventures.m.id	1	Using where; Using index

Profile

Status	Duration
Starting	0.15 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.12 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.06 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.85 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.05 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.03 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.03 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.03 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.23 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 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/corpway/vertex/module_calcs.php:15
8	require_once JROOT/templates/corpway/vertex/module_calcs.php	JROOT/templates/corpway/index.php:51
7	require JROOT/templates/corpway/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.32 ms After last query: 6.56 ms Query memory: 0.023 MB Memory before query: 3.106 MB Rows returned: 0

Duplicate queries: #18

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lz7a0_menu	ref	idx_language	idx_language	28	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.15 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.10 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/templates/corpway/vertex/responsive/responsive_mobile_menu.php:139
10	include JROOT/templates/corpway/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/corpway/vertex/responsive/responsive_mobile_top_bar.php:85
9	require JROOT/templates/corpway/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/corpway/vertex/includes/vertex_includes_top.php:12
8	require_once JROOT/templates/corpway/vertex/includes/vertex_includes_top.php	JROOT/templates/corpway/index.php:445
7	require JROOT/templates/corpway/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.40 ms After last query: 5.61 ms Query memory: 0.021 MB Memory before query: 3.225 MB Rows returned: 0

Duplicate queries: #17

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	lz7a0_menu	ref	idx_language	idx_language	28	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.25 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.11 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/templates/corpway/vertex/s5flex_menu/default.php:45
8	include JROOT/templates/corpway/vertex/s5flex_menu/default.php	JROOT/templates/corpway/index.php:639
7	require JROOT/templates/corpway/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.84 ms After last query: 3.65 ms Query memory: 0.106 MB Memory before query: 3.237 MB Rows returned: 63

Duplicate queries: #9

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

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

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

  ORDER BY m.lft

Explain

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

Profile

Status	Duration
Starting	0.17 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.12 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.38 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.07 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.07 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.23 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 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/corpway/vertex/s5flex_menu/helpers.php:41
10	S5modMainMenuHelper::getList()	JROOT/templates/corpway/vertex/s5flex_menu/helpers.php:141
9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/corpway/vertex/s5flex_menu/default.php:54
8	include JROOT/templates/corpway/vertex/s5flex_menu/default.php	JROOT/templates/corpway/index.php:639
7	require JROOT/templates/corpway/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.]

16 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 lz7a0_menu AS m 
  LEFT JOIN lz7a0_extensions AS e 
  ON m.component_id = e.extension_id

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

2 × SELECT menutype  
  FROM  lz7a0_menu

1 × SELECT `session_id` 
  FROM `lz7a0_session`

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

1 × SELECT id, rules 
  FROM `lz7a0_viewlevels

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

1 × SELECT `enabled` 
  FROM `lz7a0_extensions`

```
1 × SELECT * 
  FROM lz7a0_languages
```

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

1 × SELECT * 
  FROM lz7a0_template_styles

```
1 × SELECT * 
  FROM lz7a0_menu
```

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

OTHER Tables:

```
1 × DELETE  
  FROM `lz7a0_session`
```

1 × INSERT INTO `lz7a0_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('532fb2acf26dca268831037dfcaa91d6', 0, 1, '1765104643', 0, ''

1 × UPDATE `lz7a0_extensions` 
  SET `params` = '{\"mediaversion\":\"939954e51dc685b67d54e904d65a40a9\"}'

Find us on Facebook

Find us on Pinterest

Find us on Twitter

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

19 Queries Logged 25.05 ms

4 duplicate found!

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: