Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 9,
            "timer": {
                "start": 1715919305,
                "last": 1715919308,
                "now": 1715919310
            },
            "token": "Bsqxtytv9q0cqzCeTXLvPlqr8k0Jfis3"
        },
        "registry": {
            "com_icecool_wedding_rings": {
                "edit": {
                    "weddingringdetails": {
                        "id": "63flat"
                    }
                }
            }
        },
        "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
        },
        "weddingBandDetails": "Flat Court 2.5mm White Gold Wedding Ring",
        "com_mailto": {
            "links": {
                "62b0953cf34b6ac7cbaa0d8775dd0bf8678cb7f5": {
                    "link": "https:\/\/www.icecooldiamonds.com\/index.php\/custom-made-engagement-ring\/your-ring-journey",
                    "expiry": 1715919308
                }
            }
        },
        "6187f510f31997f03e0c216d8dd870e2": 1
    },
    "__EBLOG": {
        "MESSAGE": {
            "eblog": {
                "message": {
                    "queue": null
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 1.09 ms / 1.09 ms Memory: 0.039 MB / 0.42 MB Application: afterLoad

Time: 24.30 ms / 25.38 ms Memory: 0.693 MB / 1.11 MB Application: afterInitialise

Time: 27.76 ms / 53.14 ms Memory: 1.107 MB / 2.22 MB Application: afterRoute

Time: 14.83 ms / 67.97 ms Memory: 0.045 MB / 2.26 MB Application: beforeRenderComponent com_easyblog

Time: 32.78 ms / 100.75 ms Memory: 0.337 MB / 2.60 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.94 ms / 101.70 ms Memory: 0.016 MB / 2.62 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 1.04 ms / 102.74 ms Memory: 0.005 MB / 2.62 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.92 ms / 103.66 ms Memory: 0.016 MB / 2.64 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 168.08 ms / 271.74 ms Memory: 1.007 MB / 3.64 MB Application: afterRenderComponent com_easyblog

Time: 0.68 ms / 272.42 ms Memory: 0.010 MB / 3.65 MB Application: afterDispatch

Time: 0.40 ms / 272.82 ms Memory: 0.029 MB / 3.68 MB Application: beforeRenderModule mod_custom (Footer Copy)

Time: 0.38 ms / 273.20 ms Memory: 0.006 MB / 3.69 MB Application: afterRenderModule mod_custom (Footer Copy)

Time: 0.07 ms / 273.27 ms Memory: 0.001 MB / 3.69 MB Application: beforeRenderModule mod_menu (Footer Menu Right)

Time: 1.24 ms / 274.51 ms Memory: 0.034 MB / 3.72 MB Application: afterRenderModule mod_menu (Footer Menu Right)

Time: 0.06 ms / 274.56 ms Memory: 0.000 MB / 3.72 MB Application: beforeRenderModule mod_menu (Footer Menu Middle)

Time: 0.55 ms / 275.12 ms Memory: 0.010 MB / 3.73 MB Application: afterRenderModule mod_menu (Footer Menu Middle)

Time: 0.06 ms / 275.17 ms Memory: 0.000 MB / 3.73 MB Application: beforeRenderModule mod_menu (Footer Menu Left)

Time: 0.96 ms / 276.13 ms Memory: 0.019 MB / 3.75 MB Application: afterRenderModule mod_menu (Footer Menu Left)

Time: 0.06 ms / 276.19 ms Memory: 0.000 MB / 3.74 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 2.53 ms / 278.72 ms Memory: 0.053 MB / 3.80 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 1.39 ms / 280.10 ms Memory: 0.087 MB / 3.88 MB Application: afterRender

Database queries total: 128.97 ms

Memory Usage

Database Queries

89 Queries Logged 128.97 ms

27 duplicate found!

7 duplicates: #13 #32 #37 #49 #52 #77 #79

2 duplicates: #24 #26

2 duplicates: #29 #68

3 duplicates: #34 #38 #75

3 duplicates: #35 #39 #76

2 duplicates: #36 #42

5 duplicates: #50 #53 #78 #85 #88

3 duplicates: #55 #56 #80

Query Time: 0.95 ms Query memory: 0.022 MB Memory before query: 0.699 MB Rows returned: 1

SELECT `data`

  FROM `icecool_session`

  WHERE `session_id` = 'a32370a7691b91e8f0901effcdb98388'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
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:259
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:773
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:408
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: 1.62 ms After last query: 0.66 ms Query memory: 0.024 MB Memory before query: 0.740 MB Rows returned: 45

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

  FROM `icecool_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_extensions	ref	extension	extension	82	const	45	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	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:261
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.22 ms After last query: 0.53 ms Query memory: 0.021 MB Memory before query: 0.766 MB Rows returned: 2

SELECT b.id

  FROM icecool_usergroups AS a

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

  WHERE a.id = 9

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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.77 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 0.770 MB Rows returned: 4

SELECT id, rules

  FROM `icecool_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.27 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 0.779 MB Rows returned: 66

SELECT folder AS type, element AS name, params

  FROM icecool_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_extensions	ref	extension	extension	82	const	82	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.87 ms After last query: 2.64 ms Query memory: 0.020 MB Memory before query: 1.063 MB Rows returned: 1

SELECT `enabled`

  FROM `icecool_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.72 ms After last query: 1.30 ms Query memory: 0.090 MB Memory before query: 1.125 MB Rows returned: 59

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

  LEFT JOIN icecool_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	68	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	coltscou_clients.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
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:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
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:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.44 ms After last query: 8.12 ms Query memory: 0.025 MB Memory before query: 2.031 MB Rows returned: 2

SHOW FULL COLUMNS 
  FROM `icecool_easyblog_configs`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
17	JTable->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
16	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/configs.php:39
15	EasyBlogTableConfigs->__construct()	JROOT/libraries/joomla/table/table.php:308
14	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
13	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
12	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/helpers/helper.php:591
11	EasyBlogHelper::getConfig()	JROOT/components/com_easyblog/router.php:257
10	EasyBlogParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.08 ms After last query: 0.31 ms Query memory: 0.061 MB Memory before query: 2.047 MB Rows returned: 1

SELECT *

  FROM icecool_easyblog_configs

  WHERE `name` = 'config'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.03 ms
optimizing	0.13 ms
statistics	0.69 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.05 ms
Waiting for query cache lock	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.32 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/components/com_easyblog/helpers/helper.php:592
11	EasyBlogHelper::getConfig()	JROOT/components/com_easyblog/router.php:257
10	EasyBlogParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.47 ms After last query: 5.73 ms Query memory: 0.033 MB Memory before query: 2.163 MB Rows returned: 34

SHOW FULL COLUMNS 
  FROM `icecool_easyblog_post`

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 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
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
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
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
Sending data	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
16	JTable->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
15	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/blog.php:64
14	EasyBlogTableBlog->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
12	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
11	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/router.php:306
10	EasyBlogParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.79 ms After last query: 0.49 ms Query memory: 0.022 MB Memory before query: 2.207 MB Rows returned: 0

SELECT a.`id` 
  FROM icecool_easyblog_post as a 
  WHERE a.`permalink` = 'pink:star-diamond-to-fetch-60-million-at-sotheby-s-auction'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.50 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
13	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
12	EasyBlogDBHelper->__call()	JROOT/administrator/components/com_easyblog/tables/blog.php:81
11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/router.php:307
10	EasyBlogParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.96 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 2.214 MB Rows returned: 1

SELECT a.`id` 
  FROM icecool_easyblog_post as a 
  WHERE a.`permalink` = 'pink-star-diamond-to-fetch-60-million-at-sotheby-s-auction'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
13	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
12	EasyBlogDBHelper->__call()	JROOT/administrator/components/com_easyblog/tables/blog.php:90
11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/router.php:307
10	EasyBlogParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.01 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 2.225 MB Rows returned: 1

Duplicate queries: #32 #37 #49 #52 #77 #79

SELECT *

  FROM icecool_easyblog_post

  WHERE `id` = '45'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:92
11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/router.php:307
10	EasyBlogParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.07 ms After last query: 0.30 ms Query memory: 0.022 MB Memory before query: 2.237 MB Rows returned: 1

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

  FROM `icecool_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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: 4.22 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 2.228 MB

UPDATE `icecool_extensions`

  SET `params` = '{\"mediaversion\":\"06c78c58767635103d3626320e86c383\"}'

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.06 ms
updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.23 ms
query end	2.91 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.07 ms After last query: 0.34 ms Query memory: 0.019 MB Memory before query: 2.247 MB Rows returned: 1

SELECT *

  FROM icecool_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.48 ms After last query: 0.17 ms Query memory: 0.020 MB Memory before query: 2.258 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM icecool_template_styles as s

  LEFT JOIN icecool_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	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	7	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	coltscou_clients.s.template,const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.30 ms After last query: 6.89 ms Query memory: 0.005 MB Memory before query: 2.361 MB

DELETE 
  FROM `icecool_easyblog_mailq` 
  WHERE `status`='1' 
  AND DATEDIFF(NOW(), `created`) >= 7

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_mailq	range	easyblog_mailq_status	easyblog_mailq_status	1	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/components/com_easyblog/helpers/db.php:109
9	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
8	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/classes/mailqueue.php:36
7	EMailQueue->sendOnPageLoad()	JROOT/components/com_easyblog/easyblog.php:81
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.89 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 2.366 MB Rows returned: 0

SELECT `id` 
  FROM `icecool_easyblog_mailq` 
  WHERE `status` = 0 
  ORDER BY `created` ASC 
  LIMIT 5

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
9	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
8	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/classes/mailqueue.php:44
7	EMailQueue->sendOnPageLoad()	JROOT/components/com_easyblog/easyblog.php:81
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.83 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 2.374 MB Rows returned: 0

SELECT * 
  FROM `icecool_easyblog_post` 
  WHERE `publish_up` <= '2024-05-17 04:15:10' 
  AND `published` = '2' 
  AND `ispending` = '0' 
  ORDER BY `id` 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_post	ref	easyblog_post_published,easyblog_post_blogger_list	easyblog_post_blogger_list	1	const	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
9	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
8	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:2514
7	EasyBlogHelper::processScheduledPost()	JROOT/components/com_easyblog/easyblog.php:85
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.65 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 2.379 MB

UPDATE `icecool_easyblog_post` 
  SET `published` = '0' 
  WHERE `publish_down` > `publish_up` 
  AND `publish_down` <= '2024-05-17 04:15:10' 
  AND `publish_down` != '0000-00-00 00:00:00' 
  AND `published` != '0' 
  AND `published` != '3' 
  AND `ispending` = '0'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_post	ALL	easyblog_post_published,easyblog_post_blogger_list	NO INDEX KEY COULD BE USED	NULL	NULL	46	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/components/com_easyblog/helpers/db.php:109
9	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
8	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:2490
7	EasyBlogHelper::unPublishPost()	JROOT/components/com_easyblog/easyblog.php:88
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.63 ms After last query: 16.37 ms Query memory: 0.028 MB Memory before query: 2.571 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `icecool_assets`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.35 ms
init	0.01 ms
System lock	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.02 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
Sending data	0.03 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
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/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
14	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.07 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 2.594 MB Rows returned: 1

SELECT *

  FROM icecool_assets

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
14	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.75 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 2.601 MB Rows returned: 1

Duplicate queries: #26

SELECT a.rules

  FROM icecool_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
14	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.96 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 2.612 MB Rows returned: 1

SELECT id

  FROM icecool_assets

  WHERE parent_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_assets	ref	idx_parent_id	idx_parent_id	4	const	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
17	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
14	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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: 0.06 ms Query memory: 0.025 MB Memory before query: 2.622 MB Rows returned: 1

Duplicate queries: #24

SELECT a.rules

  FROM icecool_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
14	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.01 ms After last query: 2.48 ms Query memory: 0.028 MB Memory before query: 2.646 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `icecool_easyblog_users`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 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
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
19	JTable->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
18	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/profile.php:39
17	EasyBlogTableProfile->__construct()	JROOT/libraries/joomla/table/table.php:308
16	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
15	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
14	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/classes/themes.php:73
13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.80 ms After last query: 0.70 ms Query memory: 0.024 MB Memory before query: 2.671 MB Rows returned: 1

SELECT COUNT(*) 
  FROM `icecool_easyblog_configs` 
  WHERE `name` = 'default'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.14 ms
Waiting for query cache lock	0.03 ms
freeing items	0.01 ms
storing result in query cache	0.00 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
16	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
15	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/classes/themes.php:156
14	CodeThemes->_getThemeConfig()	JROOT/components/com_easyblog/classes/themes.php:106
13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.20 ms After last query: 0.18 ms Query memory: 0.028 MB Memory before query: 2.686 MB Rows returned: 32

Duplicate queries: #68

SELECT * 
  FROM `icecool_easyblog_acl` 
  WHERE `published`=1 
  ORDER BY `id` ASC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.39 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
17	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
16	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:317
15	EasyBlogACLHelper::getRules()	JROOT/components/com_easyblog/helpers/acl.php:33
14	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/classes/themes.php:121
13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.62 ms After last query: 0.08 ms Query memory: 0.028 MB Memory before query: 2.713 MB Rows returned: 36

SELECT * 
  FROM `icecool_easyblog_acl_group` 
  WHERE `content_id`='1' 
  AND `type`='
  group'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_acl_group	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	36	100.00	Using index condition

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.08 ms
statistics	0.66 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.37 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
16	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
15	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:136
14	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/classes/themes.php:121
13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.19 ms After last query: 8.09 ms Query memory: 0.022 MB Memory before query: 2.821 MB Rows returned: 1

SELECT id, keywords, description, indexing 
  FROM `icecool_easyblog_meta` 
  WHERE content_id = '45' 
  and type = 'post'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.42 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_easyblog/helpers/db.php:109
12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:3039
10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.76 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 2.836 MB Rows returned: 1

Duplicate queries: #13 #37 #49 #52 #77 #79

SELECT *

  FROM icecool_easyblog_post

  WHERE `id` = '45'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/helper.php:3062
10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.90 ms After last query: 4.31 ms Query memory: 0.029 MB Memory before query: 2.859 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `icecool_easyblog_category`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 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
checking permissions	0.02 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
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
16	JTable->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
15	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/category.php:52
14	EasyBlogTableCategory->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
12	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
11	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/helpers/helper.php:3067
10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.61 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 2.888 MB Rows returned: 1

Duplicate queries: #38 #75

SELECT *

  FROM icecool_easyblog_category

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_category	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.39 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
11	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/helper.php:3068
10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.01 ms After last query: 0.25 ms Query memory: 0.023 MB Memory before query: 2.896 MB Rows returned: 1

Duplicate queries: #39 #76

SELECT COUNT(1) 
  FROM `icecool_easyblog_category` 
  WHERE `alias`='icecooldiamonds' 
  AND `id`!='1'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.19 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/category.php:190
14	EasyBlogTableCategory->aliasExists()	JROOT/administrator/components/com_easyblog/tables/category.php:210
13	EasyBlogTableCategory->bind()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
11	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/helper.php:3068
10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.40 ms After last query: 0.69 ms Query memory: 0.023 MB Memory before query: 2.905 MB Rows returned: 0

Duplicate queries: #42

SELECT a.`id`, a.`title`, a.`alias` 
  FROM `icecool_easyblog_tag` AS a 
  LEFT JOIN `icecool_easyblog_post_tag` AS b 
  ON a.`id` = b.`tag_id` 
  WHERE b.`post_id` = '45' 
  AND a.`published` = '1' 
  ORDER BY a.`title` ASC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.64 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
13	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
12	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/models/posttag.php:62
11	EasyBlogModelPostTag->getBlogTags()	JROOT/components/com_easyblog/helpers/helper.php:3075
10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.27 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 2.911 MB Rows returned: 1

Duplicate queries: #13 #32 #49 #52 #77 #79

SELECT *

  FROM icecool_easyblog_post

  WHERE `id` = '45'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
11	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
10	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/views/entry/view.html.php:78
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.94 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 2.920 MB Rows returned: 1

Duplicate queries: #34 #75

SELECT *

  FROM icecool_easyblog_category

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_category	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
11	EasyBlogTableCategory->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:724
10	EasyBlogTableBlog->isAccessible()	JROOT/components/com_easyblog/views/entry/view.html.php:178
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.25 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 2.928 MB Rows returned: 1

Duplicate queries: #35 #76

SELECT COUNT(1) 
  FROM `icecool_easyblog_category` 
  WHERE `alias`='icecooldiamonds' 
  AND `id`!='1'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/category.php:190
14	EasyBlogTableCategory->aliasExists()	JROOT/administrator/components/com_easyblog/tables/category.php:210
13	EasyBlogTableCategory->bind()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
11	EasyBlogTableCategory->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:724
10	EasyBlogTableBlog->isAccessible()	JROOT/components/com_easyblog/views/entry/view.html.php:178
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.37 ms After last query: 2.44 ms Query memory: 0.006 MB Memory before query: 2.933 MB

UPDATE icecool_easyblog_post

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

  WHERE `id` = '45'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.03 ms
updating	0.45 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.11 ms
query end	0.00 ms
closing tables	0.99 ms
freeing items	0.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
11	JTable->hit()	JROOT/administrator/components/com_easyblog/tables/blog.php:260
10	EasyBlogTableBlog->hit()	JROOT/components/com_easyblog/views/entry/view.html.php:222
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.77 ms After last query: 1.11 ms Query memory: 0.023 MB Memory before query: 2.937 MB Rows returned: 1

SELECT COUNT(1) 
  FROM `icecool_easyblog_featured` 
  WHERE `content_id` = '45' 
  AND `type` = 'post'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.10 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
13	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
12	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:1794
11	EasyBlogHelper::isFeatured()	JROOT/administrator/components/com_easyblog/tables/blog.php:751
10	EasyBlogTableBlog->isFeatured()	JROOT/components/com_easyblog/views/entry/view.html.php:281
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.26 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 2.946 MB Rows returned: 0

Duplicate queries: #36

SELECT a.`id`, a.`title`, a.`alias` 
  FROM `icecool_easyblog_tag` AS a 
  LEFT JOIN `icecool_easyblog_post_tag` AS b 
  ON a.`id` = b.`tag_id` 
  WHERE b.`post_id` = '45' 
  AND a.`published` = '1' 
  ORDER BY a.`title` ASC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/models/posttag.php:62
10	EasyBlogModelPostTag->getBlogTags()	JROOT/components/com_easyblog/views/entry/view.html.php:290
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.68 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 2.957 MB Rows returned: 1

SELECT *

  FROM icecool_easyblog_users

  WHERE `id` = '966'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.58 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
11	JTable->load()	JROOT/administrator/components/com_easyblog/tables/profile.php:145
10	EasyBlogTableProfile->load()	JROOT/components/com_easyblog/views/entry/view.html.php:304
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.14 ms After last query: 1.94 ms Query memory: 0.028 MB Memory before query: 2.968 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `icecool_users`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 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
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
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
18	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
17	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:308
16	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:583
15	JUser::getTable()	JROOT/libraries/joomla/user/user.php:861
14	JUser->load()	JROOT/libraries/joomla/user/user.php:243
13	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
12	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
11	JFactory::getUser()	JROOT/administrator/components/com_easyblog/tables/profile.php:154
10	EasyBlogTableProfile->load()	JROOT/components/com_easyblog/views/entry/view.html.php:304
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.98 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 2.997 MB Rows returned: 1

SELECT *

  FROM `icecool_users`

  WHERE `id` = 966

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
15	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
14	JUser->load()	JROOT/libraries/joomla/user/user.php:243
13	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
12	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
11	JFactory::getUser()	JROOT/administrator/components/com_easyblog/tables/profile.php:154
10	EasyBlogTableProfile->load()	JROOT/components/com_easyblog/views/entry/view.html.php:304
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.75 ms After last query: 8.21 ms Query memory: 0.024 MB Memory before query: 3.070 MB Rows returned: 3

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

  FROM `icecool_usergroups` AS g

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

  WHERE `m`.`user_id` = 966

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.73 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:110
15	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
14	JUser->load()	JROOT/libraries/joomla/user/user.php:243
13	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
12	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
11	JFactory::getUser()	JROOT/administrator/components/com_easyblog/tables/profile.php:154
10	EasyBlogTableProfile->load()	JROOT/components/com_easyblog/views/entry/view.html.php:304
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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: 6.41 ms Query memory: 0.022 MB Memory before query: 3.088 MB Rows returned: 1

SELECT COUNT(1) 
  FROM `icecool_easyblog_comment` 
  WHERE `post_id`='45' 
  AND `published` = '1'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/comment.php:262
10	EasyBlogCommentHelper::getCommentCount()	JROOT/components/com_easyblog/views/entry/view.html.php:403
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.03 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 3.094 MB Rows returned: 0

select `tag_id` 
  from `icecool_easyblog_post_tag` 
  where `post_id` = '45'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/components/com_easyblog/helpers/db.php:84
12	EasyBlogDbJoomla30->loadResultArray()	JROOT/components/com_easyblog/helpers/db.php:43
11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/models/blog.php:1482
10	EasyBlogModelBlog->getRelatedBlog()	JROOT/components/com_easyblog/views/entry/view.html.php:409
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.31 ms After last query: 0.85 ms Query memory: 0.024 MB Memory before query: 3.113 MB Rows returned: 1

Duplicate queries: #13 #32 #37 #52 #77 #79

SELECT *

  FROM icecool_easyblog_post

  WHERE `id` = '45'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
14	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
13	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/router.php:203
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
11	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/classes/facebook.php:188
10	EasyBlogFacebookLikes::getLikeHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:424
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.44 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 3.118 MB Rows returned: 0

Duplicate queries: #53 #78 #85 #88

SELECT `id` 
  FROM `icecool_menu` 
  WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=966' 
  AND `published`='1' 
  AND (`language`='en-GB' OR `language` = '*' ) 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.64 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.77 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
16	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
15	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
14	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1108
13	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:208
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
11	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/classes/facebook.php:188
10	EasyBlogFacebookLikes::getLikeHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:424
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.25 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 3.128 MB Rows returned: 1

SELECT a.* 
  FROM `icecool_easyblog_post` as a 
  WHERE a.`id` ='45'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
23	JDatabaseDriver->loadObject()	JROOT/components/com_easyblog/helpers/db.php:109
22	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
21	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:688
20	EasyBlogRouter::getBlogSefPermalink()	JROOT/components/com_easyblog/router.php:35
19	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
11	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/classes/facebook.php:188
10	EasyBlogFacebookLikes::getLikeHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:424
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.91 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 3.142 MB Rows returned: 1

Duplicate queries: #13 #32 #37 #49 #77 #79

SELECT *

  FROM icecool_easyblog_post

  WHERE `id` = '45'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
13	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
12	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/router.php:203
11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:426
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.39 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 3.146 MB Rows returned: 0

Duplicate queries: #50 #78 #85 #88

SELECT `id` 
  FROM `icecool_menu` 
  WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=966' 
  AND `published`='1' 
  AND (`language`='en-GB' OR `language` = '*' ) 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
14	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
13	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1108
12	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:208
11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:426
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.30 ms After last query: 1.33 ms Query memory: 0.026 MB Memory before query: 3.154 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `icecool_easyblog_meta`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 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
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
16	JTable->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
15	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/meta.php:33
14	EasyBlogTableMeta->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
12	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
11	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/classes/facebook.php:103
10	EasyBlogFacebookLikes::addOpenGraphTags()	JROOT/components/com_easyblog/views/entry/view.html.php:431
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.99 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 3.169 MB Rows returned: 1

Duplicate queries: #56 #80

SELECT * 
  FROM icecool_easyblog_meta 
  WHERE `type`='post' 
  AND `content_id`='45'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.11 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/tables/meta.php:44
11	EasyBlogTableMeta->loadByType()	JROOT/components/com_easyblog/classes/facebook.php:104
10	EasyBlogFacebookLikes::addOpenGraphTags()	JROOT/components/com_easyblog/views/entry/view.html.php:431
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.27 ms After last query: 2.04 ms Query memory: 0.022 MB Memory before query: 3.177 MB Rows returned: 1

Duplicate queries: #55 #80

SELECT * 
  FROM icecool_easyblog_meta 
  WHERE `type`='post' 
  AND `content_id`='45'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/tables/meta.php:44
11	EasyBlogTableMeta->loadByType()	JROOT/components/com_easyblog/helpers/twitter.php:95
10	EasyBlogTwitterHelper::addCard()	JROOT/components/com_easyblog/views/entry/view.html.php:435
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.28 ms After last query: 0.43 ms Query memory: 0.023 MB Memory before query: 3.183 MB Rows returned: 0

SELECT `id` 
  FROM `icecool_menu` 
  WHERE (`link`='index.php?option=com_easyblog&view=latest' OR `link` LIKE 'index.php?option=com_easyblog&view=latest&
  limit=%') 
  AND `published`='1' 
  AND (`language`='en-GB' OR `language` = '*' ) 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.13 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
14	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
13	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1215
12	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:440
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.17 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 3.191 MB Rows returned: 0

SELECT `id` 
  FROM `icecool_menu` 
  WHERE `link` LIKE 'index.php?option=com_easyblog&view=latest%' 
  AND `published`='1' 
  AND (`language`='en-GB' OR `language` = '*' ) 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.20 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
14	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
13	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1230
12	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:440
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.09 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 3.198 MB Rows returned: 0

SELECT `id` 
  FROM `icecool_menu` 
  WHERE `link`='index.php?option=com_easyblog&view=latest' 
  AND `published`='1' 
  AND (`language`='en-GB' OR `language` = '*' ) 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.19 ms
end	0.03 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
14	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
13	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1243
12	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:440
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.50 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 3.205 MB Rows returned: 1

SELECT `id` 
  FROM `icecool_menu` 
  WHERE `link` LIKE 'index.php?option=com_easyblog&view=%' 
  AND `published`='1' 
  AND (`language`='en-GB' OR `language` = '*' ) 
  ORDER BY `id` 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_menu	index	idx_language	PRIMARY	4	NULL	1	8800.00	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.02 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
14	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
13	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1255
12	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:440
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.27 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 3.216 MB Rows returned: 0

select distinct a.`id`, a.`private` 
  from `icecool_easyblog_category` as a 	
  left join `icecool_easyblog_category_acl` as b 
  on a.`id` = b.`category_id` 
  and b.`acl_id` = '1' 
  where a.`private` != '0' 
  and b.`category_id` NOT IN (     SELECT c.category_id 
  FROM `icecool_easyblog_category_acl` as c         
  WHERE c.acl_id = '1'        
  AND c.content_id IN ('9') )

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
13	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
12	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:4675
11	EasyBlogHelper::getPrivateCategories()	JROOT/components/com_easyblog/helpers/helper.php:2891
10	EasyBlogHelper::getBlogNavigation()	JROOT/components/com_easyblog/views/entry/view.html.php:457
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.61 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 3.223 MB Rows returned: 1

SELECT a.`id`, a.`title` 
  FROM `icecool_easyblog_post` AS `a` 
  WHERE a.`published` = '1' 
  AND a.`ispending` = '0' 
  AND a.`private` = '0' 	
  AND a.`issitewide` = '1' 
  AND a.`created` < '2017-03-30 08:04:00' 
  ORDER BY a.`created` DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	range	easyblog_post_published,easyblog_post_blogger_list,easyblog_post_search	easyblog_post_search	12	NULL	41	90.24	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:3021
10	EasyBlogHelper::getBlogNavigation()	JROOT/components/com_easyblog/views/entry/view.html.php:457
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.33 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 3.230 MB Rows returned: 1

SELECT a.`id`, a.`title` 
  FROM `icecool_easyblog_post` AS `a` 
  WHERE a.`published` = '1' 
  AND a.`ispending` = '0' 
  AND a.`private` = '0' 	
  AND a.`issitewide` = '1' 
  AND a.`created` > '2017-03-30 08:04:00' 
  ORDER BY a.`created` ASC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	range	easyblog_post_published,easyblog_post_blogger_list,easyblog_post_search	easyblog_post_search	12	NULL	2	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:3021
10	EasyBlogHelper::getBlogNavigation()	JROOT/components/com_easyblog/views/entry/view.html.php:457
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.41 ms After last query: 2.30 ms Query memory: 0.022 MB Memory before query: 3.240 MB Rows returned: 0

SELECT * 
  FROM `icecool_easyblog_trackback` 
  WHERE `post_id` = '45' 
  AND `published`='1' 
  ORDER BY `created` DESC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/models/blog.php:1467
10	EasyBlogModelBlog->getTrackback()	JROOT/components/com_easyblog/views/entry/view.html.php:519
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.26 ms After last query: 1.56 ms Query memory: 0.031 MB Memory before query: 3.262 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `icecool_easyblog_adsense`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
16	JTable->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
15	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/adsense.php:55
14	EasyBlogTableAdsense->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
12	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
11	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/classes/adsense.php:62
10	EasyBlogGoogleAdsense::getHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:525
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.76 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 3.282 MB Rows returned: 0

select `id` 
  FROM `icecool_easyblog_adsense` 
  where user_id = '966'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/adsense.php:67
11	EasyBlogTableAdsense->load()	JROOT/components/com_easyblog/classes/adsense.php:63
10	EasyBlogGoogleAdsense::getHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:525
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.03 ms After last query: 2.94 ms Query memory: 0.026 MB Memory before query: 3.335 MB Rows returned: 12

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

  FROM icecool_modules AS m

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

  LEFT JOIN icecool_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 <= '2024-05-17 04:15:10') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-17 04:15:10') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 284 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	14	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	coltscou_clients.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	coltscou_clients.m.module,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.34 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
13	JModuleHelper::getModules()	JROOT/components/com_easyblog/helpers/helper.php:2579
12	EasyBlogHelper::renderModule()	JROOT/components/com_easyblog/themes/default/blog.read.php:29
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.46 ms After last query: 1.14 ms Query memory: 0.029 MB Memory before query: 3.358 MB Rows returned: 32

Duplicate queries: #29

SELECT * 
  FROM `icecool_easyblog_acl` 
  WHERE `published`=1 
  ORDER BY `id` ASC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
19	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
18	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:317
17	EasyBlogACLHelper::getRules()	JROOT/components/com_easyblog/helpers/acl.php:33
16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.32 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 3.389 MB Rows returned: 0

SELECT * 
  FROM `icecool_easyblog_acl_group` 
  WHERE `content_id`='966' 
  AND `type`='assigned'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_acl_group	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	1	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
18	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:53
16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.60 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 3.399 MB Rows returned: 3

SELECT `group_id` 
  FROM `icecool_user_usergroup_map` 
  WHERE `user_id` = '966'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_user_usergroup_map	ref	PRIMARY	PRIMARY	4	const	3	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
19	JDatabaseDriver->loadColumn()	JROOT/components/com_easyblog/helpers/db.php:84
18	EasyBlogDbJoomla30->loadResultArray()	JROOT/components/com_easyblog/helpers/db.php:43
17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:72
16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.10 ms After last query: 0.07 ms Query memory: 0.029 MB Memory before query: 3.409 MB Rows returned: 36

SELECT * 
  FROM `icecool_easyblog_acl_group` 
  WHERE `content_id`='6' 
  AND `type`='
  group'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_acl_group	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	36	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
18	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:84
16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.96 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 3.439 MB Rows returned: 36

SELECT * 
  FROM `icecool_easyblog_acl_group` 
  WHERE `content_id`='7' 
  AND `type`='
  group'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_acl_group	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	36	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
18	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:84
16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.21 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 3.469 MB Rows returned: 36

SELECT * 
  FROM `icecool_easyblog_acl_group` 
  WHERE `content_id`='8' 
  AND `type`='
  group'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_acl_group	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	36	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.07 ms
Waiting for query cache lock	0.03 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
18	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:84
16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.08 ms After last query: 0.70 ms Query memory: 0.025 MB Memory before query: 3.423 MB Rows returned: 1

SELECT `title` 
  FROM `icecool_easyblog_category` 
  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_category	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
16	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
15	EasyBlogDBHelper->__call()	JROOT/administrator/components/com_easyblog/tables/blog.php:186
14	EasyBlogTableBlog->getCategoryName()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:52
13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.99 ms After last query: 0.19 ms Query memory: 0.028 MB Memory before query: 3.440 MB Rows returned: 1

Duplicate queries: #34 #38

SELECT *

  FROM icecool_easyblog_category

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_easyblog_category	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
24	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
23	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/router.php:662
22	EasyBlogRouter::getCategoryPermalink()	JROOT/components/com_easyblog/router.php:53
21	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:53
13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.70 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 3.453 MB Rows returned: 1

Duplicate queries: #35 #39

SELECT COUNT(1) 
  FROM `icecool_easyblog_category` 
  WHERE `alias`='icecooldiamonds' 
  AND `id`!='1'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
27	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/category.php:190
26	EasyBlogTableCategory->aliasExists()	JROOT/administrator/components/com_easyblog/tables/category.php:210
25	EasyBlogTableCategory->bind()	JROOT/libraries/joomla/table/table.php:729
24	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
23	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/router.php:662
22	EasyBlogRouter::getCategoryPermalink()	JROOT/components/com_easyblog/router.php:53
21	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:53
13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.91 ms After last query: 5.21 ms Query memory: 0.026 MB Memory before query: 3.472 MB Rows returned: 1

Duplicate queries: #13 #32 #37 #49 #52 #79

SELECT *

  FROM icecool_easyblog_post

  WHERE `id` = '45'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
17	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
16	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/router.php:203
15	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.publishing.tool.php:20
14	include JROOT/components/com_easyblog/themes/default/blog.publishing.tool.php	JROOT/components/com_easyblog/classes/themes.php:319
13	CodeThemes->fetch()	JROOT/components/com_easyblog/helpers/publishtools.php:49
12	EasyBlogPublishToolsHelper->getHTML()	JROOT/components/com_easyblog/themes/default/blog.read.php:75
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.09 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 3.479 MB Rows returned: 0

Duplicate queries: #50 #53 #85 #88

SELECT `id` 
  FROM `icecool_menu` 
  WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=966' 
  AND `published`='1' 
  AND (`language`='en-GB' OR `language` = '*' ) 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
19	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
18	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1108
16	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:208
15	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.publishing.tool.php:20
14	include JROOT/components/com_easyblog/themes/default/blog.publishing.tool.php	JROOT/components/com_easyblog/classes/themes.php:319
13	CodeThemes->fetch()	JROOT/components/com_easyblog/helpers/publishtools.php:49
12	EasyBlogPublishToolsHelper->getHTML()	JROOT/components/com_easyblog/themes/default/blog.read.php:75
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.27 ms After last query: 2.45 ms Query memory: 0.025 MB Memory before query: 3.479 MB Rows returned: 1

Duplicate queries: #13 #32 #37 #49 #52 #77

SELECT *

  FROM icecool_easyblog_post

  WHERE `id` = '45'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
15	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
14	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/socialbutton.php:42
13	EasyBlogSocialButtonHelper->setBlog()	JROOT/components/com_easyblog/helpers/helper.php:3578
12	EasyBlogHelper::showSocialButton()	JROOT/components/com_easyblog/themes/default/blog.read.php:89
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.00 ms After last query: 0.25 ms Query memory: 0.023 MB Memory before query: 3.489 MB Rows returned: 1

Duplicate queries: #55 #56

SELECT * 
  FROM icecool_easyblog_meta 
  WHERE `type`='post' 
  AND `content_id`='45'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/tables/meta.php:44
14	EasyBlogTableMeta->loadByType()	JROOT/components/com_easyblog/helpers/socialbutton.php:400
13	EasyBlogSocialButtonHelper->googleone()	JROOT/components/com_easyblog/helpers/helper.php:3612
12	EasyBlogHelper::showSocialButton()	JROOT/components/com_easyblog/themes/default/blog.read.php:89
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.64 ms After last query: 10.45 ms Query memory: 0.029 MB Memory before query: 3.518 MB Rows returned: 9

SHOW FULL COLUMNS 
  FROM `icecool_easyblog_ratings`

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 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
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
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/administrator/components/com_easyblog/tables/table.php:18
19	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/ratings.php:80
18	EasyBlogTableRatings->__construct()	JROOT/libraries/joomla/table/table.php:308
17	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
16	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
15	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/helpers/ratings.php:41
14	EasyBlogRatingsHelper->getHTML()	JROOT/components/com_easyblog/themes/default/blog.rating.php:18
13	include JROOT/components/com_easyblog/themes/default/blog.rating.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:141
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.24 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 3.538 MB Rows returned: 0

SELECT * 
  FROM `icecool_easyblog_ratings` 
  WHERE `created_by`='0' 
  AND `uid`='45' 
  AND `type`='entry' 
  AND `sessionid`='a32370a7691b91e8f0901effcdb98388'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/tables/ratings.php:101
15	EasyBlogTableRatings->fill()	JROOT/components/com_easyblog/helpers/ratings.php:45
14	EasyBlogRatingsHelper->getHTML()	JROOT/components/com_easyblog/themes/default/blog.rating.php:18
13	include JROOT/components/com_easyblog/themes/default/blog.rating.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:141
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.79 ms After last query: 0.76 ms Query memory: 0.025 MB Memory before query: 3.555 MB Rows returned: 1

SELECT AVG(value) AS ratings, COUNT(1) AS total 
  FROM `icecool_easyblog_ratings` 
  WHERE `uid`='45' 
  AND `type`='entry'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.07 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	JROOT/components/com_easyblog/helpers/db.php:109
17	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
16	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/models/ratings.php:78
15	EasyBlogModelRatings->getRatingValues()	JROOT/components/com_easyblog/helpers/ratings.php:49
14	EasyBlogRatingsHelper->getHTML()	JROOT/components/com_easyblog/themes/default/blog.rating.php:18
13	include JROOT/components/com_easyblog/themes/default/blog.rating.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:141
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.47 ms After last query: 2.66 ms Query memory: 0.026 MB Memory before query: 3.575 MB Rows returned: 1

SELECT *

  FROM icecool_easyblog_post

  WHERE `id` = '44'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.11 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
16	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
15	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/router.php:203
14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:20
13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.92 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 3.584 MB Rows returned: 0

Duplicate queries: #50 #53 #78 #88

SELECT `id` 
  FROM `icecool_menu` 
  WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=966' 
  AND `published`='1' 
  AND (`language`='en-GB' OR `language` = '*' ) 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
18	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
17	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
16	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1108
15	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:208
14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:20
13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.23 ms After last query: 0.17 ms Query memory: 0.028 MB Memory before query: 3.595 MB Rows returned: 1

SELECT a.* 
  FROM `icecool_easyblog_post` as a 
  WHERE a.`id` ='44'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
25	JDatabaseDriver->loadObject()	JROOT/components/com_easyblog/helpers/db.php:109
24	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
23	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:688
22	EasyBlogRouter::getBlogSefPermalink()	JROOT/components/com_easyblog/router.php:35
21	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:20
13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.94 ms After last query: 0.24 ms Query memory: 0.026 MB Memory before query: 3.607 MB Rows returned: 1

SELECT *

  FROM icecool_easyblog_post

  WHERE `id` = '46'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
16	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
15	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/router.php:203
14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:28
13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.57 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 3.614 MB Rows returned: 0

Duplicate queries: #50 #53 #78 #85

SELECT `id` 
  FROM `icecool_menu` 
  WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=966' 
  AND `published`='1' 
  AND (`language`='en-GB' OR `language` = '*' ) 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
18	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
17	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
16	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1108
15	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:208
14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:28
13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
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.90 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 3.625 MB Rows returned: 1

SELECT a.* 
  FROM `icecool_easyblog_post` as a 
  WHERE a.`id` ='46'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
25	JDatabaseDriver->loadObject()	JROOT/components/com_easyblog/helpers/db.php:109
24	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
23	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:688
22	EasyBlogRouter::getBlogSefPermalink()	JROOT/components/com_easyblog/router.php:35
21	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
15	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:28
13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.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:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

55 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

9 × SELECT * 
  FROM icecool_easyblog_post

9 × SELECT `id` 
  FROM `icecool_menu`

5 × SELECT * 
  FROM `icecool_easyblog_acl_group`

3 × SELECT * 
  FROM icecool_easyblog_category

3 × SELECT COUNT(1) 
  FROM `icecool_easyblog_category`

3 × SELECT a.* 
  FROM `icecool_easyblog_post` as a

3 × SELECT * 
  FROM icecool_easyblog_meta

2 × SELECT a.`id`, a.`title`, a.`alias` 
  FROM `icecool_easyblog_tag` AS a 
  LEFT JOIN `icecool_easyblog_post_tag` AS b 
  ON a.`id` = b.`tag_id`

2 × SELECT a.`id` 
  FROM icecool_easyblog_post as a

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

2 × SELECT * 
  FROM `icecool_easyblog_acl`

2 × SELECT a.rules 
  FROM icecool_assets AS a

2 × SELECT a.`id`, a.`title` 
  FROM `icecool_easyblog_post` AS `a`

```
1 × SELECT * 
  FROM `icecool_users`
```

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

1 × SELECT `group_id` 
  FROM `icecool_user_usergroup_map`

1 × select distinct a.`id`, a.`private` 
  from `icecool_easyblog_category` as a  
  left join `icecool_easyblog_category_acl` as b 
  on a.`id` = b.`category_id` 
  and b.`acl_id` = '1'

1 × select `tag_id` 
  from `icecool_easyblog_post_tag`

1 × SELECT COUNT(1) 
  FROM `icecool_easyblog_comment`

1 × SELECT `title` 
  FROM `icecool_easyblog_category`

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `icecool_usergroups` AS g 
  INNER JOIN `icecool_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 × select `id` 
  FROM `icecool_easyblog_adsense`

1 × SELECT * 
  FROM `icecool_easyblog_ratings`

1 × SELECT * 
  FROM `icecool_easyblog_trackback`

1 × SELECT `data` 
  FROM `icecool_session`

1 × SELECT * 
  FROM icecool_easyblog_users

1 × SELECT * 
  FROM icecool_languages

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

1 × SELECT id, rules 
  FROM `icecool_viewlevels

1 × SELECT folder AS type, element AS name, params 
  FROM icecool_extensions

1 × SELECT `enabled` 
  FROM `icecool_extensions`

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

1 × SELECT * 
  FROM icecool_easyblog_configs

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

1 × SELECT COUNT(1) 
  FROM `icecool_easyblog_featured`

1 × SELECT `id` 
  FROM `icecool_easyblog_mailq`

1 × SELECT * 
  FROM `icecool_easyblog_post`

```
1 × SELECT * 
  FROM icecool_assets
```
```
1 × SELECT id 
  FROM icecool_assets
```

1 × SELECT COUNT(*) 
  FROM `icecool_easyblog_configs`

1 × SELECT id, keywords, description, indexing 
  FROM `icecool_easyblog_meta`

1 × SELECT AVG(value) AS ratings, COUNT(1) AS total 
  FROM `icecool_easyblog_ratings`

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `icecool_easyblog_configs

1 × SHOW FULL COLUMNS 
  FROM `icecool_easyblog_post

1 × UPDATE `icecool_extensions` 
  SET `params` = '{\"mediaversion\":\"06c78c58767635103d3626320e86c383\"}'

1 × DELETE 
  FROM `icecool_easyblog_mailq`

1 × UPDATE `icecool_easyblog_post` 
  SET `published` = '0'

1 × SHOW FULL COLUMNS 
  FROM `icecool_assets

1 × SHOW FULL COLUMNS 
  FROM `icecool_easyblog_users

1 × SHOW FULL COLUMNS 
  FROM `icecool_easyblog_category

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

1 × SHOW FULL COLUMNS 
  FROM `icecool_users

1 × SHOW FULL COLUMNS 
  FROM `icecool_easyblog_meta

1 × SHOW FULL COLUMNS 
  FROM `icecool_easyblog_adsense

1 × SHOW FULL COLUMNS 
  FROM `icecool_easyblog_ratings

custom made diamond rings & jewellery

Book a Design Appointment

020 7404 6374

Blog

Pink Star Diamond to fetch $60 million at Sotheby’s auction

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

89 Queries Logged 128.97 ms

27 duplicate found!

55 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: