News & Media

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1550906921,
                "last": 1550906921,
                "now": 1550906921
            },
            "client": {
                "forwarded": "54.226.23.160"
            },
            "token": "t61JoHAQZGFIoLmioQqzQg1BcqZqiius"
        },
        "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
        }
    }
}

Time

Memory

96 Queries Logged 121.38 ms

1. Query Time: 0.59 ms Query memory: 0.025 MB Memory before query: 3.935 MB Rows returned: 0

   SELECT `data`
   
     FROM `kxc3b_session`
   
     WHERE `session_id` = 'c47aeee9cc5b95af93fa56ee419edaca'

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

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.01 ms
   executing	0.01 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
   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.]

   ---

2. Query Time: 0.51 ms After last query: 4.73 ms Query memory: 0.022 MB Memory before query: 4.060 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `kxc3b_session`
   
     WHERE `session_id` = 'c47aeee9cc5b95af93fa56ee419edaca' 
     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

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 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.04 ms
   cleaning up	0.01 ms

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

   ---

3. Query Time: 6.94 ms After last query: 0.11 ms Query memory: 0.004 MB Memory before query: 4.065 MB

   INSERT INTO `kxc3b_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('c47aeee9cc5b95af93fa56ee419edaca', 1, 1550906921, 0, '', 0)

   EXPLAIN not possible on query: INSERT INTO `kxc3b_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('c47aeee9cc5b95af93fa56ee419edaca', 1, 1550906921, 0, '', 0)

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	2.03 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.01 ms
   update	2.23 ms
   Waiting for query cache lock	0.01 ms
   update	1.63 ms
   end	0.01 ms
   query end	0.61 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
   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.]

   ---

4. Query Time: 1.06 ms After last query: 11.76 ms Query memory: 0.030 MB Memory before query: 4.384 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

   Status	Duration
   starting	0.06 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.03 ms
   statistics	0.08 ms
   preparing	0.04 ms
   executing	0.01 ms
   Sending data	0.30 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.06 ms
   cleaning up	0.01 ms

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

   ---

5. Query Time: 0.79 ms After last query: 9.60 ms Query memory: 0.023 MB Memory before query: 4.612 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

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

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

   ---

6. Query Time: 2.43 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 4.624 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

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

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

   ---

7. Query Time: 1.33 ms After last query: 2.17 ms Query memory: 0.034 MB Memory before query: 4.696 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

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.04 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sorting result	0.49 ms
   Sending data	0.15 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
   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.]

   ---

8. Query Time: 1.34 ms After last query: 59.71 ms Query memory: 0.047 MB Memory before query: 6.040 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

   Status	Duration
   starting	0.08 ms
   checking permissions	0.09 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.09 ms
   executing	0.01 ms
   Sorting result	0.22 ms
   Sending data	0.23 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 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
   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.]

   ---

9. Query Time: 1.08 ms After last query: 124.06 ms Query memory: 0.080 MB Memory before query: 9.141 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

   Status	Duration
   starting	0.12 ms
   checking permissions	0.01 ms
   Opening tables	0.12 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   init	0.04 ms
   optimizing	0.02 ms
   statistics	0.04 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.19 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 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
   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.]

   ---

10. Query Time: 0.87 ms After last query: 6.81 ms Query memory: 0.025 MB Memory before query: 9.316 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

    Status	Duration
    starting	0.07 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.15 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.10 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.04 ms
    cleaning up	0.01 ms

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    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.]

    ---

11. Query Time: 1.62 ms After last query: 0.20 ms Query memory: 0.005 MB Memory before query: 9.306 MB

    UPDATE `kxc3b_extensions`
    
      SET `params` = '{\"mediaversion\":\"1e971c25a9172707bf5c4907a3bc7e5a\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    EXPLAIN not possible on query: UPDATE `kxc3b_extensions` SET `params` = '{\"mediaversion\":\"1e971c25a9172707bf5c4907a3bc7e5a\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Status	Duration
    starting	0.06 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.10 ms
    updating	0.11 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.02 ms
    query end	0.90 ms
    closing tables	0.03 ms
    Unlocking tables	0.02 ms
    freeing items	0.03 ms
    updating status	0.05 ms
    cleaning up	0.01 ms

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    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.]

    ---

12. Query Time: 0.63 ms After last query: 4.54 ms Query memory: 0.025 MB Memory before query: 9.513 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

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sorting result	0.05 ms
    Sending data	0.05 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
    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.]

    ---

13. Query Time: 1.14 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 9.529 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

    Status	Duration
    starting	0.08 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.03 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.43 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 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
    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.]

    ---

14. Query Time: 4.01 ms After last query: 33.32 ms Query memory: 0.037 MB Memory before query: 10.404 MB Rows returned: 0

    SELECT * 
      FROM `kxc3b_easyblog_post` 
      WHERE `publish_up`<='2019-02-23 07:28:41' 
      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

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

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

    ---

15. Query Time: 5.68 ms After last query: 8.33 ms Query memory: 0.006 MB Memory before query: 11.361 MB

    UPDATE `kxc3b_easyblog_post` 
      SET `published` = '0' 
      WHERE `publish_down` > `publish_up` 
      AND `publish_down` <= '2019-02-23 07:28:41' 
      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 07:28:41' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'

    Status	Duration
    starting	0.06 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.09 ms
    Searching rows for update	5.00 ms
    updating	0.02 ms
    end	0.01 ms
    query end	0.06 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Waiting for query cache lock	0.01 ms
    Unlocking tables	0.10 ms
    freeing items	0.02 ms
    updating status	0.04 ms
    cleaning up	0.01 ms

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

    ---

16. Query Time: 0.38 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 11.373 MB Rows returned: 0

    SELECT * 
      FROM `kxc3b_easyblog_uploader_tmp` 
      WHERE `created` <= DATE_SUB('2019-02-23 07:28:41' , 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

    Status	Duration
    starting	0.06 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.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 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
    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.]

    ---

17. Query Time: 0.61 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 11.381 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 07:28:41', 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 07:28:41', INTERVAL 3 DAY)

    Status	Duration
    starting	0.05 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.03 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.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.02 ms
    deleting from reference tables	0.01 ms
    end	0.01 ms
    end	0.01 ms
    query end	0.04 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Waiting for query cache lock	0.01 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.05 ms
    cleaning up	0.03 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.]

    ---

18. Query Time: 0.85 ms After last query: 2.04 ms Query memory: 0.043 MB Memory before query: 11.471 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.08 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.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.34 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.]

    ---

19. Query Time: 0.90 ms After last query: 5.38 ms Query memory: 0.034 MB Memory before query: 11.590 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

    Status	Duration
    starting	0.04 ms
    checking permissions	0.02 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.04 ms
    executing	0.01 ms
    Sorting result	0.05 ms
    Sending data	0.13 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.13 ms
    cleaning up	0.02 ms

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:297
    11	EasyBlogAcl::getRules()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:38
    10	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:139
    9	EB::acl()	JROOT/components/com_easyblog/controllers/controller.php:22
    8	EasyBlogController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:302
    7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_easyblog/easyblog.php:40
    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.]

    ---

20. Query Time: 0.68 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 11.634 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

    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.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.14 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.04 ms
    cleaning up	0.01 ms

    #	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/includes/acl/acl.php:112
    10	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:139
    9	EB::acl()	JROOT/components/com_easyblog/controllers/controller.php:22
    8	EasyBlogController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:302
    7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_easyblog/easyblog.php:40
    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.]

    ---

21. Query Time: 2.86 ms After last query: 8.93 ms Query memory: 0.031 MB Memory before query: 11.952 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.08 ms
    checking permissions	0.01 ms
    Opening tables	0.05 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.14 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	2.02 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.04 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.]

    ---

