{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1725763732,
                "last": 1725763732,
                "now": 1725763732
            },
            "token": "wq0KlqW9ltsyvqzBX1iorH0vdreuvTQk"
        },
        "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
        }
    },
    "__EBLOG": {
        "MESSAGE": {
            "eblog": {
                "message": {
                    "queue": null
                }
            }
        }
    }
}

Time

Memory

45 Queries Logged 99.91 ms

1. Query Time: 1.14 ms Query memory: 0.022 MB Memory before query: 0.697 MB Rows returned: 0

   SELECT `data`
   
     FROM `icecool_session`
   
     WHERE `session_id` = 'aa9c5ccb7c9cd09880834763f68cd6e4'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 1.05 ms After last query: 0.54 ms Query memory: 0.019 MB Memory before query: 0.714 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `icecool_session`
   
     WHERE `session_id` = 'aa9c5ccb7c9cd09880834763f68cd6e4' 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 8.90 ms After last query: 0.08 ms Query memory: 0.003 MB Memory before query: 0.719 MB

   INSERT INTO `icecool_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('aa9c5ccb7c9cd09880834763f68cd6e4', 0, 1, '1725763732', 0, '')

   Explain

   EXPLAIN not possible on query: INSERT INTO `icecool_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('aa9c5ccb7c9cd09880834763f68cd6e4', 0, 1, '1725763732', 0, '')

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.18 ms
   Waiting for query cache lock	0.01 ms
   update	0.02 ms
   end	0.00 ms
   query end	7.49 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 3.43 ms After last query: 0.60 ms Query memory: 0.024 MB Memory before query: 0.742 MB Rows returned: 45

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `icecool_extensions`
   
     WHERE `type` = 'component'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 1.02 ms After last query: 0.43 ms Query memory: 0.021 MB Memory before query: 0.766 MB Rows returned: 2

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

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 1.58 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 0.770 MB Rows returned: 4

   SELECT id, rules
   
     FROM `icecool_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 1.94 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 0.778 MB Rows returned: 66

   SELECT folder AS type, element AS name, params
   
     FROM icecool_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 1.49 ms After last query: 2.77 ms Query memory: 0.020 MB Memory before query: 1.061 MB Rows returned: 1

   SELECT `enabled`
   
     FROM `icecool_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 4.63 ms After last query: 1.18 ms Query memory: 0.090 MB Memory before query: 1.187 MB Rows returned: 59

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM icecool_menu AS m
   
     LEFT JOIN icecool_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	68	100.00	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	coltscou_clients.m.component_id	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   init	0.00 ms
   checking query cache for query	0.05 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.21 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   System lock	0.07 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   preparing	0.02 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	1.99 ms
   Waiting for query cache lock	0.01 ms
   Creating sort index	0.07 ms
   Waiting for query cache lock	0.00 ms
   Creating sort index	0.20 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.14 ms
   Waiting for query cache lock	0.09 ms
   freeing items	0.01 ms
   storing result in query cache	0.09 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 1.54 ms After last query: 7.18 ms Query memory: 0.025 MB Memory before query: 2.029 MB Rows returned: 2

    SHOW FULL COLUMNS 
      FROM `icecool_easyblog_configs`

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

