Judge Gary Bashor

Search for a Staff Member

Judges

Superior Court Department 1

Hall of Justice
312 SW First Avenue, Suite 250
Kelso Washington 98626

About

May 2011 - present. Judge Bashor previously served as a Court Commissioner for Superior Court.

He graduated with a Bachelor of Science degree from Lewis and Clark College and received his law degree from Lewis and Clark College of Law.

Judge Bashor received his Mediation Certificate from the National Judicial College in 2009.

He Chairs the Superior Court Judges Association Technology Committee. He is a voting member of State Superior Court Case Management Software Project (SC-CMS) Steering Committee. He served on the Washington State Child Support Workgroup in 2011.

Judge Bashor is Superior Court's Presiding Judge for 2019-2020.

Judicial Assistant: Breann Braaten - BraatenB@co.cowlitz.wa.us

- 360.577.3155

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": 1660636376,
                "last": 1660636376,
                "now": 1660636376
            },
            "token": "AeOcra36kKASa85dmzIoCw9VQ4FWLD97"
        },
        "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
        },
        "3a0fbab0db30a8b5c4b19949368cec23": "BraatenB@co.cowlitz.wa.us",
        "26c8d888ae3a5a06fee5c44ea695a562": "webmaster@CowlitzSuperiorCourt.us"
    }
}

Profile Information

Time

Memory

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

Time: 77.84 ms / 85.71 ms Memory: 5.662 MB / 8.48 MB Application: afterInitialise

Time: 12.98 ms / 98.69 ms Memory: 3.474 MB / 11.95 MB Application: Before Access::preloadComponents (all components)

Time: 1.16 ms / 99.85 ms Memory: 0.070 MB / 12.02 MB Application: After Access::preloadComponents (all components)

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

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

Time: 0.83 ms / 101.01 ms Memory: 0.020 MB / 12.05 MB Application: Before Access::preloadPermissions (com_dpcalendar)

Time: 1.93 ms / 102.94 ms Memory: 0.163 MB / 12.21 MB Application: After Access::preloadPermissions (com_dpcalendar)

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

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

Time: 0.10 ms / 103.07 ms Memory: 0.010 MB / 12.21 MB Application: Before Access::getAssetRules (id:2853 name:com_dpcalendar.extcalendar.1)

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

Time: 10.77 ms / 113.84 ms Memory: 2.882 MB / 15.10 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.04 ms / 113.88 ms Memory: 0.007 MB / 15.10 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 3.54 ms / 117.42 ms Memory: 0.512 MB / 15.61 MB Application: afterRoute

Time: 2.18 ms / 119.61 ms Memory: 0.091 MB / 15.71 MB Application: beforeRenderComponent com_contactenhanced

Time: 14.85 ms / 134.46 ms Memory: 1.791 MB / 17.50 MB Application: Before Access::getAssetRules (id:1537 name:com_contactenhanced)

Time: 0.04 ms / 134.50 ms Memory: 0.008 MB / 17.50 MB Application: After Access::getAssetRules (id:1537 name:com_contactenhanced)

Time: 164.92 ms / 299.42 ms Memory: 3.693 MB / 21.20 MB Application: Before Access::preloadPermissions (com_contactenhanced)

Time: 2.01 ms / 301.43 ms Memory: 0.026 MB / 21.22 MB Application: After Access::preloadPermissions (com_contactenhanced)

Time: 0.03 ms / 301.46 ms Memory: -0.001 MB / 21.22 MB Application: Before Access::getAssetRules (id:1539 name:com_contactenhanced.category.107)

Time: 0.01 ms / 301.47 ms Memory: 0.002 MB / 21.22 MB Application: After Access::getAssetRules (id:1539 name:com_contactenhanced.category.107)

Time: 37.64 ms / 339.11 ms Memory: 2.007 MB / 23.23 MB Application: afterRenderComponent com_contactenhanced

Time: 3.30 ms / 342.41 ms Memory: 0.185 MB / 23.42 MB Application: afterDispatch

Time: 3.71 ms / 346.12 ms Memory: 0.858 MB / 24.27 MB Application: beforeRenderModule mod_menu (Resources Menu)

Time: 2.08 ms / 348.21 ms Memory: 0.042 MB / 24.32 MB Application: afterRenderModule mod_menu (Resources Menu)

Time: 0.03 ms / 348.24 ms Memory: -0.001 MB / 24.32 MB Application: beforeRenderModule mod_menu (Outside Links)

Time: 0.75 ms / 348.99 ms Memory: 0.013 MB / 24.33 MB Application: afterRenderModule mod_menu (Outside Links)

Time: 0.03 ms / 349.02 ms Memory: -0.002 MB / 24.33 MB Application: beforeRenderModule mod_custom (Bottom Box 3 - Social)

Time: 0.59 ms / 349.61 ms Memory: 0.389 MB / 24.72 MB Application: afterRenderModule mod_custom (Bottom Box 3 - Social)

Time: 0.03 ms / 349.64 ms Memory: -0.000 MB / 24.72 MB Application: beforeRenderModule mod_custom (Bottom Box 4 - Contact)

Time: 0.39 ms / 350.03 ms Memory: 0.003 MB / 24.72 MB Application: afterRenderModule mod_custom (Bottom Box 4 - Contact)

Time: 0.07 ms / 350.10 ms Memory: 0.004 MB / 24.72 MB Application: beforeRenderModule mod_ce_search (Search for a Staff Member)

Time: 4.34 ms / 354.43 ms Memory: 0.017 MB / 24.74 MB Application: afterRenderModule mod_ce_search (Search for a Staff Member)

Time: 3.56 ms / 357.99 ms Memory: 0.039 MB / 24.78 MB Application: beforeRenderModule mod_custom (round Logo)

Time: 0.38 ms / 358.37 ms Memory: 0.004 MB / 24.78 MB Application: afterRenderModule mod_custom (round Logo)

Time: 0.29 ms / 358.66 ms Memory: 0.029 MB / 24.81 MB Application: beforeRenderModule mod_gtranslate (Translate Our Site)

Time: 0.78 ms / 359.44 ms Memory: 0.482 MB / 25.29 MB Application: afterRenderModule mod_gtranslate (Translate Our Site)

Time: 0.43 ms / 359.86 ms Memory: -0.087 MB / 25.21 MB Application: beforeRenderModule mod_menu (Main Site Menu)

Time: 5.27 ms / 365.13 ms Memory: 0.216 MB / 25.42 MB Application: afterRenderModule mod_menu (Main Site Menu)

Time: 0.04 ms / 365.17 ms Memory: 0.003 MB / 25.43 MB Application: beforeRenderModule mod_sclogin (LogIn)

Time: 3.52 ms / 368.69 ms Memory: 0.444 MB / 25.87 MB Application: afterRenderModule mod_sclogin (LogIn)

Time: 4.44 ms / 373.13 ms Memory: 0.009 MB / 25.88 MB Application: beforeRenderModule mod_custom (Logo-small)

Time: 1.59 ms / 374.72 ms Memory: 0.017 MB / 25.90 MB Application: afterRenderModule mod_custom (Logo-small)

Time: 0.86 ms / 375.58 ms Memory: 0.384 MB / 26.28 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.92 ms / 376.50 ms Memory: 0.012 MB / 26.29 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.40 ms / 376.90 ms Memory: 0.015 MB / 26.31 MB Application: beforeRenderModule mod_menu (Admin Quicklinks)

Time: 1.74 ms / 378.63 ms Memory: 0.067 MB / 26.37 MB Application: afterRenderModule mod_menu (Admin Quicklinks)

Time: 0.03 ms / 378.66 ms Memory: -0.000 MB / 26.37 MB Application: beforeRenderModule mod_menu (Juvenile Quicklinks)

Time: 6.66 ms / 385.33 ms Memory: 0.281 MB / 26.65 MB Application: afterRenderModule mod_menu (Juvenile Quicklinks)

Time: 0.05 ms / 385.38 ms Memory: -0.003 MB / 26.65 MB Application: beforeRenderModule mod_menu (Policy Quicklinks)

Time: 1.36 ms / 386.73 ms Memory: 0.416 MB / 27.07 MB Application: afterRenderModule mod_menu (Policy Quicklinks)

Time: 3.51 ms / 390.24 ms Memory: 0.008 MB / 27.08 MB Application: beforeRenderModule mod_custom (Covid 19 info)

Time: 0.34 ms / 390.58 ms Memory: 0.003 MB / 27.08 MB Application: afterRenderModule mod_custom (Covid 19 info)

Time: 0.02 ms / 390.61 ms Memory: 0.001 MB / 27.08 MB Application: beforeRenderModule mod_custom (Publication/legal notices)

Time: 0.34 ms / 390.95 ms Memory: 0.003 MB / 27.08 MB Application: afterRenderModule mod_custom (Publication/legal notices)

Time: 0.02 ms / 390.97 ms Memory: 0.001 MB / 27.08 MB Application: beforeRenderModule mod_custom (virus warning)

Time: 0.31 ms / 391.28 ms Memory: 0.003 MB / 27.09 MB Application: afterRenderModule mod_custom (virus warning)

Time: 0.02 ms / 391.30 ms Memory: 0.001 MB / 27.09 MB Application: beforeRenderModule mod_custom (Interpreter Link)

Time: 0.29 ms / 391.59 ms Memory: 0.003 MB / 27.09 MB Application: afterRenderModule mod_custom (Interpreter Link)

Time: 0.04 ms / 391.63 ms Memory: 0.012 MB / 27.10 MB Application: beforeRenderModule mod_easybloglatestblogs (Latest News "From the Bench")

Time: 1.12 ms / 392.74 ms Memory: 0.048 MB / 27.15 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.09 ms / 392.83 ms Memory: 0.002 MB / 27.15 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 55.71 ms / 448.54 ms Memory: 7.418 MB / 34.57 MB Application: afterRenderModule mod_easybloglatestblogs (Latest News "From the Bench")

Time: 2.27 ms / 450.81 ms Memory: -0.270 MB / 34.30 MB Application: beforeRenderModule mod_custom (Footer)

Time: 0.39 ms / 451.20 ms Memory: 0.014 MB / 34.31 MB Application: afterRenderModule mod_custom (Footer)

Time: 0.02 ms / 451.22 ms Memory: 0.001 MB / 34.31 MB Application: beforeRenderModule mod_custom (Statcounter - ONLY EDIT IN CODEMIRROR EDITOR)

Time: 0.32 ms / 451.54 ms Memory: 0.659 MB / 34.97 MB Application: afterRenderModule mod_custom (Statcounter - ONLY EDIT IN CODEMIRROR EDITOR)

Time: 0.34 ms / 451.88 ms Memory: 0.002 MB / 34.98 MB Application: beforeRenderModule mod_ebdarkmode (EB Dark Mode)

Time: 0.93 ms / 452.82 ms Memory: 0.014 MB / 34.99 MB Application: afterRenderModule mod_ebdarkmode (EB Dark Mode)

Time: 0.38 ms / 453.19 ms Memory: 0.017 MB / 35.01 MB Application: beforeRenderModule mod_menu (MobileMenu)

Time: 3.99 ms / 457.19 ms Memory: 0.011 MB / 35.02 MB Application: afterRenderModule mod_menu (MobileMenu)

Time: 16.74 ms / 473.93 ms Memory: 0.784 MB / 35.80 MB Application: afterRender

Database queries total: 99.51 ms

Memory Usage

Database Queries

139 Queries Logged 99.51 ms

40 duplicate found!

2 duplicates: #57 #119

2 duplicates: #58 #120

2 duplicates: #60 #121

5 duplicates: #63 #79 #88 #97 #106

5 duplicates: #64 #80 #89 #98 #110

2 duplicates: #73 #122

2 duplicates: #74 #123

2 duplicates: #76 #124

2 duplicates: #82 #125

2 duplicates: #83 #126

2 duplicates: #85 #127

2 duplicates: #91 #128

2 duplicates: #92 #129

2 duplicates: #94 #130

2 duplicates: #100 #131

2 duplicates: #101 #132

2 duplicates: #103 #133

Query Time: 0.23 ms Query memory: 0.020 MB Memory before query: 4.802 MB Rows returned: 0

SELECT `session_id`

  FROM `da7g0_session`

  WHERE `session_id` = X'3963386232376466356264663661386432306561326532613136386366303532' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	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

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

Query Time: 0.41 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 4.807 MB

INSERT INTO `da7g0_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3963386232376466356264663661386432306561326532613136386366303532', 1, 1660636376, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `da7g0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3963386232376466356264663661386432306561326532613136386366303532', 1, 1660636376, 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.53 ms After last query: 1.32 ms Query memory: 0.042 MB Memory before query: 5.144 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.21 ms After last query: 1.27 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.22 ms After last query: 0.08 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.03 ms After last query: 0.27 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.23 ms After last query: 15.38 ms Query memory: 0.021 MB Memory before query: 7.818 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: 37.45 ms After last query: 0.53 ms Query memory: 0.005 MB Memory before query: 8.127 MB

UPDATE da7g0_redirectonlogin_sessions 
  SET session_id='9c8b27df5bdf6a8d20ea2e2a168cf052', unixtime='1660636376' 
  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	15647	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.31 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 8.132 MB Rows returned: 0

SELECT *  
  FROM da7g0_redirectonlogin_sessions  
  WHERE session_id='9c8b27df5bdf6a8d20ea2e2a168cf052'  
  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	15647	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.02 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 8.138 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	15647	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.26 ms After last query: 0.04 ms Query memory: 0.005 MB Memory before query: 8.143 MB

INSERT INTO da7g0_redirectonlogin_sessions 
  SET session_id='9c8b27df5bdf6a8d20ea2e2a168cf052', unixtime='1660636376'

Explain

EXPLAIN not possible on query: INSERT INTO da7g0_redirectonlogin_sessions SET session_id='9c8b27df5bdf6a8d20ea2e2a168cf052', unixtime='1660636376'

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.33 ms After last query: 3.88 ms Query memory: 0.415 MB Memory before query: 8.812 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: 0.92 ms After last query: 9.78 ms Query memory: 0.031 MB Memory before query: 11.954 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.65 ms After last query: 0.52 ms Query memory: 0.027 MB Memory before query: 12.026 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.65 ms After last query: 0.16 ms Query memory: 0.040 MB Memory before query: 12.050 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.53 ms After last query: 1.00 ms Query memory: 0.022 MB Memory before query: 12.257 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.44 ms After last query: 6.47 ms Query memory: 0.024 MB Memory before query: 14.660 MB Rows returned: 3

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_contactenhanced' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 107

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	4	11.54	Using index condition; 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/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/components/com_contactenhanced/router.php:161
10	ContactenhancedParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->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: 0.34 ms After last query: 3.32 ms Query memory: 0.023 MB Memory before query: 15.108 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.20 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 15.120 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.15 ms After last query: 0.97 ms Query memory: 0.024 MB Memory before query: 15.527 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.12 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 15.546 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.10 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 15.556 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.09 ms Query memory: 0.024 MB Memory before query: 15.573 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.09 ms Query memory: 0.024 MB Memory before query: 15.590 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.08 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 15.598 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.605 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.07 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 15.613 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.26 ms After last query: 0.37 ms Query memory: 0.022 MB Memory before query: 15.638 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.26 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 15.629 MB

UPDATE `da7g0_extensions`

  SET `params` = '{\"mediaversion\":\"9f8c1aadc304f6f31d187aa8619acfc7\"}'

  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.22 ms After last query: 0.87 ms Query memory: 0.019 MB Memory before query: 15.687 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.99 ms After last query: 15.19 ms Query memory: 0.041 MB Memory before query: 17.506 MB Rows returned: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.params as cat_params,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM da7g0_ce_details AS a

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

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

  WHERE a.id = 5 
  AND (a.published = 1 OR a.published =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_contactenhanced/models/contact.php:100
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:39
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:286
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:51
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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.39 ms After last query: 0.66 ms Query memory: 0.023 MB Memory before query: 17.555 MB Rows returned: 0

SELECT `t`.`id`

  FROM `da7g0_tags` AS t 

  INNER JOIN `da7g0_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_contactenhanced.contact' 
  AND `m`.`content_item_id` IN ( 5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	23	4.35	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	cowlitzs_1.m.tag_id	1	100.00	Using index

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:1550
14	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Helper/TagsHelper.php:506
13	Joomla\CMS\Helper\TagsHelper->getTagIds()	JROOT/components/com_contactenhanced/models/contact.php:134
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:39
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:286
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:51
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.07 ms Query memory: 0.041 MB Memory before query: 17.570 MB Rows returned: 1

SELECT a.*, cc.access as category_access, cc.title as category_name,  
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM da7g0_ce_details AS a

  INNER JOIN da7g0_categories AS cc 
  on cc.id = a.catid

  WHERE a.id = 5 
  AND a.published IN (1,2) 
  AND cc.published IN (1,2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	cc	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_contactenhanced/models/contact.php:221
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:165
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:39
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:286
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:51
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 17.604 MB Rows returned: 0

SELECT a.id,a.title,a.state,a.access,a.catid,a.created,a.language, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug

  FROM da7g0_content as a

  LEFT JOIN da7g0_categories as c 
  on a.catid=c.id

  WHERE a.created_by = 346 
  AND a.state IN (1,2)

  ORDER BY a.state DESC, a.created DESC 
  LIMIT 10

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_createdby	idx_createdby	4	const	1	29.24	Using index condition; Using where; Using filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	cowlitzs_1.a.catid	1	100.00	Using where

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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_contactenhanced/models/contact.php:287
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:165
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:39
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:286
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:51
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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.56 ms After last query: 1.11 ms Query memory: 0.029 MB Memory before query: 18.018 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `da7g0_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
17	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_users/models/user.php:65
16	UsersModelUser->getTable()	JROOT/libraries/src/MVC/Model/AdminModel.php:971
15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:90
14	UsersModelUser->getItem()	JROOT/components/com_contactenhanced/models/contact.php:294
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:165
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:39
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:286
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:51
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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.22 ms After last query: 0.45 ms Query memory: 0.025 MB Memory before query: 18.052 MB Rows returned: 1

SELECT *

  FROM `da7g0_users`

  WHERE `id` = 346

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	da7g0_users	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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/MVC/Model/AdminModel.php:976
15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:90
14	UsersModelUser->getItem()	JROOT/components/com_contactenhanced/models/contact.php:294
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:165
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:39
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:286
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:51
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.77 ms Query memory: 0.025 MB Memory before query: 18.450 MB Rows returned: 6

SELECT `g`.`id`,`g`.`title`

  FROM `da7g0_usergroups` AS g

  INNER JOIN `da7g0_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 346

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	6	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cowlitzs_1.m.group_id	1	100.00	NULL

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:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/MVC/Model/AdminModel.php:976
15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:90
14	UsersModelUser->getItem()	JROOT/components/com_contactenhanced/models/contact.php:294
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:165
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:39
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:286
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:51
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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.39 ms After last query: 1.48 ms Query memory: 0.131 MB Memory before query: 18.984 MB Rows returned: 2

SELECT *

  FROM da7g0_easyblog_configs

  WHERE `name` = 'config'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	da7g0_easyblog_configs	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	16.67	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:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
18	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:581
17	EB::config()	JROOT/plugins/user/easyblogusers/easyblogusers.php:31
16	plgUserEasyBlogUsers->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
15	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
14	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_contactenhanced/models/contact.php:295
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:165
12	ContactenhancedModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:39
10	ContactenhancedViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contactenhanced/controller.php:286
8	ContactenhancedController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:51
6	require_once JROOT/components/com_contactenhanced/contactenhanced.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.91 ms After last query: 3.64 ms

Search for a Staff Member