Feb.31, 2016, Jan.1, 2017 and Jan.2, 2017 is our New Year Holiday. If any urgent, please call us at personal mobile.

We thanks for all customer support last year, and wish Happiness and Luck for the coming new year to all yours.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1741912740,
                "last": 1741912740,
                "now": 1741912740
            },
            "client": {
                "forwarded": "18.222.71.63"
            }
        },
        "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": [
                "9"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Profile Information

Memory Usage

Database Queries

31 Queries Logged 36.67 ms

2 duplicate found!

2 duplicates: #27 #28

Query Time: 0.91 ms Query memory: 0.012 MB Memory before query: 2.877 MB Rows returned: 0

SELECT `session_id`

  FROM `test_session`

  WHERE `session_id` = 'a46676c7b9e251665ad7e723b6e9e90c' 
  LIMIT 0, 1

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.04 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.15 ms
table lock	0.02 ms
init	0.08 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.03 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:781
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:411
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.82 ms After last query: 0.27 ms Query memory: 0.009 MB Memory before query: 2.890 MB

INSERT INTO `test_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('a46676c7b9e251665ad7e723b6e9e90c', 0, '1741912740')

Explain

EXPLAIN not possible on query: INSERT INTO `test_session` (`session_id`, `client_id`, `time`) VALUES ('a46676c7b9e251665ad7e723b6e9e90c', 0, '1741912740')

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:209
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:781
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:411
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.93 ms After last query: 82.76 ms Query memory: 0.014 MB Memory before query: 3.416 MB Rows returned: 2

SELECT b.id

  FROM test_usergroups AS a

  LEFT JOIN test_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.14 ms
checking permissions	0.07 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:423
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	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:264
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.93 ms Query memory: 0.013 MB Memory before query: 3.472 MB Rows returned: 5

SELECT id, rules

  FROM `test_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:440
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	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:264
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: 4.20 ms Query memory: 0.013 MB Memory before query: 3.829 MB Rows returned: 24

SELECT element

  FROM test_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	test_extensions	ref	extension	extension	62	const	48	Using index condition; Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.15 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.03 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
7	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:72
6	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
5	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
4	JPluginHelper::importPlugin()	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:264
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: 8.95 ms After last query: 91.95 ms Query memory: 0.141 MB Memory before query: 5.272 MB Rows returned: 706

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

  LEFT JOIN test_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	841	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	betlux5_php16.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.19 ms
checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.04 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	7.75 ms
End of update loop	0.10 ms
Query end	0.04 ms
Commit	0.05 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:442
15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:538
11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
9	PlgSystemLanguageFilter->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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: 294.52 ms Query memory: 0.032 MB Memory before query: 13.197 MB Rows returned: 1

SELECT `params` 
  FROM test_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.21 ms
End of update loop	0.02 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
15	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
14	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
13	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:132
12	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:612
11	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119
10	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:83
9	plgSystemSh404sef->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.62 ms After last query: 16.87 ms Query memory: 0.020 MB Memory before query: 14.267 MB Rows returned: 0

SELECT `id`,`alias`,`newurl`,`hits` 
  FROM `test_sh404sef_aliases` 
  WHERE `alias` = 'led-en/news/new-year-holiday-notice/print' 
  order by `alias` desc

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.03 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
12	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:592
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:249
10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/cms/router/router.php:593
8	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:548
7	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:219
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 14.285 MB Rows returned: 0

SELECT * 
  FROM test_sh404sef_pageids 
  WHERE `pageid`='led-en/news/new-year-holiday-notice/print';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	test_sh404sef_pageids	ref	alias	alias	767	const	1	Using index condition

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.16 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:1863
11	Sh404sefClassRouterInternal->_checkShurls()	JROOT/administrator/components/com_sh404sef/classes/router.php:250
10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/cms/router/router.php:593
8	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:548
7	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:219
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.96 ms After last query: 2.84 ms Query memory: 0.026 MB Memory before query: 14.521 MB Rows returned: 1

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM test_sh404sef_urls 
  WHERE `oldurl`='led-en/news/new-year-holiday-notice/print' 
  ORDER BY `rank`;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	test_sh404sef_urls	ref	oldurl	oldurl	767	const	5	Using index condition; Using where; Using filesort

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.26 ms
End of update loop	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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:690
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:471
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
15	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1549
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1237
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2125
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:383
11	Sh404sefClassRouterInternal->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/cms/router/router.php:593
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:548
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:567
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:223
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.48 ms After last query: 0.33 ms Query memory: 0.023 MB Memory before query: 14.548 MB

UPDATE `test_sh404sef_urls` 
  SET `cpt`=272 
  WHERE `id`='16007' 
  AND `rank`=0;

Explain

EXPLAIN not possible on query: UPDATE `test_sh404sef_urls` SET `cpt`=272 WHERE `id`='16007' AND `rank`=0;

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.02 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.07 ms
Updating	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	Same as call in the line below.
19	call_user_func_array()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
18	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:501
17	ShlDbClass->execute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:501
16	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:489
15	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
14	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1252
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2125
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:383
11	Sh404sefClassRouterInternal->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/cms/router/router.php:593
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:548
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:567
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:223
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 83.98 ms Query memory: 0.012 MB Memory before query: 15.653 MB

UPDATE `test_extensions`

  SET `params` = '{\"mediaversion\":\"6f13aa3fb5c2691a22e78073b28ef6ce\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `test_extensions` SET `params` = '{\"mediaversion\":\"6f13aa3fb5c2691a22e78073b28ef6ce\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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: 12.62 ms Query memory: 0.020 MB Memory before query: 16.538 MB Rows returned: 1

SELECT a.rules

  FROM test_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	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
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.02 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.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:423
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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: 0.78 ms Query memory: 0.021 MB Memory before query: 16.591 MB Rows returned: 2

SELECT b.rules

  FROM test_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	17	Using where

Profile

Status	Duration
Starting	0.07 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
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.24 ms
Creating sort index	0.06 ms
Removing tmp table	0.10 ms
Creating sort index	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.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:423
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.27 ms After last query: 69.64 ms Query memory: 0.025 MB Memory before query: 16.678 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `test_content`

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.04 ms
Opening tables	0.25 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.16 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.08 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:305
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:425
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.81 ms After last query: 8.41 ms Query memory: 0.023 MB Memory before query: 17.052 MB Rows returned: 1

SELECT *

  FROM test_content

  WHERE `id` = '852'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	test_content	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.05 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:728
10	JTable->load()	JROOT/components/com_content/models/article.php:426
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.75 ms After last query: 0.41 ms Query memory: 0.014 MB Memory before query: 17.067 MB

UPDATE test_content

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

  WHERE `id` = '852'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1249
10	JTable->hit()	JROOT/components/com_content/models/article.php:427
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.14 ms After last query: 8.00 ms Query memory: 0.029 MB Memory before query: 17.322 MB Rows returned: 1

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

  FROM test_content AS a

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

  LEFT JOIN test_users AS u 
  on u.id = a.created_by

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

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

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

  WHERE a.language in ('en-GB','*') 
  AND a.id = 852 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-03-14 00:39:00') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-03-14 00:39:00') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	2
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	28	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.31 ms
checking permissions	0.03 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.16 ms
Optimizing	0.06 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Statistics	0.18 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.15 ms
Creating sort index	0.04 ms
Removing tmp table	0.10 ms
Creating sort index	0.05 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.07 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
13	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.97 ms After last query: 3.97 ms Query memory: 0.028 MB Memory before query: 17.585 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM test_categories as c

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

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

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

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	betlux5_php16.c.id	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	28	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.11 ms
Optimizing	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Statistics	0.14 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Creating tmp table	0.09 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.12 ms
Creating sort index	0.03 ms
Removing tmp table	0.10 ms
Creating sort index	0.30 ms
Creating sort index	0.05 ms
Removing tmp table	0.07 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.06 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.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
12	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.72 ms After last query: 3.32 ms Query memory: 0.041 MB Memory before query: 17.688 MB Rows returned: 317

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
Starting	0.08 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
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	1.05 ms
Executing	0.02 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.04 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
29	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
28	JDatabaseDriverMysqli->getTableList()	Same as call in the line below.
27	call_user_func_array()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
26	ShlSystem_Abstractdecorator->__call()	JROOT/administrator/components/com_sh404sef/helpers/language.php:323
25	ShlDbClass->getTableList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:323
24	Sh404sefHelperLanguage::getInstalledLanguagesList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:208
23	Sh404sefHelperLanguage::validateSefLanguageCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:1149
22	Sh404sefClassRouterInternal->_fixUriLanguageVar()	JROOT/administrator/components/com_sh404sef/classes/router.php:1027
21	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2130
20	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:970
19	Sh404sefClassRouterInternal->buildRule()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/cms/router/router.php:635
17	JRouter->processBuildRules()	JROOT/libraries/cms/router/site.php:609
16	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:611
15	JRouter->_processBuildRules()	JROOT/libraries/cms/router/router.php:269
14	JRouter->build()	JROOT/libraries/cms/router/site.php:134
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.65 ms After last query: 0.43 ms Query memory: 0.039 MB Memory before query: 17.782 MB Rows returned: 22

SELECT * 
  FROM test_languages

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.03 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.23 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.03 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:690
25	ShlDbClass->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:330
24	Sh404sefHelperLanguage::getInstalledLanguagesList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:208
23	Sh404sefHelperLanguage::validateSefLanguageCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:1149
22	Sh404sefClassRouterInternal->_fixUriLanguageVar()	JROOT/administrator/components/com_sh404sef/classes/router.php:1027
21	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2130
20	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:970
19	Sh404sefClassRouterInternal->buildRule()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/cms/router/router.php:635
17	JRouter->processBuildRules()	JROOT/libraries/cms/router/site.php:609
16	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:611
15	JRouter->_processBuildRules()	JROOT/libraries/cms/router/router.php:269
14	JRouter->build()	JROOT/libraries/cms/router/site.php:134
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.89 ms After last query: 77.39 ms Query memory: 0.025 MB Memory before query: 18.394 MB Rows returned: 0

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

  FROM `test_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 852 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
12	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
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.30 ms After last query: 88.26 ms Query memory: 0.015 MB Memory before query: 19.400 MB Rows returned: 23

SELECT language,id

  FROM `test_menu`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	test_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	882	Using where

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.63 ms
End of update loop	0.03 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:610
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:264
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.81 ms After last query: 4.75 ms Query memory: 0.016 MB Memory before query: 19.493 MB Rows returned: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `test_content` AS `c`

  INNER JOIN `test_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

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

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

  INNER JOIN `test_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 852

Explain

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

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.02 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.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
11	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:46
10	ContentHelperAssociation::getAssociations()	Same as call in the line below.
9	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:641
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:264
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.81 ms After last query: 2.07 ms Query memory: 0.018 MB Memory before query: 19.528 MB Rows returned: 0

SELECT `pageid` 
  FROM test_sh404sef_pageids 
  WHERE `newurl`='index.php?option=com_content&Itemid=731&catid=8&id=852&lang=led-en&layout=default&page=&print=1&tmpl=component&view=article';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	test_sh404sef_pageids	ref	newurl	newurl	767	const	1	Using index condition

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	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.08 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
12	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
11	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
10	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/shurl.php:57
9	Sh404sefHelperShurl::updateShurls()	JROOT/plugins/system/sh404sef/sh404sef.php:214
8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:264
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.66 ms After last query: 5.85 ms Query memory: 0.023 MB Memory before query: 19.915 MB Rows returned: 1

SELECT `id`, `title`, `alias`, `catid`, `language` 
  FROM test_content 
  WHERE `id`=852;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	test_content	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 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.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
15	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
14	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
13	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/slugs.php:55
12	Sh404sefModelSlugs->getArticle()	JROOT/components/com_sh404sef/sef_ext.php:661
11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:144
10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:319
9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:264
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 0.83 ms Query memory: 0.028 MB Memory before query: 19.942 MB Rows returned: 0

Duplicate queries: #28

SELECT * 
  FROM test_categories 
  WHERE parent_id > 0 
  and extension = 'com_content' 
  and path = 'uncategorised' 
  and level = 1;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	test_categories	ref	cat_idx,idx_path	idx_path	302	const	4	Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.02 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.04 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
15	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
14	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
13	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:40
12	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/components/com_sh404sef/sef_ext.php:675
11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:144
10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:319
9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:264
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.58 ms After last query: 0.28 ms Query memory: 0.029 MB Memory before query: 19.963 MB Rows returned: 0

Duplicate queries: #27

SELECT * 
  FROM test_categories 
  WHERE parent_id > 0 
  and extension = 'com_content' 
  and path = 'uncategorised' 
  and level = 1;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	test_categories	ref	cat_idx,idx_path	idx_path	302	const	4	Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.07 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.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
16	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
15	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
14	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:40
13	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/administrator/components/com_sh404sef/models/slugs.php:280
12	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:682
11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:144
10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:319
9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:264
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.16 ms After last query: 0.39 ms Query memory: 0.029 MB Memory before query: 19.994 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM test_categories as c

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND s.id=8

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where; Using filesort

Profile

Status	Duration
Starting	0.23 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.12 ms
Optimizing	0.05 ms
Statistics	0.12 ms
Preparing	0.02 ms
Unlocking tables	0.04 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.13 ms
End of update loop	0.02 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.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
15	JCategories->get()	JROOT/administrator/components/com_sh404sef/models/slugs.php:161
14	Sh404sefModelSlugs->getCategory()	JROOT/administrator/components/com_sh404sef/models/slugs.php:199
13	Sh404sefModelSlugs->getCategoryPathArray()	JROOT/administrator/components/com_sh404sef/models/slugs.php:290
12	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:682
11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:144
10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:319
9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:264
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: 2.76 ms Query memory: 0.030 MB Memory before query: 20.182 MB Rows returned: 36

SHOW FULL COLUMNS 
  FROM `test_sh404sef_metas`

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Opening tables	0.21 ms
After opening tables	0.04 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.11 ms
closing tables	0.01 ms
checking permissions	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.05 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
16	JTable->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:127
15	Sh404sefTableMetas->__construct()	JROOT/libraries/joomla/table/table.php:305
14	JTable::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:33
13	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:89
12	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:114
11	Sh404sefHelperMetadata::getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:159
10	Sh404sefHelperMetadata::getFinalizedCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:213
9	Sh404sefHelperMetadata::insertMetaData()	JROOT/plugins/system/sh404sef/sh404sef.php:229
8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:264
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.43 ms Query memory: 0.032 MB Memory before query: 20.277 MB Rows returned: 0

SELECT * 
  FROM test_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_content&Itemid=731&catid=8&id=852&lang=led-en&layout=default&page=&print=1&tmpl=component&view=article';

Explain

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

Profile

Status	Duration
Starting	0.05 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	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
16	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
15	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
14	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:34
13	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:89
12	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:114
11	Sh404sefHelperMetadata::getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:159
10	Sh404sefHelperMetadata::getFinalizedCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:213
9	Sh404sefHelperMetadata::insertMetaData()	JROOT/plugins/system/sh404sef/sh404sef.php:229
8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:264
1	JApplicationCms->execute()	JROOT/index.php:49

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

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
2 × SELECT * 
  FROM test_categories
```

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

1 × SELECT language,id 
  FROM `test_menu`

```
1 × SELECT * 
  FROM test_language
```

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM test_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM test_categories AS cat JOIN test_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `test_content` AS `c` 
  INNER JOIN `test_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `test_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `test_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `test_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT `pageid` 
  FROM test_sh404sef_pageids

1 × SELECT * 
  FROM test_sh404sef_metas

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM test_categories as c 
  LEFT JOIN test_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

1 × SELECT `id`, `title`, `alias`, `catid`, `language` 
  FROM test_content

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM test_content AS a 
  LEFT JOIN test_categories AS c 
  on c.id = a.catid 
  LEFT JOIN test_users AS u 
  on u.id = a.created_by 
  LEFT JOIN test_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN test_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM test_categories AS cat JOIN test_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT * 
  FROM test_content
```

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 test_menu AS m 
  LEFT JOIN test_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT element 
  FROM test_extensions

1 × SELECT id, rules 
  FROM `test_viewlevels

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

1 × SELECT `params` 
  FROM test_extensions

1 × SELECT `id`,`alias`,`newurl`,`hits` 
  FROM `test_sh404sef_aliases`

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

1 × SELECT a.rules 
  FROM test_assets AS a

1 × SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM test_sh404sef_urls

1 × SELECT * 
  FROM test_sh404sef_pageids

1 × SELECT `session_id` 
  FROM `test_session`

OTHER Tables:

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `test_sh404sef_metas

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

1 × SHOW FULL COLUMNS 
  FROM `test_content

1 × UPDATE `test_sh404sef_urls` 
  SET `cpt`=272

1 × UPDATE `test_extensions` 
  SET `params` = '{\"mediaversion\":\"6f13aa3fb5c2691a22e78073b28ef6ce\"}'

1 × INSERT INTO `test_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('a46676c7b9e251665ad7e723b6e9e90c', 0, '1741912740'

News

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

31 Queries Logged 36.67 ms

2 duplicate found!

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: