Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1594113400,
                "last": 1594113400,
                "now": 1594113400
            },
            "token": "FXlCrpekxTc62Zc1KmJHJ0qY0XBzAM4W"
        },
        "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": [
                "1"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 16.67 ms / 16.67 ms Memory: 0.595 MB / 0.80 MB Application: afterLoad

Time: 80.91 ms / 97.58 ms Memory: 4.609 MB / 5.41 MB Application: afterInitialise

Time: 35.81 ms / 133.40 ms Memory: 1.510 MB / 6.92 MB Application: afterRoute

Time: 5.15 ms / 138.54 ms Memory: 0.247 MB / 7.17 MB Application: beforeRenderComponent com_contact

Time: 229.33 ms / 367.88 ms Memory: 5.403 MB / 12.57 MB Application: afterRenderComponent com_contact

Time: 1.06 ms / 368.93 ms Memory: 0.007 MB / 12.58 MB Application: afterDispatch

Time: 36.22 ms / 405.16 ms Memory: 0.616 MB / 13.19 MB Application: beforeRenderModule mod_ja_acm (banner-horizontal)

Time: 6.25 ms / 411.40 ms Memory: 0.171 MB / 13.36 MB Application: afterRenderModule mod_ja_acm (banner-horizontal)

Time: 1.39 ms / 412.80 ms Memory: 0.000 MB / 13.35 MB Application: beforeRenderModule mod_ja_acm (Footer)

Time: 3.31 ms / 416.11 ms Memory: 0.039 MB / 13.39 MB Application: afterRenderModule mod_ja_acm (Footer)

Time: 1.24 ms / 417.35 ms Memory: 0.000 MB / 13.37 MB Application: beforeRenderModule mod_menu (TÌM HIỂU VỀ CHÚNG TÔI)

Time: 5.01 ms / 422.36 ms Memory: 0.131 MB / 13.50 MB Application: afterRenderModule mod_menu (TÌM HIỂU VỀ CHÚNG TÔI)

Time: 1.63 ms / 423.99 ms Memory: 0.000 MB / 13.49 MB Application: beforeRenderModule mod_articles_popular (CÁC BÀI VIẾT - ĐƯỢC ĐỌC NHIỀU NHẤT)

Time: 23.62 ms / 447.61 ms Memory: 0.600 MB / 14.09 MB Application: afterRenderModule mod_articles_popular (CÁC BÀI VIẾT - ĐƯỢC ĐỌC NHIỀU NHẤT)

Time: 1.54 ms / 449.15 ms Memory: 0.000 MB / 14.02 MB Application: beforeRenderModule mod_custom (Sidebar Banners)

Time: 2.05 ms / 451.20 ms Memory: 0.010 MB / 14.03 MB Application: afterRenderModule mod_custom (Sidebar Banners)

Time: 1.26 ms / 452.46 ms Memory: 0.000 MB / 14.03 MB Application: beforeRenderModule mod_ja_acm (Header)

Time: 5.67 ms / 458.13 ms Memory: 0.078 MB / 14.11 MB Application: beforeRenderModule mod_menu (Tructuyenslots)

Time: 6.57 ms / 464.70 ms Memory: 0.060 MB / 14.17 MB Application: afterRenderModule mod_menu (Tructuyenslots)

Time: 3.05 ms / 467.75 ms Memory: 0.101 MB / 14.27 MB Application: afterRenderModule mod_ja_acm (Header)

Time: 0.49 ms / 468.25 ms Memory: 0.000 MB / 14.24 MB Application: beforeRenderModule mod_facebook_slide_likebox (Facebook Likebox Slider)

Time: 7.16 ms / 475.40 ms Memory: 0.263 MB / 14.50 MB Application: afterRenderModule mod_facebook_slide_likebox (Facebook Likebox Slider)

Time: 81.00 ms / 556.40 ms Memory: 0.299 MB / 14.80 MB Application: afterRender

Database queries total: 50.46 ms

Memory Usage

Database Queries

23 Queries Logged 50.46 ms

3 duplicate found!

3 duplicates: #11 #15 #16

Query Time: 0.99 ms Query memory: 0.018 MB Memory before query: 2.700 MB Rows returned: 0

SELECT `data`

  FROM `tau02_session`

  WHERE `session_id` = 'ipho1hpgpaemhuqdl4pp5gnmh3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tau02_session	const	PRIMARY	PRIMARY	575	const	1	100.00	NULL

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.13 ms
init	0.06 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.27 ms
executing	0.03 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:258
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:748
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.50 ms After last query: 3.28 ms Query memory: 0.012 MB Memory before query: 2.904 MB Rows returned: 0

SELECT `session_id`

  FROM `tau02_session`

  WHERE `session_id` = 'ipho1hpgpaemhuqdl4pp5gnmh3' 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tau02_session	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 7.29 ms After last query: 0.18 ms Query memory: 0.009 MB Memory before query: 2.916 MB

INSERT INTO `tau02_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('ipho1hpgpaemhuqdl4pp5gnmh3', 0, '1594113400')

Explain

EXPLAIN not possible on query: INSERT INTO `tau02_session` (`session_id`, `client_id`, `time`) VALUES ('ipho1hpgpaemhuqdl4pp5gnmh3', 0, '1594113400')

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
update	0.28 ms
end	0.01 ms
query end	6.62 ms
closing tables	0.04 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:208
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.93 ms After last query: 7.68 ms Query memory: 0.014 MB Memory before query: 3.426 MB Rows returned: 1

SELECT b.id

  FROM tau02_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:423
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->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: 0.88 ms Query memory: 0.013 MB Memory before query: 3.483 MB Rows returned: 4

SELECT id, rules

  FROM `tau02_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:440
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.78 ms After last query: 33.39 ms Query memory: 0.028 MB Memory before query: 5.644 MB Rows returned: 11

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

  LEFT JOIN tau02_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	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	33	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	tructuye_db.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1097
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 6.40 ms After last query: 4.78 ms Query memory: 0.018 MB Memory before query: 5.951 MB

UPDATE `tau02_extensions`

  SET `params` = '{\"mediaversion\":\"20559b75473921886be259ab98b23da2\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tau02_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.16 ms
updating	0.14 ms
end	0.02 ms
query end	5.74 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/betterpreview/betterpreview.php:34
9	PlgSystemBetterPreview->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.85 ms After last query: 61.66 ms Query memory: 0.024 MB Memory before query: 8.217 MB Rows returned: 1

SELECT a.rules

  FROM tau02_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
15	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
14	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:439
13	JModelLegacy->getState()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:65
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->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: 1.03 ms Query memory: 0.025 MB Memory before query: 8.273 MB Rows returned: 2

SELECT b.rules

  FROM tau02_assets AS a

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

  WHERE (a.name = 'com_contact')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	18	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.16 ms
preparing	0.03 ms
Creating tmp table	0.11 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.88 ms
Creating sort index	0.10 ms
end	0.01 ms
removing tmp table	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
14	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:439
13	JModelLegacy->getState()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:65
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.15 ms After last query: 0.53 ms Query memory: 0.034 MB Memory before query: 8.308 MB Rows returned: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 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,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM tau02_contact_details AS a

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

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

  WHERE a.id = 11 
  AND (a.published = 1 OR a.published =2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-07-07 09:16:40') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-07-07 09:16:40')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
14	JDatabaseDriver->loadObject()	JROOT/components/com_contact/models/contact.php:194
13	ContactModelContact->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 2.86 ms Query memory: 0.028 MB Memory before query: 8.518 MB Rows returned: 0

Duplicate queries: #15 #16

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

  FROM `tau02_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 11 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
14	JHelperTags->getItemTags()	JROOT/components/com_contact/models/contact.php:218
13	ContactModelContact->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.42 ms After last query: 14.78 ms Query memory: 0.034 MB Memory before query: 9.022 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `tau02_users`

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.44 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.05 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/user.php:38
19	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:305
18	JTable::getInstance()	JROOT/administrator/components/com_users/models/user.php:62
17	UsersModelUser->getTable()	JROOT/libraries/legacy/model/admin.php:897
16	JModelAdmin->getItem()	JROOT/administrator/components/com_users/models/user.php:78
15	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:364
14	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:254
13	ContactModelContact->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 66.74 ms Query memory: 0.024 MB Memory before query: 10.455 MB Rows returned: 1

SELECT COUNT(*)

  FROM `tau02_contact_details` AS a

  LEFT JOIN tau02_categories AS c 
  ON c.id = a.catid

  LEFT JOIN tau02_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN tau02_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1) 
  AND a.catid = 87 
  AND c.access IN (1,1) 
  AND a.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	tructuye_db.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	tructuye_db.a.modified_by	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:341
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:290
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:324
14	JModelList->getStart()	JROOT/libraries/legacy/model/list.php:185
13	JModelList->getItems()	JROOT/components/com_contact/models/category.php:91
12	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:84
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.67 ms After last query: 0.20 ms Query memory: 0.032 MB Memory before query: 10.469 MB Rows returned: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM `tau02_contact_details` AS a

  LEFT JOIN tau02_categories AS c 
  ON c.id = a.catid

  LEFT JOIN tau02_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN tau02_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1) 
  AND a.catid = 87 
  AND c.access IN (1,1) 
  AND a.published = 1

  ORDER BY a.name asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	tructuye_db.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	tructuye_db.a.modified_by	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
13	JModelList->getItems()	JROOT/components/com_contact/models/category.php:91
12	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:84
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.43 ms Query memory: 0.027 MB Memory before query: 10.515 MB Rows returned: 0

Duplicate queries: #11 #16

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

  FROM `tau02_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 11 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
13	JHelperTags->getItemTags()	JROOT/components/com_contact/models/category.php:104
12	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:84
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.81 ms After last query: 21.66 ms Query memory: 0.026 MB Memory before query: 11.674 MB Rows returned: 0

Duplicate queries: #11 #15

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

  FROM `tau02_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 11 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
12	JHelperTags->getItemTags()	JROOT/components/com_contact/views/contact/view.html.php:272
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.82 ms After last query: 5.58 ms Query memory: 0.030 MB Memory before query: 11.738 MB Rows returned: 43

SHOW FULL COLUMNS 
  FROM `tau02_contact_details`

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.40 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.03 ms
Opening tables	0.02 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.12 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_contact/tables/contact.php:38
14	ContactTableContact->__construct()	JROOT/libraries/joomla/table/table.php:305
13	JTable::getInstance()	JROOT/components/com_contact/models/contact.php:594
12	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:292
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 2.19 ms Query memory: 0.031 MB Memory before query: 11.944 MB Rows returned: 1

SELECT *

  FROM tau02_contact_details

  WHERE `id` = '11'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:728
13	JTable->load()	JROOT/components/com_contact/models/contact.php:595
12	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:292
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 5.15 ms After last query: 0.37 ms Query memory: 0.018 MB Memory before query: 11.961 MB

UPDATE tau02_contact_details

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

  WHERE `id` = '11'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tau02_contact_details	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1249
13	JTable->hit()	JROOT/components/com_contact/models/contact.php:596
12	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:292
11	ContactViewContact->display()	JROOT/libraries/joomla/cache/controller/view.php:96
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.04 ms After last query: 83.12 ms Query memory: 0.031 MB Memory before query: 13.042 MB Rows returned: 31

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

  FROM tau02_modules AS m

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

  LEFT JOIN tau02_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 <= '2020-07-07 09:16:40') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-07-07 09:16:40') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 691 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	48	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	tructuye_db.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	tructuye_db.m.id	2	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:430
16	JModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:373
15	JModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:89
14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
13	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:622
12	T3Template->countModules()	JROOT/templates/uber/tpls/blocks/header.php:17
11	include JROOT/templates/uber/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:195
10	T3Template->loadBlock()	JROOT/templates/uber/tpls/default.php:32
9	include JROOT/templates/uber/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:219
8	T3Template->loadLayout()	JROOT/templates/uber/index.php:34
7	require JROOT/templates/uber/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.11 ms After last query: 34.94 ms Query memory: 0.029 MB Memory before query: 13.725 MB Rows returned: 2

SELECT b.rules

  FROM tau02_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	285	18.60	Using where

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.21 ms
preparing	0.03 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.89 ms
Creating sort index	0.11 ms
end	0.01 ms
removing tmp table	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
21	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
20	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
19	JUser->authorise()	JROOT/components/com_content/models/articles.php:449
18	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:537
15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:76
14	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
13	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
12	JModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
10	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:596
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 5.99 ms After last query: 0.56 ms Query memory: 0.048 MB Memory before query: 13.758 MB Rows returned: 2

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM tau02_content AS a

  LEFT JOIN tau02_content_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN tau02_categories AS c 
  ON c.id = a.catid

  LEFT JOIN tau02_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN tau02_users AS uam 
  ON uam.id = a.modified_by

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM tau02_categories AS cat JOIN tau02_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (81) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-07-07 09:16:40') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-07-07 09:16:40')

  ORDER BY a.hits DESC 
  LIMIT 0, 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	11	100.00	Using where
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	tructuye_db.a.id	1	100.00	Using where; Using index
1	PRIMARY	ua	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	uam	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	PRIMARY	v	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using where; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	70	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.30 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.19 ms
System lock	0.03 ms
optimizing	0.02 ms
optimizing	0.02 ms
statistics	0.19 ms
preparing	0.06 ms
Creating tmp table	0.06 ms
Sorting result	0.05 ms
statistics	0.34 ms
preparing	0.15 ms
Creating tmp table	0.25 ms
Sorting result	0.01 ms
executing	0.03 ms
Sending data	1.85 ms
executing	0.01 ms
Sending data	0.27 ms
Creating sort index	0.05 ms
removing tmp table	0.01 ms
Creating sort index	0.86 ms
Creating sort index	0.45 ms
end	0.07 ms
removing tmp table	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.04 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:537
15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:76
14	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
13	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
12	JModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
10	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:596
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.92 ms After last query: 2.83 ms Query memory: 0.034 MB Memory before query: 13.990 MB Rows returned: 15

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 tau02_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM tau02_categories AS cat JOIN tau02_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN tau02_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.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 badcats.id is null 
  AND s.id=81

  GROUP BY 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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	70	32.86	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	tructuye_db.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	70	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.26 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.04 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
statistics	0.20 ms
preparing	0.05 ms
Creating tmp table	0.15 ms
Sorting result	0.01 ms
executing	0.02 ms
Sending data	0.06 ms
executing	0.01 ms
Sending data	0.23 ms
Creating sort index	0.03 ms
removing tmp table	0.01 ms
Creating sort index	1.58 ms
Creating sort index	0.33 ms
end	0.04 ms
removing tmp table	0.13 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
16	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
15	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_articles_popular/helper.php:86
14	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
13	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
12	JModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
10	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:596
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->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:

3 × SELECT `m`.`tag_id`,`t`.* 
  FROM `tau02_contentitem_tag_map` AS m  
  INNER JOIN `tau02_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

2 × SELECT b.rules 
  FROM tau02_assets AS a 
  LEFT JOIN tau02_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT COUNT(*) 
  FROM `tau02_contact_details` AS a 
  LEFT JOIN tau02_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN tau02_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN tau02_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM `tau02_contact_details` AS a 
  LEFT JOIN tau02_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN tau02_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN tau02_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM tau02_modules AS m 
  LEFT JOIN tau02_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN tau02_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_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 tau02_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM tau02_categories AS cat JOIN tau02_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM tau02_content AS a 
  LEFT JOIN tau02_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN tau02_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN tau02_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN tau02_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN tau02_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN tau02_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM tau02_categories AS cat JOIN tau02_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT * 
  FROM tau02_contact_details

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 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,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM tau02_contact_details AS a 
  LEFT JOIN tau02_categories AS c 
  on c.id = a.catid 
  LEFT JOIN tau02_categories as parent 
  ON parent.id = c.parent_id

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

1 × SELECT `session_id` 
  FROM `tau02_session`

1 × SELECT id, rules 
  FROM `tau02_viewlevels

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 tau02_menu AS m 
  LEFT JOIN tau02_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT a.rules 
  FROM tau02_assets AS a

1 × SELECT `data` 
  FROM `tau02_session`

OTHER Tables:

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

1 × SHOW FULL COLUMNS 
  FROM `tau02_contact_details

1 × SHOW FULL COLUMNS 
  FROM `tau02_users

1 × UPDATE `tau02_extensions` 
  SET `params` = '{\"mediaversion\":\"20559b75473921886be259ab98b23da2\"}'

1 × INSERT INTO `tau02_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('ipho1hpgpaemhuqdl4pp5gnmh3', 0, '1594113400'

Tructuyenslots

Gửi Email

CƠ HỘI HỢP TÁC

Liên hệ

Các liên kết

CÁC BÀI VIẾT - ĐƯỢC ĐỌC NHIỀU NHẤT

TÌM HIỂU VỀ CHÚNG TÔI

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

23 Queries Logged 50.46 ms

3 duplicate found!

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: