GAL Application - PDF

Published on 12 June 2013 By 345 2722 Downloads

Application to serve as a Guardian ad Litem in Cowlitz County Superior Court - in Adobe Acrobat portable document (PDF) format.

File Size:	463.67 KB
File Type:	application/pdf
Hits:	27547 Hits
Download:	2722 times
Created User:	345
Created Date:	06-12-2013
Last Updated Date:	11-13-2013

Resources Menu

Outside Links

TELEPHONE: (360) 577-3085
TTY (800) 883-6388 OR 7115
Superior Court Administration Hours: 8:30 AM - 4:30 PM

HALL OF JUSTICE

312 SW FIRST AVENUE, SUITE 250

KELSO, WA 98626

Building Hours - 8:00 AM - 5:00 PM

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1660632002,
                "last": 1660632002,
                "now": 1660632002
            },
            "token": "DSxq1VFbVExeGpxEwQbjGduWT3ZdgmUm"
        },
        "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": "106",
        "name": "",
        "email": "",
        "26c8d888ae3a5a06fee5c44ea695a562": "webmaster@CowlitzSuperiorCourt.us"
    }
}

Profile Information

Time

Memory

Time: 9.50 ms / 9.50 ms Memory: 2.444 MB / 2.81 MB Application: afterLoad

Time: 93.21 ms / 102.71 ms Memory: 5.667 MB / 8.48 MB Application: afterInitialise

Time: 16.04 ms / 118.76 ms Memory: 3.474 MB / 11.96 MB Application: Before Access::preloadComponents (all components)

Time: 1.47 ms / 120.23 ms Memory: 0.070 MB / 12.03 MB Application: After Access::preloadComponents (all components)

Time: 0.05 ms / 120.28 ms Memory: -0.004 MB / 12.02 MB Application: Before Access::getAssetRules (id:2851 name:com_dpcalendar)

Time: 0.37 ms / 120.65 ms Memory: 0.010 MB / 12.03 MB Application: After Access::getAssetRules (id:2851 name:com_dpcalendar)

Time: 1.12 ms / 121.76 ms Memory: 0.020 MB / 12.05 MB Application: Before Access::preloadPermissions (com_dpcalendar)

Time: 2.13 ms / 123.89 ms Memory: 0.163 MB / 12.22 MB Application: After Access::preloadPermissions (com_dpcalendar)

Time: 0.03 ms / 123.92 ms Memory: -0.011 MB / 12.20 MB Application: Before Access::getAssetRules (id:2896 name:com_dpcalendar.extcalendar.3)

Time: 0.01 ms / 123.93 ms Memory: 0.002 MB / 12.21 MB Application: After Access::getAssetRules (id:2896 name:com_dpcalendar.extcalendar.3)

Time: 0.14 ms / 124.08 ms Memory: 0.010 MB / 12.22 MB Application: Before Access::getAssetRules (id:2853 name:com_dpcalendar.extcalendar.1)

Time: 0.01 ms / 124.08 ms Memory: 0.002 MB / 12.22 MB Application: After Access::getAssetRules (id:2853 name:com_dpcalendar.extcalendar.1)

Time: 10.75 ms / 134.84 ms Memory: 2.794 MB / 15.01 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.05 ms / 134.89 ms Memory: 0.007 MB / 15.02 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 5.52 ms / 140.41 ms Memory: 0.131 MB / 15.15 MB Application: afterRoute

Time: 2.51 ms / 142.92 ms Memory: 0.435 MB / 15.58 MB Application: beforeRenderComponent com_edocman

Time: 8.54 ms / 151.46 ms Memory: 1.317 MB / 16.90 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.03 ms / 151.49 ms Memory: 0.003 MB / 16.90 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 0.02 ms / 151.51 ms Memory: 0.001 MB / 16.90 MB Application: Before Access::preloadPermissions (com_edocman)

Time: 2.58 ms / 154.09 ms Memory: 0.317 MB / 17.22 MB Application: After Access::preloadPermissions (com_edocman)

Time: 0.06 ms / 154.15 ms Memory: -0.019 MB / 17.20 MB Application: Before Access::getAssetRules (id:429 name:com_edocman.document.106)

Time: 0.06 ms / 154.21 ms Memory: 0.008 MB / 17.21 MB Application: After Access::getAssetRules (id:429 name:com_edocman.document.106)

Time: 9.45 ms / 163.66 ms Memory: 0.240 MB / 17.45 MB Application: Before Access::getAssetRules (id:256 name:com_edocman)

Time: 0.05 ms / 163.71 ms Memory: 0.008 MB / 17.46 MB Application: After Access::getAssetRules (id:256 name:com_edocman)

Time: 15.86 ms / 179.57 ms Memory: 0.691 MB / 18.15 MB Application: Before Access::getAssetRules (id:5 name:com_checkin)

Time: 0.05 ms / 179.63 ms Memory: 0.007 MB / 18.16 MB Application: After Access::getAssetRules (id:5 name:com_checkin)

Time: 0.02 ms / 179.65 ms Memory: 0.000 MB / 18.16 MB Application: Before Access::getAssetRules (id:6 name:com_config)

Time: 0.01 ms / 179.66 ms Memory: 0.002 MB / 18.16 MB Application: After Access::getAssetRules (id:6 name:com_config)

Time: 20.88 ms / 200.54 ms Memory: 0.773 MB / 18.93 MB Application: afterRenderComponent com_edocman

Time: 4.47 ms / 205.01 ms Memory: 0.827 MB / 19.76 MB Application: afterDispatch

Time: 26.90 ms / 231.91 ms Memory: 2.503 MB / 22.26 MB Application: beforeRenderModule mod_menu (Resources Menu)

Time: 2.63 ms / 234.54 ms Memory: 0.033 MB / 22.29 MB Application: afterRenderModule mod_menu (Resources Menu)

Time: 0.06 ms / 234.60 ms Memory: -0.001 MB / 22.29 MB Application: beforeRenderModule mod_menu (Outside Links)

Time: 0.95 ms / 235.55 ms Memory: 0.015 MB / 22.31 MB Application: afterRenderModule mod_menu (Outside Links)

Time: 0.04 ms / 235.59 ms Memory: -0.002 MB / 22.31 MB Application: beforeRenderModule mod_custom (Bottom Box 3 - Social)

Time: 0.77 ms / 236.36 ms Memory: 0.006 MB / 22.31 MB Application: afterRenderModule mod_custom (Bottom Box 3 - Social)

Time: 0.04 ms / 236.40 ms Memory: -0.000 MB / 22.31 MB Application: beforeRenderModule mod_custom (Bottom Box 4 - Contact)

Time: 0.36 ms / 236.76 ms Memory: 0.003 MB / 22.32 MB Application: afterRenderModule mod_custom (Bottom Box 4 - Contact)

Time: 4.33 ms / 241.09 ms Memory: 0.420 MB / 22.74 MB Application: beforeRenderModule mod_custom (round Logo)

Time: 0.46 ms / 241.55 ms Memory: 0.003 MB / 22.74 MB Application: afterRenderModule mod_custom (round Logo)

Time: 0.39 ms / 241.93 ms Memory: 0.029 MB / 22.77 MB Application: beforeRenderModule mod_gtranslate (Translate Our Site)

Time: 1.01 ms / 242.94 ms Memory: 0.099 MB / 22.87 MB Application: afterRenderModule mod_gtranslate (Translate Our Site)

Time: 0.56 ms / 243.50 ms Memory: -0.087 MB / 22.78 MB Application: beforeRenderModule mod_menu (Main Site Menu)

Time: 9.49 ms / 252.99 ms Memory: 0.948 MB / 23.73 MB Application: afterRenderModule mod_menu (Main Site Menu)

Time: 0.07 ms / 253.06 ms Memory: 0.003 MB / 23.73 MB Application: beforeRenderModule mod_sclogin (LogIn)

Time: 5.38 ms / 258.45 ms Memory: 0.452 MB / 24.18 MB Application: afterRenderModule mod_sclogin (LogIn)

Time: 4.63 ms / 263.08 ms Memory: 0.016 MB / 24.20 MB Application: beforeRenderModule mod_custom (Logo-small)

Time: 153.72 ms / 416.80 ms Memory: 0.842 MB / 25.04 MB Application: afterRenderModule mod_custom (Logo-small)

Time: 0.71 ms / 417.51 ms Memory: 0.000 MB / 25.04 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.14 ms / 418.66 ms Memory: 0.012 MB / 25.05 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.43 ms / 419.09 ms Memory: -0.003 MB / 25.05 MB Application: beforeRenderModule mod_custom (Covid 19 info)

Time: 0.49 ms / 419.58 ms Memory: 0.003 MB / 25.05 MB Application: afterRenderModule mod_custom (Covid 19 info)

Time: 0.03 ms / 419.61 ms Memory: 0.001 MB / 25.05 MB Application: beforeRenderModule mod_custom (Publication/legal notices)

Time: 0.37 ms / 419.97 ms Memory: 0.003 MB / 25.06 MB Application: afterRenderModule mod_custom (Publication/legal notices)

Time: 0.02 ms / 420.00 ms Memory: 0.001 MB / 25.06 MB Application: beforeRenderModule mod_custom (virus warning)

Time: 0.43 ms / 420.42 ms Memory: 0.003 MB / 25.06 MB Application: afterRenderModule mod_custom (virus warning)

Time: 2.32 ms / 422.74 ms Memory: 0.401 MB / 25.46 MB Application: beforeRenderModule mod_custom (Footer)

Time: 0.40 ms / 423.14 ms Memory: 0.003 MB / 25.46 MB Application: afterRenderModule mod_custom (Footer)

Time: 0.03 ms / 423.17 ms Memory: 0.001 MB / 25.47 MB Application: beforeRenderModule mod_custom (Statcounter - ONLY EDIT IN CODEMIRROR EDITOR)

Time: 0.39 ms / 423.56 ms Memory: 0.003 MB / 25.47 MB Application: afterRenderModule mod_custom (Statcounter - ONLY EDIT IN CODEMIRROR EDITOR)

Time: 0.39 ms / 423.95 ms Memory: 0.001 MB / 25.47 MB Application: beforeRenderModule mod_ebdarkmode (EB Dark Mode)

Time: 0.68 ms / 424.63 ms Memory: 0.013 MB / 25.48 MB Application: afterRenderModule mod_ebdarkmode (EB Dark Mode)

Time: 0.40 ms / 425.03 ms Memory: 0.002 MB / 25.48 MB Application: beforeRenderModule mod_menu (MobileMenu)

Time: 4.39 ms / 429.43 ms Memory: 0.011 MB / 25.50 MB Application: afterRenderModule mod_menu (MobileMenu)

Time: 15.02 ms / 444.45 ms Memory: 0.554 MB / 26.05 MB Application: afterRender

Database queries total: 112.08 ms

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

Error
The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

#	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 `da7g0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6562653036346332373036376131663838313665396635663438316265343035', 1, 1660632002, 0, '', 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.79 ms After last query: 1.32 ms Query memory: 0.042 MB Memory before query: 5.145 MB Rows returned: 52

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

  FROM `da7g0_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	da7g0_extensions	NULL	ref	extension	extension	82	const	56	1.00	Using where

Profile

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

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: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.41 ms After last query: 1.32 ms Query memory: 0.021 MB Memory before query: 5.206 MB Rows returned: 6

SELECT id, rules

  FROM `da7g0_viewlevels`

Explain

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

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.65 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 5.219 MB Rows returned: 1

SELECT b.id

  FROM da7g0_usergroups AS a

  LEFT JOIN da7g0_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

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

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: 1.26 ms After last query: 0.31 ms Query memory: 0.051 MB Memory before query: 5.241 MB Rows returned: 143

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

  FROM da7g0_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	da7g0_extensions	NULL	ref	extension	extension	82	const	244	0.40	Using index condition; Using where; Using filesort

Profile

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

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:351
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:356
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.64 ms After last query: 16.33 ms Query memory: 0.005 MB Memory before query: 7.818 MB

DELETE 

  FROM `da7g0_jhackguard_ip_filters`

  WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) 
  AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	da7g0_jhackguard_ip_filters	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	100.00	Using where

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/database.php:33
9	JDatabase->query()	JROOT/plugins/system/jhackguard/jhackguard.php:156
8	PlgSystemJhackguard->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.22 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 7.825 MB Rows returned: 0

SELECT `state`,`rule_type`

  FROM `da7g0_jhackguard_ip_filters`

  WHERE `ip` = '44.200.175.255' 
  AND `state` = 1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/jhackguard/jhackguard.php:358
9	PlgSystemJhackguard->ip_is()	JROOT/plugins/system/jhackguard/jhackguard.php:174
8	PlgSystemJhackguard->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: 44.74 ms After last query: 0.95 ms Query memory: 0.005 MB Memory before query: 8.133 MB

UPDATE da7g0_redirectonlogin_sessions 
  SET session_id='ebe064c27067a1f8816e9f5f481be405', unixtime='1660632002' 
  WHERE session_id='adopt_me'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	da7g0_redirectonlogin_sessions	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15676	100.00	Using where

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/database.php:33
9	JDatabase->query()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:120
8	plgSystemRedirectonlogin->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: 3.73 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 8.138 MB Rows returned: 0

SELECT *  
  FROM da7g0_redirectonlogin_sessions  
  WHERE session_id='ebe064c27067a1f8816e9f5f481be405'  
  LIMIT 1

Explain

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

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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:128
8	plgSystemRedirectonlogin->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: 3.86 ms After last query: 0.10 ms Query memory: 0.020 MB Memory before query: 8.143 MB Rows returned: 0

SELECT *  
  FROM da7g0_redirectonlogin_sessions  
  WHERE session_id='adopt_me'  
  AND ip='44.200.175.255'  
  LIMIT 1

Explain

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

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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:155
8	plgSystemRedirectonlogin->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.43 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 8.147 MB

INSERT INTO da7g0_redirectonlogin_sessions 
  SET session_id='ebe064c27067a1f8816e9f5f481be405', unixtime='1660632002'

Explain

EXPLAIN not possible on query: INSERT INTO da7g0_redirectonlogin_sessions SET session_id='ebe064c27067a1f8816e9f5f481be405', unixtime='1660632002'

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/database.php:33
9	JDatabase->query()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:174
8	plgSystemRedirectonlogin->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: 2.74 ms After last query: 4.95 ms Query memory: 0.415 MB Memory before query: 8.817 MB Rows returned: 286

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

  LEFT JOIN da7g0_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	414	7.66	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	cowlitzs_1.m.component_id	1	100.00	Using where

Profile

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

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:78
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:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:65
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:533
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:1141
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: 1.15 ms After last query: 12.25 ms Query memory: 0.031 MB Memory before query: 11.959 MB Rows returned: 53

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

  FROM `da7g0_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_advancedtemplates','com_ajax','com_akeeba','com_baforms','com_banners','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contactenhanced','com_content','com_contenthistory','com_contenttemplater','com_cpanel','com_docindexer','com_dpcalendar','com_easyblog','com_edocman','com_fields','com_finder','com_installer','com_jce','com_jhackguard','com_joomlaupdate','com_languages','com_login','com_m2c','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocafavicon','com_plugins','com_postinstall','com_privacy','com_pwtacl','com_redirect','com_redirectonlogin','com_search','com_slideshowck','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
23	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_dpcalendar/models/extcalendars.php:143
18	DPCalendarModelExtcalendars->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:294
15	DPCalendar\Plugin\DPCalendarPlugin->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:494
14	DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:91
10	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Rules/DPCalendarRules.php:58
9	DPCalendar\Router\Rules\DPCalendarRules->buildLookup()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:50
8	Joomla\CMS\Component\Router\Rules\MenuRules->__construct()	JROOT/components/com_dpcalendar/router.php:74
7	DPCalendarRouter->__construct()	JROOT/libraries/src/Router/SiteRouter.php:789
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.85 ms After last query: 0.69 ms Query memory: 0.027 MB Memory before query: 12.031 MB Rows returned: 3

SELECT a.*,ag.title AS access_level,l.title AS language_title

  FROM `da7g0_dpcalendar_extcalendars` AS a

  LEFT JOIN da7g0_viewlevels AS ag 
  ON ag.id = a.access

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

  WHERE a.state = 1 
  AND a.access IN (1,1) 
  AND a.plugin = 'exchange'

  ORDER BY a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_plugin,idx_state	idx_plugin	767	const	4	20.00	Using index condition; Using where; Using filesort
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	cowlitzs_1.a.access	1	100.00	Using where
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	func	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_dpcalendar/models/extcalendars.php:84
17	DPCalendarModelExtcalendars->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:294
15	DPCalendar\Plugin\DPCalendarPlugin->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:494
14	DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:91
10	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Rules/DPCalendarRules.php:58
9	DPCalendar\Router\Rules\DPCalendarRules->buildLookup()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:50
8	Joomla\CMS\Component\Router\Rules\MenuRules->__construct()	JROOT/components/com_dpcalendar/router.php:74
7	DPCalendarRouter->__construct()	JROOT/libraries/src/Router/SiteRouter.php:789
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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: 1.79 ms After last query: 0.22 ms Query memory: 0.040 MB Memory before query: 12.055 MB Rows returned: 173

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

  FROM `da7g0_assets`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
20	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:320
15	DPCalendar\Plugin\DPCalendarPlugin->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:494
14	DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:91
10	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Rules/DPCalendarRules.php:58
9	DPCalendar\Router\Rules\DPCalendarRules->buildLookup()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:50
8	Joomla\CMS\Component\Router\Rules\MenuRules->__construct()	JROOT/components/com_dpcalendar/router.php:74
7	DPCalendarRouter->__construct()	JROOT/libraries/src/Router/SiteRouter.php:789
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.64 ms After last query: 1.32 ms Query memory: 0.023 MB Memory before query: 12.264 MB Rows returned: 0

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

  FROM `da7g0_categories` AS `s`

  INNER JOIN `da7g0_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = -1

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:64
10	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Rules/DPCalendarRules.php:58
9	DPCalendar\Router\Rules\DPCalendarRules->buildLookup()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:50
8	Joomla\CMS\Component\Router\Rules\MenuRules->__construct()	JROOT/components/com_dpcalendar/router.php:74
7	DPCalendarRouter->__construct()	JROOT/libraries/src/Router/SiteRouter.php:789
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.71 ms After last query: 5.56 ms Query memory: 0.021 MB Memory before query: 14.596 MB Rows returned: 1

SELECT `query`

  FROM da7g0_edocman_urls

  WHERE md5_key="eebd3ebf86758f8645d603a1ed1d6e5d"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/components/com_edocman/router.php:351
9	EdocmanRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
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:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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: 1.55 ms After last query: 3.81 ms Query memory: 0.023 MB Memory before query: 15.026 MB Rows returned: 10

SELECT s.*

  FROM da7g0_template_styles as s

  WHERE s.client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	11	90.91	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedtemplates/src/Document.php:193
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyles()	JROOT/plugins/system/advancedtemplates/src/Document.php:121
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.36 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 15.039 MB Rows returned: 1

SELECT a.params

  FROM da7g0_advancedtemplates AS a

  WHERE a.styleid = 20

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.24 ms After last query: 0.99 ms Query memory: 0.024 MB Memory before query: 15.063 MB Rows returned: 1

SELECT a.params

  FROM da7g0_advancedtemplates AS a

  WHERE a.styleid = 48

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.14 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 15.081 MB Rows returned: 1

SELECT a.params

  FROM da7g0_advancedtemplates AS a

  WHERE a.styleid = 52

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.18 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 15.092 MB Rows returned: 1

SELECT a.params

  FROM da7g0_advancedtemplates AS a

  WHERE a.styleid = 87

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.12 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 15.108 MB Rows returned: 1

SELECT a.params

  FROM da7g0_advancedtemplates AS a

  WHERE a.styleid = 88

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.10 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 15.125 MB Rows returned: 1

SELECT a.params

  FROM da7g0_advancedtemplates AS a

  WHERE a.styleid = 95

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.09 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 15.133 MB Rows returned: 1

SELECT a.params

  FROM da7g0_advancedtemplates AS a

  WHERE a.styleid = 96

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.08 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 15.141 MB Rows returned: 1

SELECT a.params

  FROM da7g0_advancedtemplates AS a

  WHERE a.styleid = 97

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.10 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 15.149 MB Rows returned: 1

SELECT a.params

  FROM da7g0_advancedtemplates AS a

  WHERE a.styleid = 98

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:533
8	RegularLabs\Library\SystemPlugin->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.30 ms After last query: 0.53 ms Query memory: 0.022 MB Memory before query: 15.170 MB Rows returned: 1

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

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
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.33 ms After last query: 0.15 ms Query memory: 0.005 MB Memory before query: 15.161 MB

UPDATE `da7g0_extensions`

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

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

Explain

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

Profile

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

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.26 ms After last query: 0.90 ms Query memory: 0.019 MB Memory before query: 15.576 MB Rows returned: 1

SELECT *

  FROM da7g0_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	da7g0_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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.60 ms After last query: 3.00 ms Query memory: 0.031 MB Memory before query: 16.047 MB Rows returned: 151

SELECT * 
  FROM da7g0_edocman_configs

Explain

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

Profile

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

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:594
9	EDocmanHelper::getConfig()	JROOT/components/com_edocman/controller/controller.php:35
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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.80 ms After last query: 4.27 ms Query memory: 0.025 MB Memory before query: 16.889 MB Rows returned: 1

SELECT *

  FROM da7g0_edocman_documents

  WHERE id = 106

Explain

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

Profile

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

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:967
11	EDocmanHelper::canAccessDocument()	JROOT/components/com_edocman/view/document/html.php:47
10	EDocmanViewDocumentHtml->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:363
9	OSController->display()	JROOT/components/com_edocman/controller/controller.php:46
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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: 1.98 ms After last query: 0.21 ms Query memory: 0.071 MB Memory before query: 16.908 MB Rows returned: 341

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

  FROM `da7g0_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	da7g0_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	2939	20.86	Using where

Profile

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

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:1014
11	EDocmanHelper::canAccessDocument()	JROOT/components/com_edocman/view/document/html.php:47
10	EDocmanViewDocumentHtml->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:363
9	OSController->display()	JROOT/components/com_edocman/controller/controller.php:46
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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.42 ms After last query: 0.87 ms Query memory: 0.023 MB Memory before query: 17.207 MB Rows returned: 1

SELECT *,DATEDIFF('2022-08-16 06:40:02', created_time) AS number_created_days,DATEDIFF('2022-08-16 06:40:02', modified_time) AS number_updated_days

  FROM da7g0_edocman_documents

  WHERE id = 106

Explain

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

Profile

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

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:68
10	EDocmanViewDocumentHtml->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:363
9	OSController->display()	JROOT/components/com_edocman/controller/controller.php:46
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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.48 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 17.218 MB Rows returned: 2

SELECT category_id, is_main_category

  FROM da7g0_edocman_document_category

  WHERE document_id=106

Explain

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

Profile

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

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:68
10	EDocmanViewDocumentHtml->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:363
9	OSController->display()	JROOT/components/com_edocman/controller/controller.php:46
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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.07 ms Query memory: 0.006 MB Memory before query: 17.224 MB

UPDATE da7g0_edocman_documents

  SET hits = hits + 1

  WHERE id=106

Explain

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

Profile

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

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:81
10	EDocmanViewDocumentHtml->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:363
9	OSController->display()	JROOT/components/com_edocman/controller/controller.php:46
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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.19 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 17.230 MB Rows returned: 1

SELECT category_id

  FROM da7g0_edocman_document_category AS a

  WHERE document_id=106 
  AND is_main_category=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	document_id	document_id	5	const	3	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_edocman/view/document/html.php:93
10	EDocmanViewDocumentHtml->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:363
9	OSController->display()	JROOT/components/com_edocman/controller/controller.php:46
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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.48 ms After last query: 0.71 ms Query memory: 0.023 MB Memory before query: 17.232 MB Rows returned: 26

SELECT id, title, parent_id

  FROM da7g0_edocman_categories

  WHERE published=1

Explain

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

Profile

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

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:358
11	EDocmanHelper::getCategoriesBreadcrumb()	JROOT/components/com_edocman/view/document/html.php:104
10	EDocmanViewDocumentHtml->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:363
9	OSController->display()	JROOT/components/com_edocman/controller/controller.php:46
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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.18 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 17.239 MB Rows returned: 26

SELECT id, alias, parent_id

  FROM da7g0_edocman_categories

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_edocman/helper/route.php:183
12	EDocmanHelperRoute::getCategoriesPath()	JROOT/components/com_edocman/helper/route.php:107
11	EDocmanHelperRoute::getCategoryRoute()	JROOT/components/com_edocman/view/document/html.php:108
10	EDocmanViewDocumentHtml->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:363
9	OSController->display()	JROOT/components/com_edocman/controller/controller.php:46
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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.21 ms Query memory: 0.023 MB Memory before query: 17.262 MB Rows returned: 1

Duplicate queries: #65

SELECT *

  FROM da7g0_edocman_categories

  WHERE id=19

Explain

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

Profile

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

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:221
11	EDocmanHelper::getCategory()	JROOT/components/com_edocman/view/document/html.php:118
10	EDocmanViewDocumentHtml->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:363
9	OSController->display()	JROOT/components/com_edocman/controller/controller.php:46
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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.15 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 17.270 MB Rows returned: 1

Duplicate queries: #68

SELECT file_size, document_url

  FROM da7g0_edocman_documents

  WHERE id = '106'

Explain

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

Profile

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

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/file.class.php:77
11	EDocman_File->EDocman_File()	JROOT/components/com_edocman/view/document/html.php:139
10	EDocmanViewDocumentHtml->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:363
9	OSController->display()	JROOT/components/com_edocman/controller/controller.php:46
8	EDocmanController->display()	JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:301
7	OSController->execute()	JROOT/components/com_edocman/edocman.php:39
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: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.15 ms After last query: 0.15 ms Query memory: 0.006 MB Memory before query: 17.277 MB

GAL Application - PDF

Related documents

Resources Menu

Outside Links

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

124 Queries Logged 112.08 ms

19 duplicate found!