Exploring Biotechnology

May 14 Posted by CareerZing in Articles & Interviews

bio-medical-3 Careerzing has had many questions about the new field of Biotechnology. Here are a few websites to help you explore this exciting and varied field.

Biotech Resource Web Sites

Northeast Biomanufacturing Center and Collaborative – colleges and community college programs in associates and bachelors degree programs throughout the northeast United States. There are also job postings. Check them out even if you are not searching for a job right now. The postings will give you descriptions of work and salary ranges. This site also offers information on apprenticeships and features students who have participated in them. They give, in their own words, details of their experiences. Link to 8 different sites with more biotech knowledge. Read articles on the latest biotech industry news.
Bio-Link - This site features a comprehensive list of educational, industry and organizational resources related to biotechnology by state. Career profiles of several professionals including “Research & Development Scientist”, “Metrology Specialist”, “DNA Library Coordinator” and others. Watch a biotech student working in the lab under the direction of her professor. Look at some resumes of biotech professionals and see what education they’ve obtained and the projects they’ve work on.
CareerVoyages.gov – This site has a handy search tool where you can explore by state. Pick a biotech interest and view the programs availbable from certifications to 4 year degrees and beyond. The site also offers and industry overview and descriptions of various fields within biotech like agriculture, bioinformatics and bioprocessing. Check out the list of “in-demand” occupations for the biotech field and educational requirements for each.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1715932848,
                "last": 1715932848,
                "now": 1715932850
            },
            "token": "lxfHW1nCcs3oi8Aed11i6Iih3ydAUyN9"
        },
        "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
        },
        "e4e7e63e471330487120a1b35c7d16c8": 1,
        "e7cc2e5ad852529faa621c263eef9701": 1
    },
    "__EBLOG": {
        "MESSAGE": {
            "eblog": {
                "message": {
                    "queue": null
                }
            }
        }
    }
}

Profile Information

Memory Usage

Database Queries

49 Queries Logged 22.56 ms

9 duplicate found!

3 duplicates: #12 #26 #30

2 duplicates: #23 #40

2 duplicates: #28 #31

2 duplicates: #29 #32

Query Time: 0.23 ms Query memory: 0.023 MB Memory before query: 3.774 MB Rows returned: 1

SELECT `data`

  FROM `f8dzt_session`

  WHERE `session_id` = X'396c6967303176706c6f31736962766f323068693172766a717231656b6b7564'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.48 ms After last query: 46.78 ms Query memory: 0.024 MB Memory before query: 4.074 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.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.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.02 ms
cleaning up	0.05 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.25 ms After last query: 29.34 ms Query memory: 0.021 MB Memory before query: 4.328 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.02 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.08 ms Query memory: 0.021 MB Memory before query: 4.340 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.66 ms After last query: 7.68 ms Query memory: 0.030 MB Memory before query: 4.409 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.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.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.40 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.57 ms After last query: 171.62 ms Query memory: 0.048 MB Memory before query: 5.722 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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 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.05 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: 1.34 ms After last query: 269.63 ms Query memory: 0.025 MB Memory before query: 8.698 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.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.76 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 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.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.31 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.33 ms After last query: 12.03 ms Query memory: 0.061 MB Memory before query: 8.728 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.00 ms
cleaning up	0.06 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.44 ms After last query: 59.64 ms Query memory: 0.033 MB Memory before query: 9.122 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.73 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.01 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.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.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.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.31 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.53 ms After last query: 4.38 ms Query memory: 0.022 MB Memory before query: 9.175 MB Rows returned: 0

SELECT a.`id` 
  FROM f8dzt_easyblog_post as a 
  WHERE a.`permalink` = 'exploring:biotechnology'

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.32 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.38 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 9.181 MB Rows returned: 1

SELECT a.`id` 
  FROM f8dzt_easyblog_post as a 
  WHERE a.`permalink` = 'exploring-biotechnology'

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.22 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
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.23 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 9.193 MB Rows returned: 1

Duplicate queries: #26 #30

SELECT *

  FROM f8dzt_easyblog_post

  WHERE `id` = '123'

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: 11.99 ms Query memory: 0.024 MB Memory before query: 9.240 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.00 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.58 ms After last query: 0.12 ms Query memory: 0.006 MB Memory before query: 9.233 MB

UPDATE `f8dzt_extensions`

  SET `params` = '{\"mediaversion\":\"e067825a8225ba210dcaa89a02dcd6c5\"}'

  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.02 ms
query end	0.36 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: 8.32 ms Query memory: 0.019 MB Memory before query: 9.407 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.480 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.31 ms After last query: 56.28 ms Query memory: 0.022 MB Memory before query: 9.804 MB Rows returned: 0

SELECT * 
  FROM `f8dzt_easyblog_post` 
  WHERE `publish_up` <= '2024-05-17 08:00:50' 
  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.01 ms
init	0.03 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.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 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: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.92 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 9.811 MB

UPDATE `f8dzt_easyblog_post` 
  SET `published` = '0' 
  WHERE `publish_down` > `publish_up` 
  AND `publish_down` <= '2024-05-17 08:00:50' 
  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.01 ms
init	0.01 ms
System lock	0.04 ms
Searching rows for update	0.50 ms
updating	0.00 ms
end	0.01 ms
query end	0.18 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.03 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.54 ms After last query: 71.57 ms Query memory: 0.028 MB Memory before query: 10.670 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.09 ms
preparing	0.00 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.07 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: 2.13 ms After last query: 14.48 ms Query memory: 0.028 MB Memory before query: 10.866 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.48 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.02 ms
checking permissions	0.01 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
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.33 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.24 ms After last query: 18.98 ms Query memory: 0.024 MB Memory before query: 10.943 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.07 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.26 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 10.956 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.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.04 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.27 ms After last query: 0.21 ms Query memory: 0.028 MB Memory before query: 10.970 MB Rows returned: 32

Duplicate queries: #40

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.00 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.08 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.70 ms After last query: 0.12 ms Query memory: 0.028 MB Memory before query: 10.998 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.01 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.04 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.30 ms After last query: 164.04 ms Query memory: 0.022 MB Memory before query: 13.089 MB Rows returned: 1

SELECT id, keywords, description, indexing 
  FROM `f8dzt_easyblog_meta` 
  WHERE content_id = '123' 
  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.05 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.24 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 13.104 MB Rows returned: 1

Duplicate queries: #12 #30

SELECT *

  FROM f8dzt_easyblog_post

  WHERE `id` = '123'

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.01 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.00 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: 2.09 ms After last query: 12.58 ms Query memory: 0.028 MB Memory before query: 13.299 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.39 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.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.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.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.38 ms
closing tables	0.00 ms
freeing items	0.02 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.19 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 13.327 MB Rows returned: 1

Duplicate queries: #31

SELECT *

  FROM f8dzt_easyblog_category

  WHERE `id` = '6'

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.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.25 ms After last query: 3.31 ms Query memory: 0.023 MB Memory before query: 13.337 MB Rows returned: 1

Duplicate queries: #32

SELECT COUNT(1) 
  FROM `f8dzt_easyblog_category` 
  WHERE `alias`='articles-interviews' 
  AND `id`!='6'

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.03 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.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/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.21 ms Query memory: 0.022 MB Memory before query: 13.339 MB Rows returned: 1

Duplicate queries: #12 #26

SELECT *

  FROM f8dzt_easyblog_post

  WHERE `id` = '123'

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.01 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.16 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 13.349 MB Rows returned: 1

Duplicate queries: #28

SELECT *

  FROM f8dzt_easyblog_category

  WHERE `id` = '6'

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.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/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.16 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 13.356 MB Rows returned: 1

Duplicate queries: #29

SELECT COUNT(1) 
  FROM `f8dzt_easyblog_category` 
  WHERE `alias`='articles-interviews' 
  AND `id`!='6'

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.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
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.40 ms After last query: 10.87 ms Query memory: 0.007 MB Memory before query: 13.494 MB

UPDATE f8dzt_easyblog_post

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

  WHERE `id` = '123'

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.01 ms
init	0.01 ms
System lock	0.02 ms
updating	0.04 ms
end	0.01 ms
query end	0.17 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.24 ms After last query: 3.58 ms Query memory: 0.023 MB Memory before query: 13.517 MB Rows returned: 1

SELECT COUNT(1) 
  FROM `f8dzt_easyblog_featured` 
  WHERE `content_id` = '123' 
  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.03 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.33 ms After last query: 7.10 ms Query memory: 0.022 MB Memory before query: 13.550 MB Rows returned: 0

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` = '123' 
  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	1	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.04 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.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
end	0.00 ms
removing tmp table	0.01 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.18 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 13.562 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.02 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.44 ms After last query: 4.56 ms Query memory: 0.028 MB Memory before query: 13.633 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.82 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.01 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.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.31 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.10 ms Query memory: 0.024 MB Memory before query: 13.661 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.00 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.01 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: 12.62 ms Query memory: 0.024 MB Memory before query: 14.477 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.03 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.02 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.30 ms After last query: 16.23 ms Query memory: 0.028 MB Memory before query: 14.562 MB Rows returned: 32

Duplicate queries: #23

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.03 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
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 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/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.22 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 14.591 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.15 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 14.600 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.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.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.28 ms After last query: 0.05 ms Query memory: 0.028 MB Memory before query: 14.609 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.05 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.18 ms Query memory: 0.025 MB Memory before query: 14.600 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.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.16 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.30 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 14.610 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.27 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 14.619 MB Rows returned: 0

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.22 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 14.628 MB Rows returned: 1

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.01 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.28 ms After last query: 2.61 ms Query memory: 0.024 MB Memory before query: 14.641 MB Rows returned: 1

SELECT `id` 
  FROM `f8dzt_menu` 
  WHERE (`link`='index.php?option=com_easyblog&view=categories&layout=listings&id=6' OR `link` LIKE 'index.php?option=com_easyblog&view=categories&layout=listings&id=6&
  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.09 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.16 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 14.650 MB Rows returned: 1

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

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.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.]

35 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
5 × SELECT `id` 
  FROM `f8dzt_menu`
```

3 × SELECT * 
  FROM f8dzt_easyblog_post

3 × SELECT * 
  FROM `f8dzt_easyblog_acl_group`

2 × SELECT * 
  FROM f8dzt_easyblog_category

2 × SELECT * 
  FROM f8dzt_easyblog_configs

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

2 × SELECT COUNT(1) 
  FROM `f8dzt_easyblog_category`

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

2 × SELECT * 
  FROM `f8dzt_easyblog_acl`

1 × SELECT `data` 
  FROM `f8dzt_session`

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 COUNT(*) 
  FROM `f8dzt_easyblog_configs`

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

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 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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM f8dzt_extensions

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 id, rules 
  FROM `f8dzt_viewlevels

1 × SELECT `title` 
  FROM `f8dzt_easyblog_category`

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_configs

1 × SHOW FULL COLUMNS 
  FROM `f8dzt_easyblog_post

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

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