SDL Sites - Meeting Documents

Monday - Friday

9:00 - 5:00

732.357.1280

285 Davidson Ave
Somerset, NJ

Folder Meeting Documents

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 18.07 ms / 18.07 ms Memory: 1.699 MB / 2.03 MB Application: afterLoad

Time: 137.93 ms / 156.00 ms Memory: 11.684 MB / 13.71 MB Application: afterInitialise

Time: 17.81 ms / 173.81 ms Memory: 2.365 MB / 16.08 MB Application: afterRoute

Time: 3.10 ms / 176.92 ms Memory: 0.237 MB / 16.31 MB Application: beforeRenderComponent com_docman

Time: 8.87 ms / 185.79 ms Memory: 0.678 MB / 16.99 MB Application: Before Access::preloadComponents (all components)

Time: 0.86 ms / 186.65 ms Memory: 0.070 MB / 17.06 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 186.67 ms Memory: -0.005 MB / 17.06 MB Application: Before Access::getAssetRules (id:357 name:com_docman)

Time: 0.36 ms / 187.03 ms Memory: 0.027 MB / 17.08 MB Application: After Access::getAssetRules (id:357 name:com_docman)

Time: 175.09 ms / 362.13 ms Memory: 7.062 MB / 24.15 MB Application: afterRenderComponent com_docman

Time: 1.33 ms / 363.45 ms Memory: 0.091 MB / 24.24 MB Application: afterDispatch

Time: 30.53 ms / 393.99 ms Memory: 2.727 MB / 26.96 MB Application: beforeRenderModule mod_search (Search)

Time: 5.89 ms / 399.88 ms Memory: 0.132 MB / 27.10 MB Application: afterRenderModule mod_search (Search)

Time: 2.22 ms / 402.10 ms Memory: 0.534 MB / 27.63 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.04 ms / 402.14 ms Memory: 0.008 MB / 27.64 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 0.70 ms / 402.84 ms Memory: 0.033 MB / 27.67 MB Application: beforeRenderModule mod_finder (smart search)

Time: 5.96 ms / 408.81 ms Memory: 0.351 MB / 28.02 MB Application: afterRenderModule mod_finder (smart search)

Time: 0.10 ms / 408.91 ms Memory: 0.005 MB / 28.03 MB Application: beforeRenderModule mod_djmegamenu (Main Menu)

Time: 19.22 ms / 428.12 ms Memory: 0.749 MB / 28.78 MB Application: afterRenderModule mod_djmegamenu (Main Menu)

Time: 12.54 ms / 440.66 ms Memory: 0.420 MB / 29.20 MB Application: afterRender

Database queries total: 23.81 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_session	const	PRIMARY	PRIMARY	194	const	1

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN not possible on query: INSERT INTO `y5bln_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'6133663932396434613132643432653934343834323866316430376535373233', 1, 1675615488, 0, '')

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.26 ms After last query: 5.18 ms Query memory: 0.021 MB Memory before query: 4.164 MB Rows returned: 20

SELECT id, rules

  FROM `y5bln_viewlevels`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 4.185 MB Rows returned: 1

SELECT b.id

  FROM y5bln_usergroups AS a

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

  WHERE a.id = 1

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 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
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 12.67 ms Query memory: 0.022 MB Memory before query: 5.685 MB Rows returned: 1

SELECT `value`

  FROM `y5bln_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

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.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 1.73 ms Query memory: 0.021 MB Memory before query: 5.862 MB Rows returned: 0

SELECT *

  FROM `y5bln_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

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

Profile

Status	Duration
starting	0.03 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
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 60.62 ms Query memory: 0.022 MB Memory before query: 10.237 MB Rows returned: 1

SELECT manifest_cache 
  FROM y5bln_extensions 
  WHERE element = 'com_logman'

Explain

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

Profile

Status	Duration
starting	0.05 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/koowa/logman/logman.php:153
12	PlgKoowaLogman->_getLogmanVersion()	JROOT/plugins/koowa/logman/logman.php:23
11	PlgKoowaLogman->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/plugins/system/joomlatools/joomlatools.php:170
8	PlgSystemJoomlatools->bootstrap()	JROOT/plugins/system/joomlatools/joomlatools.php:49
7	PlgSystemJoomlatools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 32.01 ms Query memory: 0.022 MB Memory before query: 13.084 MB Rows returned: 0

SELECT *

  FROM `y5bln_admintools_ipautoban`

  WHERE `ip` = '3.236.70.233'

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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 13.089 MB Rows returned: 3

SELECT `ip`

  FROM `y5bln_admintools_ipblock`

Explain

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

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.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/ipblacklist.php:143
11	AtsystemFeatureIpblacklist->isIPBlocked()	JROOT/plugins/system/admintools/feature/ipblacklist.php:37
10	AtsystemFeatureIpblacklist->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 13.096 MB Rows returned: 1

SELECT *

  FROM `y5bln_admintools_storage`

  WHERE `key` LIKE 'timestamp_%'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_admintools_storage	range	PRIMARY	PRIMARY	402	NULL	1	Using where

Profile

Status	Duration
starting	0.03 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.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:277
12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:356
11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:115
10	AtsystemFeatureDisableobsoleteadmins->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.31 ms Query memory: 0.021 MB Memory before query: 13.103 MB Rows returned: 0

SELECT `word`

  FROM `y5bln_admintools_badwords`

  GROUP BY `word`

Explain

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

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.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/badwords.php:48
10	AtsystemFeatureBadwords->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 13.110 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `y5bln_admintools_redirects`

  WHERE ((`dest` = 'government/documents/meeting-documents') OR (`dest` = 'government/documents/meeting-documents') OR ('government/documents/meeting-documents' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 16.36 ms Query memory: 0.021 MB Memory before query: 15.574 MB Rows returned: 1

SELECT *

  FROM `y5bln_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('','com_docman') 
  AND `view` IN('','list') 
  AND `task` IN('','list.') 
  AND `enabled` = '1'

  GROUP BY `query`

  ORDER BY `query` ASC

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:92
10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:154
8	plgSystemAdmintools->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 6.36 ms Query memory: 0.068 MB Memory before query: 15.985 MB Rows returned: 1

Duplicate queries: #38 #39 #40 #41 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.01 ms
removing tmp table	0.01 ms
Creating sort index	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:215
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:244
8	PlgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 1.06 ms Query memory: 0.005 MB Memory before query: 16.099 MB

UPDATE `y5bln_extensions`

  SET `params` = '{\"mediaversion\":\"87d4698fb5248a83797a66d535afd211\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `y5bln_extensions` SET `params` = '{\"mediaversion\":\"87d4698fb5248a83797a66d535afd211\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.03 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
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 10.83 ms Query memory: 0.034 MB Memory before query: 16.997 MB Rows returned: 44

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

  FROM `y5bln_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_content','com_contenthistory','com_cpanel','com_docman','com_dpcalendar','com_fields','com_fileman','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_logman','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend_installer','com_offlajn_installer','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_assets	range	idx_asset_name	idx_asset_name	202	NULL	45	Using index condition

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.02 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.02 ms
removing tmp table	0.01 ms
Creating sort index	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
30	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
29	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
28	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
27	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
26	Joomla\CMS\User\User->authorise()	JROOT/libraries/joomlatools/component/koowa/user/trait.php:168
25	ComKoowaUser->authorise()	JROOT/components/com_docman/dispatcher/http.php:115
24	ComDocmanDispatcherHttp->getRequest()	JROOT/libraries/joomlatools/component/koowa/dispatcher/behavior/decoratable.php:34
23	ComKoowaDispatcherBehaviorDecoratable->isSupported()	JROOT/libraries/joomlatools/library/behavior/abstract.php:176
22	KBehaviorAbstract->getHandle()	JROOT/libraries/joomlatools/library/object/queue.php:63
21	KObjectQueue->enqueue()	JROOT/libraries/joomlatools/library/command/chain/chain.php:168
20	KCommandChain->addHandler()	JROOT/libraries/joomlatools/library/command/mixin/mixin.php:259
19	KCommandMixin->addCommandHandler()	JROOT/libraries/joomlatools/library/behavior/mixin/mixin.php:122
18	KBehaviorMixin->addBehavior()	JROOT/libraries/joomlatools/library/behavior/mixin/mixin.php:45
17	KBehaviorMixin->__construct()	JROOT/libraries/joomlatools/library/object/object.php:132
16	KObject->mixin()	JROOT/libraries/joomlatools/library/controller/abstract.php:201
15	KControllerAbstract->mixin()	JROOT/libraries/joomlatools/library/controller/abstract.php:72
14	KControllerAbstract->__construct()	JROOT/libraries/joomlatools/library/dispatcher/abstract.php:49
13	KDispatcherAbstract->__construct()	JROOT/libraries/joomlatools/library/dispatcher/http.php:32
12	KDispatcherHttp->__construct()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:25
11	ComKoowaDispatcherHttp->__construct()	JROOT/components/com_docman/dispatcher/http.php:13
10	ComDocmanDispatcherHttp->__construct()	JROOT/libraries/joomlatools/library/dispatcher/http.php:75
9	KDispatcherHttp::getInstance()	JROOT/libraries/joomlatools/library/object/manager/manager.php:721
8	KObjectManager->_instantiate()	JROOT/libraries/joomlatools/library/object/manager/manager.php:161
7	KObjectManager->getObject()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 40.67 ms Query memory: 0.027 MB Memory before query: 19.689 MB Rows returned: 1

SELECT extension_id, params, manifest_cache 
  FROM y5bln_extensions
                    
  WHERE type = 'plugin' 
  AND element = 'joomlatoolsupdater' 
  AND folder = 'system'
                    
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.04 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.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/plugins/system/joomlatoolsupdater/license/license.php:252
23	PlgSystemJoomlatoolsupdaterLicense->_getPlugin()	JROOT/plugins/system/joomlatoolsupdater/license/license.php:42
22	PlgSystemJoomlatoolsupdaterLicense->_initialize()	JROOT/libraries/joomlatools/library/object/object.php:73
21	KObject->__construct()	JROOT/plugins/system/joomlatoolsupdater/license/license.php:31
20	PlgSystemJoomlatoolsupdaterLicense->__construct()	JROOT/libraries/joomlatools/library/object/manager/manager.php:723
19	KObjectManager->_instantiate()	JROOT/libraries/joomlatools/library/object/manager/manager.php:161
18	KObjectManager->getObject()	JROOT/libraries/joomlatools/library/object/object.php:290
17	KObject->getObject()	JROOT/plugins/system/joomlatoolsupdater/event/subscriber/license.php:27
16	PlgSystemJoomlatoolsupdaterEventSubscriberLicense->onBeforeDispatcherDispatch()	JROOT/libraries/joomlatools/library/event/publisher/abstract.php:128
15	KEventPublisherAbstract->publishEvent()	JROOT/libraries/joomlatools/component/koowa/event/publisher/publisher.php:55
14	ComKoowaEventPublisher->publishEvent()	JROOT/libraries/joomlatools/library/command/handler/event.php:165
13	KCommandHandlerEvent->execute()	JROOT/libraries/joomlatools/library/command/chain/chain.php:147
12	KCommandChain->execute()	JROOT/libraries/joomlatools/library/command/mixin/mixin.php:133
11	KCommandMixin->invokeCommand()	JROOT/libraries/joomlatools/library/object/object.php:377
10	KObject->__call()	JROOT/libraries/joomlatools/library/controller/abstract.php:365
9	KControllerAbstract->__call()	JROOT/libraries/joomlatools/library/controller/abstract.php:133
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 90.66 ms Query memory: 0.033 MB Memory before query: 23.186 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'meeting-documents'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	1	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.06 ms
updating	0.05 ms
end	0.01 ms
query end	0.58 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:28
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.05 ms Query memory: 0.033 MB Memory before query: 23.204 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = ''
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level 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.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.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:203
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:28
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 2.84 ms Query memory: 0.033 MB Memory before query: 23.244 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'board-of-adjustment-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

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.04 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.31 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 1.37 ms Query memory: 0.033 MB Memory before query: 23.265 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'wildlife-management-committee-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 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.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 1.37 ms Query memory: 0.033 MB Memory before query: 23.286 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'utility-board-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

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.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 1.37 ms Query memory: 0.033 MB Memory before query: 23.308 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'shade-tree-commission-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.02 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 1.27 ms Query memory: 0.033 MB Memory before query: 23.329 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'rent-control-board-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 1.22 ms Query memory: 0.033 MB Memory before query: 23.350 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'recreation-board-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 1.33 ms Query memory: 0.033 MB Memory before query: 23.371 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'planning-board-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 1.46 ms Query memory: 0.033 MB Memory before query: 23.408 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'open-space-advisory-commission-1'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 1.35 ms Query memory: 0.033 MB Memory before query: 23.430 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'mayor-council-meeting'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 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.07 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.02 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 1.23 ms Query memory: 0.033 MB Memory before query: 23.451 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'library-board-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 1.24 ms Query memory: 0.033 MB Memory before query: 23.472 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'human-rights-committee-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 1.23 ms Query memory: 0.033 MB Memory before query: 23.493 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'historic-preservation-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting for group	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.66 ms
Creating sort index	0.10 ms
removing tmp table	0.12 ms
Creating sort index	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 1.28 ms Query memory: 0.034 MB Memory before query: 23.521 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'environmental-meeting-documents'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
checking permissions	0.26 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 1.27 ms Query memory: 0.033 MB Memory before query: 23.543 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'economic-assistance-board-meeting-documents'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 1.20 ms Query memory: 0.033 MB Memory before query: 23.564 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'board-of-health-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.18 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 1.22 ms Query memory: 0.033 MB Memory before query: 23.587 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'board-of-fire-commissioners-meeting-documents'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 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.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 1.22 ms Query memory: 0.033 MB Memory before query: 23.624 MB Rows returned: 1

SELECT GROUP_CONCAT(c.slug 
  ORDER BY r.level DESC SEPARATOR '/')
                
  FROM `y5bln_docman_category_relations` as r
                
  INNER JOIN `y5bln_docman_categories` AS c2 
  ON c2.slug = 'agricultural-advisory-board-meetings'
                
  LEFT JOIN `y5bln_docman_categories` AS c 
  ON c.docman_category_id = r.ancestor_id
                
  WHERE r.descendant_id = c2.docman_category_id
                
  ORDER BY r.level DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c2	const	docman_category_id,slug	slug	767	const	1	Using index
1	SIMPLE	r	ref	path_index	path_index	8	const	2	Using index
1	SIMPLE	c	eq_ref	docman_category_id	docman_category_id	8	sdlsites_core.r.ancestor_id	1

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
36	JDatabaseDriver->loadResult()	JROOT/components/com_docman/router.php:83
35	ComDocmanRouter->getCategoryPath()	JROOT/components/com_docman/router.php:192
34	ComDocmanRouter->build()	JROOT/components/com_docman/router.php:408
33	DocmanBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
32	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
31	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
30	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
29	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
28	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
27	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
26	Joomla\CMS\Router\Route::_()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:102
25	ComKoowaDispatcherRouterRoute->_getRoute()	JROOT/libraries/joomlatools/component/koowa/dispatcher/router/route.php:71
24	ComKoowaDispatcherRouterRoute->toString()	JROOT/libraries/joomlatools/library/http/url/url.php:709
23	KHttpUrl->__toString()	/tmp/buffer63dfdd013bf2c303006919:133
22	include /tmp/buffer63dfdd013bf2c303006919	JROOT/libraries/joomlatools/library/template/engine/koowa.php:351
21	KTemplateEngineKoowa->_evaluate()	JROOT/libraries/joomlatools/library/template/engine/koowa.php:170
20	KTemplateEngineKoowa->render()	JROOT/libraries/joomlatools/library/template/template.php:201
19	KTemplate->render()	JROOT/libraries/joomlatools/library/view/template.php:114
18	KViewTemplate->_actionRender()	JROOT/components/com_docman/views/html.php:32
17	ComDocmanViewHtml->_actionRender()	JROOT/libraries/joomlatools/library/view/abstract.php:114
16	KViewAbstract->render()	JROOT/libraries/joomlatools/library/controller/view.php:230
15	KControllerView->_actionRender()	JROOT/libraries/joomlatools/library/controller/model.php:188
14	KControllerModel->_actionRender()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
13	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:203
12	KDispatcherHttp->_actionGet()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
11	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/dispatcher/http.php:142
10	KDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/component/koowa/dispatcher/http.php:96
9	ComKoowaDispatcherHttp->_actionDispatch()	JROOT/libraries/joomlatools/library/controller/abstract.php:151
8	KControllerAbstract->execute()	JROOT/libraries/joomlatools/library/controller/abstract.php:352
7	KControllerAbstract->__call()	JROOT/components/com_docman/docman.php:10
6	require_once JROOT/components/com_docman/docman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 17.92 ms Query memory: 0.068 MB Memory before query: 24.467 MB Rows returned: 1

Duplicate queries: #15 #39 #40 #41 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 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.05 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
10	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
9	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:117
8	HelixUltimate\Framework\Core\HelixUltimate->__construct()	JROOT/templates/shaper_helixultimate/index.php:44
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.28 ms Query memory: 0.068 MB Memory before query: 24.515 MB Rows returned: 1

Duplicate queries: #15 #38 #40 #41 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
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.02 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
9	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
8	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/templates/shaper_helixultimate/index.php:45
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.23 ms Query memory: 0.068 MB Memory before query: 24.562 MB Rows returned: 1

Duplicate queries: #15 #38 #39 #41 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting for group	0.02 ms
Sorting result	0.03 ms
executing	0.01 ms
Sending data	0.19 ms
Creating sort index	0.02 ms
removing tmp table	0.05 ms
Creating sort index	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
10	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
9	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:388
8	HelixUltimate\Framework\Platform\Helper::flushSettingsDataToJs()	JROOT/templates/shaper_helixultimate/index.php:50
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 9.55 ms Query memory: 0.068 MB Memory before query: 25.844 MB Rows returned: 1

Duplicate queries: #15 #38 #39 #40 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
10	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
9	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1058
8	HelixUltimate\Framework\Core\HelixUltimate->add_scss()	JROOT/templates/shaper_helixultimate/index.php:131
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.79 ms Query memory: 0.069 MB Memory before query: 25.951 MB Rows returned: 1

Duplicate queries: #15 #38 #39 #40 #41 #43 #44 #45 #46 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
12	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
11	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/templates/shaper_helixultimate/features/logo.php:54
10	HelixUltimateFeatureLogo->renderFeature()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:550
9	HelixUltimate\Framework\Core\HelixUltimate->include_features()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:568
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/shaper_helixultimate/index.php:156
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 1.48 ms Query memory: 0.070 MB Memory before query: 26.060 MB Rows returned: 1

Duplicate queries: #15 #38 #39 #40 #41 #42 #44 #45 #46 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 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.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
13	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
12	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/Classes/HelixultimateMenu.php:95
11	HelixUltimate\Framework\Core\Classes\HelixultimateMenu->__construct()	JROOT/templates/shaper_helixultimate/features/menu.php:79
10	HelixUltimateFeatureMenu->renderFeature()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:550
9	HelixUltimate\Framework\Core\HelixUltimate->include_features()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:568
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/shaper_helixultimate/index.php:156
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 6.34 ms Query memory: 0.073 MB Memory before query: 26.948 MB Rows returned: 1

Duplicate queries: #15 #38 #39 #40 #41 #42 #43 #45 #46 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:693
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:589
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/shaper_helixultimate/index.php:156
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.50 ms Query memory: 0.073 MB Memory before query: 26.958 MB Rows returned: 1

Duplicate queries: #15 #38 #39 #40 #41 #42 #43 #44 #46 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:693
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:589
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/shaper_helixultimate/index.php:156
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.73 ms Query memory: 0.073 MB Memory before query: 26.968 MB Rows returned: 1

Duplicate queries: #15 #38 #39 #40 #41 #42 #43 #44 #45 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.02 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.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:693
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:589
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/shaper_helixultimate/index.php:156
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.51 ms Query memory: 0.073 MB Memory before query: 26.978 MB Rows returned: 1

Duplicate queries: #15 #38 #39 #40 #41 #42 #43 #44 #45 #46 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:693
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:589
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/shaper_helixultimate/index.php:156
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.46 ms Query memory: 0.073 MB Memory before query: 26.988 MB Rows returned: 1

Duplicate queries: #15 #38 #39 #40 #41 #42 #43 #44 #45 #46 #47 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #64 #65 #66 #67 #68 #69 #70 #71 #72 #75

SELECT *

  FROM `y5bln_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y5bln_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:35
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:693
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:589
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/shaper_helixultimate/index.php:156
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.80 ms Query memory: 0.073 MB Memory before query: 27.000 MB Rows returned: 1
</

Folder Meeting Documents

Categories

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

75 Queries Logged 23.81 ms

34 duplicate found!