What is on Your Mind?

Feb 02 Posted by CareerZing in What is on your mind?

Start the discussion Today!

Add your comments. Ask questions. Post your thoughts. Let CareerZing know what is on your mind.

Tags: discussion, we want to know, What is on your mind

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1743792168,
                "last": 1743792168,
                "now": 1743792168
            },
            "token": "m0YMXxGLo5VqdRkMX9loNBI0WcVO4YGR"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "4d44a086988186aac6aa615fe9ed0663": 1
    },
    "__EBLOG": {
        "MESSAGE": {
            "eblog": {
                "message": {
                    "queue": null
                }
            }
        }
    }
}

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

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

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

EXPLAIN not possible on query: INSERT INTO `f8dzt_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'673638717564653631326d34713875626133686163763739673373706b6d3336', 1, 1743792168, 0, '', 0)

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
update	0.05 ms
end	0.00 ms
query end	0.28 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.08 ms

Call Stack

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

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

Query Time: 0.44 ms After last query: 12.62 ms Query memory: 0.024 MB Memory before query: 4.152 MB Rows returned: 40

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

  FROM `f8dzt_extensions`

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.21 ms After last query: 9.77 ms Query memory: 0.021 MB Memory before query: 4.343 MB Rows returned: 5

SELECT id, rules

  FROM `f8dzt_viewlevels`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.22 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 4.355 MB Rows returned: 2

SELECT b.id

  FROM f8dzt_usergroups AS a

  LEFT JOIN f8dzt_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
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.06 ms

Call Stack

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

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

Query Time: 0.70 ms After last query: 2.43 ms Query memory: 0.030 MB Memory before query: 4.424 MB Rows returned: 96

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

  FROM f8dzt_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	f8dzt_extensions	ref	extension	extension	82	const	125	100.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

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

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

Query Time: 0.58 ms After last query: 55.08 ms Query memory: 0.048 MB Memory before query: 5.737 MB Rows returned: 23

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

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

Profile

Status	Duration
starting	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
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.19 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.04 ms

Call Stack

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

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

Query Time: 2.87 ms After last query: 89.51 ms Query memory: 0.026 MB Memory before query: 8.714 MB Rows returned: 2

SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_configs`

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	2.17 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 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.43 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__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/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 6.38 ms Query memory: 0.061 MB Memory before query: 8.744 MB Rows returned: 1

SELECT *

  FROM f8dzt_easyblog_configs

  WHERE `name` = 'config'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_easyblog/helpers/helper.php:592
11	EasyBlogHelper::getConfig()	JROOT/components/com_easyblog/router.php:257
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.87 ms After last query: 19.82 ms Query memory: 0.033 MB Memory before query: 9.137 MB Rows returned: 35

SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_post`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
15	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/blog.php:65
14	EasyBlogTableBlog->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::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/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 1.02 ms Query memory: 0.022 MB Memory before query: 9.190 MB Rows returned: 0

SELECT a.`id` 
  FROM f8dzt_easyblog_post as a 
  WHERE a.`permalink` = 'what:is-
  on-your-mind'

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	248	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:82
11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/router.php:307
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 9.196 MB Rows returned: 1

SELECT a.`id` 
  FROM f8dzt_easyblog_post as a 
  WHERE a.`permalink` = 'what-is-
  on-your-mind'

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	248	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:91
11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/router.php:307
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 9.208 MB Rows returned: 1

Duplicate queries: #28 #32

SELECT *

  FROM f8dzt_easyblog_post

  WHERE `id` = '161'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:93
11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/router.php:307
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 3.72 ms Query memory: 0.024 MB Memory before query: 9.255 MB Rows returned: 1

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

  FROM `f8dzt_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f8dzt_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
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 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
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.12 ms Query memory: 0.006 MB Memory before query: 9.248 MB

UPDATE `f8dzt_extensions`

  SET `params` = '{\"mediaversion\":\"4b013c6f9556ba7752aadd4e95fadff2\"}'

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 3.88 ms Query memory: 0.020 MB Memory before query: 9.487 MB Rows returned: 1

SELECT *

  FROM f8dzt_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	f8dzt_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
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 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.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.19 ms Query memory: 0.019 MB Memory before query: 9.497 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM f8dzt_template_styles as s

  LEFT JOIN f8dzt_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,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	60.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	careerdb2015.s.template,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 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.00 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

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

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

Query Time: 0.29 ms After last query: 18.29 ms Query memory: 0.021 MB Memory before query: 9.820 MB Rows returned: 0

SELECT * 
  FROM `f8dzt_easyblog_post` 
  WHERE `publish_up` <= '2025-04-04 18:42:48' 
  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	f8dzt_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
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 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.00 ms
freeing items	0.01 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:2525
7	EasyBlogHelper::processScheduledPost()	JROOT/components/com_easyblog/easyblog.php:85
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.76 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 9.826 MB

UPDATE `f8dzt_easyblog_post` 
  SET `published` = '0' 
  WHERE `publish_down` > `publish_up` 
  AND `publish_down` <= '2025-04-04 18:42:48' 
  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	f8dzt_easyblog_post	range	easyblog_post_published,easyblog_post_blogger_list	easyblog_post_blogger_list	1	const	231	100.00	Using where; Using temporary

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.03 ms
Searching rows for update	0.41 ms
updating	0.00 ms
end	0.01 ms
query end	0.14 ms
closing tables	0.01 ms
freeing items	0.01 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:2501
7	EasyBlogHelper::unPublishPost()	JROOT/components/com_easyblog/easyblog.php:88
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 25.58 ms Query memory: 0.028 MB Memory before query: 10.700 MB Rows returned: 40

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

  FROM `f8dzt_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f8dzt_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	155	26.45	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->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:3524
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:611
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.74 ms After last query: 4.76 ms Query memory: 0.028 MB Memory before query: 10.895 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_users`

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.42 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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__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/src/Table/Table.php:312
16	Joomla\CMS\Table\Table::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:3524
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:611
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 5.60 ms Query memory: 0.024 MB Memory before query: 10.972 MB Rows returned: 1

SELECT COUNT(*) 
  FROM `f8dzt_easyblog_configs` 
  WHERE `name` = 'nomad'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:3524
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:611
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 10.985 MB Rows returned: 1

SELECT *

  FROM f8dzt_easyblog_configs

  WHERE `name` = 'nomad'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 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
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
15	Joomla\CMS\Table\Table->load()	JROOT/components/com_easyblog/classes/themes.php:159
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:3524
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:611
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.18 ms Query memory: 0.028 MB Memory before query: 11.000 MB Rows returned: 32

Duplicate queries: #42

SELECT * 
  FROM `f8dzt_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	f8dzt_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
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:3524
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:611
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.09 ms Query memory: 0.028 MB Memory before query: 11.027 MB Rows returned: 36

SELECT * 
  FROM `f8dzt_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	f8dzt_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
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 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.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:3524
9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:611
7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 60.46 ms Query memory: 0.022 MB Memory before query: 13.118 MB Rows returned: 1

SELECT id, keywords, description, indexing 
  FROM `f8dzt_easyblog_meta` 
  WHERE content_id = '161' 
  and type = 'post'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
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:3048
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 13.134 MB Rows returned: 1

Duplicate queries: #14 #32

SELECT *

  FROM f8dzt_easyblog_post

  WHERE `id` = '161'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:72
11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/helper.php:3071
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.76 ms After last query: 3.97 ms Query memory: 0.028 MB Memory before query: 13.327 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_category`

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.04 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
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.42 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__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/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::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:3076
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 13.355 MB Rows returned: 1

Duplicate queries: #33 #54

SELECT *

  FROM f8dzt_easyblog_category

  WHERE `id` = '12'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 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
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
11	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/helper.php:3077
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.88 ms Query memory: 0.023 MB Memory before query: 13.365 MB Rows returned: 1

Duplicate queries: #34 #55

SELECT COUNT(1) 
  FROM `f8dzt_easyblog_category` 
  WHERE `alias`='what-is-
  on-your-mind' 
  AND `id`!='12'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 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.00 ms
freeing items	0.01 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/src/Table/Table.php:741
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
11	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/helper.php:3077
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 13.369 MB Rows returned: 1

Duplicate queries: #14 #28

SELECT *

  FROM f8dzt_easyblog_post

  WHERE `id` = '161'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
11	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:72
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 13.383 MB Rows returned: 1

Duplicate queries: #30 #54

SELECT *

  FROM f8dzt_easyblog_category

  WHERE `id` = '12'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 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
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
11	EasyBlogTableCategory->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:735
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 13.392 MB Rows returned: 1

Duplicate queries: #31 #55

SELECT COUNT(1) 
  FROM `f8dzt_easyblog_category` 
  WHERE `alias`='what-is-
  on-your-mind' 
  AND `id`!='12'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 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
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/src/Table/Table.php:741
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
11	EasyBlogTableCategory->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:735
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 3.97 ms Query memory: 0.006 MB Memory before query: 13.522 MB

UPDATE f8dzt_easyblog_post

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

  WHERE `id` = '161'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
11	Joomla\CMS\Table\Table->hit()	JROOT/administrator/components/com_easyblog/tables/blog.php:265
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 1.20 ms Query memory: 0.023 MB Memory before query: 13.545 MB Rows returned: 1

SELECT COUNT(1) 
  FROM `f8dzt_easyblog_featured` 
  WHERE `content_id` = '161' 
  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
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1805
11	EasyBlogHelper::isFeatured()	JROOT/administrator/components/com_easyblog/tables/blog.php:762
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 2.47 ms Query memory: 0.022 MB Memory before query: 13.578 MB Rows returned: 3

SELECT a.`id`, a.`title`, a.`alias` 
  FROM `f8dzt_easyblog_tag` AS a 
  LEFT JOIN `f8dzt_easyblog_post_tag` AS b 
  ON a.`id` = b.`tag_id` 
  WHERE b.`post_id` = '161' 
  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	b	ref	easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id	easyblog_post_tag_post_id	8	const	3	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY,easyblog_tag_published,easyblog_tag_query1	PRIMARY	8	careerdb2015.b.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 13.591 MB Rows returned: 1

SELECT *

  FROM f8dzt_easyblog_users

  WHERE `id` = '281'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 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
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
11	Joomla\CMS\Table\Table->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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.58 ms After last query: 1.37 ms Query memory: 0.028 MB Memory before query: 13.662 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `f8dzt_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
18	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
17	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
16	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
15	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
14	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
13	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
12	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
11	Joomla\CMS\Factory::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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 13.753 MB Rows returned: 1

SELECT *

  FROM `f8dzt_users`

  WHERE `id` = 281

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 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
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
15	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
14	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
13	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
12	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
11	Joomla\CMS\Factory::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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 4.92 ms Query memory: 0.024 MB Memory before query: 14.506 MB Rows returned: 1

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

  FROM `f8dzt_usergroups` AS g

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

  WHERE `m`.`user_id` = 281

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
15	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
14	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
13	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
12	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
11	Joomla\CMS\Factory::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/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 5.44 ms Query memory: 0.028 MB Memory before query: 14.592 MB Rows returned: 32

Duplicate queries: #25

SELECT * 
  FROM `f8dzt_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	f8dzt_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
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 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.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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/helpers/helper.php:4804
13	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:322
12	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:17
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 14.621 MB Rows returned: 0

SELECT * 
  FROM `f8dzt_easyblog_acl_group` 
  WHERE `content_id`='281' 
  AND `type`='assigned'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f8dzt_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
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 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.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:53
14	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4804
13	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:322
12	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:17
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 14.630 MB Rows returned: 1

SELECT `group_id` 
  FROM `f8dzt_user_usergroup_map` 
  WHERE `user_id` = '281'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 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
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/components/com_easyblog/helpers/db.php:84
16	EasyBlogDbJoomla30->loadResultArray()	JROOT/components/com_easyblog/helpers/db.php:43
15	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:72
14	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4804
13	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:322
12	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:17
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 14.639 MB Rows returned: 36

SELECT * 
  FROM `f8dzt_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	f8dzt_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
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 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.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:84
14	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4804
13	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:322
12	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:17
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 14.630 MB Rows returned: 0

SELECT `id` 
  FROM `f8dzt_menu` 
  WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=281' 
  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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/helpers/router.php:1111
14	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:301
13	EasyBlogRouter::_()	JROOT/administrator/components/com_easyblog/tables/profile.php:378
12	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:17
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 14.639 MB Rows returned: 0

SELECT `id` 
  FROM `f8dzt_menu` 
  WHERE (`link`='index.php?option=com_easyblog&view=blogger' OR `link` LIKE 'index.php?option=com_easyblog&view=blogger&
  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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/helpers/router.php:1218
14	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:310
13	EasyBlogRouter::_()	JROOT/administrator/components/com_easyblog/tables/profile.php:378
12	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:17
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 14.648 MB Rows returned: 0

Duplicate queries: #52 #60

SELECT `id` 
  FROM `f8dzt_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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/helpers/router.php:1246
14	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:310
13	EasyBlogRouter::_()	JROOT/administrator/components/com_easyblog/tables/profile.php:378
12	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:17
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 14.657 MB Rows returned: 1

Duplicate queries: #53 #61

SELECT `id` 
  FROM `f8dzt_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	f8dzt_menu	index	idx_language	PRIMARY	4	NULL	1	5500.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/helpers/router.php:1258
14	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:310
13	EasyBlogRouter::_()	JROOT/administrator/components/com_easyblog/tables/profile.php:378
12	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:17
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 1.22 ms Query memory: 0.024 MB Memory before query: 14.671 MB Rows returned: 0

SELECT `id` 
  FROM `f8dzt_menu` 
  WHERE (`link`='index.php?option=com_easyblog&view=categories&layout=listings&id=12' OR `link` LIKE 'index.php?option=com_easyblog&view=categories&layout=listings&id=12&
  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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1076
13	EasyBlogRouter::getItemIdByCategories()	JROOT/components/com_easyblog/helpers/router.php:323
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:36
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 14.680 MB Rows returned: 0

SELECT `id` 
  FROM `f8dzt_menu` 
  WHERE (`link`='index.php?option=com_easyblog&view=categories' OR `link` LIKE 'index.php?option=com_easyblog&view=categories&
  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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1218
13	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:340
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:36
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 14.688 MB Rows returned: 0

Duplicate queries: #48 #60

SELECT `id` 
  FROM `f8dzt_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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1246
13	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:340
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:36
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 14.697 MB Rows returned: 1

Duplicate queries: #49 #61

SELECT `id` 
  FROM `f8dzt_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	f8dzt_menu	index	idx_language	PRIMARY	4	NULL	1	5500.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1258
13	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:340
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:36
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 14.712 MB Rows returned: 1

Duplicate queries: #30 #33

SELECT *

  FROM f8dzt_easyblog_category

  WHERE `id` = '12'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 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
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
23	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
22	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/router.php:662
21	EasyBlogRouter::getCategoryPermalink()	JROOT/components/com_easyblog/router.php:53
20	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_easyblog/helpers/router.php:475
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:36
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.05 ms Query memory: 0.028 MB Memory before query: 14.724 MB Rows returned: 1

Duplicate queries: #31 #34

SELECT COUNT(1) 
  FROM `f8dzt_easyblog_category` 
  WHERE `alias`='what-is-
  on-your-mind' 
  AND `id`!='12'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/category.php:190
25	EasyBlogTableCategory->aliasExists()	JROOT/administrator/components/com_easyblog/tables/category.php:210
24	EasyBlogTableCategory->bind()	JROOT/libraries/src/Table/Table.php:741
23	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
22	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/router.php:662
21	EasyBlogRouter::getCategoryPermalink()	JROOT/components/com_easyblog/router.php:53
20	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_easyblog/helpers/router.php:475
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:36
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 14.729 MB Rows returned: 1

SELECT `title` 
  FROM `f8dzt_easyblog_category` 
  WHERE `id` = '12'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/administrator/components/com_easyblog/tables/blog.php:187
12	EasyBlogTableBlog->getCategoryName()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:36
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 14.754 MB Rows returned: 0

SELECT `id` 
  FROM `f8dzt_menu` 
  WHERE (`link`='index.php?option=com_easyblog&view=tags&layout=tag&id=13' OR `link` LIKE 'index.php?option=com_easyblog&view=tags&layout=tag&id=13&
  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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1139
13	EasyBlogRouter::getItemIdByTag()	JROOT/components/com_easyblog/helpers/router.php:386
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 14.763 MB Rows returned: 0

SELECT `id` 
  FROM `f8dzt_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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1218
13	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 14.772 MB Rows returned: 0

SELECT `id` 
  FROM `f8dzt_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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 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.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1233
13	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 14.780 MB Rows returned: 0

Duplicate queries: #48 #52

SELECT `id` 
  FROM `f8dzt_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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1246
13	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 14.789 MB Rows returned: 1

Duplicate queries: #49 #53

SELECT `id` 
  FROM `f8dzt_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	f8dzt_menu	index	idx_language	PRIMARY	4	NULL	1	5500.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1258
13	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.51 ms After last query: 1.40 ms Query memory: 0.031 MB Memory before query: 14.846 MB Rows returned: 9

SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_tag`

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.86 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Opening tables	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
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.41 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
29	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
28	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
27	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
26	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/tag.php:39
25	EasyBlogTableTag->__construct()	JROOT/libraries/src/Table/Table.php:312
24	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
23	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
22	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/helpers/router.php:578
21	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
20	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_easyblog/helpers/router.php:531
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.08 ms Query memory: 0.027 MB Memory before query: 14.873 MB Rows returned: 1

SELECT *

  FROM f8dzt_easyblog_tag

  WHERE `id` = '13'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 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
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
23	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
22	EasyBlogTableTag->load()	JROOT/components/com_easyblog/helpers/router.php:579
21	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
20	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_easyblog/helpers/router.php:531
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 14.885 MB Rows returned: 1

SELECT COUNT(1) 
  FROM `f8dzt_easyblog_tag` 
  WHERE `alias`='discussion' 
  AND `id`!='13'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f8dzt_easyblog_tag	ref	PRIMARY,easyblog_tag_alias	easyblog_tag_alias	768	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/tag.php:110
25	EasyBlogTableTag->aliasExists()	JROOT/administrator/components/com_easyblog/tables/tag.php:152
24	EasyBlogTableTag->bind()	JROOT/libraries/src/Table/Table.php:741
23	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
22	EasyBlogTableTag->load()	JROOT/components/com_easyblog/helpers/router.php:579
21	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
20	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_easyblog/helpers/router.php:531
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.15 ms Query memory: 0.030 MB Memory before query: 14.901 MB Rows returned: 0

SELECT `id` 
  FROM `f8dzt_menu` 
  WHERE (`link`='index.php?option=com_easyblog&view=tags&layout=tag&id=14' OR `link` LIKE 'index.php?option=com_easyblog&view=tags&layout=tag&id=14&
  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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1139
13	EasyBlogRouter::getItemIdByTag()	JROOT/components/com_easyblog/helpers/router.php:386
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 14.922 MB Rows returned: 1

SELECT *

  FROM f8dzt_easyblog_tag

  WHERE `id` = '14'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 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
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
23	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
22	EasyBlogTableTag->load()	JROOT/components/com_easyblog/helpers/router.php:579
21	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
20	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_easyblog/helpers/router.php:531
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 14.934 MB Rows returned: 1

SELECT COUNT(1) 
  FROM `f8dzt_easyblog_tag` 
  WHERE `alias`='we-want-to-know' 
  AND `id`!='14'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f8dzt_easyblog_tag	ref	PRIMARY,easyblog_tag_alias	easyblog_tag_alias	768	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/tag.php:110
25	EasyBlogTableTag->aliasExists()	JROOT/administrator/components/com_easyblog/tables/tag.php:152
24	EasyBlogTableTag->bind()	JROOT/libraries/src/Table/Table.php:741
23	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
22	EasyBlogTableTag->load()	JROOT/components/com_easyblog/helpers/router.php:579
21	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
20	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_easyblog/helpers/router.php:531
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 14.940 MB Rows returned: 0

SELECT `id` 
  FROM `f8dzt_menu` 
  WHERE (`link`='index.php?option=com_easyblog&view=tags&layout=tag&id=12' OR `link` LIKE 'index.php?option=com_easyblog&view=tags&layout=tag&id=12&
  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	f8dzt_menu	range	idx_language	idx_language	28	NULL	55	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:1139
13	EasyBlogRouter::getItemIdByTag()	JROOT/components/com_easyblog/helpers/router.php:386
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.10 ms Query memory: 0.027 MB Memory before query: 14.955 MB Rows returned: 1

SELECT *

  FROM f8dzt_easyblog_tag

  WHERE `id` = '12'

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 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
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
23	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
22	EasyBlogTableTag->load()	JROOT/components/com_easyblog/helpers/router.php:579
21	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
20	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_easyblog/helpers/router.php:531
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 14.967 MB Rows returned: 1

SELECT COUNT(1) 
  FROM `f8dzt_easyblog_tag` 
  WHERE `alias`='what-is-
  on-your-mind' 
  AND `id`!='12'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f8dzt_easyblog_tag	ref	PRIMARY,easyblog_tag_alias	easyblog_tag_alias	768	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/tag.php:110
25	EasyBlogTableTag->aliasExists()	JROOT/administrator/components/com_easyblog/tables/tag.php:152
24	EasyBlogTableTag->bind()	JROOT/libraries/src/Table/Table.php:741
23	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
22	EasyBlogTableTag->load()	JROOT/components/com_easyblog/helpers/router.php:579
21	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
20	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_easyblog/helpers/router.php:531
12	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.print.php:60
11	include JROOT/components/com_easyblog/themes/default/blog.read.print.php	JROOT/components/com_easyblog/classes/themes.php:319
10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:350
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:142
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
15 × SELECT `id` 
  FROM `f8dzt_menu`
```

3 × SELECT COUNT(1) 
  FROM `f8dzt_easyblog_tag`

3 × SELECT * 
  FROM f8dzt_easyblog_post

3 × SELECT * 
  FROM f8dzt_easyblog_tag

3 × SELECT COUNT(1) 
  FROM `f8dzt_easyblog_category`

3 × SELECT * 
  FROM f8dzt_easyblog_category

3 × SELECT * 
  FROM `f8dzt_easyblog_acl_group`

2 × SELECT * 
  FROM `f8dzt_easyblog_acl`

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

2 × SELECT * 
  FROM f8dzt_easyblog_configs

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

1 × SELECT `title` 
  FROM `f8dzt_easyblog_category`

1 × SELECT id, rules 
  FROM `f8dzt_viewlevels

1 × SELECT `group_id` 
  FROM `f8dzt_user_usergroup_map`

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

```
1 × SELECT * 
  FROM `f8dzt_users`
```

1 × SELECT * 
  FROM f8dzt_easyblog_users

1 × SELECT a.`id`, a.`title`, a.`alias` 
  FROM `f8dzt_easyblog_tag` AS a 
  LEFT JOIN `f8dzt_easyblog_post_tag` AS b 
  ON a.`id` = b.`tag_id`

1 × SELECT COUNT(1) 
  FROM `f8dzt_easyblog_featured`

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

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

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

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

1 × SELECT `session_id` 
  FROM `f8dzt_session`

1 × SELECT COUNT(*) 
  FROM `f8dzt_easyblog_configs`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `f8dzt_assets`

1 × SELECT * 
  FROM `f8dzt_easyblog_post`

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

```
1 × SELECT * 
  FROM f8dzt_languages
```

1 × SELECT `data` 
  FROM `f8dzt_session`

OTHER Tables:

1 × INSERT INTO `f8dzt_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'673638717564653631326d34713875626133686163763739673373706b6d3336', 1, 1743792168, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_configs

1 × SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_post

1 × UPDATE `f8dzt_extensions` 
  SET `params` = '{\"mediaversion\":\"4b013c6f9556ba7752aadd4e95fadff2\"}'

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

1 × SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_users

1 × SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_category

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

1 × SHOW FULL COLUMNS 
  FROM `f8dzt_users

1 × SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_tag

What is on Your Mind?

Start the discussion Today!

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

70 Queries Logged 29.54 ms

17 duplicate found!

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: