{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1550903721,
                "last": 1550903721,
                "now": 1550903721
            },
            "client": {
                "forwarded": "54.226.23.160"
            },
            "token": "BWdoWPgttZBxMbp4VJyDuCUJUauObdYQ"
        },
        "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
        }
    },
    "__easyblog": {
        "site": {
            "messages": null
        }
    }
}

Profile Information

Time

Memory

Time: 59.25 ms / 59.25 ms Memory: 0.575 MB / 0.95 MB Application: afterLoad

Time: 103.56 ms / 162.81 ms Memory: 0.844 MB / 1.79 MB Application: afterInitialise

Time: 107.68 ms / 270.49 ms Memory: 2.528 MB / 4.32 MB Application: afterRoute

Time: 2.81 ms / 273.30 ms Memory: 0.027 MB / 4.35 MB Application: beforeRenderComponent com_easyblog

Time: 56.30 ms / 329.60 ms Memory: 1.944 MB / 6.29 MB Application: Before Access::preloadComponents (all components)

Time: 1.36 ms / 330.96 ms Memory: 0.060 MB / 6.35 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 330.99 ms Memory: 0.000 MB / 6.35 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 2.43 ms / 333.42 ms Memory: 0.030 MB / 6.38 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 275.91 ms / 609.33 ms Memory: 6.108 MB / 12.49 MB Application: afterRenderComponent com_easyblog

Time: 8.68 ms / 618.01 ms Memory: 0.073 MB / 12.56 MB Application: afterDispatch

Time: 7.86 ms / 625.87 ms Memory: 0.027 MB / 12.59 MB Application: beforeRenderModule mod_footer_content (Footer-Content)

Time: 3.57 ms / 629.44 ms Memory: 0.008 MB / 12.60 MB Application: afterRenderModule mod_footer_content (Footer-Content)

Time: 0.07 ms / 629.50 ms Memory: 0.000 MB / 12.60 MB Application: beforeRenderModule mod_easyblogcategories (Blog Categories)

Time: 14.36 ms / 643.87 ms Memory: 0.097 MB / 12.69 MB Application: afterRenderModule mod_easyblogcategories (Blog Categories)

Time: 0.09 ms / 643.96 ms Memory: 0.000 MB / 12.69 MB Application: beforeRenderModule mod_easyblogarchive (EasyBlog Archive)

Time: 76.91 ms / 720.87 ms Memory: 0.300 MB / 12.99 MB Application: afterRenderModule mod_easyblogarchive (EasyBlog Archive)

Time: 0.10 ms / 720.97 ms Memory: 0.012 MB / 13.00 MB Application: beforeRenderModule mod_easybloglatestblogs (EasyBlog Latest Blogs)

Time: 70.94 ms / 791.91 ms Memory: 1.805 MB / 14.80 MB Application: afterRenderModule mod_easybloglatestblogs (EasyBlog Latest Blogs)

Time: 0.14 ms / 792.05 ms Memory: 0.000 MB / 14.66 MB Application: beforeRenderModule mod_body_text (News & Media Title and description)

Time: 1.36 ms / 793.41 ms Memory: 0.005 MB / 14.66 MB Application: afterRenderModule mod_body_text (News & Media Title and description)

Time: 0.06 ms / 793.47 ms Memory: 0.000 MB / 14.66 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 6.60 ms / 800.07 ms Memory: 0.014 MB / 14.67 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.07 ms / 800.14 ms Memory: 0.000 MB / 14.67 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 7.75 ms / 807.88 ms Memory: 0.036 MB / 14.71 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.09 ms / 807.98 ms Memory: 0.000 MB / 14.70 MB Application: beforeRenderModule mod_menu (Top Menu)

Time: 2.92 ms / 810.89 ms Memory: 0.048 MB / 14.75 MB Application: afterRenderModule mod_menu (Top Menu)

Time: 0.06 ms / 810.96 ms Memory: 0.000 MB / 14.75 MB Application: beforeRenderModule mod_google_analytics_code (Google Analytics Code)

Time: 1.44 ms / 812.40 ms Memory: 0.005 MB / 14.75 MB Application: afterRenderModule mod_google_analytics_code (Google Analytics Code)

Time: 2.11 ms / 814.51 ms Memory: 0.080 MB / 14.83 MB Application: afterRender

Database queries total: 94.00 ms

Database Queries

122 Queries Logged 94.00 ms

48 duplicate found!

3 duplicates: #16 #27 #62

2 duplicates: #17 #28

2 duplicates: #18 #29

2 duplicates: #54 #57

2 duplicates: #55 #58

2 duplicates: #56 #59

2 duplicates: #69 #108

2 duplicates: #70 #109

2 duplicates: #71 #110

5 duplicates: #74 #85 #92 #99 #106

2 duplicates: #80 #111

2 duplicates: #81 #112

2 duplicates: #82 #113

2 duplicates: #87 #114

2 duplicates: #88 #115

2 duplicates: #89 #116

2 duplicates: #94 #117

2 duplicates: #95 #118

2 duplicates: #96 #119

2 duplicates: #101 #120

2 duplicates: #102 #121

2 duplicates: #103 #122

Query Time: 0.53 ms Query memory: 0.025 MB Memory before query: 1.225 MB Rows returned: 0

SELECT `data`

  FROM `kxc3b_session`

  WHERE `session_id` = '5ef79a7355c9794be5b6aa8457876060'

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

No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

Query Time: 0.33 ms After last query: 3.32 ms Query memory: 0.022 MB Memory before query: 1.241 MB Rows returned: 0

SELECT `session_id`

  FROM `kxc3b_session`

  WHERE `session_id` = '5ef79a7355c9794be5b6aa8457876060' 
  LIMIT 1

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

No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

Query Time: 1.00 ms After last query: 0.11 ms Query memory: 0.004 MB Memory before query: 1.246 MB

INSERT INTO `kxc3b_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('5ef79a7355c9794be5b6aa8457876060', 1, 1550903721, 0, '', 0)

EXPLAIN not possible on query: INSERT INTO `kxc3b_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('5ef79a7355c9794be5b6aa8457876060', 1, 1550903721, 0, '', 0)No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

Query Time: 0.94 ms After last query: 9.32 ms Query memory: 0.030 MB Memory before query: 1.346 MB Rows returned: 40

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

  FROM `kxc3b_extensions`

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_extensions	ref	extension	extension	82	const	50	Using index condition; Using where

No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

Query Time: 0.37 ms After last query: 7.20 ms Query memory: 0.023 MB Memory before query: 1.378 MB Rows returned: 5

SELECT id, rules

  FROM `kxc3b_viewlevels`

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

No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

Query Time: 0.46 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 1.390 MB Rows returned: 2

SELECT b.id

  FROM kxc3b_usergroups AS a

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

  WHERE a.id = 9

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

Query Time: 1.12 ms After last query: 1.61 ms Query memory: 0.034 MB Memory before query: 1.413 MB Rows returned: 82

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

  FROM kxc3b_extensions

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

  ORDER BY ordering

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

No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

Query Time: 0.97 ms After last query: 38.05 ms Query memory: 0.047 MB Memory before query: 1.823 MB Rows returned: 26

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

  LEFT JOIN kxc3b_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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	39	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	944894_goodhope.m.component_id	1	Using where

No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

Query Time: 0.50 ms After last query: 64.05 ms Query memory: 0.080 MB Memory before query: 2.925 MB Rows returned: 1

SELECT *

  FROM kxc3b_easyblog_configs

  WHERE `name` = 'config'

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

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:418
11	EB::config()	JROOT/components/com_easyblog/router.php:301
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
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.52 ms After last query: 9.73 ms Query memory: 0.029 MB Memory before query: 3.733 MB Rows returned: 1

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

  FROM `kxc3b_extensions`

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

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

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
23	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
22	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
19	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
18	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
17	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
14	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_easyblog/includes/utils.php:55
13	EasyBlog->__construct()	JROOT/administrator/components/com_easyblog/includes/post/post.php:197
12	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4342
11	EB::post()	JROOT/components/com_easyblog/router.php:395
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
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.92 ms After last query: 0.17 ms Query memory: 0.008 MB Memory before query: 3.727 MB

UPDATE `kxc3b_extensions`

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

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

EXPLAIN not possible on query: UPDATE `kxc3b_extensions` SET `params` = '{\"mediaversion\":\"4f652cf57d3cbb40498aa01e0cce6d53\"}' WHERE `type` = 'library' AND `element` = 'joomla'No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
18	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
17	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
14	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_easyblog/includes/utils.php:55
13	EasyBlog->__construct()	JROOT/administrator/components/com_easyblog/includes/post/post.php:197
12	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4342
11	EB::post()	JROOT/components/com_easyblog/router.php:395
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
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.90 ms After last query: 10.25 ms Query memory: 0.036 MB Memory before query: 3.988 MB Rows returned: 40

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

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

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:297
15	EasyBlogAcl::getRules()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:38
14	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:139
13	EB::acl()	JROOT/administrator/components/com_easyblog/includes/post/post.php:206
12	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4342
11	EB::post()	JROOT/components/com_easyblog/router.php:395
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
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.80 ms After last query: 0.17 ms Query memory: 0.030 MB Memory before query: 4.034 MB Rows returned: 37

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_acl_group	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	37	Using index condition

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
15	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:112
14	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:139
13	EB::acl()	JROOT/administrator/components/com_easyblog/includes/post/post.php:206
12	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4342
11	EB::post()	JROOT/components/com_easyblog/router.php:395
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
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.55 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 4.048 MB Rows returned: 0

SELECT `id` 
  FROM `kxc3b_easyblog_post` 
  WHERE `permalink`='status:update-
  from-goodhope-asia-holdings-ltd-
  on-the-greenpeace-report-entitled-deadly-trade-off-ioi-s-palm-oil-supply-
  and-its-human-
  and-environmental-costs-
  on-social-
  and-environmental-complaints-regarding-its-subsidiary-pt-nabire-baru'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_post	ref	idx_post_permalink	idx_post_permalink	767	const	1	Using where

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/post/post.php:396
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:396
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
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.65 ms After last query: 2.26 ms Query memory: 0.024 MB Memory before query: 4.060 MB Rows returned: 1

SELECT `id` 
  FROM `kxc3b_easyblog_post` 
  WHERE `permalink`='status-update-
  from-goodhope-asia-holdings-ltd-
  on-the-greenpeace-report-entitled-deadly-trade-off-ioi-s-palm-oil-supply-
  and-its-human-
  and-environmental-costs-
  on-social-
  and-environmental-complaints-regarding-its-subsidiary-pt-nabire-baru'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_post	ref	idx_post_permalink	idx_post_permalink	767	const	1	Using where

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/post/post.php:410
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:396
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
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.63 ms After last query: 5.71 ms Query memory: 0.039 MB Memory before query: 4.164 MB Rows returned: 1

Duplicate queries: #27 #62

SELECT *

  FROM kxc3b_easyblog_post

  WHERE `id` = '31'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_post	const	PRIMARY	PRIMARY	8	const	1

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
15	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/post.php:73
14	EasyBlogTablePost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:332
13	EasyBlogPost->loadPost()	JROOT/administrator/components/com_easyblog/includes/post/post.php:257
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:414
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:396
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
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.58 ms After last query: 1.59 ms Query memory: 0.027 MB Memory before query: 4.278 MB Rows returned: 1

Duplicate queries: #28

SELECT *

  FROM kxc3b_easyblog_revisions

  WHERE `id` = '114'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_revisions	const	PRIMARY	PRIMARY	8	const	1

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:370
13	EasyBlogPost::loadRevision()	JROOT/administrator/components/com_easyblog/includes/post/post.php:286
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:414
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:396
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
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.62 ms After last query: 1.38 ms Query memory: 0.027 MB Memory before query: 4.315 MB Rows returned: 1

Duplicate queries: #29

SELECT * 
  FROM `kxc3b_easyblog_meta` 
  WHERE `type`='post' 
  AND `content_id`='31'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_meta	ref	idx_meta_content_type	idx_meta_content_type	66	const,const	1	Using index condition

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
15	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/tables/meta.php:51
14	EasyBlogTableMeta->loadByType()	JROOT/administrator/components/com_easyblog/includes/post/post.php:453
13	EasyBlogPost->loadMeta()	JROOT/administrator/components/com_easyblog/includes/post/post.php:305
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:414
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:396
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
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.58 ms After last query: 0.38 ms Query memory: 0.025 MB Memory before query: 4.326 MB Rows returned: 1

SELECT *

  FROM kxc3b_languages

  WHERE published=1

  ORDER BY ordering ASC

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

No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

Query Time: 0.91 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 4.343 MB Rows returned: 34

SELECT id, home, template, s.params

  FROM kxc3b_template_styles as s

  LEFT JOIN kxc3b_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

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

No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

Query Time: 0.84 ms After last query: 30.16 ms Query memory: 0.037 MB Memory before query: 4.914 MB Rows returned: 0

SELECT * 
  FROM `kxc3b_easyblog_post` 
  WHERE `publish_up`<='2019-02-23 06:35:21' 
  AND `published`='2' 
  AND `state`='0' 
  ORDER BY `id` 
  LIMIT 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_post	ref	easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_blogger_list	1	const	1	Using where

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:271
10	EasyBlogModelBlogs->getScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:54
9	EasyBlogScheduler->publish()	JROOT/components/com_easyblog/services/maintenance.php:22
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
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.09 ms After last query: 9.38 ms Query memory: 0.006 MB Memory before query: 5.829 MB

UPDATE `kxc3b_easyblog_post` 
  SET `published` = '0' 
  WHERE `publish_down` > `publish_up` 
  AND `publish_down` <= '2019-02-23 06:35:21' 
  AND `publish_down` != '0000-00-00 00:00:00' 
  AND `published` = '1' 
  AND `state` = '0'

EXPLAIN not possible on query: UPDATE `kxc3b_easyblog_post` SET `published` = '0' WHERE `publish_down` > `publish_up` AND `publish_down` <= '2019-02-23 06:35:21' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:316
10	EasyBlogModelBlogs->unpublishScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:34
9	EasyBlogScheduler->unpublish()	JROOT/components/com_easyblog/services/maintenance.php:25
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 5.841 MB Rows returned: 0

SELECT * 
  FROM `kxc3b_easyblog_uploader_tmp` 
  WHERE `created` <= DATE_SUB('2019-02-23 06:35:21' , INTERVAL 120 MINUTE)

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

No SHOW PROFILE (maybe because there are more than 100 queries)

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
10	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:95
9	EasyBlogScheduler->removeTmpFiles()	JROOT/components/com_easyblog/services/maintenance.php:28
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
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.53 ms After last query: 0.12 ms Query memory: 0.006 MB Memory before query: 5.847 MB

delete a, b 
  from `kxc3b_easyblog_post` as a	
  inner join `kxc3b_easyblog_revisions` as b 
  on a.`id` = b.`post_id` 
  where a.`published` = '9' 
  and a.`created` <= DATE_SUB('2019-02-23 06:35:21', INTERVAL 3 DAY)

EXPLAIN not possible on query: delete a, b from `kxc3b_easyblog_post` as a inner join `kxc3b_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2019-02-23 06:35:21', INTERVAL 3 DAY)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
init	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
deleting from main table	0.00 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
deleting from reference tables	0.00 ms
end	0.01 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
10	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:132
9	EasyBlogScheduler->removeBlankPosts()	JROOT/components/com_easyblog/services/maintenance.php:32
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
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.78 ms After last query: 2.96 ms Query memory: 0.043 MB Memory before query: 5.999 MB Rows returned: 22

SELECT * 
  FROM `kxc3b_menu` 
  WHERE `published`='1' 
  AND `link` LIKE 'index.php?option=com_easyblog%'

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

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

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/menu.php:61
12	EasyBlogModelMenu->getAssociatedMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:80
11	EBR::getMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:365
10	EBR::_()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4277
9	EB::_()	JROOT/components/com_easyblog/services/weblog.php:27
8	require_once JROOT/components/com_easyblog/services/weblog.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
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.10 ms After last query: 10.92 ms Query memory: 0.031 MB Memory before query: 6.298 MB Rows returned: 40

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

  FROM `kxc3b_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_announcements','com_associations','com_business','com_cache','com_careers','com_categories','com_checkin','com_config','com_contact_data','com_content','com_contenthistory','com_cpanel','com_easyblog','com_events','com_fields','com_financial_reports','com_history','com_installer','com_jacc','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_modules','com_people_philosophy','com_plugins','com_postinstall','com_privacy','com_sustainability','com_tags','com_templates','com_users','com_why_goodhope','com_wrapper','com_xmap')

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.01 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.42 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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/administrator/components/com_easyblog/includes/easyblog.php:992
14	EB::isSiteAdmin()	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:96
13	EasyBlogThemes->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4185
12	EB::template()	JROOT/components/com_easyblog/views/views.php:51
11	EasyBlogView->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:598
10	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:841
9	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/components/com_easyblog/controllers/controller.php:73
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.53 ms After last query: 2.85 ms Query memory: 0.040 MB Memory before query: 6.398 MB Rows returned: 1

Duplicate queries: #16 #62

SELECT *

  FROM kxc3b_easyblog_post

  WHERE `id` = '31'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_post	const	PRIMARY	PRIMARY	8	const	1

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

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
15	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/post.php:73
14	EasyBlogTablePost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:332
13	EasyBlogPost->loadPost()	JROOT/administrator/components/com_easyblog/includes/post/post.php:257
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:212
11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4342
10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:32
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.42 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 6.409 MB Rows returned: 1

Duplicate queries: #17

SELECT *

  FROM kxc3b_easyblog_revisions

  WHERE `id` = '114'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_revisions	const	PRIMARY	PRIMARY	8	const	1

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:370
13	EasyBlogPost::loadRevision()	JROOT/administrator/components/com_easyblog/includes/post/post.php:286
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:212
11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4342
10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:32
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.39 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 6.424 MB Rows returned: 1

Duplicate queries: #18

SELECT * 
  FROM `kxc3b_easyblog_meta` 
  WHERE `type`='post' 
  AND `content_id`='31'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_meta	ref	idx_meta_content_type	idx_meta_content_type	66	const,const	1	Using index condition

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

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
15	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/tables/meta.php:51
14	EasyBlogTableMeta->loadByType()	JROOT/administrator/components/com_easyblog/includes/post/post.php:453
13	EasyBlogPost->loadMeta()	JROOT/administrator/components/com_easyblog/includes/post/post.php:305
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:212
11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4342
10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:32
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT COUNT(1) as `voted`, `uid` 
  FROM `kxc3b_easyblog_ratings` 
  WHERE `uid` = '31' 
  AND `type`='entry' 
  AND `created_by`='0' 
  AND (`sessionid` = '5ef79a7355c9794be5b6aa8457876060' OR `ip` = '54.226.23.160') 
  GROUP BY `uid` 
  ORDER BY NULL

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

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:135
12	EasyBlogModelRatings->preloadUserPostRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:343
11	EasyBlogCache->cacheVoted()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:265
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:43
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.47 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 6.494 MB Rows returned: 0

SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` 
  FROM `kxc3b_easyblog_ratings` AS a 
  WHERE a.`uid` IN(31) 
  AND `type`='entry' 
  GROUP BY `uid` 
  ORDER BY NULL

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:176
12	EasyBlogModelRatings->preloadRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:474
11	EasyBlogCache->cacheRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:268
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:43
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.50 ms After last query: 5.16 ms Query memory: 0.030 MB Memory before query: 6.665 MB Rows returned: 0

SELECT a.* 
  FROM `kxc3b_easyblog_comment` AS a 
  WHERE a.`post_id` IN(31) 
  AND a.`published`='1'

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

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/comment.php:574
12	EasyBlogModelComment->preloadComments()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:506
11	EasyBlogCache->cacheComments()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:271
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:43
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.32 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 6.679 MB Rows returned: 0

SELECT a.`post_id`, COUNT(1) AS `count` 
  FROM `kxc3b_easyblog_comment` AS a 
  WHERE a.`post_id` IN(31) 
  AND a.`published`='1' 
  GROUP BY a.`post_id`

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

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/comment.php:618
12	EasyBlogModelComment->preloadCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:532
11	EasyBlogCache->cacheCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:274
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:43
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.60 ms After last query: 2.81 ms Query memory: 0.031 MB Memory before query: 6.893 MB Rows returned: 1

select a.*, b.`post_id`, b.`primary` 
  from `kxc3b_easyblog_category` as a 
  inner join `kxc3b_easyblog_post_category` as b 
  on a.`id` = b.`category_id` 
  where b.`post_id` IN ( 31)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	b	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_postid	4	const	1	Using where

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:1370
12	EasyBlogModelCategory->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:616
11	EasyBlogCache->cacheCategories()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:277
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:43
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.61 ms After last query: 5.23 ms Query memory: 0.027 MB Memory before query: 7.229 MB Rows returned: 0

select a.*, b.`post_id` 
  from `kxc3b_easyblog_tag` as a 
  inner join `kxc3b_easyblog_post_tag` as b 
  on a.`id` = b.`tag_id` 
  where b.`post_id` IN ( 31)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	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
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	8	944894_goodhope.b.tag_id	1

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/tags.php:834
12	EasyBlogModelTags->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:694
11	EasyBlogCache->cacheTags()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:280
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:43
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.41 ms After last query: 2.25 ms Query memory: 0.027 MB Memory before query: 7.331 MB Rows returned: 1

select a.* 
  from `kxc3b_easyblog_revisions` as a 
  where a.`id` IN ( 114)

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

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

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/revisions.php:570
12	EasyBlogModelRevisions->preload()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:592
11	EasyBlogCache->cacheRevisions()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:283
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:43
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.67 ms After last query: 1.61 ms Query memory: 0.032 MB Memory before query: 7.392 MB Rows returned: 0

select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`,  e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` 
  from `kxc3b_users` as u 
  left join `kxc3b_easyblog_users` as e 
  ON u.`id` = e.`id` 
  where u.`id` = 812

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

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/users.php:300
15	EasyBlogModelUsers->getUsersMeta()	JROOT/administrator/components/com_easyblog/includes/user/user.php:193
14	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:85
13	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:885
12	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:675
11	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:286
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:43
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.59 ms After last query: 1.90 ms Query memory: 0.031 MB Memory before query: 7.476 MB Rows returned: 0

select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` 
  from `kxc3b_easyblog_category_fields_groups` as a 
  inner join `kxc3b_easyblog_post_category` as p 
  on `a`.`category_id` = `p`.`category_id`	
  inner join `kxc3b_easyblog_fields_groups` as fg 
  on `a`.`group_id` = `fg`.`id`	
  inner join `kxc3b_easyblog_fields` as f 
  on `fg`.`id` = `f`.`group_id`	
  left join `kxc3b_easyblog_fields_values` as fv 
  on `fv`.`field_id` = `f`.`id` 
  and `fv`.`post_id` = `p`.`post_id` 
  where `p`.`post_id` = '31'

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

Status	Duration
starting	0.07 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
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/fields.php:302
12	EasyBlogModelFields->preloadFields()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:380
11	EasyBlogCache->cacheFields()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:289
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:43
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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.58 ms After last query: 1.99 ms Query memory: 0.026 MB Memory before query: 7.548 MB Rows returned: 1

select * 
  from `kxc3b_easyblog_meta` 
  where `content_id` in (31) 
  and `type` = 'post'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kxc3b_easyblog_meta	ref	idx_meta_content_type	idx_meta_content_type	66	const,const	1	Using index condition

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

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/metas.php:396
12	EasyBlogModelMetas->preloadPostMetas()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:309
11	EasyBlogCache->cacheMetas()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:292
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:43
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:109
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:43
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: 0.17 ms Query memory: 0.026 MB Memory before query: 7.560 MB Rows returned: 1

News & Media

Status update from Goodhope Asia Holdings Ltd on the Greenpeace Report entitled "Deadly Trade-Off, IOI's Palm Oil Supply and its Human and Environmental Costs," on Social and Environmental Complaints regarding its subsidiary PT Nabire Baru

Latest News

Archive

Categories

About Goodhope

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

122 Queries Logged 94.00 ms

48 duplicate found!