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

Time

Memory

93 Queries Logged 332.50 ms

1. Query Time: 6.60 ms Query memory: 0.022 MB Memory before query: 0.704 MB Rows returned: 0

   SELECT `data`
   
     FROM `icecool_session`
   
     WHERE `session_id` = '4d1445e4af791f07ff01f33b6437a8bd'

   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.11 ms
   Waiting for query cache lock	0.03 ms
   init	0.01 ms
   checking query cache for query	0.15 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   init	0.02 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   System lock	0.06 ms
   optimizing	0.02 ms
   statistics	0.15 ms
   executing	0.02 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.03 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.01 ms
   storing result in query cache	0.20 ms
   cleaning up	0.09 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.12 ms After last query: 0.64 ms Query memory: 0.003 MB Memory before query: 0.721 MB

   DELETE 
   
     FROM `icecool_session`
   
     WHERE `time` < '1725762539'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	icecool_session	range	time	time	59	const	1	100.00	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   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: 1.62 ms After last query: 0.11 ms Query memory: 0.019 MB Memory before query: 0.726 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `icecool_session`
   
     WHERE `session_id` = '4d1445e4af791f07ff01f33b6437a8bd' 
     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.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.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.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.08 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.]

   ---

4. Query Time: 6.67 ms After last query: 0.12 ms Query memory: 0.003 MB Memory before query: 0.730 MB

   INSERT INTO `icecool_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('4d1445e4af791f07ff01f33b6437a8bd', 0, 1, '1725763439', 0, '')

   Explain

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

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.07 ms
   Waiting for query cache lock	0.01 ms
   update	0.03 ms
   end	0.01 ms
   query end	5.13 ms
   closing tables	0.03 ms
   freeing items	0.03 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.]

   ---

5. Query Time: 29.32 ms After last query: 0.42 ms Query memory: 0.024 MB Memory before query: 0.752 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.02 ms
   Waiting for query cache lock	20.20 ms
   init	0.03 ms
   checking query cache for query	0.21 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	4.75 ms
   System lock	0.05 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.07 ms
   executing	0.01 ms
   Sending data	0.23 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.04 ms
   Waiting for query cache lock	0.35 ms
   freeing items	0.01 ms
   storing result in query cache	0.01 ms
   cleaning up	0.04 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.]

   ---

6. Query Time: 0.94 ms After last query: 0.58 ms Query memory: 0.021 MB Memory before query: 0.775 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.02 ms
   Waiting for query cache lock	0.01 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.01 ms
   sending cached result to clien	0.02 ms
   cleaning up	0.01 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.]

   ---

7. Query Time: 1.33 ms After last query: 0.18 ms Query memory: 0.021 MB Memory before query: 0.780 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.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.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.]

   ---

8. Query Time: 8.45 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 0.788 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.00 ms
   init	0.01 ms
   checking query cache for query	0.05 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	5.99 ms
   optimizing	0.04 ms
   statistics	0.08 ms
   preparing	0.03 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.92 ms
   end	0.02 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.04 ms
   Waiting for query cache lock	0.01 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
   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.]

   ---

9. Query Time: 1.79 ms After last query: 3.34 ms Query memory: 0.021 MB Memory before query: 1.072 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.03 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   checking query cache for query	0.05 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.01 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.01 ms
   storing result in query cache	0.01 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.]

   ---

10. Query Time: 6.17 ms After last query: 1.49 ms Query memory: 0.090 MB Memory before query: 1.197 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.03 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.64 ms
    Waiting for query cache lock	0.02 ms
    Creating sort index	0.12 ms
    Waiting for query cache lock	0.08 ms
    Creating sort index	0.26 ms
    end	0.01 ms
    query end	0.09 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.07 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.19 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.]

    ---

11. Query Time: 2.40 ms After last query: 6.78 ms Query memory: 0.025 MB Memory before query: 2.039 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.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.70 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.01 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.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.09 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.11 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.]

    ---

12. Query Time: 1.10 ms After last query: 0.27 ms Query memory: 0.061 MB Memory before query: 2.054 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.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.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.05 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.15 ms
    cleaning up	0.02 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.]

    ---

13. Query Time: 2.89 ms After last query: 7.09 ms Query memory: 0.033 MB Memory before query: 2.171 MB Rows returned: 34

    SHOW FULL COLUMNS 
      FROM `icecool_easyblog_post`

    Explain

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

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.53 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.03 ms
    Opening tables	0.03 ms
    checking permissions	0.07 ms
    checking permissions	0.03 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
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    Sending data	0.06 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.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/blog.php:64
    14	EasyBlogTableBlog->__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:306
    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.69 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 2.215 MB Rows returned: 0

    SELECT a.`id` 
      FROM icecool_easyblog_post as a 
      WHERE a.`permalink` = 'bespoke:diamond-engagement-ring-setting-a-new-trend'

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.11 ms
    init	0.01 ms
    checking query cache for query	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 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
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.08 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.08 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    13	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    12	EasyBlogDBHelper->__call()	JROOT/administrator/components/com_easyblog/tables/blog.php:81
    11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/router.php:307
    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.]

    ---

15. Query Time: 1.46 ms After last query: 0.41 ms Query memory: 0.022 MB Memory before query: 2.221 MB Rows returned: 1

    SELECT a.`id` 
      FROM icecool_easyblog_post as a 
      WHERE a.`permalink` = 'bespoke-diamond-engagement-ring-setting-a-new-trend'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	46	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.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.04 ms
    Sending data	0.25 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.12 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.06 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    13	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    12	EasyBlogDBHelper->__call()	JROOT/administrator/components/com_easyblog/tables/blog.php:90
    11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/router.php:307
    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.]

    ---

16. Query Time: 1.48 ms After last query: 0.31 ms Query memory: 0.022 MB Memory before query: 2.232 MB Rows returned: 1
    Duplicate queries: #35  #40  #52  #55  #81  #83

    SELECT *
    
      FROM icecool_easyblog_post
    
      WHERE `id` = '14'

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 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
    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.03 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:92
    11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/router.php:307
    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.]

    ---

17. Query Time: 7.58 ms After last query: 0.44 ms Query memory: 0.022 MB Memory before query: 2.247 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.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 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.00 ms
    System lock	5.78 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.06 ms
    executing	0.01 ms
    Sending data	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.07 ms
    freeing items	0.01 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.]

    ---

18. Query Time: 4.32 ms After last query: 0.24 ms Query memory: 0.005 MB Memory before query: 2.238 MB

    UPDATE `icecool_extensions`
    
      SET `params` = '{\"mediaversion\":\"3f7bf3df9477496098b3f3f6abf8ef6f\"}'
    
      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.08 ms
    checking permissions	0.06 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.07 ms
    updating	0.04 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.31 ms
    query end	2.71 ms
    closing tables	0.06 ms
    freeing items	0.03 ms
    cleaning up	0.01 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.]

    ---

19. Query Time: 1.28 ms After last query: 0.49 ms Query memory: 0.019 MB Memory before query: 2.256 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.02 ms
    Waiting for query cache lock	0.01 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
    sending cached result to clien	0.02 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.]

    ---

20. Query Time: 1.32 ms After last query: 0.30 ms Query memory: 0.019 MB Memory before query: 2.266 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.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 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.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 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.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.05 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.]

    ---

21. Query Time: 1.28 ms After last query: 15.20 ms Query memory: 0.005 MB Memory before query: 2.368 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.14 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.05 ms
    updating	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.07 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.]

    ---

22. Query Time: 1.10 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 2.373 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.06 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 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.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
    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.]

    ---

23. Query Time: 1.25 ms After last query: 0.47 ms Query memory: 0.021 MB Memory before query: 2.381 MB Rows returned: 0

    SELECT * 
      FROM `icecool_easyblog_post` 
      WHERE `publish_up` <= '2024-09-08 02:43:59' 
      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.02 ms
    init	0.01 ms
    checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 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.06 ms
    preparing	0.02 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.01 ms
    cleaning up	0.05 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.]

    ---

24. Query Time: 1.28 ms After last query: 0.24 ms Query memory: 0.005 MB Memory before query: 2.386 MB

    UPDATE `icecool_easyblog_post` 
      SET `published` = '0' 
      WHERE `publish_down` > `publish_up` 
      AND `publish_down` <= '2024-09-08 02:43:59' 
      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.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.08 ms
    updating	0.16 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.]

    ---

25. Query Time: 1.81 ms After last query: 31.23 ms Query memory: 0.028 MB Memory before query: 2.579 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.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.41 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.03 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.02 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.09 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.08 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.]

    ---

26. Query Time: 1.33 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 2.601 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.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.05 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.01 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.19 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 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.01 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.]

    ---

27. Query Time: 2.38 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 2.609 MB Rows returned: 1
    Duplicate queries: #29

    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.03 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    checking query cache for query	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.28 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.04 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.21 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.03 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.01 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.]

    ---

28. Query Time: 1.01 ms After last query: 0.50 ms Query memory: 0.025 MB Memory before query: 2.619 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.02 ms
    Waiting for query cache lock	0.01 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.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.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.02 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
    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.]

    ---

29. Query Time: 0.84 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 2.629 MB Rows returned: 1
    Duplicate queries: #27

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

    ---

30. Query Time: 2.50 ms After last query: 4.75 ms Query memory: 0.028 MB Memory before query: 2.653 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.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.81 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.06 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.05 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.17 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 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.]

    ---

31. Query Time: 1.38 ms After last query: 0.89 ms Query memory: 0.024 MB Memory before query: 2.678 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.02 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 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.00 ms
    System lock	0.02 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.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.07 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.]

    ---

32. Query Time: 1.60 ms After last query: 0.30 ms Query memory: 0.028 MB Memory before query: 2.693 MB Rows returned: 32
    Duplicate queries: #72

    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.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.02 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.40 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.03 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.]

    ---

33. Query Time: 2.91 ms After last query: 0.24 ms Query memory: 0.029 MB Memory before query: 2.727 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.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.26 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.84 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.44 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.02 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.]

    ---

34. Query Time: 2.22 ms After last query: 22.84 ms Query memory: 0.022 MB Memory before query: 2.836 MB Rows returned: 1

    SELECT id, keywords, description, indexing 
      FROM `icecool_easyblog_meta` 
      WHERE content_id = '14' 
      and type = 'post'

    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.03 ms
    Waiting for query cache lock	0.00 ms
    init	0.01 ms
    checking query cache for query	0.05 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.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.47 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.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/entry/view.html.php:66
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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: 0.97 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 2.852 MB Rows returned: 1
    Duplicate queries: #16  #40  #52  #55  #81  #83

    SELECT *
    
      FROM icecool_easyblog_post
    
      WHERE `id` = '14'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_easyblog_post	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.01 ms
    sending cached result to clien	0.03 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/administrator/components/com_easyblog/tables/blog.php:71
    11	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/helper.php:3062
    10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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: 4.82 ms After last query: 2.68 ms Query memory: 0.028 MB Memory before query: 2.868 MB Rows returned: 16

    SHOW FULL COLUMNS 
      FROM `icecool_easyblog_category`

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.42 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.12 ms
    Opening tables	0.02 ms
    checking permissions	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.04 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.01 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/category.php:52
    14	EasyBlogTableCategory->__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/helpers/helper.php:3067
    10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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: 1.05 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 2.896 MB Rows returned: 1
    Duplicate queries: #41  #79

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

    Explain

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

    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.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.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 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.22 ms
    cleaning up	0.05 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/administrator/components/com_easyblog/tables/category.php:59
    11	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/helper.php:3068
    10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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.04 ms After last query: 0.24 ms Query memory: 0.023 MB Memory before query: 2.903 MB Rows returned: 1
    Duplicate queries: #42  #80

    SELECT COUNT(1) 
      FROM `icecool_easyblog_category` 
      WHERE `alias`='icecooldiamonds' 
      AND `id`!='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.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.01 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.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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/category.php:190
    14	EasyBlogTableCategory->aliasExists()	JROOT/administrator/components/com_easyblog/tables/category.php:210
    13	EasyBlogTableCategory->bind()	JROOT/libraries/joomla/table/table.php:729
    12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
    11	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/helper.php:3068
    10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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: 2.24 ms After last query: 1.20 ms Query memory: 0.023 MB Memory before query: 2.912 MB Rows returned: 0
    Duplicate queries: #45

    SELECT a.`id`, a.`title`, a.`alias` 
      FROM `icecool_easyblog_tag` AS a 
      LEFT JOIN `icecool_easyblog_post_tag` AS b 
      ON a.`id` = b.`tag_id` 
      WHERE b.`post_id` = '14' 
      AND a.`published` = '1' 
      ORDER BY a.`title` ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	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.05 ms
    checking permissions	0.01 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.01 ms
    statistics	1.11 ms
    executing	0.02 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.01 ms
    cleaning up	0.05 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/models/posttag.php:62
    11	EasyBlogModelPostTag->getBlogTags()	JROOT/components/com_easyblog/helpers/helper.php:3075
    10	EasyBlogHelper::setMeta()	JROOT/components/com_easyblog/views/entry/view.html.php:66
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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.09 ms After last query: 0.36 ms Query memory: 0.022 MB Memory before query: 2.918 MB Rows returned: 1
    Duplicate queries: #16  #35  #52  #55  #81  #83

    SELECT *
    
      FROM icecool_easyblog_post
    
      WHERE `id` = '14'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_easyblog_post	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.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
    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/blog.php:71
    10	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/views/entry/view.html.php:78
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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.19 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 2.928 MB Rows returned: 1
    Duplicate queries: #37  #79

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_easyblog_category	system	PRIMARY	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.54 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
    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:1453
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
    11	EasyBlogTableCategory->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:724
    10	EasyBlogTableBlog->isAccessible()	JROOT/components/com_easyblog/views/entry/view.html.php:178
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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: 5.34 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 2.935 MB Rows returned: 1
    Duplicate queries: #38  #80

    SELECT COUNT(1) 
      FROM `icecool_easyblog_category` 
      WHERE `alias`='icecooldiamonds' 
      AND `id`!='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.01 ms
    Waiting for query cache lock	3.04 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
    sending cached result to clien	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/category.php:190
    14	EasyBlogTableCategory->aliasExists()	JROOT/administrator/components/com_easyblog/tables/category.php:210
    13	EasyBlogTableCategory->bind()	JROOT/libraries/joomla/table/table.php:729
    12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
    11	EasyBlogTableCategory->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:724
    10	EasyBlogTableBlog->isAccessible()	JROOT/components/com_easyblog/views/entry/view.html.php:178
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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.89 ms After last query: 3.51 ms Query memory: 0.006 MB Memory before query: 2.941 MB

    UPDATE icecool_easyblog_post
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '14'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
    11	JTable->hit()	JROOT/administrator/components/com_easyblog/tables/blog.php:260
    10	EasyBlogTableBlog->hit()	JROOT/components/com_easyblog/views/entry/view.html.php:222
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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.20 ms After last query: 1.26 ms Query memory: 0.023 MB Memory before query: 2.946 MB Rows returned: 1

    SELECT COUNT(1) 
      FROM `icecool_easyblog_featured` 
      WHERE `content_id` = '14' 
      AND `type` = 'post'

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 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.01 ms
    System lock	0.02 ms
    optimizing	0.02 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.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.00 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/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:1794
    11	EasyBlogHelper::isFeatured()	JROOT/administrator/components/com_easyblog/tables/blog.php:751
    10	EasyBlogTableBlog->isFeatured()	JROOT/components/com_easyblog/views/entry/view.html.php:281
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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: 0.72 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 2.954 MB Rows returned: 0
    Duplicate queries: #39

    SELECT a.`id`, a.`title`, a.`alias` 
      FROM `icecool_easyblog_tag` AS a 
      LEFT JOIN `icecool_easyblog_post_tag` AS b 
      ON a.`id` = b.`tag_id` 
      WHERE b.`post_id` = '14' 
      AND a.`published` = '1' 
      ORDER BY a.`title` ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	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.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
    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: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/posttag.php:62
    10	EasyBlogModelPostTag->getBlogTags()	JROOT/components/com_easyblog/views/entry/view.html.php:290
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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.]

    ---

46. Query Time: 2.04 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 2.965 MB Rows returned: 1

    SELECT *
    
      FROM icecool_easyblog_users
    
      WHERE `id` = '966'

    Explain

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

    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.05 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.05 ms
    optimizing	0.01 ms
    statistics	0.86 ms
    preparing	0.06 ms
    executing	0.01 ms
    Sending data	0.02 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.01 ms
    cleaning up	0.26 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/profile.php:145
    10	EasyBlogTableProfile->load()	JROOT/components/com_easyblog/views/entry/view.html.php:304
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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.]

    ---

47. Query Time: 2.00 ms After last query: 2.16 ms Query memory: 0.028 MB Memory before query: 2.977 MB Rows returned: 16

    SHOW FULL COLUMNS 
      FROM `icecool_users`

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.22 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 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
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.03 ms
    end	0.05 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.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    18	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
    17	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:308
    16	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:583
    15	JUser::getTable()	JROOT/libraries/joomla/user/user.php:861
    14	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    13	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    12	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    11	JFactory::getUser()	JROOT/administrator/components/com_easyblog/tables/profile.php:154
    10	EasyBlogTableProfile->load()	JROOT/components/com_easyblog/views/entry/view.html.php:304
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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.]

    ---

48. Query Time: 1.80 ms After last query: 0.26 ms Query memory: 0.024 MB Memory before query: 3.006 MB Rows returned: 1

    SELECT *
    
      FROM `icecool_users`
    
      WHERE `id` = 966

    Explain

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

    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.02 ms
    init	0.02 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.80 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 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.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
    15	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
    14	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    13	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    12	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    11	JFactory::getUser()	JROOT/administrator/components/com_easyblog/tables/profile.php:154
    10	EasyBlogTableProfile->load()	JROOT/components/com_easyblog/views/entry/view.html.php:304
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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.]

    ---

49. Query Time: 2.36 ms After last query: 9.91 ms Query memory: 0.024 MB Memory before query: 3.017 MB Rows returned: 3

    SELECT `g`.`id`,`g`.`title`
    
      FROM `icecool_usergroups` AS g
    
      INNER JOIN `icecool_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 966

    Explain

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

    Profile

    Status	Duration
    starting	0.03 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.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.90 ms
    preparing	0.03 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.00 ms
    storing result in query cache	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:110
    15	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
    14	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    13	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    12	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    11	JFactory::getUser()	JROOT/administrator/components/com_easyblog/tables/profile.php:154
    10	EasyBlogTableProfile->load()	JROOT/components/com_easyblog/views/entry/view.html.php:304
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    8	EasyBlogController->display()	JROOT/libraries/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.]

    ---

50. Query Time: 0.98 ms After last query: 10.25 ms Query memory: 0.022 MB Memory before query: 3.097 MB Rows returned: 1

    SELECT COUNT(1) 
      FROM `icecool_easyblog_comment` 
      WHERE `post_id`='14' 
      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.03 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.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
    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.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/helpers/comment.php:262
    10	EasyBlogCommentHelper::getCommentCount()	JROOT/components/com_easyblog/views/entry/view.html.php:403
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

51. Query Time: 1.19 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 3.103 MB Rows returned: 0

    select `tag_id` 
      from `icecool_easyblog_post_tag` 
      where `post_id` = '14'

    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.01 ms
    init	0.00 ms
    checking query cache for query	0.11 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.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.09 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.01 ms
    storing result in query cache	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/components/com_easyblog/helpers/db.php:84
    12	EasyBlogDbJoomla30->loadResultArray()	JROOT/components/com_easyblog/helpers/db.php:43
    11	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/models/blog.php:1482
    10	EasyBlogModelBlog->getRelatedBlog()	JROOT/components/com_easyblog/views/entry/view.html.php:409
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

52. Query Time: 5.22 ms After last query: 1.34 ms Query memory: 0.024 MB Memory before query: 3.122 MB Rows returned: 1
    Duplicate queries: #16  #35  #40  #55  #81  #83

    SELECT *
    
      FROM icecool_easyblog_post
    
      WHERE `id` = '14'

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    init	0.09 ms
    checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.06 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.10 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.57 ms
    query end	0.02 ms
    closing tables	0.14 ms
    freeing items	0.02 ms
    Waiting for query cache lock	2.15 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.17 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    14	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
    13	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/router.php:203
    12	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
    11	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/classes/facebook.php:188
    10	EasyBlogFacebookLikes::getLikeHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:424
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

53. Query Time: 4.07 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 3.128 MB Rows returned: 0
    Duplicate queries: #56  #82  #89  #92

    SELECT `id` 
      FROM `icecool_menu` 
      WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=966' 
      AND `published`='1' 
      AND (`language`='en-GB' OR `language` = '*' ) 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.08 ms
    optimizing	0.05 ms
    statistics	0.70 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.89 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.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    16	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    15	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    14	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1108
    13	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:208
    12	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
    11	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/classes/facebook.php:188
    10	EasyBlogFacebookLikes::getLikeHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:424
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

54. Query Time: 1.11 ms After last query: 0.27 ms Query memory: 0.027 MB Memory before query: 3.139 MB Rows returned: 1

    SELECT a.* 
      FROM `icecool_easyblog_post` as a 
      WHERE a.`id` ='14'

    Explain

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

    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.03 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
    Sending data	0.04 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.00 ms
    storing result in query cache	0.02 ms
    cleaning up	0.07 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    23	JDatabaseDriver->loadObject()	JROOT/components/com_easyblog/helpers/db.php:109
    22	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    21	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:688
    20	EasyBlogRouter::getBlogSefPermalink()	JROOT/components/com_easyblog/router.php:35
    19	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
    12	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
    11	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/classes/facebook.php:188
    10	EasyBlogFacebookLikes::getLikeHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:424
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

55. Query Time: 1.22 ms After last query: 0.34 ms Query memory: 0.023 MB Memory before query: 3.151 MB Rows returned: 1
    Duplicate queries: #16  #35  #40  #52  #81  #83

    SELECT *
    
      FROM icecool_easyblog_post
    
      WHERE `id` = '14'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_easyblog_post	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.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.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    13	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
    12	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/router.php:203
    11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
    10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:426
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

56. Query Time: 0.92 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 3.157 MB Rows returned: 0
    Duplicate queries: #53  #82  #89  #92

    SELECT `id` 
      FROM `icecool_menu` 
      WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=966' 
      AND `published`='1' 
      AND (`language`='en-GB' OR `language` = '*' ) 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; 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.01 ms
    checking privileges on cached	0.01 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    14	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    13	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1108
    12	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:208
    11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
    10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:426
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

57. Query Time: 2.09 ms After last query: 1.03 ms Query memory: 0.026 MB Memory before query: 3.163 MB Rows returned: 6

    SHOW FULL COLUMNS 
      FROM `icecool_easyblog_meta`

    Explain

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

    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.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.05 ms
    Opening tables	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.06 ms
    checking permissions	0.30 ms
    checking permissions	0.07 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.15 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.64 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/meta.php:33
    14	EasyBlogTableMeta->__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/classes/facebook.php:103
    10	EasyBlogFacebookLikes::addOpenGraphTags()	JROOT/components/com_easyblog/views/entry/view.html.php:431
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

58. Query Time: 0.79 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 3.178 MB Rows returned: 1
    Duplicate queries: #59  #84

    SELECT * 
      FROM icecool_easyblog_meta 
      WHERE `type`='post' 
      AND `content_id`='14'

    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.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.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.09 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.00 ms
    freeing items	0.08 ms
    storing result in query cache	0.02 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/administrator/components/com_easyblog/tables/meta.php:44
    11	EasyBlogTableMeta->loadByType()	JROOT/components/com_easyblog/classes/facebook.php:104
    10	EasyBlogFacebookLikes::addOpenGraphTags()	JROOT/components/com_easyblog/views/entry/view.html.php:431
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

59. Query Time: 1.11 ms After last query: 1.16 ms Query memory: 0.022 MB Memory before query: 3.186 MB Rows returned: 1
    Duplicate queries: #58  #84

    SELECT * 
      FROM icecool_easyblog_meta 
      WHERE `type`='post' 
      AND `content_id`='14'

    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.02 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.11 ms
    sending cached result to clien	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/tables/meta.php:44
    11	EasyBlogTableMeta->loadByType()	JROOT/components/com_easyblog/helpers/twitter.php:95
    10	EasyBlogTwitterHelper::addCard()	JROOT/components/com_easyblog/views/entry/view.html.php:435
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

60. Query Time: 1.66 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 3.193 MB Rows returned: 0

    SELECT `id` 
      FROM `icecool_menu` 
      WHERE (`link`='index.php?option=com_easyblog&view=latest' OR `link` LIKE 'index.php?option=com_easyblog&view=latest&
      limit=%') 
      AND `published`='1' 
      AND (`language`='en-GB' OR `language` = '*' ) 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	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.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.36 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.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.02 ms
    cleaning up	0.06 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    14	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    13	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1215
    12	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
    11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
    10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:440
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

61. Query Time: 2.37 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 3.200 MB Rows returned: 0

    SELECT `id` 
      FROM `icecool_menu` 
      WHERE `link` LIKE 'index.php?option=com_easyblog&view=latest%' 
      AND `published`='1' 
      AND (`language`='en-GB' OR `language` = '*' ) 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; 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.13 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.07 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.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.39 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.04 ms
    freeing items	0.03 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    14	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    13	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1230
    12	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
    11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
    10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:440
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

62. Query Time: 1.64 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 3.207 MB Rows returned: 0

    SELECT `id` 
      FROM `icecool_menu` 
      WHERE `link`='index.php?option=com_easyblog&view=latest' 
      AND `published`='1' 
      AND (`language`='en-GB' OR `language` = '*' ) 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 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.06 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.12 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.49 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.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    14	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    13	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1243
    12	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
    11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
    10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:440
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

63. Query Time: 1.70 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 3.215 MB Rows returned: 1

    SELECT `id` 
      FROM `icecool_menu` 
      WHERE `link` LIKE 'index.php?option=com_easyblog&view=%' 
      AND `published`='1' 
      AND (`language`='en-GB' OR `language` = '*' ) 
      ORDER BY `id` 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_menu	index	idx_language	PRIMARY	4	NULL	1	8800.00	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.01 ms
    checking query cache for query	0.07 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.02 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.09 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.01 ms
    cleaning up	0.06 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    14	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    13	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1255
    12	EasyBlogRouter::getItemId()	JROOT/components/com_easyblog/helpers/router.php:511
    11	EasyBlogRouter::_()	JROOT/components/com_easyblog/helpers/router.php:874
    10	EasyBlogRouter::getRoutedURL()	JROOT/components/com_easyblog/views/entry/view.html.php:440
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

64. Query Time: 1.64 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 3.225 MB Rows returned: 0

    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.04 ms
    Waiting for query cache lock	0.01 ms
    init	0.00 ms
    checking query cache for query	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.04 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 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.02 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/helpers/helper.php:2891
    10	EasyBlogHelper::getBlogNavigation()	JROOT/components/com_easyblog/views/entry/view.html.php:457
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

65. Query Time: 32.40 ms After last query: 0.11 ms Query memory: 0.028 MB Memory before query: 3.241 MB Rows returned: 1

    SELECT a.`id`, a.`title` 
      FROM `icecool_easyblog_post` AS `a` 
      WHERE a.`published` = '1' 
      AND a.`ispending` = '0' 
      AND a.`private` = '0' 	
      AND a.`issitewide` = '1' 
      AND a.`created` < '2014-03-27 12:33:32' 
      ORDER BY a.`created` DESC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	range	easyblog_post_published,easyblog_post_blogger_list,easyblog_post_search	easyblog_post_search	12	NULL	12	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	30.36 ms
    init	0.06 ms
    checking query cache for query	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    init	0.05 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.06 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.19 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.47 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.02 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/helpers/helper.php:3021
    10	EasyBlogHelper::getBlogNavigation()	JROOT/components/com_easyblog/views/entry/view.html.php:457
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

66. Query Time: 48.00 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 3.254 MB Rows returned: 1

    SELECT a.`id`, a.`title` 
      FROM `icecool_easyblog_post` AS `a` 
      WHERE a.`published` = '1' 
      AND a.`ispending` = '0' 
      AND a.`private` = '0' 	
      AND a.`issitewide` = '1' 
      AND a.`created` > '2014-03-27 12:33:32' 
      ORDER BY a.`created` ASC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	range	easyblog_post_published,easyblog_post_blogger_list,easyblog_post_search	easyblog_post_search	12	NULL	28	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	25.33 ms
    init	0.02 ms
    checking query cache for query	0.09 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	12.08 ms
    System lock	0.05 ms
    optimizing	0.02 ms
    statistics	0.22 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 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: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/helpers/helper.php:3021
    10	EasyBlogHelper::getBlogNavigation()	JROOT/components/com_easyblog/views/entry/view.html.php:457
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

67. Query Time: 11.77 ms After last query: 1.09 ms Query memory: 0.022 MB Memory before query: 3.264 MB Rows returned: 0

    SELECT * 
      FROM `icecool_easyblog_trackback` 
      WHERE `post_id` = '14' 
      AND `published`='1' 
      ORDER BY `created` DESC

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 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.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.03 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:1467
    10	EasyBlogModelBlog->getTrackback()	JROOT/components/com_easyblog/views/entry/view.html.php:519
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

68. Query Time: 1.64 ms After last query: 0.71 ms Query memory: 0.026 MB Memory before query: 3.277 MB Rows returned: 5

    SHOW FULL COLUMNS 
      FROM `icecool_easyblog_adsense`

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.36 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.01 ms
    checking permissions	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.13 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.12 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/adsense.php:55
    14	EasyBlogTableAdsense->__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/classes/adsense.php:62
    10	EasyBlogGoogleAdsense::getHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:525
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

69. Query Time: 1.86 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 3.291 MB Rows returned: 1

    select `id` 
      FROM `icecool_easyblog_adsense` 
      where user_id = '966'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_easyblog_adsense	system	user_id	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.03 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.01 ms
    optimizing	0.01 ms
    statistics	0.37 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.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/adsense.php:67
    11	EasyBlogTableAdsense->load()	JROOT/components/com_easyblog/classes/adsense.php:63
    10	EasyBlogGoogleAdsense::getHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:525
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

70. Query Time: 0.95 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 3.301 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 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.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.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    12	JTable->load()	JROOT/administrator/components/com_easyblog/tables/adsense.php:76
    11	EasyBlogTableAdsense->load()	JROOT/components/com_easyblog/classes/adsense.php:63
    10	EasyBlogGoogleAdsense::getHTML()	JROOT/components/com_easyblog/views/entry/view.html.php:525
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

71. Query Time: 1.83 ms After last query: 2.41 ms Query memory: 0.026 MB Memory before query: 3.351 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:43:59') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-08 02:43:59') 
      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.02 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 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.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Sorting result	0.05 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.32 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.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.07 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/blog.read.php:29
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

72. Query Time: 0.93 ms After last query: 1.15 ms Query memory: 0.029 MB Memory before query: 3.375 MB Rows returned: 32
    Duplicate queries: #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.06 ms
    Waiting for query cache lock	0.01 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
    sending cached result to clien	0.02 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    19	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    18	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:317
    17	EasyBlogACLHelper::getRules()	JROOT/components/com_easyblog/helpers/acl.php:33
    16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
    15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
    14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
    13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

73. Query Time: 1.59 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 3.405 MB Rows returned: 0

    SELECT * 
      FROM `icecool_easyblog_acl_group` 
      WHERE `content_id`='966' 
      AND `type`='assigned'

    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	1	100.00	Using index condition

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.01 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.01 ms
    optimizing	0.01 ms
    statistics	0.15 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.26 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.10 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    18	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:53
    16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
    15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
    14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
    13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

74. Query Time: 2.61 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 3.415 MB Rows returned: 3

    SELECT `group_id` 
      FROM `icecool_user_usergroup_map` 
      WHERE `user_id` = '966'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_user_usergroup_map	ref	PRIMARY	PRIMARY	4	const	3	100.00	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.02 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.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    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.10 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    19	JDatabaseDriver->loadColumn()	JROOT/components/com_easyblog/helpers/db.php:84
    18	EasyBlogDbJoomla30->loadResultArray()	JROOT/components/com_easyblog/helpers/db.php:43
    17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:72
    16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
    15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
    14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
    13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

75. Query Time: 1.12 ms After last query: 0.11 ms Query memory: 0.029 MB Memory before query: 3.425 MB Rows returned: 36

    SELECT * 
      FROM `icecool_easyblog_acl_group` 
      WHERE `content_id`='6' 
      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.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.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.07 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.10 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.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.07 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    18	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:84
    16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
    15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
    14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
    13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

76. Query Time: 9.87 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 3.455 MB Rows returned: 36

    SELECT * 
      FROM `icecool_easyblog_acl_group` 
      WHERE `content_id`='7' 
      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.01 ms
    Waiting for query cache lock	7.32 ms
    init	0.03 ms
    checking query cache for query	0.30 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.01 ms
    System lock	0.35 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.25 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.48 ms
    Waiting for query cache lock	0.23 ms
    freeing items	0.01 ms
    storing result in query cache	0.03 ms
    cleaning up	0.09 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    18	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:84
    16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
    15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
    14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
    13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

77. Query Time: 2.29 ms After last query: 0.20 ms Query memory: 0.029 MB Memory before query: 3.485 MB Rows returned: 36

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	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.03 ms
    Waiting for query cache lock	0.09 ms
    init	0.01 ms
    checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 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.10 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.14 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.01 ms
    freeing items	0.09 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.02 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_easyblog/helpers/db.php:109
    18	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:84
    16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/helpers/helper.php:4795
    15	EasyBlogHelper::isBlogger()	JROOT/administrator/components/com_easyblog/tables/profile.php:316
    14	EasyBlogTableProfile->getProfileLink()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:35
    13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

78. Query Time: 1.27 ms After last query: 2.37 ms Query memory: 0.025 MB Memory before query: 3.439 MB Rows returned: 1

    SELECT `title` 
      FROM `icecool_easyblog_category` 
      WHERE `id` = '1'

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.01 ms
    init	0.06 ms
    checking query cache for query	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 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.03 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.10 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/administrator/components/com_easyblog/tables/blog.php:186
    14	EasyBlogTableBlog->getCategoryName()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:52
    13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

79. Query Time: 0.79 ms After last query: 0.36 ms Query memory: 0.028 MB Memory before query: 3.456 MB Rows returned: 1
    Duplicate queries: #37  #41

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_easyblog_category	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	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.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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    25	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    24	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
    23	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/router.php:662
    22	EasyBlogRouter::getCategoryPermalink()	JROOT/components/com_easyblog/router.php:53
    21	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    15	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
    14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:53
    13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

80. Query Time: 0.70 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 3.469 MB Rows returned: 1
    Duplicate queries: #38  #42

    SELECT COUNT(1) 
      FROM `icecool_easyblog_category` 
      WHERE `alias`='icecooldiamonds' 
      AND `id`!='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.01 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
    sending cached result to clien	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    27	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/tables/category.php:190
    26	EasyBlogTableCategory->aliasExists()	JROOT/administrator/components/com_easyblog/tables/category.php:210
    25	EasyBlogTableCategory->bind()	JROOT/libraries/joomla/table/table.php:729
    24	JTable->load()	JROOT/administrator/components/com_easyblog/tables/category.php:59
    23	EasyBlogTableCategory->load()	JROOT/components/com_easyblog/helpers/router.php:662
    22	EasyBlogRouter::getCategoryPermalink()	JROOT/components/com_easyblog/router.php:53
    21	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    15	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
    14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.meta.read.php:53
    13	include JROOT/components/com_easyblog/themes/default/blog.meta.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:46
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

81. Query Time: 1.76 ms After last query: 1.83 ms Query memory: 0.026 MB Memory before query: 3.487 MB Rows returned: 1
    Duplicate queries: #16  #35  #40  #52  #55  #83

    SELECT *
    
      FROM icecool_easyblog_post
    
      WHERE `id` = '14'

    Explain

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

    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.05 ms
    checking privileges on cached	0.01 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    18	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    17	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
    16	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/router.php:203
    15	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.publishing.tool.php:20
    14	include JROOT/components/com_easyblog/themes/default/blog.publishing.tool.php	JROOT/components/com_easyblog/classes/themes.php:319
    13	CodeThemes->fetch()	JROOT/components/com_easyblog/helpers/publishtools.php:49
    12	EasyBlogPublishToolsHelper->getHTML()	JROOT/components/com_easyblog/themes/default/blog.read.php:75
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

82. Query Time: 12.88 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 3.496 MB Rows returned: 0
    Duplicate queries: #53  #56  #89  #92

    SELECT `id` 
      FROM `icecool_menu` 
      WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=966' 
      AND `published`='1' 
      AND (`language`='en-GB' OR `language` = '*' ) 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	11.79 ms
    init	0.02 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    19	JDatabaseDriver->loadResult()	JROOT/components/com_easyblog/helpers/db.php:109
    18	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    17	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:1108
    16	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:208
    15	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.publishing.tool.php:20
    14	include JROOT/components/com_easyblog/themes/default/blog.publishing.tool.php	JROOT/components/com_easyblog/classes/themes.php:319
    13	CodeThemes->fetch()	JROOT/components/com_easyblog/helpers/publishtools.php:49
    12	EasyBlogPublishToolsHelper->getHTML()	JROOT/components/com_easyblog/themes/default/blog.read.php:75
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

83. Query Time: 5.01 ms After last query: 2.75 ms Query memory: 0.025 MB Memory before query: 3.495 MB Rows returned: 1
    Duplicate queries: #16  #35  #40  #52  #55  #81

    SELECT *
    
      FROM icecool_easyblog_post
    
      WHERE `id` = '14'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    15	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
    14	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/socialbutton.php:42
    13	EasyBlogSocialButtonHelper->setBlog()	JROOT/components/com_easyblog/helpers/helper.php:3578
    12	EasyBlogHelper::showSocialButton()	JROOT/components/com_easyblog/themes/default/blog.read.php:89
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

84. Query Time: 0.65 ms After last query: 0.40 ms Query memory: 0.023 MB Memory before query: 3.505 MB Rows returned: 1
    Duplicate queries: #58  #59

    SELECT * 
      FROM icecool_easyblog_meta 
      WHERE `type`='post' 
      AND `content_id`='14'

    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.02 ms
    Waiting for query cache lock	0.01 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.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/tables/meta.php:44
    14	EasyBlogTableMeta->loadByType()	JROOT/components/com_easyblog/helpers/socialbutton.php:400
    13	EasyBlogSocialButtonHelper->googleone()	JROOT/components/com_easyblog/helpers/helper.php:3612
    12	EasyBlogHelper::showSocialButton()	JROOT/components/com_easyblog/themes/default/blog.read.php:89
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

85. Query Time: 2.08 ms After last query: 3.21 ms Query memory: 0.029 MB Memory before query: 3.535 MB Rows returned: 9

    SHOW FULL COLUMNS 
      FROM `icecool_easyblog_ratings`

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.33 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 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
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.15 ms
    closing tables	0.01 ms
    freeing items	0.04 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/administrator/components/com_easyblog/tables/table.php:18
    19	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/ratings.php:80
    18	EasyBlogTableRatings->__construct()	JROOT/libraries/joomla/table/table.php:308
    17	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
    16	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
    15	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/helpers/ratings.php:41
    14	EasyBlogRatingsHelper->getHTML()	JROOT/components/com_easyblog/themes/default/blog.rating.php:18
    13	include JROOT/components/com_easyblog/themes/default/blog.rating.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:141
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

86. Query Time: 5.86 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 3.555 MB Rows returned: 0

    SELECT * 
      FROM `icecool_easyblog_ratings` 
      WHERE `created_by`='0' 
      AND `uid`='14' 
      AND `type`='entry' 
      AND `sessionid`='4d1445e4af791f07ff01f33b6437a8bd'

    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	2.23 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.01 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.05 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.30 ms
    freeing items	0.04 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/tables/ratings.php:101
    15	EasyBlogTableRatings->fill()	JROOT/components/com_easyblog/helpers/ratings.php:45
    14	EasyBlogRatingsHelper->getHTML()	JROOT/components/com_easyblog/themes/default/blog.rating.php:18
    13	include JROOT/components/com_easyblog/themes/default/blog.rating.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:141
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

87. Query Time: 1.30 ms After last query: 1.01 ms Query memory: 0.025 MB Memory before query: 3.567 MB Rows returned: 1

    SELECT AVG(value) AS ratings, COUNT(1) AS total 
      FROM `icecool_easyblog_ratings` 
      WHERE `uid`='14' 
      AND `type`='entry'

    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.03 ms
    init	0.00 ms
    checking query cache for query	0.05 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.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.02 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.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    18	JDatabaseDriver->loadObject()	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/models/ratings.php:78
    15	EasyBlogModelRatings->getRatingValues()	JROOT/components/com_easyblog/helpers/ratings.php:49
    14	EasyBlogRatingsHelper->getHTML()	JROOT/components/com_easyblog/themes/default/blog.rating.php:18
    13	include JROOT/components/com_easyblog/themes/default/blog.rating.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:141
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

88. Query Time: 1.75 ms After last query: 1.98 ms Query memory: 0.026 MB Memory before query: 3.592 MB Rows returned: 1

    SELECT *
    
      FROM icecool_easyblog_post
    
      WHERE `id` = '13'

    Explain

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

    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.02 ms
    init	0.03 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.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	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.25 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    17	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    16	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
    15	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/router.php:203
    14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:20
    13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

89. Query Time: 3.15 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 3.600 MB Rows returned: 0
    Duplicate queries: #53  #56  #82  #92

    SELECT `id` 
      FROM `icecool_menu` 
      WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=966' 
      AND `published`='1' 
      AND (`language`='en-GB' OR `language` = '*' ) 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; 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.01 ms
    checking privileges on cached	0.01 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	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/router.php:1108
    15	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:208
    14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:20
    13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

90. Query Time: 2.76 ms After last query: 0.23 ms Query memory: 0.028 MB Memory before query: 3.611 MB Rows returned: 1

    SELECT a.* 
      FROM `icecool_easyblog_post` as a 
      WHERE a.`id` ='13'

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.56 ms
    init	0.02 ms
    checking query cache for query	0.15 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.05 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.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.08 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    25	JDatabaseDriver->loadObject()	JROOT/components/com_easyblog/helpers/db.php:109
    24	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    23	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:688
    22	EasyBlogRouter::getBlogSefPermalink()	JROOT/components/com_easyblog/router.php:35
    21	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    15	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
    14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:20
    13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

91. Query Time: 1.33 ms After last query: 0.26 ms Query memory: 0.026 MB Memory before query: 3.624 MB Rows returned: 1

    SELECT *
    
      FROM icecool_easyblog_post
    
      WHERE `id` = '15'

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 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.03 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.05 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.04 ms
    cleaning up	0.20 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    17	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    16	JTable->load()	JROOT/administrator/components/com_easyblog/tables/blog.php:71
    15	EasyBlogTableBlog->load()	JROOT/components/com_easyblog/helpers/router.php:203
    14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:28
    13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

92. Query Time: 2.43 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 3.630 MB Rows returned: 0
    Duplicate queries: #53  #56  #82  #89

    SELECT `id` 
      FROM `icecool_menu` 
      WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=966' 
      AND `published`='1' 
      AND (`language`='en-GB' OR `language` = '*' ) 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icecool_menu	range	idx_language	idx_language	28	NULL	88	100.00	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	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/router.php:1108
    15	EasyBlogRouter::getItemIdByBlogger()	JROOT/components/com_easyblog/helpers/router.php:208
    14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:28
    13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---

93. Query Time: 2.04 ms After last query: 0.30 ms Query memory: 0.028 MB Memory before query: 3.641 MB Rows returned: 1

    SELECT a.* 
      FROM `icecool_easyblog_post` as a 
      WHERE a.`id` ='15'

    Explain

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

    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.02 ms
    init	0.04 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.02 ms
    optimizing	0.09 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.13 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.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.03 ms
    cleaning up	0.06 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    25	JDatabaseDriver->loadObject()	JROOT/components/com_easyblog/helpers/db.php:109
    24	EasyBlogDbJoomla30->__call()	JROOT/components/com_easyblog/helpers/db.php:43
    23	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/router.php:688
    22	EasyBlogRouter::getBlogSefPermalink()	JROOT/components/com_easyblog/router.php:35
    21	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    20	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    19	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    18	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    17	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    16	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    15	JRoute::_()	JROOT/components/com_easyblog/helpers/router.php:475
    14	EasyBlogRouter::_()	JROOT/components/com_easyblog/themes/default/blog.read.navigation.php:28
    13	include JROOT/components/com_easyblog/themes/default/blog.read.navigation.php	JROOT/components/com_easyblog/classes/themes.php:319
    12	CodeThemes->fetch()	JROOT/components/com_easyblog/themes/default/blog.read.php:160
    11	include JROOT/components/com_easyblog/themes/default/blog.read.php	JROOT/components/com_easyblog/classes/themes.php:319
    10	CodeThemes->fetch()	JROOT/components/com_easyblog/views/entry/view.html.php:531
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controller.php:250
    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.]

    ---