22. Query Time: 3.77 ms After last query: 21.39 ms Query memory: 0.038 MB Memory before query: 12.638 MB Rows returned: 2

    SELECT a.*, DAY( DATE_ADD(a.`created`, INTERVAL 0 HOUR) ) AS day, MONTH( DATE_ADD(a.`created`, INTERVAL 0 HOUR) ) AS month, YEAR( DATE_ADD(a.`created`, INTERVAL 0 HOUR) ) AS year  
      FROM `kxc3b_easyblog_post` as a 
      WHERE a.`published` = '1'  
      AND a.`state` = '0'  
      AND a.`access` = '0'  
      AND (a.`created` > '2018-06-01 00:00:00' 
      AND a.`created` < '2018-06-31 23:59:59')  
      AND (1 <= (select count(1) 
      from `kxc3b_easyblog_post_category` AS acp 
      INNER JOIN `kxc3b_easyblog_category` as cat 
      on acp.`category_id` = cat.`id` 
      where acp.`post_id` = a.`id` 
      and ( 	( cat.`private` = 0 ) OR 	( (cat.`private` = 1) 
      and (0 > 0) ) OR 	( (cat.`private` = 2) 
      and ( (select count(1) 
      from `kxc3b_easyblog_category_acl` as cacl 
      where cacl.`category_id` = cat.id 
      and cacl.`acl_id` = 1 
      and cacl.`content_id` in (9)) > 0 ) ) ) ))  
      AND ( (a.`source_type` = 'easyblog.sitewide')  OR ( a.`source_type` = 'easyblog.team' 
      and 1 <= (select count(1) 
      from `kxc3b_easyblog_team` as srcteam 
      where srcteam.`id` = a.`source_id` 
      and srcteam.`published` = 1 
      and ( (srcteam.`access` = 3)       OR (srcteam.`access` = 2 
      and (select count(1) 
      from `kxc3b_easyblog_team_groups` as srcteamgrp 
      where srcteamgrp.`team_id` = srcteam.`id` 
      and srcteamgrp.`group_id` IN (9) ) > 0))))) 
      ORDER BY a.`created` ASC

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	range	easyblog_post_published,easyblog_post_blogger_list,easyblog_post_search,easyblog_frontpage1,easyblog_post_searchnew,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_searchnew	10	NULL	2	Using index condition; Using where
    4	SUBQUERY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    5	SUBQUERY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    2	DEPENDENT SUBQUERY	cat	system	PRIMARY,easyblog_cat_private	NO INDEX KEY COULD BE USED	NULL	NULL	1
    2	DEPENDENT SUBQUERY	acp	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	8	944894_goodhope.a.id,const	1	Using where; Using index
    3	SUBQUERY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Status	Duration
    starting	0.21 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	1.62 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.11 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.03 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.01 ms
    Sending data	0.10 ms
    executing	0.01 ms
    Sending data	0.06 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.04 ms
    freeing items	0.01 ms
    removing tmp table	0.54 ms
    freeing items	0.03 ms
    updating status	0.04 ms
    cleaning up	0.01 ms

    #	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/archive.php:536
    10	EasyBlogModelArchive->getArchivePostListByMonth()	JROOT/components/com_easyblog/views/calendar/view.html.php:73
    9	EasyBlogViewCalendar->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.]

    ---

23. Query Time: 0.54 ms After last query: 15.14 ms Query memory: 0.026 MB Memory before query: 13.568 MB Rows returned: 0

    SELECT COUNT(1) as `voted`, `uid` 
      FROM `kxc3b_easyblog_ratings` 
      WHERE `uid` IN (53,54) 
      AND `type`='entry' 
      AND `created_by`='0' 
      AND (`sessionid` = 'c47aeee9cc5b95af93fa56ee419edaca' 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.08 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.00 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
    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/ratings.php:135
    15	EasyBlogModelRatings->preloadUserPostRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:343
    14	EasyBlogCache->cacheVoted()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:265
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

24. Query Time: 0.43 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 13.577 MB Rows returned: 0

    SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` 
      FROM `kxc3b_easyblog_ratings` AS a 
      WHERE a.`uid` IN(53,54) 
      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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.01 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.03 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/ratings.php:176
    15	EasyBlogModelRatings->preloadRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:474
    14	EasyBlogCache->cacheRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:268
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

25. Query Time: 0.64 ms After last query: 5.90 ms Query memory: 0.032 MB Memory before query: 13.856 MB Rows returned: 0

    SELECT a.* 
      FROM `kxc3b_easyblog_comment` AS a 
      WHERE a.`post_id` IN(53,54) 
      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.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.02 ms
    preparing	0.01 ms
    executing	0.03 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/comment.php:574
    15	EasyBlogModelComment->preloadComments()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:506
    14	EasyBlogCache->cacheComments()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:271
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

26. Query Time: 0.55 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 13.865 MB Rows returned: 0

    SELECT a.`post_id`, COUNT(1) AS `count` 
      FROM `kxc3b_easyblog_comment` AS a 
      WHERE a.`post_id` IN(53,54) 
      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.05 ms
    checking permissions	0.02 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.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.06 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/comment.php:618
    15	EasyBlogModelComment->preloadCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:532
    14	EasyBlogCache->cacheCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:274
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

27. Query Time: 0.66 ms After last query: 2.57 ms Query memory: 0.033 MB Memory before query: 14.080 MB Rows returned: 2

    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 ( 53,54)

    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	range	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_postid	4	NULL	2	Using index condition; Using where

    Status	Duration
    starting	0.07 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.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    Unlocking tables	0.05 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.03 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/category.php:1370
    15	EasyBlogModelCategory->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:616
    14	EasyBlogCache->cacheCategories()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:277
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

28. Query Time: 2.22 ms After last query: 4.73 ms Query memory: 0.028 MB Memory before query: 14.359 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 ( 53,54)

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	index	easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id	easyblog_post_tagpost_id	16	NULL	2	Using where; Using index
    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.05 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	1.56 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.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.04 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/tags.php:834
    15	EasyBlogModelTags->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:694
    14	EasyBlogCache->cacheTags()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:280
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

29. Query Time: 2.21 ms After last query: 3.18 ms Query memory: 0.028 MB Memory before query: 14.463 MB Rows returned: 2

    select a.* 
      from `kxc3b_easyblog_revisions` as a 
      where a.`id` IN ( 136,138)

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	PRIMARY	PRIMARY	8	NULL	2	Using index condition

    Status	Duration
    starting	0.04 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.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	1.56 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.04 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/revisions.php:570
    15	EasyBlogModelRevisions->preload()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:592
    14	EasyBlogCache->cacheRevisions()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:283
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

30. Query Time: 0.72 ms After last query: 3.03 ms Query memory: 0.034 MB Memory before query: 14.584 MB Rows returned: 1

    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` = 814

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	e	const	PRIMARY	PRIMARY	8	const	1

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.08 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.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.04 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/administrator/components/com_easyblog/includes/utils.php:235
    19	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/users.php:300
    18	EasyBlogModelUsers->getUsersMeta()	JROOT/administrator/components/com_easyblog/includes/user/user.php:193
    17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:85
    16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:885
    15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:675
    14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:286
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

31. Query Time: 1.24 ms After last query: 5.34 ms Query memory: 0.035 MB Memory before query: 14.752 MB Rows returned: 16

    SHOW FULL COLUMNS 
      FROM `kxc3b_users`

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

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.32 ms
    After opening tables	0.01 ms
    System lock	0.01 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
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    executing	0.01 ms
    Sending data	0.13 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.06 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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    26	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    25	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
    24	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
    23	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    22	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
    21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:238
    17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:85
    16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:885
    15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:675
    14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:286
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

32. Query Time: 0.57 ms After last query: 0.16 ms Query memory: 0.032 MB Memory before query: 14.793 MB Rows returned: 1

    SELECT *
    
      FROM `kxc3b_users`
    
      WHERE `id` = 814

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	kxc3b_users	const	PRIMARY	PRIMARY	4	const	1

    Status	Duration
    starting	0.04 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.05 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    executing	0.01 ms
    Sending data	0.05 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.04 ms
    cleaning up	0.01 ms

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
    22	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:238
    17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:85
    16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:885
    15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:675
    14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:286
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

33. Query Time: 0.83 ms After last query: 5.73 ms Query memory: 0.030 MB Memory before query: 15.631 MB Rows returned: 3

    SELECT `g`.`id`,`g`.`title`
    
      FROM `kxc3b_usergroups` AS g
    
      INNER JOIN `kxc3b_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 814

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	3	Using index
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	944894_goodhope.m.group_id	1

    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.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.05 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    23	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
    22	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
    21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:238
    17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:85
    16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:885
    15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:675
    14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:286
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

34. Query Time: 0.88 ms After last query: 1.89 ms Query memory: 0.033 MB Memory before query: 15.714 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 IN (53,54)

    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.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	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.03 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/fields.php:302
    15	EasyBlogModelFields->preloadFields()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:380
    14	EasyBlogCache->cacheFields()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:289
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

35. Query Time: 0.61 ms After last query: 1.83 ms Query memory: 0.028 MB Memory before query: 15.788 MB Rows returned: 2

    select * 
      from `kxc3b_easyblog_meta` 
      where `content_id` in (53,54) 
      and `type` = 'post'

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	kxc3b_easyblog_meta	range	idx_meta_content_type	idx_meta_content_type	66	NULL	2	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.02 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 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.04 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/metas.php:396
    15	EasyBlogModelMetas->preloadPostMetas()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:309
    14	EasyBlogCache->cacheMetas()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:292
    13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:31
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

36. Query Time: 1.96 ms After last query: 2.73 ms Query memory: 0.026 MB Memory before query: 15.873 MB Rows returned: 0

    SELECT * 
      FROM `kxc3b_easyblog_featured` 
      WHERE `content_id` IN(53,54) 
      AND `type`='post'

    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	1.49 ms
    After opening tables	0.07 ms
    System lock	0.01 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
    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.04 ms
    cleaning up	0.01 ms

    #	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/models/featured.php:253
    14	EasyBlogModelFeatured->preload()	JROOT/administrator/components/com_easyblog/includes/formatter/types/standard.php:160
    13	EasyBlogFormatterStandard->preloadFeaturedItems()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:39
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

37. Query Time: 0.53 ms After last query: 2.52 ms Query memory: 0.026 MB Memory before query: 16.066 MB Rows returned: 0

    SELECT `group_id` 
      FROM `kxc3b_easyblog_category_fields_groups` 
      WHERE `category_id`='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.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
    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.04 ms
    cleaning up	0.01 ms

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
    16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/categories.php:53
    15	EasyBlogModelCategories->getCustomFieldGroup()	JROOT/administrator/components/com_easyblog/tables/category.php:1048
    14	EasyBlogTableCategory->getCustomFields()	JROOT/administrator/components/com_easyblog/includes/post/post.php:5156
    13	EasyBlogPost->getCustomFields()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:71
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

38. Query Time: 0.61 ms After last query: 1.15 ms Query memory: 0.028 MB Memory before query: 16.091 MB Rows returned: 0

    SELECT a.* 
      FROM `kxc3b_easyblog_fields` AS a 
      INNER JOIN `kxc3b_easyblog_category_fields_groups` AS b 
      ON a.`group_id`= b.`group_id` 
      WHERE b.`category_id`='1' 
      AND a.`state`='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.06 ms
    checking permissions	0.01 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.02 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.06 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/categories.php:81
    15	EasyBlogModelCategories->getCustomFields()	JROOT/administrator/components/com_easyblog/tables/category.php:1049
    14	EasyBlogTableCategory->getCustomFields()	JROOT/administrator/components/com_easyblog/includes/post/post.php:5156
    13	EasyBlogPost->getCustomFields()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:71
    12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
    11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4262
    10	EB::formatter()	JROOT/components/com_easyblog/views/calendar/view.html.php:75
    9	EasyBlogViewCalendar->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.]

    ---

39. Query Time: 0.49 ms After last query: 0.61 ms Query memory: 0.025 MB Memory before query: 16.103 MB Rows returned: 0

    SELECT *
    
      FROM kxc3b_easyblog_meta
    
      WHERE `type` = 'view' 
      AND `content_id` = '0'

    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.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.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    11	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2238
    10	EB::setMeta()	JROOT/components/com_easyblog/views/calendar/view.html.php:83
    9	EasyBlogViewCalendar->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.]

    ---

40. Query Time: 2.62 ms After last query: 48.42 ms Query memory: 0.032 MB Memory before query: 17.593 MB Rows returned: 19

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM kxc3b_modules AS m
    
      LEFT JOIN kxc3b_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN kxc3b_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-02-23 07:28:41') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-23 07:28:41') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 108 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	106	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	944894_goodhope.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	944894_goodhope.m.module,const	1	Using index condition; Using where

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.10 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.07 ms
    preparing	0.06 ms
    executing	0.01 ms
    Sorting result	0.93 ms
    Sending data	0.69 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.08 ms
    cleaning up	0.01 ms

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2104
    14	EB::renderModule()	JROOT/components/com_easyblog/themes/wireframe/toolbar/default.php:14
    13	include JROOT/components/com_easyblog/themes/wireframe/toolbar/default.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:438
    12	EasyBlogThemes->output()	JROOT/components/com_easyblog/views/views.php:434
    11	EasyBlogView->getToolbar()	JROOT/components/com_easyblog/views/views.php:196
    10	EasyBlogView->display()	JROOT/components/com_easyblog/views/calendar/view.html.php:97
    9	EasyBlogViewCalendar->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.]

    ---

41. Query Time: 9.83 ms After last query: 29.51 ms Query memory: 0.030 MB Memory before query: 17.938 MB Rows returned: 1

    select SQL_CALC_FOUND_ROWS a.*, count(pcat.`id`) as `cnt` 
      from `kxc3b_easyblog_category` as a 	
      inner join `kxc3b_easyblog_category` as c 
      on a.`lft` <= c.`lft` 
      and a.`rgt` >= c.`rgt` 	
      left join `kxc3b_easyblog_post_category` as `pcat` 
      on c.`id` = pcat.`category_id` 					
      and exists (select p.`id` 
      from `kxc3b_easyblog_post` as p 
      where pcat.`post_id` = p.`id` 
      and p.`published` = '1' 
      and p.`state` = '0') 
      WHERE a.`published`='1' 
      and a.`parent_id` = 0 
      and (( ( a.`private` = 0) OR ( a.`private` = 1 
      and 1 > 0) OR ( a.`private` = 2 
      and (select count(1) 
      from `kxc3b_easyblog_category_acl` 
      where `category_id` = a.`id` 
      and `acl_id` = 1 
      and `content_id` in (9)) > 0)) ) 
      GROUP BY a.`id` 
      having (count(pcat.`id`) > 0) 
      ORDER BY `cnt` DESC

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	system	easyblog_cat_published,easyblog_cat_parentid,easyblog_cat_private,easyblog_cat_lft,idx_category_access,idx_cat_lftrgt	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	PRIMARY	c	system	easyblog_cat_lft,idx_cat_lftrgt	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	PRIMARY	pcat	ALL	eb_post_category_catid,eb_post_category_cat_post	NO INDEX KEY COULD BE USED	NULL	NULL	60	Using where
    3	SUBQUERY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    2	DEPENDENT SUBQUERY	p	eq_ref	PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	PRIMARY	8	944894_goodhope.pcat.post_id	1	Using index condition; Using where

    Status	Duration
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	7.10 ms
    executing	0.02 ms
    Sending data	0.32 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.05 ms
    freeing items	0.01 ms
    removing tmp table	0.07 ms
    freeing items	0.03 ms
    updating status	0.05 ms
    cleaning up	0.01 ms

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
    12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:971
    11	EasyBlogModelCategory->getCategories()	JROOT/modules/mod_easyblogcategories/mod_easyblogcategories.php:46
    10	include JROOT/modules/mod_easyblogcategories/mod_easyblogcategories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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.]

    ---

42. Query Time: 0.40 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 17.948 MB Rows returned: 1

    select FOUND_ROWS()

    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	No tables used

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.05 ms
    cleaning up	0.01 ms

    #	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/models/category.php:979
    11	EasyBlogModelCategory->getCategories()	JROOT/modules/mod_easyblogcategories/mod_easyblogcategories.php:46
    10	include JROOT/modules/mod_easyblogcategories/mod_easyblogcategories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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.]

    ---

43. Query Time: 0.93 ms After last query: 3.99 ms Query memory: 0.025 MB Memory before query: 18.073 MB Rows returned: 0

    SELECT `a`.`id`, `a`.`title`, `a`.`parent_id`, `a`.`alias`, `a`.`avatar`, COUNT(b.`id`) AS `cnt` , '2' AS level 
      FROM `kxc3b_easyblog_category` AS `a` 
      LEFT JOIN `kxc3b_easyblog_post_category` AS pc 
      ON a.`id` = pc.`category_id` 
      LEFT JOIN `kxc3b_easyblog_post` AS b 
      ON b.`id` = pc.`post_id` 
      AND b.`published` = '1' 
      AND b.`state` = '0' 
      WHERE a.`published` = 1 
      AND a.`parent_id`='1' 
      GROUP BY a.`id` 
      HAVING (COUNT(b.`id`) > 0) 
      ORDER BY `cnt` desc

    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.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.23 ms
    preparing	0.02 ms
    Unlocking tables	0.01 ms
    executing	0.02 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.04 ms
    cleaning up	0.01 ms

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
    12	EasyBlogDbJoomla->__call()	JROOT/modules/mod_easyblogcategories/helper.php:84
    11	modEasyBlogCategoriesHelper::getChildCategories()	JROOT/modules/mod_easyblogcategories/mod_easyblogcategories.php:74
    10	include JROOT/modules/mod_easyblogcategories/mod_easyblogcategories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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.]

    ---

44. Query Time: 1.08 ms After last query: 6.04 ms Query memory: 0.024 MB Memory before query: 18.093 MB Rows returned: 1

    SELECT YEAR(MIN( `created` )) AS minyear, YEAR(MAX( `created` )) AS maxyear 
      FROM `kxc3b_easyblog_post` 
      WHERE `published` = '1' 
      AND `state` = '0' 
      AND `access` = '0'

    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_post_search,easyblog_frontpage1,easyblog_post_searchnew,idx_pre_soucetype_postcount,idx_post_sql1	idx_pre_soucetype_postcount	5	const,const	49	Using where

    Status	Duration
    starting	0.05 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.15 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.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.04 ms
    cleaning up	0.01 ms

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
    12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/archive.php:168
    11	EasyBlogModelArchive->getArchiveMinMaxYear()	JROOT/modules/mod_easyblogarchive/mod_easyblogarchive.php:34
    10	include JROOT/modules/mod_easyblogarchive/mod_easyblogarchive.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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.]

    ---

45. Query Time: 3.95 ms After last query: 0.41 ms Query memory: 0.027 MB Memory before query: 18.105 MB Rows returned: 35

    SELECT COUNT(1) as count, MONTH( a.`created` ) AS month, YEAR( a.`created` ) AS year 
      FROM `kxc3b_easyblog_post` AS a  
      WHERE a.`published`='1' 
      AND a.`state`='0'  
      AND a.`access` = '0'   
      AND ( a.`created` > '2010-12-31 23:59:59' 
      AND a.`created` < '2020-01-01 00:00:00') 
      AND (1 <= (select count(1) 
      from `kxc3b_easyblog_post_category` AS acp 
      INNER JOIN `kxc3b_easyblog_category` as cat 
      on acp.`category_id` = cat.`id` 
      where acp.`post_id` = a.`id` 
      and ( 	( cat.`private` = 0 ) OR 	( (cat.`private` = 1) 
      and (0 > 0) ) OR 	( (cat.`private` = 2) 
      and ( (select count(1) 
      from `kxc3b_easyblog_category_acl` as cacl 
      where cacl.`category_id` = cat.id 
      and cacl.`acl_id` = 1 
      and cacl.`content_id` in (9)) > 0 ) ) ) )) 
      GROUP BY year, month DESC 
      ORDER BY a.`created` DESC

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	ref	easyblog_post_published,easyblog_post_blogger_list,easyblog_post_search,easyblog_frontpage1,easyblog_post_searchnew,idx_pre_soucetype_postcount,idx_post_sql1	idx_pre_soucetype_postcount	5	const,const	49	Using where; Using temporary; Using filesort
    2	DEPENDENT SUBQUERY	cat	system	PRIMARY,easyblog_cat_private	NO INDEX KEY COULD BE USED	NULL	NULL	1
    2	DEPENDENT SUBQUERY	acp	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	8	944894_goodhope.a.id,const	1	Using where; Using index
    3	SUBQUERY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Status	Duration
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.18 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing