Palo Alto Neighborhoods Map

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1761847551,
                "last": 1761847551,
                "now": 1761847551
            },
            "token": "s4Qx9S8bmKD3osNtafVC1xhEvCtivc86"
        },
        "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
        },
        "viewed_doc_ids": "97"
    }
}

Profile Information

Time

Memory

Time: 14.13 ms / 14.13 ms Memory: 1.796 MB / 2.17 MB Application: afterLoad

Time: 79.67 ms / 93.80 ms Memory: 5.354 MB / 7.52 MB Application: afterInitialise

Time: 69.15 ms / 162.95 ms Memory: 2.930 MB / 10.46 MB Application: afterRoute

Time: 0.35 ms / 163.31 ms Memory: 0.009 MB / 10.46 MB Application: beforeRenderComponent com_edocman

Time: 12.96 ms / 176.27 ms Memory: 1.074 MB / 11.54 MB Application: Before Access::preloadComponents (all components)

Time: 0.77 ms / 177.04 ms Memory: 0.065 MB / 11.60 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 177.06 ms Memory: 0.000 MB / 11.60 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.33 ms / 177.40 ms Memory: 0.033 MB / 11.63 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 0.02 ms / 177.42 ms Memory: 0.001 MB / 11.63 MB Application: Before Access::preloadPermissions (com_edocman)

Time: 0.79 ms / 178.21 ms Memory: 0.169 MB / 11.80 MB Application: After Access::preloadPermissions (com_edocman)

Time: 0.02 ms / 178.23 ms Memory: 0.000 MB / 11.79 MB Application: Before Access::getAssetRules (id:423 name:com_edocman.document.97)

Time: 0.04 ms / 178.27 ms Memory: 0.007 MB / 11.80 MB Application: After Access::getAssetRules (id:423 name:com_edocman.document.97)

Time: 29.35 ms / 207.62 ms Memory: 0.620 MB / 12.42 MB Application: Before Access::getAssetRules (id:5 name:com_checkin)

Time: 0.06 ms / 207.68 ms Memory: 0.007 MB / 12.42 MB Application: After Access::getAssetRules (id:5 name:com_checkin)

Time: 2.53 ms / 210.22 ms Memory: 0.000 MB / 12.41 MB Application: afterRenderComponent com_edocman

Time: 7.11 ms / 217.33 ms Memory: 0.460 MB / 12.87 MB Application: afterDispatch

Time: 9.33 ms / 226.66 ms Memory: 0.383 MB / 13.25 MB Application: beforeRenderModule mod_custom (Copyright)

Time: 0.98 ms / 227.64 ms Memory: 0.049 MB / 13.30 MB Application: afterRenderModule mod_custom (Copyright)

Time: 0.07 ms / 227.71 ms Memory: 0.000 MB / 13.30 MB Application: beforeRenderModule mod_custom (Understanding Prop 13)

Time: 0.24 ms / 227.95 ms Memory: 0.003 MB / 13.30 MB Application: afterRenderModule mod_custom (Understanding Prop 13)

Time: 0.03 ms / 227.98 ms Memory: 0.000 MB / 13.30 MB Application: beforeRenderModule mod_menu (Quick Links)

Time: 2.79 ms / 230.76 ms Memory: 0.121 MB / 13.42 MB Application: afterRenderModule mod_menu (Quick Links)

Time: 0.04 ms / 230.80 ms Memory: 0.000 MB / 13.42 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 0.24 ms / 231.04 ms Memory: 0.003 MB / 13.42 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 0.05 ms / 231.10 ms Memory: 0.000 MB / 13.42 MB Application: beforeRenderModule mod_custom (Google Search)

Time: 0.20 ms / 231.30 ms Memory: 0.003 MB / 13.43 MB Application: afterRenderModule mod_custom (Google Search)

Time: 0.02 ms / 231.32 ms Memory: 0.000 MB / 13.43 MB Application: beforeRenderModule mod_custom (Multi Language Bar)

Time: 0.19 ms / 231.51 ms Memory: 0.003 MB / 13.43 MB Application: afterRenderModule mod_custom (Multi Language Bar)

Time: 0.04 ms / 231.56 ms Memory: 0.002 MB / 13.43 MB Application: beforeRenderModule mod_custom (Social Media)

Time: 0.18 ms / 231.74 ms Memory: 0.003 MB / 13.43 MB Application: afterRenderModule mod_custom (Social Media)

Time: 0.04 ms / 231.78 ms Memory: 0.000 MB / 13.43 MB Application: beforeRenderModule mod_menu (Top SCC Menu)

Time: 0.94 ms / 232.72 ms Memory: 0.008 MB / 13.44 MB Application: afterRenderModule mod_menu (Top SCC Menu)

Time: 38.37 ms / 271.09 ms Memory: 2.334 MB / 15.78 MB Application: afterRender

Database queries total: 86.16 ms

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

#	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:660
9	Joomla\CMS\Session\Session->_start()	JROOT\libraries\src\Session\Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT\libraries\src\Session\Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT\libraries\src\Session\Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT\libraries\src\Application\CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
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:344
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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	asr_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

EXPLAIN not possible on query: INSERT INTO `asr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6d6266626d64636f6e6562667461326838756a64617535693634', 1, 1761847551, 0, '', 0)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
update	0.48 ms
end	0.00 ms
query end	23.06 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.02 ms

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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
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:344
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.82 ms After last query: 2.64 ms Query memory: 0.040 MB Memory before query: 4.272 MB Rows returned: 42

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

  FROM `asr_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	asr_extensions	NULL	ref	extension	extension	82	const	48	1.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Component\ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Component\ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT\libraries\src\Component\ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT\libraries\src\Component\ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT\libraries\src\Component\ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT\libraries\src\Application\SiteApplication.php:594
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:196
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.35 ms After last query: 1.87 ms Query memory: 0.021 MB Memory before query: 4.477 MB Rows returned: 5

SELECT id, rules

  FROM `asr_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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:321
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:196
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.10 ms Query memory: 0.021 MB Memory before query: 4.489 MB Rows returned: 1

SELECT b.id

  FROM asr_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php: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:321
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:196
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: 1.16 ms After last query: 0.57 ms Query memory: 0.035 MB Memory before query: 4.558 MB Rows returned: 136

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM asr_extensions

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

  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Plugin\PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Plugin\PluginHelper.php:359
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:196
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.60 ms After last query: 9.00 ms Query memory: 0.020 MB Memory before query: 5.643 MB Rows returned: 1

SELECT `enabled`

  FROM `asr_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT\plugins\system\backuponupdate\backuponupdate.php:50
7	require_once JROOT\plugins\system\backuponupdate\backuponupdate.php	JROOT\libraries\src\Plugin\PluginHelper.php:253
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:625
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:196
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: 2.74 ms After last query: 24.24 ms Query memory: 0.181 MB Memory before query: 7.772 MB Rows returned: 197

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM asr_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	404	8.24	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	asrpubnew.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Menu\SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Menu\SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT\libraries\src\Menu\AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT\libraries\src\Menu\SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT\libraries\src\Menu\AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT\libraries\src\Application\SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT\libraries\src\Router\SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT\libraries\src\Router\Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT\libraries\src\Application\SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT\libraries\src\Application\CMSApplication.php:1073
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:196
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: 1.52 ms After last query: 11.26 ms Query memory: 0.021 MB Memory before query: 9.179 MB Rows returned: 1

SELECT `query`

  FROM asr_edocman_urls

  WHERE md5_key="8bf1f6a42f0a920e919c39cc0f67ec0f"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	asr_edocman_urls	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	421	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT\components\com_edocman\router.php:268
10	EDocmanParseRoute()	JROOT\libraries\src\Component\Router\RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT\libraries\src\Router\SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT\libraries\src\Router\Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT\libraries\src\Router\Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT\libraries\src\Router\SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT\libraries\src\Application\CMSApplication.php:1074
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:196
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.81 ms After last query: 0.34 ms Query memory: 0.100 MB Memory before query: 9.187 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM asr_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	2	2.50	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	asrpubnew.e.element	1	88.89	Using index condition; Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.43 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 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\libraries\src\Application\SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT\plugins\system\t3\includes\core\t3.php:310
9	T3::detect()	JROOT\plugins\system\t3\t3.php:81
8	plgSystemT3->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:1122
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:196
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: 4.28 ms Query memory: 0.024 MB Memory before query: 9.467 MB Rows returned: 1

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

  FROM `asr_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	asr_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 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\libraries\src\Helper\LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT\libraries\src\Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT\plugins\system\k2\k2.php:374
8	plgSystemK2->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:1122
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:196
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: 25.66 ms After last query: 0.13 ms Query memory: 0.006 MB Memory before query: 9.459 MB

UPDATE `asr_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.06 ms
updating	0.51 ms
end	0.01 ms
query end	24.84 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Helper\LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT\libraries\src\Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT\libraries\src\Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT\plugins\system\k2\k2.php:374
8	plgSystemK2->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:1122
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:196
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.41 ms After last query: 3.59 ms Query memory: 0.022 MB Memory before query: 9.827 MB Rows returned: 1

SELECT *

  FROM asr_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Language\LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT\libraries\src\Application\SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT\components\com_k2\helpers\utilities.php:248
10	K2HelperUtilities::getParams()	JROOT\administrator\components\com_k2\helpers\html.php:244
9	K2HelperHTML::loadHeadIncludes()	JROOT\plugins\system\k2\k2.php:390
8	plgSystemK2->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:1122
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:196
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.69 ms After last query: 22.74 ms Query memory: 0.030 MB Memory before query: 11.089 MB Rows returned: 86

SELECT * 
  FROM asr_edocman_configs

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT\components\com_edocman\helper\helper.php:533
9	EDocmanHelper::getConfig()	JROOT\components\com_edocman\controller\controller.php:34
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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.48 ms After last query: 4.68 ms Query memory: 0.023 MB Memory before query: 11.466 MB Rows returned: 1

SELECT *

  FROM asr_edocman_documents

  WHERE id = 97

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT\components\com_edocman\helper\helper.php:796
11	EDocmanHelper::canAccessDocument()	JROOT\components\com_edocman\view\document\html.php:41
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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.60 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 11.547 MB Rows returned: 42

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

  FROM `asr_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_edocman','com_fields','com_finder','com_fsf','com_installer','com_jce','com_jevents','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT\libraries\src\Access\Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT\components\com_edocman\helper\helper.php:803
11	EDocmanHelper::canAccessDocument()	JROOT\components\com_edocman\view\document\html.php:41
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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.60 ms After last query: 0.49 ms Query memory: 0.055 MB Memory before query: 11.634 MB Rows returned: 171

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

  FROM `asr_assets`

  WHERE `name` LIKE 'com_edocman.%' OR `name` = 'com_edocman' OR `parent_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	asr_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	582	21.38	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT\libraries\src\Access\Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT\components\com_edocman\helper\helper.php:825
11	EDocmanHelper::canAccessDocument()	JROOT\components\com_edocman\view\document\html.php:41
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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.28 ms Query memory: 0.023 MB Memory before query: 11.794 MB Rows returned: 1

SELECT *,DATEDIFF('2025-10-30 18:05:51', created_time) AS number_created_days

  FROM asr_edocman_documents

  WHERE id = 97

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.04 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\components\com_edocman\model\document.php:34
13	EDocmanModelDocument->loadData()	JROOT\administrator\components\com_edocman\libraries\rad\model\item.php:43
12	OSModelItem->getData()	JROOT\administrator\components\com_edocman\model\common\document.php:28
11	EDocmanModelCommonDocument->getData()	JROOT\components\com_edocman\view\document\html.php:62
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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.18 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 11.804 MB Rows returned: 1

SELECT category_id, is_main_category

  FROM asr_edocman_document_category

  WHERE document_id=97

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	asr_edocman_document_category	NULL	ref	document_id	document_id	5	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_edocman\model\common\document.php:37
11	EDocmanModelCommonDocument->getData()	JROOT\components\com_edocman\view\document\html.php:62
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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: 10.00 ms After last query: 0.05 ms Query memory: 0.006 MB Memory before query: 11.810 MB

UPDATE asr_edocman_documents

  SET hits = hits + 1

  WHERE id=97

Explain

EXPLAIN not possible on query: UPDATE asr_edocman_documents SET hits = hits + 1 WHERE id=97

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.02 ms
updating	0.47 ms
end	0.00 ms
query end	9.32 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT\components\com_edocman\model\document.php:60
11	EDocmanModelDocument->hitCounter()	JROOT\components\com_edocman\view\document\html.php:75
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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.35 ms After last query: 1.27 ms Query memory: 0.022 MB Memory before query: 11.843 MB Rows returned: 7

SELECT id, title, parent_id

  FROM asr_edocman_categories

  WHERE published=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	asr_edocman_categories	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	14.29	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT\components\com_edocman\helper\helper.php:350
11	EDocmanHelper::getCategoriesBreadcrumb()	JROOT\components\com_edocman\view\document\html.php:98
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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.19 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 11.850 MB Rows returned: 1

SELECT file_size

  FROM asr_edocman_documents

  WHERE id = '97'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT\components\com_edocman\helper\file.class.php:74
11	EDocman_File->EDocman_File()	JROOT\components\com_edocman\view\document\html.php:115
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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: 7.62 ms After last query: 5.07 ms Query memory: 0.025 MB Memory before query: 12.254 MB Rows returned: 7

SELECT id, alias, parent_id

  FROM asr_edocman_categories

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT\components\com_edocman\helper\route.php:184
15	EDocmanHelperRoute::getCategoriesPath()	JROOT\components\com_edocman\helper\route.php:47
14	EDocmanHelperRoute::getDocumentRoute()	JROOT\components\com_edocman\view\document\tmpl\default.php:14
13	include JROOT\components\com_edocman\view\document\tmpl\default.php	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:207
12	OSViewHtml->render()	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:113
11	OSViewHtml->display()	JROOT\components\com_edocman\view\document\html.php:177
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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: 0.35 ms Query memory: 0.027 MB Memory before query: 12.269 MB Rows returned: 1

SELECT alias

  FROM asr_edocman_documents

  WHERE id=97

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT\components\com_edocman\helper\route.php:164
22	EDocmanHelperRoute::getDocumentTitle()	JROOT\components\com_edocman\router.php:110
21	EDocmanBuildRoute()	JROOT\libraries\src\Component\Router\RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT\libraries\src\Router\SiteRouter.php:528
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT\libraries\src\Router\SiteRouter.php:498
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT\libraries\src\Router\Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT\libraries\src\Router\Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT\components\com_edocman\view\document\tmpl\default.php:14
13	include JROOT\components\com_edocman\view\document\tmpl\default.php	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:207
12	OSViewHtml->render()	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:113
11	OSViewHtml->display()	JROOT\components\com_edocman\view\document\html.php:177
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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: 1.22 ms After last query: 1.79 ms Query memory: 0.026 MB Memory before query: 12.396 MB Rows returned: 1

SELECT id

  FROM asr_edocman_urls

  WHERE md5_key="8bf1f6a42f0a920e919c39cc0f67ec0f"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	asr_edocman_urls	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	421	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT\components\com_edocman\router.php:223
21	EDocmanBuildRoute()	JROOT\libraries\src\Component\Router\RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT\libraries\src\Router\SiteRouter.php:528
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT\libraries\src\Router\SiteRouter.php:498
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT\libraries\src\Router\Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT\libraries\src\Router\Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT\components\com_edocman\view\document\tmpl\default.php:14
13	include JROOT\components\com_edocman\view\document\tmpl\default.php	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:207
12	OSViewHtml->render()	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:113
11	OSViewHtml->display()	JROOT\components\com_edocman\view\document\html.php:177
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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.22 ms After last query: 0.06 ms Query memory: 0.010 MB Memory before query: 12.408 MB

UPDATE asr_edocman_urls

  SET `query`="view=document&id=97&catid=6"

  WHERE md5_key="8bf1f6a42f0a920e919c39cc0f67ec0f" 
  AND id=206

Explain

EXPLAIN not possible on query: UPDATE asr_edocman_urls SET `query`="view=document&id=97&catid=6" WHERE md5_key="8bf1f6a42f0a920e919c39cc0f67ec0f" AND id=206

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\components\com_edocman\router.php:230
21	EDocmanBuildRoute()	JROOT\libraries\src\Component\Router\RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT\libraries\src\Router\SiteRouter.php:528
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT\libraries\src\Router\SiteRouter.php:498
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT\libraries\src\Router\Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT\libraries\src\Router\Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT\components\com_edocman\view\document\tmpl\default.php:14
13	include JROOT\components\com_edocman\view\document\tmpl\default.php	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:207
12	OSViewHtml->render()	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:113
11	OSViewHtml->display()	JROOT\components\com_edocman\view\document\html.php:177
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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: 1.20 ms After last query: 1.11 ms Query memory: 0.026 MB Memory before query: 12.463 MB Rows returned: 1

SELECT id

  FROM asr_edocman_urls

  WHERE md5_key="d8153db16bc9f64e3f77b9d6cd0083de"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	asr_edocman_urls	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	421	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT\components\com_edocman\router.php:223
21	EDocmanBuildRoute()	JROOT\libraries\src\Component\Router\RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT\libraries\src\Router\SiteRouter.php:528
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT\libraries\src\Router\SiteRouter.php:498
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT\libraries\src\Router\Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT\libraries\src\Router\Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT\components\com_edocman\view\document\tmpl\default.php:320
13	include JROOT\components\com_edocman\view\document\tmpl\default.php	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:207
12	OSViewHtml->render()	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:113
11	OSViewHtml->display()	JROOT\components\com_edocman\view\document\html.php:177
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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.06 ms Query memory: 0.010 MB Memory before query: 12.475 MB

UPDATE asr_edocman_urls

  SET `query`="task=document.download&id=97"

  WHERE md5_key="d8153db16bc9f64e3f77b9d6cd0083de" 
  AND id=207

Explain

EXPLAIN not possible on query: UPDATE asr_edocman_urls SET `query`="task=document.download&id=97" WHERE md5_key="d8153db16bc9f64e3f77b9d6cd0083de" AND id=207

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\components\com_edocman\router.php:230
21	EDocmanBuildRoute()	JROOT\libraries\src\Component\Router\RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT\libraries\src\Router\SiteRouter.php:528
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT\libraries\src\Router\SiteRouter.php:498
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT\libraries\src\Router\Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
16	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT\libraries\src\Router\Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT\components\com_edocman\view\document\tmpl\default.php:320
13	include JROOT\components\com_edocman\view\document\tmpl\default.php	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:207
12	OSViewHtml->render()	JROOT\administrator\components\com_edocman\libraries\rad\view\html.php:113
11	OSViewHtml->display()	JROOT\components\com_edocman\view\document\html.php:177
10	EDocmanViewDocumentHtml->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:360
9	OSController->display()	JROOT\components\com_edocman\controller\controller.php:46
8	EDocmanController->display()	JROOT\administrator\components\com_edocman\libraries\rad\controller\controller.php:302
7	OSController->execute()	JROOT\components\com_edocman\edocman.php:30
6	require_once JROOT\components\com_edocman\edocman.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:196
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: 1.39 ms After last query: 12.88 ms Query memory: 0.027 MB Memory before query: 13.220 MB Rows returned: 9

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

  FROM asr_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-10-30 18:05:51') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-10-30 18:05:51') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 936 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
18	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:442
16	JModuleHelper::getModuleList()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:378
15	JModuleHelper::load()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:84
14	JModuleHelper::getModules()	JROOT\libraries\src\Document\HtmlDocument.php:591
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT\plugins\system\t3\includes\core\template.php:624
12	T3Template->countModules()	JROOT\templates\cepon\tpls\blocks\header.php:23
11	include JROOT\templates\cepon\tpls\blocks\header.php	JROOT\plugins\system\t3\includes\core\template.php:195
10	T3Template->loadBlock()	JROOT\templates\cepon\tpls\default.php:32
9	include JROOT\templates\cepon\tpls\default.php	JROOT\plugins\system\t3\includes\core\template.php:221
8	T3Template->loadLayout()	JROOT\templates\cepon\index.php:38
7	require JROOT\templates\cepon\index.php	JROOT\libraries\src\Document\HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1030
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:202
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: 30.63 ms Query memory: 0.025 MB Memory before query: 15.633 MB Rows returned: 80

SELECT * 
  FROM asr_acymailing_config

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.27 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.07 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\administrator\components\com_acymailing\classes\cpanel.php:17
10	cpanelClass->load()	JROOT\administrator\components\com_acymailing\helpers\helper.php:473
9	acymailing_config()	JROOT\administrator\components\com_acymailing\helpers\helper.php:1183
8	include_once JROOT\administrator\components\com_acymailing\helpers\helper.php	JROOT\plugins\system\regacymailing\regacymailing.php:139
7	plgSystemRegacymailing->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1050
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:202
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.]

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT `id`,`name`,`rules`,`parent_id`
 
  FROM `asr_assets`

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

2 × SELECT id
 
  FROM asr_edocman_urls

1 × SELECT `data`
 
  FROM `asr_session`

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

1 × SELECT alias
 
  FROM asr_edocman_documents

1 × SELECT id, alias, parent_id
 
  FROM asr_edocman_categorie

1 × SELECT file_size
 
  FROM asr_edocman_documents

1 × SELECT id, title, parent_id
 
  FROM asr_edocman_categories

1 × SELECT category_id, is_main_category
 
  FROM asr_edocman_document_category

1 × SELECT *,DATEDIFF('2025-10-30 18:05:51', created_time) AS number_created_days
 
  FROM asr_edocman_documents

1 × SELECT * 
  FROM asr_edocman_config

1 × SELECT *
 
  FROM asr_edocman_documents

1 × SELECT `session_id`
 
  FROM `asr_session`

```
1 × SELECT *
 
  FROM asr_languages
```

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

1 × SELECT `query`
 
  FROM asr_edocman_urls

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
 
  FROM asr_menu AS m
 
  LEFT JOIN asr_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `enabled`
 
  FROM `asr_extensions`

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
 
  FROM asr_extensions

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

1 × SELECT id, rules
 
  FROM `asr_viewlevels

1 × SELECT * 
  FROM asr_acymailing_confi

OTHER Tables:

1 × INSERT INTO `asr_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 (X'6d6266626d64636f6e6562667461326838756a64617535693634', 1, 1761847551, 0, '', 0

1 × UPDATE `asr_extensions`
 
  SET `params` = '{\"mediaversion\":\"baea85b99d4fea776e63039883a7e925\"}'

1 × UPDATE asr_edocman_documents
 
  SET hits = hits + 1

1 × UPDATE asr_edocman_urls
 
  SET `query`="view=document&id=97&catid=6"

1 × UPDATE asr_edocman_urls
 
  SET `query`="task=document.download&id=97"

File Name:	2011 Palo Alto Neighborhoods.pdf
File Size:	3.07 MB
File Type:	application/pdf

Quick Links

Contact Us

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

31 Queries Logged 86.16 ms

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: