CD's are available by contacting us at: This email address is being protected from spambots. You need JavaScript enabled to view it.

Forgive and Forget

HCC 04-06-14 Forgive and Forget - part 1

HCC 04-27-14 Forgive and Forget - part 2

CCofVa. © 2005; 2006; 2007; 2008; 2009; 2010; 2011; 2012; 2013; 2014; 2015; 2016; 2017; 2018

Blacksburg
Tuesdays 7 P.M.

Harrisonburg
Sundays 10 A.M.

Roanoke
Sundays 6 p.m.

Bible Study
Wednesdays 7 P.M.
Hollins Library

Bible Study
Thursdays 7 P.M.
Bridgewater, Va.

Sign up for classes HERE

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 615.27 ms / 615.27 ms Memory: 1.327 MB / 1.46 MB Application: afterLoad

Time: 1760.19 ms / 2375.46 ms Memory: 3.001 MB / 4.46 MB Application: afterInitialise

Time: 682.07 ms / 3057.53 ms Memory: 0.846 MB / 5.31 MB Application: afterRoute

Time: 62.81 ms / 3120.35 ms Memory: 0.235 MB / 5.54 MB Application: beforeRenderComponent com_content

Time: 203.14 ms / 3323.48 ms Memory: 0.386 MB / 5.93 MB Application: Before Access::preloadComponents (all components)

Time: 2.19 ms / 3325.67 ms Memory: 0.055 MB / 5.99 MB Application: After Access::preloadComponents (all components)

Time: 0.06 ms / 3325.73 ms Memory: 0.000 MB / 5.98 MB Application: Before Access::preloadPermissions (com_content)

Time: 2.02 ms / 3327.76 ms Memory: 0.087 MB / 6.07 MB Application: After Access::preloadPermissions (com_content)

Time: 0.07 ms / 3327.83 ms Memory: 0.000 MB / 6.07 MB Application: Before Access::getAssetRules (id:117 name:com_content.article.51)

Time: 17.62 ms / 3345.45 ms Memory: 0.028 MB / 6.09 MB Application: After Access::getAssetRules (id:117 name:com_content.article.51)

Time: 2085.11 ms / 5430.56 ms Memory: 2.516 MB / 8.61 MB Application: afterRenderComponent com_content

Time: 96.20 ms / 5526.76 ms Memory: 0.087 MB / 8.70 MB Application: afterDispatch

Time: 197.33 ms / 5724.09 ms Memory: 0.134 MB / 8.83 MB Application: beforeRenderModule mod_custom (Service Times)

Time: 52.84 ms / 5776.93 ms Memory: 0.026 MB / 8.86 MB Application: afterRenderModule mod_custom (Service Times)

Time: 0.36 ms / 5777.29 ms Memory: 0.000 MB / 8.86 MB Application: beforeRenderModule mod_custom (CC Banner)

Time: 47.39 ms / 5824.68 ms Memory: 0.029 MB / 8.89 MB Application: afterRenderModule mod_custom (CC Banner)

Time: 0.27 ms / 5824.95 ms Memory: 0.000 MB / 8.89 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 800.87 ms / 6625.81 ms Memory: 0.391 MB / 9.28 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 422.17 ms / 7047.99 ms Memory: 0.090 MB / 9.37 MB Application: afterRender

Database queries total: 35.74 ms

Memory Usage

Database Queries

23 Queries Logged 35.74 ms

Query Time: 2.03 ms

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = 'f9q7r7hoqa5ueqvqual1euugh7'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 2.44 ms After last query: 90.51 ms

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = 'f9q7r7hoqa5ueqvqual1euugh7' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT\libraries\src\Session\MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT\libraries\src\Application\CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

Query Time: 2.31 ms After last query: 0.37 ms

INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('f9q7r7hoqa5ueqvqual1euugh7', 1, 1553250494, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('f9q7r7hoqa5ueqvqual1euugh7', 1, 1553250494, 0, '', 0)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.01 ms
update	0.24 ms
Waiting for query cache lock	0.00 ms
update	0.01 ms
end	0.00 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 2.15 ms After last query: 97.31 ms

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

  FROM `jos_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	38	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Component\ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Component\ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT\libraries\src\Component\ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT\libraries\src\Component\ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT\libraries\src\Component\ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT\libraries\src\Application\SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.75 ms After last query: 59.73 ms

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.61 ms After last query: 0.26 ms

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 13

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.92 ms After last query: 4.65 ms

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

  FROM jos_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	106	Using where; Using filesort

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.56 ms
Sending data	0.51 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.09 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Plugin\PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Plugin\PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 2.94 ms After last query: 678.66 ms

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	73	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	joomla_e0.m.component_id	1

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Menu\SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Menu\SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT\libraries\src\Menu\AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT\libraries\src\Menu\SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT\libraries\src\Menu\AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT\libraries\src\Application\SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT\libraries\src\Router\SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT\libraries\src\Router\Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT\libraries\src\Application\SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT\libraries\src\Application\CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.83 ms After last query: 617.50 ms

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

  FROM `jos_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1656
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:1119
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.74 ms After last query: 0.44 ms

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"987059052475b4208b5a9fe056690bea\"}'

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.06 ms
Updating	0.08 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->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:1119
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.87 ms After last query: 34.97 ms

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.89 ms After last query: 2.15 ms

SELECT id, home, template, s.params

  FROM jos_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	joomla_e0.s.template,const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Application\SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT\libraries\src\Application\SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.51 ms After last query: 210.44 ms

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

  FROM `jos_assets`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT\libraries\src\Access\Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT\components\com_content\models\article.php:58
11	ContentModelArticle->populateState()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT\components\com_content\models\article.php:251
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.35 ms After last query: 0.55 ms

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

  FROM `jos_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	107	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT\libraries\src\Access\Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT\components\com_content\models\article.php:58
11	ContentModelArticle->populateState()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT\components\com_content\models\article.php:251
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.77 ms After last query: 46.86 ms

SHOW FULL COLUMNS 
  FROM `jos_content`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.22 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.08 ms
closing tables	0.00 ms
freeing items	0.07 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT\libraries\src\Table\Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT\libraries\src\Table\Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT\components\com_content\models\article.php:253
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.92 ms After last query: 124.26 ms

SELECT *

  FROM jos_content

  WHERE `id` = '51'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT\components\com_content\models\article.php:254
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.87 ms After last query: 0.35 ms

UPDATE jos_content

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

  WHERE `id` = '51'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.03 ms
Updating	0.09 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.11 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT\libraries\src\Table\Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT\components\com_content\models\article.php:255
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.74 ms After last query: 160.82 ms

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

  FROM jos_content AS a

  INNER JOIN jos_categories AS c 
  on c.id = a.catid

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

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

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

  WHERE a.id = 51 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-03-22 10:28:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-03-22 10:28:16') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT\components\com_content\models\article.php:151
12	ContentModelArticle->getItem()	JROOT\libraries\src\MVC\View\HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\components\com_content\views\article\view.html.php:42
10	ContentViewArticle->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 0.94 ms After last query: 53.99 ms

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

  FROM `jos_contentitem_tag_map` AS m 

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	joomla_e0.m.tag_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Helper\TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT\components\com_content\views\article\view.html.php:184
10	ContentViewArticle->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 2.21 ms After last query: 371.56 ms

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 `jos_categories` AS `s`

  INNER JOIN `jos_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_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	2	Using where

Profile

Status	Duration
starting	0.25 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.40 ms
optimizing	0.04 ms
statistics	0.23 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.13 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.13 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Categories\Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT\libraries\src\Categories\Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT\administrator\components\com_fields\models\fields.php:203
18	FieldsModelFields->getListQuery()	JROOT\libraries\src\MVC\Model\ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT\libraries\src\MVC\Model\ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:135
15	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:488
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:193
10	ContentViewArticle->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.45 ms After last query: 13.39 ms

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM jos_fields AS a

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

  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out

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

  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `jos_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	joomla_e0.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	joomla_e0.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	joomla_e0.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	joomla_e0.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	joomla_e0.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	joomla_e0.a.id	1	Using where; Using index

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
System lock	0.01 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.06 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:333
17	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:135
15	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:488
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:193
10	ContentViewArticle->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.81 ms After last query: 1437.06 ms

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

  FROM jos_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-03-22 10:28:16') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-03-22 10:28:16') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 152 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	7	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	joomla_e0.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	joomla_e0.m.module,const	1	Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.00 ms
Sorting result	0.13 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.11 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\ModuleHelper.php:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT\libraries\src\Helper\ModuleHelper.php:362
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT\libraries\src\Helper\ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT\libraries\src\Document\HtmlDocument.php:581
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT\templates\ccofva\index.php:51
7	require JROOT\templates\ccofva\index.php	JROOT\libraries\src\Document\HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

Query Time: 1.68 ms After last query: 258.32 ms

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM jos_fields AS a

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

  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out

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

  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `jos_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'mod_custom.content' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	joomla_e0.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	joomla_e0.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	joomla_e0.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	joomla_e0.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	joomla_e0.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	joomla_e0.a.id	1	Using where; Using index

Profile

Status	Duration
starting	0.20 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
System lock	0.01 ms
init	0.09 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.00 ms
Sorting result	0.04 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.07 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:333
21	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:135
19	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:488
18	PlgSystemFields->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\libraries\cms\html\content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\modules\mod_custom\mod_custom.php:15
10	include JROOT\modules\mod_custom\mod_custom.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

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

2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
 
  FROM jos_fields AS a
 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language
 
  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out
 
  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access
 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id
 
  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id
 
  LEFT JOIN `jos_fields_categories` AS fc 
  ON fc.field_id = a.id

```
1 × SELECT *
 
  FROM jos_content
```

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

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

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

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

```
1 × SELECT *
 
  FROM jos_languages
```

1 × SELECT id, rules
 
  FROM `jos_viewlevels

1 × SELECT `session_id`
 
  FROM `jos_session`

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

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

1 × SELECT `data`
 
  FROM `jos_session`

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

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

OTHER Tables:

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

1 × SHOW FULL COLUMNS 
  FROM `jos_content

1 × UPDATE `jos_extensions`
 
  SET `params` = '{\"mediaversion\":\"987059052475b4208b5a9fe056690bea\"}'

1 × INSERT INTO `jos_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 ('f9q7r7hoqa5ueqvqual1euugh7', 1, 1553250494, 0, '', 0