11. Query Time: 2.54 ms After last query: 0.31 ms Query memory: 0.061 MB Memory before query: 2.044 MB Rows returned: 1

    SELECT *
    
      FROM icecool_easyblog_configs
    
      WHERE `name` = 'config'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    12	JTable->load()	JROOT/components/com_easyblog/helpers/helper.php:592
    11	EasyBlogHelper::getConfig()	JROOT/components/com_easyblog/router.php:257
    10	EasyBlogParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 6.43 ms After last query: 5.70 ms Query memory: 0.026 MB Memory before query: 2.153 MB Rows returned: 9

    SHOW FULL COLUMNS 
      FROM `icecool_easyblog_tag`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    16	JTable->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
    15	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/tag.php:39
    14	EasyBlogTableTag->__construct()	JROOT/libraries/joomla/table/table.php:308
    13	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
    12	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
    11	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/router.php:418
    10	EasyBlogParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 2.02 ms After last query: 0.53 ms Query memory: 0.022 MB Memory before query: 2.171 MB Rows returned: 1

    SELECT * 
      FROM `icecool_easyblog_tag` 
      WHERE (`title` = 'thank-you' OR `title` = 'thank you'  OR `alias` = 'thank-you') 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_easyblog_tag	ALL	easyblog_tag_title,easyblog_tag_alias	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    14	JDatabaseDriver->loadObject()	JROOT/components/com_easyblog/helpers/db.php:109
    13	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    12	EasyBlogDBHelper->__call()	JROOT/administrator/components/com_easyblog/tables/tag.php:68
    11	EasyBlogTableTag->load()	JROOT/components/com_easyblog/router.php:419
    10	EasyBlogParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 1.12 ms After last query: 0.33 ms Query memory: 0.022 MB Memory before query: 2.193 MB Rows returned: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `icecool_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 3.87 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 2.184 MB

    UPDATE `icecool_extensions`
    
      SET `params` = '{\"mediaversion\":\"cb0aac4ec38c7fcbb08220c0cd194cfb\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.45 ms
    updating	0.05 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.20 ms
    query end	2.24 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.64 ms After last query: 0.56 ms Query memory: 0.019 MB Memory before query: 2.203 MB Rows returned: 1

    SELECT *
    
      FROM icecool_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 1.95 ms After last query: 0.30 ms Query memory: 0.020 MB Memory before query: 2.214 MB Rows returned: 4

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 1.19 ms After last query: 9.49 ms Query memory: 0.005 MB Memory before query: 2.254 MB

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    10	JDatabase->query()	JROOT/components/com_easyblog/helpers/db.php:109
    9	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    8	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/classes/mailqueue.php:36
    7	EMailQueue->sendOnPageLoad()	JROOT/components/com_easyblog/easyblog.php:81
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 1.10 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 2.259 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    9	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    8	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/classes/mailqueue.php:44
    7	EMailQueue->sendOnPageLoad()	JROOT/components/com_easyblog/easyblog.php:81
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.91 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 2.267 MB Rows returned: 0

    SELECT * 
      FROM `icecool_easyblog_post` 
      WHERE `publish_up` <= '2024-09-08 02:48:52' 
      AND `published` = '2' 
      AND `ispending` = '0' 
      ORDER BY `id` 
      LIMIT 5

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    9	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    8	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:2514
    7	EasyBlogHelper::processScheduledPost()	JROOT/components/com_easyblog/easyblog.php:85
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 1.13 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 2.272 MB

    UPDATE `icecool_easyblog_post` 
      SET `published` = '0' 
      WHERE `publish_down` > `publish_up` 
      AND `publish_down` <= '2024-09-08 02:48:52' 
      AND `publish_down` != '0000-00-00 00:00:00' 
      AND `published` != '0' 
      AND `published` != '3' 
      AND `ispending` = '0'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    10	JDatabase->query()	JROOT/components/com_easyblog/helpers/db.php:109
    9	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    8	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:2490
    7	EasyBlogHelper::unPublishPost()	JROOT/components/com_easyblog/easyblog.php:88
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 5.37 ms After last query: 22.86 ms Query memory: 0.028 MB Memory before query: 2.465 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `icecool_assets`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
    14	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
    13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
    12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
    11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
    10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
    9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
    8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
    7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 1.50 ms After last query: 0.23 ms Query memory: 0.025 MB Memory before query: 2.487 MB Rows returned: 1

    SELECT *
    
      FROM icecool_assets
    
      WHERE `id` = '1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
    14	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
    13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
    12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
    11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
    10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
    9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
    8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
    7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 1.43 ms After last query: 0.18 ms Query memory: 0.024 MB Memory before query: 2.495 MB Rows returned: 1
    Duplicate queries: #26

    SELECT a.rules
    
      FROM icecool_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
    14	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
    13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
    12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
    11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
    10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
    9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
    8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
    7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 1.57 ms After last query: 0.36 ms Query memory: 0.025 MB Memory before query: 2.505 MB Rows returned: 1

    SELECT id
    
      FROM icecool_assets
    
      WHERE parent_id = 0

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
    17	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
    14	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
    13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
    12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
    11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
    10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
    9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
    8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
    7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 1.20 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 2.515 MB Rows returned: 1
    Duplicate queries: #24

    SELECT a.rules
    
      FROM icecool_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
    14	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
    13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
    12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
    11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
    10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
    9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
    8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
    7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 1.69 ms After last query: 2.98 ms Query memory: 0.028 MB Memory before query: 2.602 MB Rows returned: 10

    SHOW FULL COLUMNS 
      FROM `icecool_easyblog_users`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    19	JTable->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
    18	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/profile.php:39
    17	EasyBlogTableProfile->__construct()	JROOT/libraries/joomla/table/table.php:308
    16	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
    15	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
    14	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/classes/themes.php:73
    13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
    12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
    11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
    10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
    9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
    8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
    7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 1.44 ms After last query: 0.68 ms Query memory: 0.024 MB Memory before query: 2.627 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    17	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    16	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    15	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/classes/themes.php:156
    14	CodeThemes->_getThemeConfig()	JROOT/components/com_easyblog/classes/themes.php:106
    13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
    12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
    11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
    10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
    9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
    8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
    7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 1.79 ms After last query: 0.21 ms Query memory: 0.028 MB Memory before query: 2.642 MB Rows returned: 32

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    17	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    16	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:317
    15	EasyBlogACLHelper::getRules()	JROOT/components/com_easyblog/helpers/acl.php:33
    14	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/classes/themes.php:121
    13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
    12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
    11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
    10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
    9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
    8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
    7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 8.56 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 2.669 MB Rows returned: 36

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    16	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    15	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:136
    14	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/classes/themes.php:121
    13	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
    12	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
    11	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
    10	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3515
    9	EasyBlogHelper::loadHeaders()	JROOT/components/com_easyblog/controller.php:50
    8	EasyBlogController->__construct()	JROOT/components/com_easyblog/controller.php:615
    7	EasyBlogController::getInstance()	JROOT/components/com_easyblog/easyblog.php:139
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 1.11 ms After last query: 17.34 ms Query memory: 0.022 MB Memory before query: 2.717 MB Rows returned: 1
    Duplicate queries: #41  #43

    SELECT *
    
      FROM icecool_easyblog_tag
    
      WHERE `id` = '1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    12	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    11	JTable->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
    10	EasyBlogTableTag->load()	JROOT/components/com_easyblog/views/tags/view.html.php:80
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 3.04 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 2.724 MB Rows returned: 1
    Duplicate queries: #42  #44

    SELECT COUNT(1) 
      FROM `icecool_easyblog_tag` 
      WHERE `alias`='thank-you' 
      AND `id`!='1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/tag.php:110
    13	EasyBlogTableTag->aliasExists()	JROOT/administrator/components/com_easyblog/tables/tag.php:152
    12	EasyBlogTableTag->bind()	JROOT/libraries/joomla/table/table.php:729
    11	JTable->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
    10	EasyBlogTableTag->load()	JROOT/components/com_easyblog/views/tags/view.html.php:80
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 1.50 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 2.735 MB Rows returned: 1

    SELECT id, keywords, description, indexing 
      FROM `icecool_easyblog_meta` 
      WHERE content_id = '3' 
      and type = 'view'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/components/com_easyblog/helpers/db.php:109
    12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:3039
    10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/tags/view.html.php:87
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 2.18 ms After last query: 10.72 ms Query memory: 0.023 MB Memory before query: 2.823 MB Rows returned: 0

    select `id` 
      FROM `icecool_easyblog_team` 
      where `access` = '3' 
      and `published` = '1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_easyblog/helpers/db.php:84
    13	EasyBlogDbJoomla30->loadResultArray()	JROOT/components/com_easyblog/helpers/db.php:43
    12	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:4720
    11	EasyBlogHelper::getViewableTeamIds()	JROOT/components/com_easyblog/models/blog.php:1131
    10	EasyBlogModelBlog->getTaggedBlogs()	JROOT/components/com_easyblog/views/tags/view.html.php:98
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 2.36 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 2.831 MB Rows returned: 0
    Duplicate queries: #39

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    13	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    12	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:4675
    11	EasyBlogHelper::getPrivateCategories()	JROOT/components/com_easyblog/models/blog.php:1137
    10	EasyBlogModelBlog->getTaggedBlogs()	JROOT/components/com_easyblog/views/tags/view.html.php:98
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 1.75 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 2.838 MB Rows returned: 0

    SELECT b.*, c.`title` as `category` 
      FROM `icecool_easyblog_post_tag` AS a  
      INNER JOIN `icecool_easyblog_post` AS b  
      ON a.post_id=b.id  
      LEFT JOIN `icecool_easyblog_category` AS c 
      ON b.category_id = c.id 
      WHERE a.tag_id = '1' 
      AND b.`published` = '1' 
      AND b.`private` = '0' 
      AND b.`issitewide` = '1' 
      ORDER BY b.`created` desc 
      LIMIT 0,20

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/models/blog.php:1332
    10	EasyBlogModelBlog->getTaggedBlogs()	JROOT/components/com_easyblog/views/tags/view.html.php:98
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 2.33 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 2.845 MB Rows returned: 1
    Duplicate queries: #38

    SELECT COUNT(1) 
      FROM (SELECT b.*, c.`title` as `category` 
      FROM `icecool_easyblog_post_tag` AS a  
      INNER JOIN `icecool_easyblog_post` AS b  
      ON a.post_id=b.id  
      LEFT JOIN `icecool_easyblog_category` AS c 
      ON b.category_id = c.id 
      WHERE a.tag_id = '1' 
      AND b.`published` = '1' 
      AND b.`private` = '0' 
      AND b.`issitewide` = '1' 
      ORDER BY b.`created` desc) as x

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	NULL
    2	DERIVED	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/models/blog.php:1337
    10	EasyBlogModelBlog->getTaggedBlogs()	JROOT/components/com_easyblog/views/tags/view.html.php:98
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 1.21 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 2.852 MB Rows returned: 1
    Duplicate queries: #37

    SELECT COUNT(1) 
      FROM (SELECT b.*, c.`title` as `category` 
      FROM `icecool_easyblog_post_tag` AS a  
      INNER JOIN `icecool_easyblog_post` AS b  
      ON a.post_id=b.id  
      LEFT JOIN `icecool_easyblog_category` AS c 
      ON b.category_id = c.id 
      WHERE a.tag_id = '1' 
      AND b.`published` = '1' 
      AND b.`private` = '0' 
      AND b.`issitewide` = '1' 
      ORDER BY b.`created` desc) as x

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	NULL
    2	DERIVED	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/models/blog.php:1338
    10	EasyBlogModelBlog->getTaggedBlogs()	JROOT/components/com_easyblog/views/tags/view.html.php:98
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 1.02 ms After last query: 1.10 ms Query memory: 0.023 MB Memory before query: 2.862 MB Rows returned: 0
    Duplicate queries: #35

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    13	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    12	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/helper.php:4675
    11	EasyBlogHelper::getPrivateCategories()	JROOT/components/com_easyblog/models/tags.php:538
    10	EasyBlogModelTags->getTagPrivateBlogCount()	JROOT/components/com_easyblog/views/tags/view.html.php:106
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 1.30 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 2.868 MB Rows returned: 1

    select count(1) 
      from `icecool_easyblog_post` as a  
      inner join `icecool_easyblog_post_tag` as b    
      on a.`id` = b.`post_id`    
      and b.`tag_id` = '1'  
      where a.`private` = '1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    12	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/models/tags.php:556
    10	EasyBlogModelTags->getTagPrivateBlogCount()	JROOT/components/com_easyblog/views/tags/view.html.php:106
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 1.52 ms After last query: 5.50 ms Query memory: 0.027 MB Memory before query: 2.906 MB Rows returned: 1
    Duplicate queries: #31  #43

    SELECT *
    
      FROM icecool_easyblog_tag
    
      WHERE `id` = '1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    24	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    23	JTable->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
    22	EasyBlogTableTag->load()	JROOT/components/com_easyblog/helpers/router.php:579
    21	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
    20	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    14	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
    13	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/feeds.php:73
    12	EasyBlogFeedsHelper->getFeedURL()	JROOT/components/com_easyblog/themes/default/blog.tags.php:19
    11	include JROOT/components/com_easyblog/themes/default/blog.tags.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/tags/view.html.php:150
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.96 ms After last query: 0.10 ms Query memory: 0.028 MB Memory before query: 2.919 MB Rows returned: 1
    Duplicate queries: #32  #44

    SELECT COUNT(1) 
      FROM `icecool_easyblog_tag` 
      WHERE `alias`='thank-you' 
      AND `id`!='1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    26	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/tag.php:110
    25	EasyBlogTableTag->aliasExists()	JROOT/administrator/components/com_easyblog/tables/tag.php:152
    24	EasyBlogTableTag->bind()	JROOT/libraries/joomla/table/table.php:729
    23	JTable->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
    22	EasyBlogTableTag->load()	JROOT/components/com_easyblog/helpers/router.php:579
    21	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
    20	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    14	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
    13	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/feeds.php:73
    12	EasyBlogFeedsHelper->getFeedURL()	JROOT/components/com_easyblog/themes/default/blog.tags.php:19
    11	include JROOT/components/com_easyblog/themes/default/blog.tags.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/tags/view.html.php:150
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 1.13 ms After last query: 1.12 ms Query memory: 0.028 MB Memory before query: 2.931 MB Rows returned: 1
    Duplicate queries: #31  #41

    SELECT *
    
      FROM icecool_easyblog_tag
    
      WHERE `id` = '1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    25	JTable->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
    24	EasyBlogTableTag->load()	JROOT/components/com_easyblog/helpers/router.php:579
    23	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
    22	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    21	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    20	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    19	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    18	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    16	JRoute::_()	JROOT/libraries/cms/pagination/pagination.php:773
    15	JPagination->_buildDataObject()	JROOT/libraries/cms/pagination/pagination.php:248
    14	JPagination->getData()	JROOT/components/com_easyblog/classes/pagination.php:42
    13	EasyBlogPagination->toHTML()	JROOT/components/com_easyblog/classes/pagination.php:28
    12	EasyBlogPagination->getPagesLinks()	JROOT/components/com_easyblog/themes/default/blog.tags.php:48
    11	include JROOT/components/com_easyblog/themes/default/blog.tags.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/tags/view.html.php:150
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 1.00 ms After last query: 0.08 ms Query memory: 0.029 MB Memory before query: 2.944 MB Rows returned: 1
    Duplicate queries: #32  #42

    SELECT COUNT(1) 
      FROM `icecool_easyblog_tag` 
      WHERE `alias`='thank-you' 
      AND `id`!='1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    28	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/tag.php:110
    27	EasyBlogTableTag->aliasExists()	JROOT/administrator/components/com_easyblog/tables/tag.php:152
    26	EasyBlogTableTag->bind()	JROOT/libraries/joomla/table/table.php:729
    25	JTable->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:50
    24	EasyBlogTableTag->load()	JROOT/components/com_easyblog/helpers/router.php:579
    23	EasyBlogRouter::getTagPermalink()	JROOT/components/com_easyblog/router.php:64
    22	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    21	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    20	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    19	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    18	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    16	JRoute::_()	JROOT/libraries/cms/pagination/pagination.php:773
    15	JPagination->_buildDataObject()	JROOT/libraries/cms/pagination/pagination.php:248
    14	JPagination->getData()	JROOT/components/com_easyblog/classes/pagination.php:42
    13	EasyBlogPagination->toHTML()	JROOT/components/com_easyblog/classes/pagination.php:28
    12	EasyBlogPagination->getPagesLinks()	JROOT/components/com_easyblog/themes/default/blog.tags.php:48
    11	include JROOT/components/com_easyblog/themes/default/blog.tags.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/tags/view.html.php:150
    9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controller.php:244
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 3.36 ms After last query: 2.20 ms Query memory: 0.026 MB Memory before query: 2.971 MB Rows returned: 12

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM icecool_modules AS m
    
      LEFT JOIN icecool_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN icecool_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-09-08 02:48:52') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-08 02:48:52') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 284 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    13	JModuleHelper::getModules()	JROOT/components/com_easyblog/helpers/helper.php:2579
    12	EasyBlogHelper::renderModule()	JROOT/components/com_easyblog/themes/default/toolbar.php:50
    11	include JROOT/components/com_easyblog/themes/default/toolbar.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/controller.php:569
    9	EasyBlogController->getToolbar()	JROOT/components/com_easyblog/controller.php:295
    8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:142
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---